Bug 94841 - Libre office calc crashes when full blocks are filled and sorted
Summary: Libre office calc crashes when full blocks are filled and sorted
Status: RESOLVED DUPLICATE of bug 96910
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.1.1 rc
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks:
 
Reported: 2015-10-07 04:11 UTC by Sibi
Modified: 2016-06-02 16:50 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Screen shot of the issue (103.21 KB, image/png)
2015-10-07 04:11 UTC, Sibi
Details
screenshot after sort (134.16 KB, image/png)
2015-10-13 10:45 UTC, Jacques Guilleron
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Sibi 2015-10-07 04:11:13 UTC
Created attachment 119377 [details]
Screen shot of the issue

When I tried to sort with all the A and B row filled , getting fatal error and then the Calc crashes .
Comment 1 raal 2015-10-07 16:25:27 UTC
Hello Sibi,

Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
Thank you
Comment 2 Sibi 2015-10-07 17:31:58 UTC
(In reply to raal from comment #1)
> Hello Sibi,
> 
> Thank you for filing the bug. Please send us a sample document, as this
> makes it easier for us to verify the bug. 
> I have set the bug's status to 'NEEDINFO', so please do change it back to
> 'UNCONFIRMED' once you have attached a document.
> (Please note that the attachment will be public, remove any sensitive
> information before attaching it.)
> How can I eliminate confidential data from a sample document?
> https://wiki.documentfoundation.org/QA/
> FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
> Thank you

Hi raal , 

The sample document is 75 MB . Please let me know how/where  I can upload it and share it .

Regards , 
Sib
Comment 3 raal 2015-10-07 18:44:35 UTC
(In reply to Sibi from comment #2)
> 
> The sample document is 75 MB . Please let me know how/where  I can upload it
> and share it .
> 
Hello, you can use some free share service -  google disk, mega.co.nz, dropbox etc. and paste link here to bug comment. Please compress file first. Thank you
Comment 4 Sibi 2015-10-13 07:19:31 UTC
(In reply to raal from comment #3)
> (In reply to Sibi from comment #2)
> > 
> > The sample document is 75 MB . Please let me know how/where  I can upload it
> > and share it .
> > 
> Hello, you can use some free share service -  google disk, mega.co.nz,
> dropbox etc. and paste link here to bug comment. Please compress file first.

Uploaded in dropbox 
https://www.dropbox.com/s/x7zd445rpxz5vsi/theekathirwords.txt?dl=0 

So , while importing it use UTF-8 format to see Tamil Characters . The number of elements will be greater that the maximum limit . Import the maximum . And then sort it 

> Thank you
Comment 5 Sibi 2015-10-13 07:20:22 UTC
Reqired info added . Changed the status to unconfirmed
Comment 6 Jacques Guilleron 2015-10-13 10:45:28 UTC
Created attachment 119552 [details]
screenshot after sort
Comment 7 Jacques Guilleron 2015-10-13 10:58:18 UTC
Hi Sibi,

I deleted some lines at the end of the sheet. It seems Tamil sort add two lines at the end of the sort. See attachment.
Comment 8 Jacques Guilleron 2015-10-13 15:36:43 UTC
I reproduce with a full colon of random numbers, when I ask for a sort.
I get the same error message on Windows 7 Home.
LO 5.0.2.2 Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe Locale: fr-FR(fr_FR)
This began with
LO 4.3.1.1 Build ID: c4b15cd4d00dec6b266fa830b4ba73e31ae6ce73
Set qt
Comment 9 Jacques Guilleron 2015-10-13 15:39:48 UTC
Set status to NEW, hardware to all, and Keywords to regression.
Comment 10 raal 2016-01-10 09:56:58 UTC
This seems to have begun at the below commit.
Adding Cc: to Kohei Yoshida ; Could you possibly take a look at this one?
Thanks
 cbd3a1049b8e33bc5a862189b30518ece7f1307e is the first bad commit
commit cbd3a1049b8e33bc5a862189b30518ece7f1307e
Author: Matthew Francis <mjay.francis@gmail.com>
Date:   Sat Mar 14 23:56:31 2015 +0800

    source-hash-a3fc7f20089062afa4f778e70ba8be84032a30a7
    
    (Bibisect: Skipped preceding irrelevant commit(s) 97f700721e942912101d5acd73433448e57e39e5)
    
    commit a3fc7f20089062afa4f778e70ba8be84032a30a7
    Author:     Kohei Yoshida <kohei.yoshida@collabora.com>
    AuthorDate: Sun Jul 27 14:35:37 2014 -0400
    Commit:     Kohei Yoshida <kohei.yoshida@collabora.com>
    CommitDate: Sun Jul 27 14:41:21 2014 -0400
    
        fdo#81617: Split formula groups at sort range boundaries.
    
        Otherwise, partially sorting a range may crash, or at best incorrectly
        update formula references.
    
        Change-Id: Iefcb86d205d83ccc5b684048bfd9aadabf6e13eb

:040000 040000 21f062a0f14872375b5a0c6004dede2964d5e158 b19810b51622977125d344ca7763b81becd3c09a M	opt
Comment 11 Caolán McNamara 2016-06-02 16:50:29 UTC
According to bibisect this got fixed in the 0e7cd653ea90da388820220bf6a3eb140b57bbd6..c43fdd74097cb12f69f86fd1217dd2f41ccae101 range

I see...


commit 208883398dcf9af6b88611097d1f75d5fbc9afad
Author: Yogesh <er.yogeshdesai@gmail.com>
Date:   Thu Jan 21 16:24:40 2016 +0530

    tdf#96910 : Calc crashes while using "Insert Column Left" for large Documents

in this range and I reckon its the mostly like duplicate

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