[Libreoffice-bugs] [Bug 116340] New: FILEOPEN XLSX Opening an .xlsb file with LibreOffice Calc is much slower than opening the same file with .xlsx extension

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 116340
           Summary: FILEOPEN XLSX Opening an .xlsb file with LibreOffice
                    Calc is much slower than opening the same file with
                    .xlsx extension
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kelemeng at ubuntu.com

Created attachment 140551
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140551&action=edit
Example file from Excel 2013

FILEOPEN XLSX Opening an .xlsb file with LibreOffice Calc is much slower than
opening the same file with .xlsx extension

The main problem here is the time difference of opening an .xlsb file compared
to an .xlsx file. The reason of the slower file load is the conversion of a
function formula. Certain references in an .xlsb file were replaced with
another function.

Steps to reproduce:
1. Create a new spreadsheet with Microsoft Excel 2010/2013/2016
2. Insert a three columns table to the spreadsheet.
3. Insert a letter to the first column (Column1) and insert numbers to the
second column (Column2) from the first row of the table to the 10000th row at
least. (just to see the import of time difference) 
4. Insert this function
“=IF(A4="";"";IF(COUNTIF(Táblázat1[Oszlop2];B4)>1;"dupla!";"OK"))” to the third
column (Column3) from the first row of the table to the 10000th row at least.
5. Save the file as *.XLSX and save as an *.XLSB file with Microsoft Excel.
6. First, open the *.XLSX file with LibreOffice Calc. (it will be opened very
fast and the function remains unchanged)
7. Second, open the *.XLSB file with LibreOffice Calc. (it will be opened much
more slower than the *.XLSX file and the function changed)

Actual results:
After we opened the *.XLSB file the function looked like this:
“=IF(A21="";"";IF(COUNTIF(OFFSET(Táblázat1;1;1;ROWS(Táblázat1)-1;1);B21)>1;"dupla!";"OK"))”.
The “Táblázat1[Oszlop2]” reference was replaced with
“OFFSET(Táblázat1;1;1;ROWS(Táblázat1)-1;1)”. Because of this the file opened
much more slower than an *.XLSX file.
We met an *.XLSB file which contains much more data (25000 Kb) than the example
file. Because of this problem LibreOffice Calc 6.0.0.1 could not open that file
and soffice.exe/soffice.bin was frozen.
Another problem:
If we open the *.XLSB file with LibreOffice Calc and save as *.XLSX (because in
the LibreOffice Calc we cannot save as *.XLSB), the modified formula was saved
of course. And we open it with Microsoft Excel we got a #NAME? error message in
the cells.

Expected results:
The function formula should not be modified after we import an *.XLSB file
(because of the loading time). In the *.XLSX file the function formula was not
modified.

Version: 6.0.0.1.0+
Build ID: c678dc5309741097d9b0265f03dd279a8794d256
CPU threads: 4; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86 at 42, Branch:libreoffice-6-0, Time: 2017-12-28_04:21:33
Locale: hu-HU (hu_HU); Calc: group

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180310/79610f9b/attachment.html>