Bug 130527 - Calc spoils xlsx file when saving
Summary: Calc spoils xlsx file when saving
Status: RESOLVED DUPLICATE of bug 117274
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.8.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-02-08 14:27 UTC by Marko
Modified: 2020-03-19 15:29 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
xlsx file that is modified and the saved with Calc (35.81 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-02-11 04:45 UTC, Marko
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Marko 2020-02-08 14:27:17 UTC
Description:
After modifying the xslx file, several sheets have rectangles with approximate size of screen on top of the tables.

Steps to Reproduce:
1) I open the xlsx file with multiple sheets
2) I add some data to it
3) Save and close
4) Open the file again

Actual Results:
Several sheets have rectangles with approximate size of screen on top of the tables. When I delete or move a rectangle, another rectangle with exactly same size appears below it.

Expected Results:
The file is not spoiled, all data is intact.


Reproducible: Always


User Profile Reset: No



Additional Info:
I have not tried with another files yet.
But as it destroys my files, I don't dare to use it any more.
Comment 1 ian 2020-02-08 15:33:30 UTC
Thank you for reporting the bug. Please attach the document that you described in the bug report, as this makes it easier for us to verify the bug. 

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.

(Note that the attachment will be public, remove any sensitive information before attaching it.
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for further detail.)
Comment 2 Marko 2020-02-11 04:45:06 UTC
Created attachment 157784 [details]
xlsx file that is modified and the saved with Calc

You can see the added rectangle at the top of the first sheet.
Comment 3 QA Administrators 2020-02-12 03:34:58 UTC Comment hidden (obsolete)
Comment 4 raal 2020-02-12 16:18:56 UTC
Can you attach original file before save?
Comment 5 Timur 2020-02-12 16:47:48 UTC
I think this was fixed in 6.4 and can be seen with https://dev-builds.libreoffice.org/daily/master/current.html.
Comment 6 QA Administrators 2020-02-13 03:18:40 UTC Comment hidden (obsolete)
Comment 7 Timur 2020-02-13 09:07:56 UTC
Marko, thanks, but rule of thumb is search before posting.
Simple search for rectangles would point to bug 117274 that's fixed but from 6.4.
Other rule is to attach source file, not modified. 
Finally, it's advisable to test with LO master before posting.

*** This bug has been marked as a duplicate of bug 117274 ***
Comment 8 Timur 2020-02-13 09:15:10 UTC
To fix this document with LO 6.4, you need to delete rectangles, there are like 30 of them. You may track in Navigator-Drawing Objects.
Comment 9 QA Administrators 2020-02-14 02:32:07 UTC Comment hidden (obsolete)
Comment 10 Timur 2020-02-14 08:07:06 UTC
Script that reopened the bug does all wrong and should be turned off. 
It's meant to help those who do not track bugs and instructions, but it does so at the expense of those who do.

*** This bug has been marked as a duplicate of bug 117274 ***
Comment 11 QA Administrators 2020-02-15 02:05:28 UTC Comment hidden (obsolete)
Comment 12 Timur 2020-02-15 07:49:04 UTC
Xusco, please see this script gone wild and neutralize it.
Comment 13 Xisco Faulí 2020-02-15 10:14:45 UTC
Hi,
Sorry for the noise. Yep, it seems something is wrong with the script.
Keep it UNCONFIRMED for the time being. I'll take a look and fix it
Comment 14 Timur 2020-03-19 15:29:07 UTC
let's try again to close this rebelled bug

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