https://bugs.documentfoundation.org/show_bug.cgi?id=143943
Bug ID: 143943
Summary: [FILEOPEN] XLSB booleans interpreted as numeric
formulae
Product: LibreOffice
Version: 7.3.0.0 alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
LibreOffice translates both `BrtCellBool` (record type 4) as well as
`BrtShortBool` (record type 15) to numeric expressions.
Steps to Reproduce:
download and open
https://github.com/SheetJS/notes/raw/main/xlsb_short_records/brt_sst.xlsb
Actual Results:
cell A4 is 1 (formula expression `=TRUE()`)
cell B4 is 0 (formula expression `=FALSE()`)
Expected Results:
Cell A4 is `TRUE` (the value TRUE)
Cell A4 is `FALSE` (the value FALSE)
Reproducible: Always
User Profile Reset: Yes
Additional Info:
XLSB differentiates the literal true (record type 4 `BrtCellBool`) from the
formula =TRUE() (record type 10 `BrtFmlaBool`)
--
You are receiving this mail because:
You are the assignee for the bug.
