[Libreoffice-bugs] [Bug 130020] No warning displayed even if error/warning code was set when spreadsheet data fails to save to dBASE format.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Athos <szat07 at gmail.com> ---
(In reply to Eike Rathke from comment #3)
> 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.

The ",C" post-field-name addition is not a bad idea, but doing hundreds or 1000
columns is a big job.
It would be better if you took the dBASE data field type from the table column
type.

-- 
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/20200116/fd9736e1/attachment.htm>