Apache OpenOffice (AOO) Bugzilla – Issue 100592
Converting Drop Down list from Excel 2007 to OpenOffice calc
Last modified: 2013-01-29 21:41:52 UTC
I have a spreadsheet made with excel 2007, and when I open it with openoffice, my drop down stuff link changed field (Data/Validity) on excel 2007 I added a drop down with a range of $C1:$C31, but when I open it with scalc, it convert it to $I1:$I31 which is completely wrong. if you want me to post the spreadsheet somewhere I could
If I use a validity list in Excel 2007 and save a xlsx, then the list is set to 0 when opening in OOoDEV300m44.
Created attachment 61217 [details] Validity list is lost when opening in OOo
I noticed the same problem, any drop down lists with cells and saved as XLSX file opened in OpenOffice Calc loses its values (the cell range changes to "0"). This happens in OO 3.1.1 OOO310m19 (build:9420) @ WinXP What is strange is that the same file opened in older version: OO 3.1.0 OOO310m11 (build:9399) @ Ubuntu works correctly.
What's even more puzzling: While OO 3.1.0 OOO310m11 (build:9399) @ Ubuntu works does not suffer from this bug, OO 3.1.0 OOO310m11 (build:9399) @ WinXP does.
*** Issue 107427 has been marked as a duplicate of this issue. ***
apparently no problem in 3.2.0 anymore - or I don't see the problem. Please check again and if it still occurs, please describe the problem with the attachment in more detail.