Issue 100592 - Converting Drop Down list from Excel 2007 to OpenOffice calc
Summary: Converting Drop Down list from Excel 2007 to OpenOffice calc
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0.1
Hardware: Unknown Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
: 107427 (view as issue list)
Depends on:
Reported: 2009-03-26 15:30 UTC by tohands
Modified: 2013-01-29 21:41 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Validity list is lost when opening in OOo (8.27 KB, application/
2009-03-26 21:50 UTC, Regina Henschel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.