<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - if I open an MS Excel XLSX file in Calc, dropdowns in cells do not show" href="https://bugs.documentfoundation.org/show_bug.cgi?id=94393#c9">Comment # 9</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - if I open an MS Excel XLSX file in Calc, dropdowns in cells do not show" href="https://bugs.documentfoundation.org/show_bug.cgi?id=94393">bug 94393</a> from <a class="email" href="mailto:richard.leger@gmail.com" title="Richard Léger <richard.leger@gmail.com>"> Richard Léger</a> <pre> In this post (<a href="https://www.amazon.co.uk/Converter-VicTsing-Transmission-Computer-Projector/dp/B01M1IQ7F9/ref=pd_sim_23_4?_encoding=UTF8&psc=1&refRID=3MVH3EK0XMVE1QEBHXD7">https://www.amazon.co.uk/Converter-VicTsing-Transmission-Computer-Projector/dp/B01M1IQ7F9/ref=pd_sim_23_4?_encoding=UTF8&psc=1&refRID=3MVH3EK0XMVE1QEBHXD7</a>) 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>