[Libreoffice-bugs] [Bug 94393] if I open an MS Excel XLSX file in Calc, dropdowns in cells do not show

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=94393

--- Comment #9 from Richard Léger <richard.leger at gmail.com> ---

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170608/91df1e2e/attachment.html>