In Excel with AutoFilter, the dropdown list in a column is in the same format as the cells in that column. So if the numbers in the column are formatted to 3 decimal places, the numbers in the dropdown list will also be listed with 3 decimal places. But in Open Office, the numbers are unformatted. Is there a way to format the dropdown list?
Ken
Format dropdown list?
Format dropdown list?
OpenOffice 4.1.3 on Windows 7
Re: Format dropdown list?
Sorry In do know such functionality either in AOO nor LO.Is there a way to format the dropdown list?
My suggestion: use a helper column with rounded data or formatted converted string results. Then you van filter by the helper column.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.