[Libreoffice-bugs] [Bug 143943] New: [FILEOPEN] XLSB booleans interpreted as numeric formulae

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: dev at sheetjs.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210818/f90aaf78/attachment-0001.htm>