Bug 50343 - Calc FILEOPEN: Segmentation fault opening xlsx file with array formula [backtrace with symbols attached]
Summary: Calc FILEOPEN: Segmentation fault opening xlsx file with array formula [backt...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.1.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-25 02:20 UTC by Manos S. Pappas
Modified: 2014-02-20 11:46 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Test xlsx file that causes "General Error" in LibreOffice Calc. (61.85 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-05-25 02:20 UTC, Manos S. Pappas
Details
TestXLSX Excel 2010 ScreenShot (221.62 KB, image/jpeg)
2012-06-06 08:18 UTC, Manos S. Pappas
Details
Calc can open this Excel 2010 .xslx file with one number in one cell (7.27 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-09-17 21:41 UTC, rl
Details
Calc can open this Excel 2010 .xlsx file with numbers in 8 cells (7.33 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-09-17 21:42 UTC, rl
Details
Calc cannot open this Excel 2010 .xlsx file with a few numbers and one array formula (7.69 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-09-17 21:43 UTC, rl
Details
backtrace with symbols produced on Fedora 64 bit (26.66 KB, text/plain)
2012-09-20 04:55 UTC, sasha.libreoffice
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Manos S. Pappas 2012-05-25 02:20:50 UTC
Created attachment 62092 [details]
Test xlsx file that causes "General Error" in LibreOffice Calc.

Problem description: 
LibreOffice Calc produces a "General Error" on opening xlsx files (they open fine in Office 2007/2010). Using release 3.5.3.2.

Attached is a test xlsx file that produces the error.

Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:12.0) Gecko/20120427 Firefox/12.0
Comment 1 Sven Eden 2012-06-06 05:45:02 UTC
I can confirm that for all .xlsx on versions 3.5.2.2 and 3.5.4.2.

Platform: Gentoo Linux x64
LibreOffice: 3.5.4.2 built from source

When opening an .xlsx a popup appears:
"The file '*filename*' is corrupt and therefore cannot be opened. LibreOffice can try to repair the file.
The corruption could be the result of document manipulation or of structural document damage due to data transmission.
We recommend that you do not trust the content of the repaired documents.
Execution of macros is disabled for this document.
Should LibreOffice repair the file?
*Yes* / *No*

When I select "Yes" ("No" just stops the attempt) the following popup appears:

"General Error.
General input/output error."

Unfortunately there is absolutely no informational/debugging output on the console, and I can't find a way to enable any. So these two popups are everything that shows up.
Comment 2 Manos S. Pappas 2012-06-06 06:15:03 UTC
On Windows version 3.5.4.2 the popup regarding file corruption does not even appear and the program goes directly to the dialog "General Error".

The attached sample file is not corrupt in any way; it opens without any issues with Excel 2007 and Excel 2010.
Comment 3 Sven Eden 2012-06-06 07:24:59 UTC
Just for the record: I just tried to open the sample file and it does not work.
Comment 4 Manos S. Pappas 2012-06-06 08:18:48 UTC
Created attachment 62675 [details]
TestXLSX Excel 2010 ScreenShot
Comment 5 Manos S. Pappas 2012-06-06 08:19:49 UTC
(In reply to comment #3)
> Just for the record: I just tried to open the sample file and it does not work.

The file opens correctly with Excel 2010, please see the attached screenshot.
Comment 6 Sven Eden 2012-06-06 12:12:00 UTC
Sorry, I did not mean to produce such a misunderstanding, but the screenshot is valuable as proof anyway. I meant your example does not work with my version of LibreOffice. ;)
Comment 7 Manos S. Pappas 2012-06-06 13:01:41 UTC
(In reply to comment #6)
> Sorry, I did not mean to produce such a misunderstanding, but the screenshot is
> valuable as proof anyway. I meant your example does not work with my version of
> LibreOffice. ;)

No worries Sven ;)

Another thing I do not understand is why the Windows version of LibreOffice Calc does not show a file repair dialog for this file, where at the same time on Linux it does. One can only assume that both versions (i.e Linux and Windows) are equally feature-wise and this behavior is strange.

I will try to set-up a virtual Linux box on my spare time to investigate on that issue too.
Comment 8 Sven Eden 2012-07-05 13:40:22 UTC
I just wanted to inform you, that the error is still present in version 3.5.5.3 :-(
Comment 9 Sven Eden 2012-08-08 16:52:15 UTC
(In reply to comment #8)
> I just wanted to inform you, that the error is still present in version 3.5.5.3
> :-(

Ok, this is odd. After I have upgraded to KDE-4.9 I got some distortions in LibreOffice and decided to rebuild whole thing without gtk+ and nsplugin.  (gtk+ is needed for the nsplugin, thus it had to be disabeld, too.)

And now I can open any docx, xlsx, pptx and so on files that were not possible to open in the very same LibreOffice version built with gtk+ and nsplugin enabled.

Here is the (stripped down!) configure string that Gentoo portage produced and used:

./configure --disable-dependency-tracking --with-system-headers --with-system-libs --with-system-jars --with-system-dicts --enable-cairo-canvas --enable-largefile --enable-python=system --enable-mergelibs --disable-fetch-external --disable-gnome-vfs --disable-kdeab --disable-kde --disable-ldap --disable-mozilla --disable-online-update --disable-pch --disable-rpath --disable-systray --disable-static-gtk --disable-strip-solver --disable-ugly --disable-zenity --with-x --without-sun-templates --enable-binfilter --enable-dbus --disable-evolution2 --disable-gconf --disable-gio --disable-lockdown --enable-graphite --enable-gstreamer --disable-gtk --disable-gtk3 --enable-kde4 --disable-nsplugin --enable-odk --enable-opengl --enable-ext-pdfimport --enable-vba --enable-activex-component --enable-neon --with-java --without-junit

Note: The original configure string is about for times the size of this stripped version.
Comment 10 rl 2012-09-17 21:40:57 UTC
I just noticed this issue with LibreOffice 3.6.1.2 on Windows 7 (64 bit). 

Therefore I changed "Version" to "3.6.1.2 release".

I attached three small files created in Excel 2010, two of which Calc can open and one of which it cannot. The file names indicate, which is which.

The two file Calc can open, have just a few numbers in them.

The one file Calc cannot open, has a few numbers and one array formula.
Comment 11 rl 2012-09-17 21:41:52 UTC
Created attachment 67300 [details]
Calc can open this Excel 2010 .xslx file with one number in one cell
Comment 12 rl 2012-09-17 21:42:41 UTC
Created attachment 67301 [details]
Calc can open this Excel 2010 .xlsx file with numbers in 8 cells
Comment 13 rl 2012-09-17 21:43:26 UTC
Created attachment 67302 [details]
Calc cannot open this Excel 2010 .xlsx file with a few numbers and one array formula
Comment 14 sasha.libreoffice 2012-09-20 04:55:17 UTC
Created attachment 67422 [details]
backtrace with symbols produced on Fedora 64 bit
Comment 15 sasha.libreoffice 2012-09-20 04:59:06 UTC
@ Markus
Greetings
What do You think about this bug?
Comment 16 Markus Mohrhard 2012-09-29 16:27:30 UTC
Muthu already fixed this one some time ago. Please check 3.6.2.2 for the fix.
Comment 17 Xisco Faulí 2014-02-20 11:46:05 UTC
I close this bug report as RESOLVED FIXED because it is no longer reproducible.
Tested again on:

   - Libreoffice 4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72
   - Libreoffice 4.2.0.4 Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71
   - Libreoffice 4.3.0.0.alpha0+ Build ID: e076b5290e706b8a69abd397a9f255eba6a0cd1a