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.
It worked in a previous version (up to v.7), from v.25 it stopped working:
…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
Im looking for a solution as well. @EarnestAl comes very close, but isnt it just possible to do it without opening the list? So just be in the cell and while typing it autocompletes. That would be nice.
Segue uma sugestão, primeiro digite qualquer letra, vai abrir a entrada de texto, digite o fragmento da palavra e de ok, vai abrir os itens que atende, e só escolher.
Here’s a suggestion: first, type any letter, the text input will open, type the word fragment and click OK, the items that match will appear, and you just need to choose.
Lista Pesquisável_v25842.ods (19,5,KB)