https://bugs.documentfoundation.org/show_bug.cgi?id=156861
Bug ID: 156861
Summary: FILEOPEN XLS, Function with logic answer gives back 1
or 0 in LO
Product: LibreOffice
Version: 4.1 all versions
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: bibisected, bisected, filter:xls, regression
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Blocks: 109072
Function in xls with logic formula shows 0 or 1 in LO while in Excel it shows
TRUE or FALSE. This is the XLS version of XLSX bug 122098 (broken from
4.2-7.3.2).
Steps to reproduce:
-Open attachment 185193 (seriesexport.xlsx) from bug 153425. Notice true/false.
-export as XLS format and reload. notice 0/1.
History:
Starting in LO 4.2, importing the xlsx (or the round-tripped xls) showed
general-number-formatted logic functions as 0/1 instead of true/false with
linux bibisect commit 8e7bade4e7314a340c77edd9042e230f61f0323d
Bibisect: This commit covers the following source commit(s) which failed to
build (at which point we have a total re-write of how cells store formula data)
https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=c7bdee8dbd1cf260a8513a0d31b36f90daa70f1c..ec0080c40cfdb26896537f47a4c2e0439f9afd
However, the underlying "stuff" in xls export is unchanged because in older
versions it still showed as true/false. In fact, 24.2's export to XLS looks
fine in OOo 3.3 - 4.2.
FYI: In Excel 2010, the resulting XLS file opens and shows true/false. The
formula in XLSX in Excel is =TRUE(), but in XLS in Excel the formula is =TRUE.
LO shows the formula as =TRUE() [The difference is whether the '()' are used.]
Excel UI does not seem to have a "Boolean" format category like LO does -
although the XLSX format DOES have a boolean specifier, so maybe XLS does too.
Since LO only "displays" boolean when the formatting is boolean, at least
import needs to be smarter about this.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=109072
[Bug 109072] [META] XLS (binary) format bug tracker
--
You are receiving this mail because:
You are the assignee for the bug.
