This has a few entries previously but nothing in the last couple years i can find so here goes.
I have setup a selection list that a group of cells references.
In Excel I could start typing and it would bring up a matching list of entries from the reference list e.g. if I typed in FLOUR it would bring up “Flour, Gluten Free”, “Flour, Wholemeal” etc as a list but I don’t think thats available as standard in CALC?
Just checking in case I missed something…
I think it exists, as it is one of the first things to switch off for me (use alt-down-arrow for the list)
https://help.libreoffice.org/latest/en-US/text/scalc/01/06130000.html
Cf. tdf#94513 (“editing: Improvement: text completion should include validity values”)
Not quite what I was looking for. I want a list of all entries showing the word “Flour” to appear that has been sourced from a separate list on another tab (for example) whereas this just autocompletes from other entries in the same list.
…possibly with multiple dependent drop-down lists?
The duplex listings 1. and 2. are easy to create. The triplex listing 3. is complicated. Try my tested file:
1_LO-CALC_drop downs_simplex-duplex-triplex_TEST_025800.ods (24.2 KB)
It’s not perfect!
I appreciate your effort but not practical when I am entering 20 or more items in an ingredient list to get total pricing for an item I am selling, and while I didn’t say it, this is description is then used to VLOOKUP pricing for that particular ingredient in the adjacent cell.
An example of the list I am referecning from a separate pricing tab is:
| Ingredient | Amount in Pack | Price | Price Per Piece/Gm/Etc |
|---|---|---|---|
| Additions | 1 | $1.00 | $1.00 |
| Almond Extract | 20 | $2.50 | $0.13 |
| Almond flour | 1000 | $10.00 | $0.01 |
| Almonds. Salted Roasted Woolies | 200 | $4.50 | $0.02 |
| Amercian Buttercream, ABC by MK | 1000 | $0.00 | |
| Americolour White | 550 | $43.95 | $0.08 |
| Apple, Granny Smith | 1 | $0.85 | $0.85 |
| Apple, Tinned | 400 | $3.20 | $0.01 |
| Astor Honey | 1 | $1.00 | $1.00 |
| Bacon, streaky | 1000 | $18.00 | $0.02 |
| Baking Powder McKenzie’s | 125 | $2.85 | $0.02 |
| Baking Soda McKenzie’s | 350 | $4.50 | $0.01 |
| Bananas | 1 | $0.75 | $0.75 |
| Beef Mince | 500 | $7.00 | $0.01 |
| Black Sesame Seeds | 150 | $2.50 | $0.02 |
| Blueberries, Frozen | 500 | $6.20 | $0.01 |
| Bread Flour | 1000 | $3.50 | $0.00 |
| Butter, Western Star | 500 | $7.50 | $0.02 |
| Butter, Lurpak | 400 | $8.00 | $0.02 |
| Buttercake Coles Golden | 340 | $0.75 | $0.00 |
| Buttermilk | 600 | $2.15 | $0.00 |
| Carrot, each | 1 | $0.35 | $0.35 |
| Celery, 1 bunch | 1 | $4.00 | $4.00 |
| Chilli, ground | 30 | $2.20 | $0.07 |
| Choc Ripple Biscuits | 250 | $3.30 | $0.01 |
| Chocolate Callebaut White | 2500 | $65.00 | $0.03 |
| Chocolate Pearls | 500 | $39.95 | $0.08 |
| Chocolate, 41 40.7% Milk Power Callebaut | 2500 | $65.00 | $0.03 |
| Chocolate, 70% Callebaut | 2500 | $59.00 | $0.02 |
| Chocolate, 70% Plaistowe | 200 | $4.50 | $0.02 |
| Chocolate, 811 54.5% Callebaut | 1000 | $40.00 | $0.04 |
| Chocolate, 823 Milk Callebaut | 2500 | $57.00 | $0.02 |
| Chocolate, Gold 30.4% Power Callebaut | 2500 | $75.00 | $0.03 |
| Chocolate, Ruby, Callebaut | 2500 | $68.00 | $0.03 |
| Choux, per éclair | 1 | $0.29 | $0.29 |
In Excel: Data Validation with AutoComplete (filtered dropdown)
⠀
I was thinking that a normal data Validity works. You just have to click the drop down arrow to expose the list and then start typing; it will match the start of the word.
ValidityLookupPrice128152.ods (12.9 KB)
Not for me: LO v.25.2.1.2 (AARCH64) / macOS 15.7
It works the same for me in Windows with 25.8.2.2 and Mint Linux with 25.2.6
