Bug 79620

Summary:	Sorting column from imported .xlsx file will crash Calc
Product:	LibreOffice	Reporter:	Luke <lukebenes>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED FIXED
Severity:	normal	CC:	deena.francis, miguelangelrv
Priority:	medium
Version:	4.3.0.0.alpha0+ Master
Hardware:	Other
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Backtrace with 4.4.0.0.alpha0+

Description Luke 2014-06-04 05:37:44 UTC

This bug was tested LibreOffice v4.2-4.4 running in windows 7 and Linux. It appears that Calc crashes when sorting a column.

Steps to reproduce the bug:
1. Open attachment 81707 [details] document in Calc 4.2
2. Select any of the drop downs on the 4th row, and "Sort Ascending"
3. Open attachment 81707 [details] in Calc 4.3+
4. Select any of the drop downs on the 4th row, and "Sort Ascending"

LibreOffice 4.3+ will crash with a "Unknown SEH Exception". Interestingly, if you save the file as an .ods, Calc will still crash, but if you open the .ods file, it will not crash when sorted.

Comment 1 m_a_riosv 2014-06-04 21:36:24 UTC

Created attachment 100422 [details]
Backtrace with 4.4.0.0.alpha0+

Reproducible
Win7x64
Version: 4.2.6.0.0+ Win-x86@42, Branch:libreoffice-4-2, Time: 2014-06-03_01:47:36
Version: 4.3.0.0.beta1 Win-x86@42, Branch:libreo-4-3, Time: 2014-06-03_16:28:29
Version: 4.4.0.0.alpha0+ Win-x86@39, Branch:master, Time: 2014-06-04_04:27:18
Attached backtrace file.

Last working for me:
Version: 4.1.6.2 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a

From 4.2.0 to 4.2.5 LibreOffice hangs opening the file.

Comment 2 Luke 2014-06-05 20:32:07 UTC

@m.a.riosv 
I'm not seeing any hanging when I open the file under Win 7 or Linux.

Win 7 Version: 4.2.3.3
Build ID: 882f8a0a489bc99a9e60c7905a60226254cb6ff0
Result: Pass

Win 7 Version: 4.4.0.0.alpha0+
Build ID: b447687292334687a371b66d7ad56ba9662b898e
Result: FAIL


On the Linux box:Linux Mint 17 Qiana
3.13.0-24-generic i686
LO Version: 4.2.3.3
Build ID: 420m0(Build:3)
Result: Pass

Linux LO Version: 4.4
Result: FAIL

Comment 3 m_a_riosv 2014-06-05 21:53:13 UTC

I have just retried with 4.2.3.3 and hangs opening the file.
As there are links and not available functions
I5: =Table1[[#this row];[total]]/Table1[[#this row];['# athletes]]
in LibreOffice, maybe accessibility to the links, or some different option between our configurations leads to a different behaviour.

In any case the status is set up as new, so is time to wait for the attention of some developer.

Comment 4 Luke 2014-07-19 03:20:13 UTC

Version: 4.4.0.0.alpha0+ current build off of the master branch is still crashing when you "Sort Ascending". Would a crash dump help?

Comment 5 Luke 2014-08-27 19:53:26 UTC

Deena Francis committed a patch that resolved this issue:

http://cgit.freedesktop.org/libreoffice/core/commit/?id=3a04813fbf9824ae6cf651bab0c3f55cf36ea8fa&h=libreoffice-4-2

Verified fixed with latest master 4.4 in Linux. Thanks so much Deena!