Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Converting Drop Down list from Excel 2007 to OpenOffice calc|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||issues, kkotowicz, lohmaier, rb.henschel|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description tohands 2009-03-26 15:30:48 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
Comment 1 Regina Henschel 2009-03-26 21:49:02 UTC
If I use a validity list in Excel 2007 and save a xlsx, then the list is set to 0 when opening in OOoDEV300m44.
Comment 2 Regina Henschel 2009-03-26 21:50:50 UTC
Created attachment 61217 [details] Validity list is lost when opening in OOo
Comment 3 koto1sa 2009-09-16 23:17:58 UTC
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.
Comment 4 koto1sa 2009-09-17 01:49:37 UTC
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.
Comment 5 lohmaier 2010-03-12 21:38:44 UTC
*** Issue 107427 has been marked as a duplicate of this issue. ***
Comment 6 lohmaier 2010-03-12 21:43:25 UTC
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.