Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | OO causes corruption in Excel files with combo boxes | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | daveytee <davet> | ||||
Component: | save-export | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CONFIRMED --- | QA Contact: | |||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | frank, issues, kpalagin | ||||
Version: | OOo 2.4.1 | ||||||
Target Milestone: | --- | ||||||
Hardware: | PC | ||||||
OS: | Windows XP | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
daveytee
2009-01-13 10:23:17 UTC
Please provide sample file. Created attachment 59424 [details]
Example file
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) 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. Regards, Rafiq 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. I forgot to mention that I tried both OO 3.0/Linux and 3.1/Windows. They behaved the same. Confirming - as described. |