[Libreoffice-bugs] [Bug 130020] CALC spreadsheet failed to save to dBASE format.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW

--- Comment #3 from Eike Rathke <erack at redhat.com> ---
You can't have columns of mixed types in dBase. If the first data row's cell
has numeric content then numeric/Decimal type is assumed, similar for
boolean/Logical and Date. However, you can force a field to type Text/Character
by appending ",C" (without quotes) to the field name, so in your case that
would be "CODE1,C". Then numeric cell content is converted to text for export.

All columns' data could be scanned whether they contain mixed types and then
switch to Character type, but.. that's rather a data layout error.

-- 
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/20200115/1abac475/attachment.htm>