Bug 122715 - FILEOPEN XLSB format is inconsistent with Excel with incorrect cell references and hiding
Summary: FILEOPEN XLSB format is inconsistent with Excel with incorrect cell reference...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on:
Blocks: XLSX
  Show dependency treegraph
Reported: 2019-01-14 20:25 UTC by byronigoe
Modified: 2021-01-29 12:31 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:

Illustrates the bug (58.65 KB, application/vnd.ms-excel.sheet.binary.macroEnabled.12)
2019-01-14 20:27 UTC, byronigoe
comparison MSO 2010 and LibreOffice 6.3 Master (150.64 KB, image/png)
2019-01-16 16:31 UTC, Xisco Faulí

Note You need to log in before you can comment on or make changes to this bug.
Description byronigoe 2019-01-14 20:25:58 UTC
I received an XLSB file and opened it in LibreOffice Calc. The total formulas at the bottom show different numbers than if you open the same file in MS Excel. It seems that some rows were hidden in the Microsoft file, but Calc shows them. This causes the cell references to be out of sync, and thus incorrect.

Steps to Reproduce:
0. Open the attached file in both LibreOffice Calc and Microsoft Excel
1. Look at cell F72 in both
2. Look at cell D18 in both

Actual Results:
1. 131,400
2. TJ681AAE

Expected Results:
1. 107,100
2. TG627BA

Reproducible: Always

User Profile Reset: Yes

Additional Info:
Comment 1 byronigoe 2019-01-14 20:27:34 UTC
Created attachment 148316 [details]
Illustrates the bug
Comment 2 Durgapriyanka 2019-01-15 16:00:21 UTC
Thank you for reporting the bug. I can confirm this bug in

Build ID: 3c964980da07892a02d5ac721d80558c459532d0
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 3 Xisco Faulí 2019-01-16 16:31:49 UTC
Created attachment 148365 [details]
comparison MSO 2010 and LibreOffice 6.3 Master
Comment 4 Xisco Faulí 2019-01-16 16:34:22 UTC
Also reproduced in

Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.15; Render: default; 

Version (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-
Comment 5 QA Administrators 2021-01-16 04:16:54 UTC Comment hidden (obsolete)
Comment 6 Roman Kuznetsov 2021-01-29 12:31:41 UTC
still repro in

Version: (x64)
Build ID: 94f6765d6ecc3145fa2d266231124003cf953118
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded