Issue 128229 - Crash when comparing 2 spreadsheets
Summary: Crash when comparing 2 spreadsheets
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.1.7
Hardware: PC Windows 10
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-11-19 14:15 UTC by Anonym
Modified: 2020-04-10 20:55 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Error message when reopening Calc (8.98 KB, image/png)
2019-11-19 14:15 UTC, Anonym 		no flags Details
Document to compare2 (300.96 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-12-09 08:36 UTC, Anonym 		no flags Details
Document to compare1 (178.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-12-09 08:36 UTC, Anonym 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Anonym 2019-11-19 14:15:56 UTC 
Created attachment 86765 [details]
Error message when reopening Calc

1) Open .ods spreadsheet with 2000+ rows, 40+ columns
2) Click edit -> compare document (very similar spreadsheet)
3) Bottom loading bar starts comparing
4) Eventually crashes with and say documents will be able to be recovered on next startup

The two sheets contain email adrress, numbers, text etc, and are converted from .csv to .odt with all standard "data" defined columns (so should be fairly "clean data"). No formulas in them

I cannot upload the spreadsheets due to confidencial reasons. I tried to compare two other test sheets found here (5K rows, copied them to have 40 columns for dummy data, edited random cells to make them different) which works fine, the popup with reject/accept changes shows quite quickly. https://file-examples.com/index.php/sample-documents-download/sample-ods-download/
Comment 1 oooforum (fr) 2019-11-20 18:34:02 UTC 
(In reply to Anonym from comment #0)
> I cannot upload the spreadsheets due to confidencial reasons. 
You must anonymize your document. Read this tutorial:
https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=8289

It is essential to understand and reproduce what you describe.
Comment 2 Anonym 2019-12-09 08:35:29 UTC 
Hi,

Thank you for the guide. I have now anonymized the 2 documents.
Comment 3 Anonym 2019-12-09 08:36:36 UTC 
Created attachment 86783 [details]
Document to compare2
Comment 4 Anonym 2019-12-09 08:36:52 UTC 
Created attachment 86784 [details]
Document to compare1
Comment 5 oooforum (fr) 2019-12-10 16:50:46 UTC 
I see that document is not a native format ODS but a converted XLS.
You have a lot of imported styles from Excel.
For me, this could be explain random crashes.
Comment 6 oooforum (fr) 2020-01-27 08:11:54 UTC 
Did you have rebuild your documents from scratch and testing if the problem still occurs?
Comment 7 Anonym 2020-01-27 15:51:51 UTC 
I did try yes, to remove formatting and only keep data, but still crashes.
Comment 8 oooforum (fr) 2020-01-28 07:43:10 UTC 
(In reply to Anonym from comment #7)
> I did try yes, to remove formatting and only keep data, but still crashes.

Not remove but from scratch
You don't know if your document is really clean.
Comment 9 oooforum (fr) 2020-04-10 06:45:30 UTC 
No news from OP