[Libreoffice-bugs] [Bug 135000] FILEOPEN: CSV: boolean import option

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|6.4.5.2 release             |unspecified
           Hardware|x86-64 (AMD64)              |All

--- Comment #1 from Eike Rathke <erack at redhat.com> ---
Fwiw, one already gets that for true and false if in the import dialog "Detect
special numbers" is activated, which then imports them as 1 and 0 formatted
with BOOLEAN to TRUE and FALSE. Columns with numeric values (e.g. 1 or 0) can
always be assigned the BOOLEAN number format after import.

I don't know if we would gain much with an explicit Boolean column type, though
it might be nice in some circumstances. Note however that forcing to Boolean
could hide values other than 0 or 1 because any numeric value other than 0 is
formatted to TRUE. Of course the import could not apply the BOOLEAN format for
other values to make them stand out, ending up with a column of mixed types
again.

-- 
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/20210126/4d38b905/attachment-0001.htm>