[Libreoffice-bugs] [Bug 137651] Importing CSV automatically converts data with no possibility of tweaking

[bugzilla-daemon at bugs.documentfoundation.org]

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

Jean-Baptiste Faure <jbfaure at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |WORKSFORME
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |jbfaure at libreoffice.org

--- Comment #3 from Jean-Baptiste Faure <jbfaure at libreoffice.org> ---
(In reply to Andrei from comment #0)
> [...]
> Expected Results:
> 1. preview data consistent with data after import

Solution given in comment #1. Note that the case of numbers with leading 0 like
phone numbers is explicitly mentioned in the help.

> 2. have an option to not convert data at all (eg: leave everything as text)

I think that is not a so good idea because CSV are mainly used for numbers, not
for text, and there is probably very few examples of CSV files without numbers.
So, even you have 100 columns of text, it is enough you have 1 column of
numbers, to make this option useless.
Note that this option would be useless for a CSV file with the kind of data
given in the bug description.

So I close this bug report as worksforme. Please feel free to reopen if you
disagree. In that case thank you for adding arguments.

Best regards. JBF

-- 
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/20210511/6d9ce89e/attachment.htm>