Bug 94111

Summary:	Calc crashes when sorting
Product:	LibreOffice	Reporter:	subs
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	major	CC:	raal, wolfgang-58
Priority:	medium
Version:	5.0.1.2 release
Hardware:	x86 (IA32)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Test file that crashes when trying to sort Simple file for sort crash (just sort rows 3 and 4 by column A

Description subs 2015-09-10 21:30:53 UTC

User-Agent:       Mozilla/5.0 (Windows NT 6.1; rv:40.0) Gecko/20100101 Firefox/40.0
Build Identifier: LibreOffice 5.0.1.2

Every time I try to sort a table in Calc LibreOffice crashes. When it is a short table, it sorts, but still crashes.

This version is also much slower than the previous version.

Reproducible: Always

Steps to Reproduce:
1. Create table.
2. Highlight cells for sorting.
3. Data - Sort
Actual Results:  
LibreOffice completely freezes and I have to CTRL-ALT-DEL to stop process. Have left it to try and sort itself out for up to 15 minutes, but no joy.

Expected Results:  
Sorted table according to requirements almost immediately like previous version did.

[Information automatically included from LibreOffice]
Locale: en-ZA
Module: StartModule
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no


Reset User Profile?No

Comment 1 raal 2015-09-11 05:57:27 UTC

I can not confirm with Verze: 5.0.1.2
ID sestavení: 81898c9f5c0d43f3473ba111d7b351050be20261, win7
I can sort table without crash.

 For the test, could you rename your LibreOffice directory profile (see https://wiki.documentfoundation.org/UserProfile) and give it a new try?

Comment 2 subs 2015-09-11 07:01:54 UTC

(In reply to raal from comment #1)
> I can not confirm with Verze: 5.0.1.2
> ID sestavení: 81898c9f5c0d43f3473ba111d7b351050be20261, win7
> I can sort table without crash.
> 
>  For the test, could you rename your LibreOffice directory profile (see
> https://wiki.documentfoundation.org/UserProfile) and give it a new try?

Tried that, but it still crashes on sorting.

Comment 3 raal 2015-09-11 07:19:16 UTC

Attach test file and steps to reproduce, thanks

Comment 4 subs 2015-09-11 07:42:11 UTC

Created attachment 118597 [details]
Test file that crashes when trying to sort

Steps taken:

1. Highlight the 2 rows to be sorted.
2. Select Data - Sort
3. Change Sort Key 1 to column 4 and click OK.

At this point LibreOffice crashes and files are restored. The funny thing too is, if I save the file as a different name before I do this, it then restores the original file and not the saved as file.

Comment 5 subs 2015-09-11 07:43:00 UTC

sorry, column f not 4.

I have also tried a re-install but the problem persists.

Comment 6 subs 2015-09-11 07:51:30 UTC

(In reply to subs from comment #5)
> sorry, column f not 4.
> 
> I have also tried a re-install but the problem persists.

Please note that this error does not seem to happen with new files created in v5, but with those originally created in v4 and earlier.

Comment 7 MM 2015-09-11 23:55:18 UTC

My rough guess is that it was fixed in the latest (pre-)release 5.0.2.1.

https://bugs.documentfoundation.org/show_bug.cgi?id=93098

Comment 8 wolfgang-58 2015-09-14 16:58:27 UTC

Created attachment 118712 [details]
Simple file for sort crash (just sort rows 3 and 4 by column A

This is the simplest sheet I could find that crashes reliably when
sorted.

Just select rows 3 und 4 and press button "sort ascending".
For reproducabitity reasons don't restore or save the document after the crash because sometimes the sorting is done after restore.

It crashes reliablly on Wondows Vista and Windows7 (other systems not tested)
and with the release 4.4.5 and 5.0.1.

Remark: This Bug renders LibreOffice Calc unusable for me.

Comment 9 MM 2015-09-14 18:09:16 UTC

(In reply to wolfgang-58 from comment #8)

> It crashes reliablly on Wondows Vista and Windows7 (other systems not tested)
> and with the release 4.4.5 and 5.0.1.
> 

As I already said in comment 7 maybe it got fixed already in v5.0.2.1. So please test this version if it works for you.

Comment 10 wolfgang-58 2015-09-14 18:19:41 UTC

Yes, it's fixed. I read comment 7 after submitting my attachment and comment (sorry for that). I installed 5.0.2.1, and can confirm that my problem is fixed.
Thanks a lot!