Issue 98025 - OO causes corruption in Excel files with combo boxes
Summary: OO causes corruption in Excel files with combo boxes
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.4.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-01-13 10:23 UTC by daveytee
Modified: 2013-01-29 21:50 UTC (History)
3 users (show)

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

Example file (85.50 KB, application/
2009-01-16 09:45 UTC, daveytee
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description daveytee 2009-01-13 10:23:17 UTC
An excel file saved in Excel 2003 format containing combo boxes, after opening
in OO 2.4 or 3.0 will not then open in Excel - Excel says the file is corrupt
and loses all the formatting data and the combos. Have tested in Excel 2003 and
it only appears to be with SP3 (works ok without SP and with SP1 and SP2).
The file opens ok in OO
Comment 1 kpalagin 2009-01-15 20:57:08 UTC
Please provide sample file.
Comment 2 daveytee 2009-01-16 09:45:16 UTC
Created attachment 59424 [details]
Example file
Comment 3 daveytee 2009-01-16 09:54:01 UTC
Example file uploaded - the file was created in Excel. Upon opening in OO
everything displayed fine, I changed the combo value and it populated the
destination cell. Clicked Save (told it to leave in Excel format) and then the
file is reported by Excel 2003 SP3 as corrupt and if you tell Excel to open the
file anyway it strips all formatting and loses the combo box.
The give a bit of background (if you're interested) we have a template we send
out to people for them to fill in (on which there are 2 combos), we found that a
lot of people don't have Excel on their PCs so we recommended they downloaded
and installed OO which most have done. They open the xls, set the details then
send it back to us. We have an automated system that imports the data which has
been working fine until recently (seems to be a Microsoft update/SP because the
files can be opened fine in Excel 2003 without SP, or with SP1 or SP2)
Comment 4 ahmad_rafiq 2009-03-27 20:38:06 UTC
I did manage to reproduce the bug. 
  - I saved the attachment in excel and managed to open it in Excel 2003 or in
Excel 2007 without any problem. But after opening it in OOo 2.4.1 or 3.0 , when
I tried to open it back in excel 2003 , as mentioned by daveytee, it says the
file is corrupt. In a different machine, I repeated the test and when I tried to
open it in Excel 2007, it let me open the file but all I got was garbage.
  - I did create a simple spread sheet in Excel 2007 without any combo box in it
and repeated the test and everything went well. So, it is possible that the
macro(s) associated with the combo box in OOo may be causing some problems. 
  - In any case, as far as I am concerned, the bug is now CONFIRMED.
Comment 5 moseby 2009-05-08 16:45:47 UTC
I seem to have hit this bug as well.  

1. I started with an Excel 2003 .xls file which included combo boxes.
2. Made extensive modifications including deleting and duplicating sheets. 
3. Saved it in OO format.
4. repeat steps 2 and 3 a few times
5. saved it in Excel 97/2000/XP format
6. Opened it in Excel 2003 which resulted in the error described with the same
lack of formatting.

To debug this I systematically deleted sheets and elements to narrow down where
the issue lies. I found that the combo box was an issue.  With that knowledge
and Google I found this issue was open.

 My final test after reading this issue, was to start with the step 6 document
and just delete out the combo boxes (there were about a dozen).  Just that
allowed excel to open it.  I did an undo of one combobox delete, saved, and
excel puked again.

Definite confirmation.

Unfortunately the nature of the data in this spreadsheet makes it impossible for
me to share. 
Comment 6 moseby 2009-05-08 16:51:13 UTC
I forgot to mention that I tried both OO 3.0/Linux and 3.1/Windows. They behaved
the same.
Comment 7 kpalagin 2009-05-08 20:48:07 UTC
Confirming - as described.