Download it now!
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)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX
  Show dependency treegraph
 
Reported: 2019-01-14 20:25 UTC by byronigoe
Modified: 2019-01-16 16:34 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


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

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
Description:
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

Version: 6.3.0.0.alpha0+
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

Version: 5.2.0.0.alpha0+
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.15; Render: default; 

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4