Created attachment 94004 [details] Original Excell file whit no shapes Problem description: Every time i save this specific file in LibreOffice it inserts shapes that were not there originally. This was a file originally created in MS Office and needs to be changed on a computer with LibreOffice. However, everytime i save it this shappes cover all the data and as a consequence it generated quite a confusion on the business i'm working for. (i can confirm this happens on at least Windows 7, Windows 8.1, openSUSE 12.3 and openSUSE 13.1 and this also happens in LO 4.2.0.4) Steps to reproduce: 1. Open attached file "OriginalFile.xlsx" 2. Change a number (or don't do anything) and save the file. 3. Open it again (either on LibreOffice or MS Office) Current behavior: Shapes apeared out of nothing and cover all data Expected behavior: There should be no shapes... (please also note that hidden cells also became visible, but i suspect this is a result of the same bug) Operating System: All Version: 4.1.4.2 release
I can reproduce this behavior, tested using Mac OSX 10.9 with LibreOffice Version: 4.2.2.1 Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f Kind regards, Joren
I can still reproduce this in 4.3.0.4. I'm not used to Bugzilla. Are we supposed to update "Version:" to match the last release where the bug exists?
In 'Navigator', under View menu (or hit F5) we can see 4 Drawing objects named "shapetype_202" Possibly those "Drawing object" causes filesave problem. I ever saw another issue in different bug report about importing problem with .xlsx file created with MSO which has "Drawing object". Set Version back to 4.1.4.2 according to: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Version
Ah..I found that: Bug 81842 -> similar problem with printing
I can also add that i picked the OriginalFile.xlsx and removed all cell formats (backgrouns, borders, etc), all cell data, un-hidded all hidden cells, unlocked panels and removed all filters (in another words, i've removed and reverted everthing i could remember to leave the document as clean as a new one) on MSO and everytime i save the file in LO i still get the bug as result.
The issue in attached file is, there are 4 shapes in document which are hidden and after exporting it to .xlsx the shape hidden property does not export. XML Difference Original File : <xdr:cNvPr id="2" name="Rectangle 1" hidden="1"/> After saving it as .xlsx : <xdr:cNvPr id="0" name="CustomShape 1"></xdr:cNvPr>
For me also reproducible with LO 4.4.3.2, Win 8.1
PriyankaGaikwad committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ccf91b9f823c28f2cb08784e4be4157bad40837e tdf#74932 FILESAVE: Shapes appear when saving a .XLSX file with filter It will be available in 5.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Testing the file with 5.0.0.2 (RC2) still causes problems: cells that were previously hidden became visible. Steps: Download OriginalFile.xlsx Open It > make no changes > select "Save As" > Select any location on computer > keep xlsx file extension > Save Open the saved file once again. Now Instead of having lines from 1 to 12 hidden, only Line 1 remains hidden. Lines 2 - 12 became visible.
I have submitted a new bug for the remaining problems at: https://bugs.documentfoundation.org/show_bug.cgi?id=98106
This bug was already resolved. The fix for hide row will be done in separate ticket