Autocomplete in a dropdown list in OOO Calc
morbleu
Posted messages
23
Status
Member
-
morbleu Posted messages 23 Status Member -
morbleu Posted messages 23 Status Member -
Hello,
In a column of a table created in OOO Calc, I want to insert a list of possible values (CB, Cheque, Cash)
But as the entries are going to be numerous and tedious, I would like to benefit from semi-automatic input without having to click on the arrow beforehand.
I tried a solution proposed for Excel (here: https://www.commentcamarche.net/applis-sites/bureautique/549-creer-des-listes-deroulantes-dans-excel/
and I successfully obtained my list in the desired cells but the row suggested for the "Source" area of the "Validity" dialog box (after choosing "cell range") does not work:
IF(I9<>"";OFFSET(d_names;MATCH(I9&"*";l_names;0)-1;;SUMPRODUCT((MID(l_names;1;LEN(I9))=TEXT(I9;"0"))*1));l_names)
(this list is assigned to a row of cells and I9 is my first selected cell)
Did I incorrectly transpose one of the instructions given for Excel into OOO or ...?
Could someone help me?
Thank you in advance ...
Configuration: Windows / Firefox 45.0
In a column of a table created in OOO Calc, I want to insert a list of possible values (CB, Cheque, Cash)
But as the entries are going to be numerous and tedious, I would like to benefit from semi-automatic input without having to click on the arrow beforehand.
I tried a solution proposed for Excel (here: https://www.commentcamarche.net/applis-sites/bureautique/549-creer-des-listes-deroulantes-dans-excel/
and I successfully obtained my list in the desired cells but the row suggested for the "Source" area of the "Validity" dialog box (after choosing "cell range") does not work:
IF(I9<>"";OFFSET(d_names;MATCH(I9&"*";l_names;0)-1;;SUMPRODUCT((MID(l_names;1;LEN(I9))=TEXT(I9;"0"))*1));l_names)
(this list is assigned to a row of cells and I9 is my first selected cell)
Did I incorrectly transpose one of the instructions given for Excel into OOO or ...?
Could someone help me?
Thank you in advance ...
Configuration: Windows / Firefox 45.0
1 answer
Essential tutorial to read: https://forum.openoffice.org/fr/forum/ftopic22412-tout-sur-les-listes-deroulantes-sous-calc.html
.
--
Why hack MS Office when there is a free solution?
Use OpenOffice
.
--
Why hack MS Office when there is a free solution?
Use OpenOffice
I had read it but it doesn't answer my question: it doesn't mention either autocomplete or instruction line in the "Source" area. Unless you mean that what is not specified in this tutorial is not feasible?
Or did I misunderstand this tutorial?