Created attachment 94004 [details]
Original Excell file whit no shapes
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 220.127.116.11)
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)
Shapes apeared out of nothing and cover all data
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: 18.104.22.168 release
I can reproduce this behavior, tested using Mac OSX 10.9 with LibreOffice Version: 22.214.171.124 Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f
I can still reproduce this in 126.96.36.199.
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 188.8.131.52 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.
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 184.108.40.206, Win 8.1
PriyankaGaikwad committed a patch related to this issue.
It has been pushed to "master":
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:
Affected users are encouraged to test the fix and report feedback.
Testing the file with 220.127.116.11 (RC2) still causes problems: cells that were previously hidden became visible.
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:
This bug was already resolved. The fix for hide row will be done in separate ticket