[Libreoffice-bugs] [Bug 134691] Failure to reformat cells
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Fri Jul 10 08:55:14 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=134691
--- Comment #6 from Scott P <scott at smashcat.org> ---
This will work if the "Format quoted field as text" is unchecked at import.
However if file is imported with that field checked, using Data->Text to
Columns dialogue does not allow converting column to numbers. If imported as
numbers, then changing to "Text" in Data->Text to Columns works. However it is
then not possible to change back to numbers. Only option is to close document
and re-import again.
If this is "working as intended" then suggest dialogue is changed to reflect
the fact it cannot change columns containing numbers into actual numbers.
--
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/20200710/2ca05159/attachment.htm>
More information about the Libreoffice-bugs
mailing list