https://bugs.documentfoundation.org/show_bug.cgi?id=153767
Bug ID: 153767
Summary: FILEOPEN XLSX Boolean formula results not loaded,
needs recalculation
Product: LibreOffice
Version: 6.2.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: bibisected, bisected, regression
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Blocks: 108897
Created attachment 185504
--> https://bugs.documentfoundation.org/attachment.cgi?id=185504&action=edit
The Customers2 tab in Excel and Calc
attachment 185496 from bug 153763 has the following formula on the Customers2
sheet in the H3:H20 range:
=NOT(IF(G3>1;TRUE;FALSE))
When the file is loaded, all cells in the above range open with the value 0
instead of a series of TRUE/FALSE.
1. Open attachment 185496
2. Go to the Customers2 sheet
3. Observe that the H3:H20 range has the 0 values
4. Press F9
-> the values change to TRUE/FALSE according to the formula result. These match
what Excel shows.
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 16a35542aa07ed69c6c699d1c17f076d87708958
CPU threads: 14; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: threaded
Started in 6.2 with:
https://git.libreoffice.org/core/+/bd3baf8dab6c5b8865a33136cc28a016e6ee6afb
author Eike Rathke <[email protected]> Tue Jul 17 12:58:30 2018 +0200
committer Eike Rathke <[email protected]> Tue Jul 17 17:19:13 2018 +0200
OOXML import: CalcFormulaTree() is unnecessary, tdf#94925 follow-up
Adding CC to: Eike Rathke
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
--
You are receiving this mail because:
You are the assignee for the bug.
