Is there a "remindme" bot in lemmy?
I want to know the answer too.
Community to discuss LibreOffice, new features, etc. You can also discuss Apache OpenOffice here.
Is there a "remindme" bot in lemmy?
I want to know the answer too.
Can't test now but ChatGPT said this:
Creating a drop-down list in LibreOffice Calc involves using the Data Validity feature. Here are the steps to create a drop-down list:
Open LibreOffice Calc: Open your spreadsheet in LibreOffice Calc.
Select the Cells: Click on the cell or select the range of cells where you want the drop-down list to appear.
Open Data Validity: Go to the menu and click on Data
> Validity...
.
Set Criteria: In the Validity
dialog box, go to the Criteria
tab.
Allow
drop-down menu, select List
.Entries
field, type the values you want to appear in the drop-down list. Separate each value with a comma. For example, type Option 1, Option 2, Option 3
.Optional Settings:
Input Help
tab to provide users with instructions or help text when they select the cell.Error Alert
tab to define how Calc should behave if an invalid value is entered.Click OK: Once you've configured the settings, click OK
.
Now, the selected cells will have a drop-down arrow, and users can choose from the list of values you defined.
If your list of values is long, you might want to reference a range of cells instead of typing each value manually. Here's how:
List Values in a Range: List your values in a separate column or sheet.
Name the Range: Select the range of cells with your values. Go to Sheet
> Named Ranges and Expressions
> Define
. Name your range (e.g., MyRange
).
Data Validity: Follow steps 3-4 above, but instead of typing values in the Entries
field, type =$MyRange
.
Click OK: Once you've configured the settings, click OK
.
This method makes it easier to update your list of values without modifying the Data Validity settings.
Libreoffice really needs a Small Language Model reading their documents and giving summaries like these...
I will try that!