Bug 135400 - [FILESAVE] Saving as xlsx (2007-365) would bring ~50 white rectangles putting at position (0,0)
Summary: [FILESAVE] Saving as xlsx (2007-365) would bring ~50 white rectangles putting...
Status: RESOLVED DUPLICATE of bug 117274
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-08-03 03:27 UTC by Franklin Weng
Modified: 2020-09-03 13:29 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Problematic file (22.46 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-08-03 03:28 UTC, Franklin Weng
Details
Screenshot (146.17 KB, image/png)
2020-08-03 03:29 UTC, Franklin Weng
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Franklin Weng 2020-08-03 03:27:32 UTC
Description:
Reported by users.

The attached sample files is an xlsx generated by Microsoft Excel (unknown version).  When opening it with LibreOffice it was okay.  Then save it back with xlsx format, close and reopen it, there will be a lot of white rectangles putting at position (0,0) with name "CustomShape1".  Those rectangles can be dragged (moved) and deleted.

After deleting all the rectangles and save the file again it will be okay.

* Saving as xls (97-2003) will not produce the rectangles.
* Saving as ods will not produce the rectangles.
* Saving as xls/ods THEN saving as xlsx (2007-) *will* produce the rectangles.

So far only this sample file will have this behavior.


Steps to Reproduce:
1. Open the attached xlsx file
2. Save as another xlsx (2007-) file (to avoid overwriting the original one)
3. Open the saved new file
4. A lot of rectangles will appear.

Actual Results:
~50 white rectangles will appear in the position (0,0)

Expected Results:
rectangles shouldn't be there


Reproducible: Always


User Profile Reset: No



Additional Info:
The earliest version I tested was
版本 3.6.7.2 (組建 ID:e183d5b)
so it seems to be a bug inherited from OOo.

7.0 alpha1 can reproduce this behavior.
Version: 7.0.0.0.alpha1
Build ID: 6a03b2a54143a9bc0c6d4c7f1...
CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: kf5; 
Locale: zh-TW (zh_TW.UTF-8); UI: en-US
Calc: threaded

Didn't test with RC1/2.
Comment 1 Franklin Weng 2020-08-03 03:28:43 UTC
Created attachment 163890 [details]
Problematic file

open it and save as xlsx (2007-) will cause a lot white rectangles appearing.
Comment 2 Franklin Weng 2020-08-03 03:29:26 UTC
Created attachment 163891 [details]
Screenshot
Comment 3 Murtaza 2020-08-18 11:09:22 UTC Comment hidden (spam)
Comment 4 Timur 2020-09-03 13:29:00 UTC
Looks like a damaged file as explained in
https://bugs.documentfoundation.org/show_bug.cgi?id=117274#c37

When you say "Reported by users." you should write their LO version. Probably from 6.1 to 6.3.

*** This bug has been marked as a duplicate of bug 117274 ***