<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Failure to reformat cells" href="https://bugs.documentfoundation.org/show_bug.cgi?id=134691#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Failure to reformat cells" href="https://bugs.documentfoundation.org/show_bug.cgi?id=134691">bug 134691</a> from <a class="email" href="mailto:scott@smashcat.org" title="Scott P <scott@smashcat.org>"> Scott P</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>