There are many cases when people might want to have a dropdown list of the other entered values in a column.

And the ability to prohibit entering others.

Classic one: entering yes, no, maybe.

These are not boolean, but discrete, and others should not be allowed.

Do you know how to do that?

Answer

source

select your range D25:D99, then menu Data->Validity In dialogue Validity select from drop-down list variant “Cell range”, and bottom set “Source” (your H3:H25) Push OK

Here is an example.

Thanks @Aufgehtsabgehts@feddit.org

Ende Gelände!

  • vort3@lemmy.ml
    2·
    5 months ago

    Is there a “remindme” bot in lemmy?

    I want to know the answer too.

  • driving_crooner
    2·
    5 months ago

    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:

    1. Open LibreOffice Calc: Open your spreadsheet in LibreOffice Calc.

    2. Select the Cells: Click on the cell or select the range of cells where you want the drop-down list to appear.

    3. Open Data Validity: Go to the menu and click on Data > Validity....

    4. Set Criteria: In the Validity dialog box, go to the Criteria tab.

      • From the Allow drop-down menu, select List.
      • In the 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.

    5. Optional Settings:

      • Go to the Input Help tab to provide users with instructions or help text when they select the cell.
      • Use the Error Alert tab to define how Calc should behave if an invalid value is entered.

    6. 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:

    1. List Values in a Range: List your values in a separate column or sheet.

    2. 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).

    3. Data Validity: Follow steps 3-4 above, but instead of typing values in the Entries field, type =$MyRange.

    4. 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.

    • boredsquirrel@slrpnk.netOP
      1·
      5 months ago

      Libreoffice really needs a Small Language Model reading their documents and giving summaries like these…

      I will try that!

  • Aufgehtsabgehts@feddit.orgDeutsch
    2·
    3 months ago

    I hope you found what you were looking for. A quick search delivered:

    select your range D25:D99, then menu Data->Validity In dialogue Validity select from drop-down list variant “Cell range”, and bottom set “Source” (your H3:H25) Push OK

    Here is an example.