[Libreoffice-qa] Informations and help for a bug report

[Terrence Enger]

Marina,

Thank you for taking the time to help us improve LibreOffice.

A bug report would be good, please.  Please add me
<lo_bugs at iseries-guru-com> to the CC.  I can confirm the bug, and I
hope to do a bibisect.

More comments in-line.

Terry.

On Tue, 2015-01-27 at 17:10 +0100, Marina Latini wrote:
> Hi all,
> 
> I'm writing here because I need to report a bug but I have some
problem to write the correct report.

This looks wonderful.  

> 
> I have a business xlsx file with complex formulas. In particular there
are:
> * matrix with nested indirect references
> * formulas that refer to a query from Excel.

My old LibreOffice complains

    This file contains links to other files.  Should they be updated?

When I click <No> it displays the file, but pegs the CPU for the few
minutes that I waited for it.

I presume that you have the linked-to file(s).  Do you get the same
result when you do and do not update the links?

> 
> I can't open the document with a LibreOffice version bigger then
3.6.7.2. All the 4.X versions hang during opening while LibreOffice
3.6.7.2 opens the file with some errors.
> 
> I can provide the xlsx file and 3 screenshots of the document opened
with Office365 and LibreOffice 3.6.7.2.
> I tested the files on my Ubuntu 14.04 x86_64 and on Windows Server
2012 R2
> 
> I don't know what LibreOffice version set in the report but I'm sure
that 3.6.7.2 opens the file.

Set the earliest version which you have observed to fail to open the
file.  Anybody who finds an earlier failing version will adjust the
LibreOffice version to the earlier version.

> 
> file to test: https://www.dropbox.com/s/4rmc162mgjisd4a/01%
20CLEAN.xlsx?dl=0
> 
> Screenshot from Office365:
https://www.dropbox.com/s/ws8rr3mj6juouuo/01Clean_Office365.png?dl=0
> Screenshot from LibreOffice 3.6.7.2 (query):
https://www.dropbox.com/s/00xnspejrrk1nfd/01CleanLibO-query3672.png?dl=0
> Screenshot from LibreOffice 3.6.7.2 (matrix with indirect):
https://www.dropbox.com/s/h5qtxf6ji9u71n2/01CleanLibO-indirect3672.png?dl=0
> 
> 
> Best,
> Marina