Created attachment 85449 [details] Folder containing ODS version of test sheet and two XLS exports Exporting a spreadsheet to XLS (Excel 97 format), where the spreadsheet contains a matrix formula, will result in a sheet, which will likely crash Excel (here Excel 2013). The problem does not appear with OpenOffice 4.0 (and with earlier versions of LibreOffice). The problem is 100% reproducible (and a big one for me, since I have to switch to OpenOffice or earlier Versions of LibreOffice ;-). To reproduce: 1. Open the attached file LibreOfficeExportXLSBug.ods in OpenOffice and LibreOffice respectively. 2. Export the sheet via "Save as... XLS" using the respective program. 3. Open the exported sheet in Excel 2013 (Windows). 4. Notice that cell I17 looks different depending on whether the sheet was exported from LibreOffice or OpenOffice. 5. Select cell I16, click in the formula and press CTRL-SHIFT-ENTER (the command to calculate the formula). Result: a) Excel will crash for the sheet exported with LibreOffice. b) Excel will work as expected for the sheet exported with OpenOffice. For your convenience, my attachments also contains the two different versions of the XLS resulting from export using OpenOffice and LibreOffice respectively.
Version info: The problem exists in LibreOffice 4.1.1(.2) (current download at LibreOffice.org) The problem does not exist in LibreOffice 4.0.5
I can confirm that with your test case MS Office 2010 crashes but the problem is fixed in LibreOffice 4.2 master build. You can confirm this here: http://dev-builds.libreoffice.org/daily/master/Win-x86@6-debug/ Also you can test 4.1 daily build which is here: http://dev-builds.libreoffice.org/daily/libreoffice-4-1/Win-x86@6-debug/ I haven't tested 4.1 daily but I know 4.2 is fixed. So marking as WFM If it's still a problem in 4.1 daily let me know and we'll figure out what to do. Hopefully it's just fixed in 4.1 daily and then you can expect a fix with the next release of 4.1.x Thanks!
I had this problem again today with a fresh install of 4.1.2.3 (current and very new version).
PS: I am using MacOS and the daily build directory is often empty...
Yes indeed - it seems like the patch never found it's way into 4.1. I'm going to mark this as NEW and add Markus to see if he can help locate what fixed it with 4.2.
I just checked LO 4.1.3.1 from the web page. It also has this problem.
Indeed it will until you see "target 4.1" in the whiteboard here - until then you can assume we haven't located the patch which fixed it in 4.2
Honestly I have no idea. Maybe some parts of Kohei's rework. A bibisect identifying the commit is necessary if there is the need for a backport. Otherwise I suppose we can close this bug.
Unfortunately bibisect isn't very useful - surprisingly enough it always works fine from bibisect package throughout . . . just tested again on 4.1.2.3 release and it's still broken. That being said without a bibisect we just can't locate the code (and even if we could it would take an immense amount of time). So, ultimately this will be fixed shortly (upon release of 4.2). Alpha 1 is being released in just a week or so, you can verify that it's fixed in it. Closing as WFM
Migrating Whiteboard tags to Keywords: (bibisectrequest) [NinjaEdit]