[Libreoffice-bugs] [Bug 115351] New: ISLOGICAL function depends on column formatting EDITING

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=115351

            Bug ID: 115351
           Summary: ISLOGICAL function depends on column formatting
                    EDITING
           Product: LibreOffice
           Version: 6.0.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: chemingway at semissourian.com

Description:
ISLOGICAL function does not always return TRUE when the column is not set to
precisely BOOLEAN
For instance, Setting a Custom format of T;;F will always return false.  Also,
ISLOGICAL does not change after the column format changes until the document is
reloaded or the formula in the target cell is modified.

Steps to Reproduce:
1. Create spreadsheet in LO 6
2. Set column A to custom format T;;F
3. Set Column B to Logical
3a. Set Column C to Number/Generic
4. Set the value =TRUE() in A1, B1 and C1
5. Set the value =FALSE() in A2, B2, and C2
6. Reference 6 cells with ISLOGICAL to the cells A1, B1, C1, A2, B2, C2.
7. Note items in column A are considered "False"
8. Note items in column B are considered "True" (Truthy?)
9. Note items in column C are considered "False"

Actual Results:  
Functions with custom T/F header are always considered FALSE() by ISLOGICAL(). 
ISLOGICAL should evaluate the function and not the header.

Expected Results:
ISLOGICAL should evaluate the function in the cell, not the cell format (okay,
a TEXT cell I *might* understand)


Reproducible: Always


User Profile Reset: Yes



Additional Info:
XLS/XLSX bug! When saving a spreadsheet to XLS/XLSX format BOOLEAN is converted
to TRUE;TRUE;FALSE, and all conditional formatting the references that column &
ISLOGICAL are broken. (Assuming that the CF is not stripped away altogether).

Oldest version that this still applies to v4.4.7.2


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101
Firefox/58.0

-- 
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/20180131/b2a1a817/attachment-0001.html>