Issue 128229

Summary: Crash when comparing 2 spreadsheets
Product: Calc Reporter: Anonym <thorvald.soerensen>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CLOSED NOT_AN_OOO_ISSUE QA Contact:
Severity: Normal    
Priority: P5 (lowest) CC: oooforum
Version: 4.1.7   
Target Milestone: ---   
Hardware: PC   
OS: Windows 10   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Error message when reopening Calc
none
Document to compare2
none
Document to compare1 none

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