Apache OpenOffice (AOO) Bugzilla – Issue 87555
Newly loaded Excel or PowerPoint file considered as modified - approved
Last modified: 2008-06-30 14:06:39 UTC
Open any Excel 97 or PowerPoint 97 file. The "save" icon is enabled. If you close the document the warning message says that the document has not been saved. Same problem with a PowerPoint or Excel document created by OpenOffice. Regression found by several users on 2.4.0 RC6 and 2.4.0 final <http://www.oooforum.org/forum/viewtopic.phtml?t=69882&highlight=> <http://user.services.openoffice.org/en/forum/viewtopic.php?f=5&t=3924>
Setting regression keyword :-(
*** Issue 87555 has been confirmed by votes. ***
confirming on WinXP SP2 with OOo 2.4.0 german even after: - complete deinstall and removing of program directory, then new install - complete new profile in %appdata% (current OpenOffice.org2 dir renamed) all xls worksheets on my system, created with excel 97 or previous OOo versions, (presumalby all in excel 97 format) open as modified except when having the read-only attribute set: then they open read-only.
*** Issue 88148 has been marked as a duplicate of this issue. ***
Also see http://qa.openoffice.org/issues/show_bug.cgi?id=88083 targeted for 2.4.1.
*** Issue 88083 has been marked as a duplicate of this issue. ***
Confirmed that this can be duplicated on the Mac X11 version of 2.4. This is not a showstopper but should be fixed for 2.4.1 and 3.0 as this is definitely a regression from 2.3.1 actions. Saving an .xls to .ods and opening the .ods file did not show a need for saving on a new file. However, saving a modified .ods file as .xls and then opening the .xls file did. James McKenzie
An accountant's plea for a quick fix to my favorite spreadsheet program: This issue degrades the user experience with OpenOffice by a fair amount if like me you are in an environment where many shared documents are opened and closed throughout the day often only for viewing. This bug also reflects poorly on OpenOffice since it is so obviously incorrect to report a just opened xls file as modified.
IMHO import of an MS Office into OOo document always is a modification, because we actually do not (and perhaps never will) have 100% import filters. So you may loose information on opening such documents in OOo (i.e. some effects in Powerpoint) - and not notice this as modification of the original document??? At least the quality of the import filter should be considered.
@ uwealtmann : this issue describes a bug, it is not a new feature. It concerns Excel and PowerPoint, but not Word. Open a new Calc document. Write Hello in a cell. Save it as MS Excel 97. Close. Reopen it : it is considered as already modified. Where is the loss of information?
TM->SJ: please have a look, thanks
There will be an automated testcase for this.
added "approved" to the title, because it will be easier to work with the 2.4.1 meta issue during release status meetings.
accepted
This issue has been fixed now in cws[sjfixes04]
sj->cgu: please verify
CGU: Verified in cws sjfixes04
This bug is not dependant on newly loading Excel or PowerPoint files. I have native Calc ODS files (i.e., created from scratch in Calc) that exhibit this behavior. I can open the file, immediately close it, and Calc asks me if I would like to save changes. Interestingly, not _all_ ODS files do this. I'm trying to determine what triggers this. No macros in any of the files.
CGU: Integrated in dev300m19