https://bugs.documentfoundation.org/show_bug.cgi?id=94393
--- Comment #9 from Richard Léger <[email protected]> ---
In this post
(https://www.amazon.co.uk/Converter-VicTsing-Transmission-Computer-Projector/dp/B01M1IQ7F9/ref=pd_sim_23_4?_encoding=UTF8&psc=1&refRID=3MVH3EK0XMVE1QEBHXD7)
someone suggest the following as possible workaround:
"...
When you use "Data", "Validity", from the "Allow" drop down select "Cell Range"
instead of "List", and then use a range of cells to list the available options.
This works saving to xls or xlsx from LibreOffice 5.2.0.2, possibly also from
earlier versions but I have not tested.
..."
I haven't tested but I thought it may help someone perhaps.
It would be great of course if LO could manage directly to save this info
correctly in xls and xlsx files... for improved compatibility.
I can confirm that opening the "MS Excel sample file" attached to this bug in
LO 5.2.7.2 (x64) installed on Win10 Pro x64 OS, I cannot see or select the
dropdown cells in the file they appear as standard cells with "Please Select"
as text content.
So bug is still present.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
