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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from C Hemingway <chemingway at semissourian.com> ---
Bug Clarification:

When I save an XLS or XLSX spreadsheet with a Logical field, when I later
reload it, it loses the logical designation and becomes that
[>0]"T";[<0]"T";"F" format.

Clarification - on that 4th column, I changed the display format of the Boolean
field to T;;F.  When LibreOffice opens the file later, the boolean field has
become numeric, and the column becomes [>0]"T";[<0]"T";"F".  Should assigning a
custom display change the column type on reload?  For the ISLOGICAL test, is
LibreOffice remembering (caching?) that the column is Boolean until the
spreadsheet is reloaded?

My apologies if I am explaining this incorrectly.

-- 
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/20180227/bca92765/attachment.html>