https://bugs.documentfoundation.org/show_bug.cgi?id=168364
--- Comment #13 from ady <[email protected]> --- Created attachment 207344 --> https://bugs.documentfoundation.org/attachment.cgi?id=207344&action=edit Direct result of importing the csv, as ods file (In reply to ace_dent from comment #12) > @ady - details from above, in the simplest form: > > Expected: > - Cell `B4` after import contains: '01 > > Actual: > - Cell `B4` after import contains: ''01 Again, the first apostrophe is only relevant when you type-in a value that _looks_ as a number (so Calc would normally parse it as a numeric value) but you actually want it to be parsed as text. I am attaching an ods file that is a direct result of importing attachment 202798, possibly with different options than what you used. IIUC, that is the result that you seem to expect. On this attached ods file, if you expand the width of the relevant column, you should see that the values are aligned to the left, not because I set it so but because they are parsed as text, as you expected. There are no duplicated apostrophes (single quotation marks) in the ods, as you expected. I already said that I have no way to know whether there is really a bug or not. I can only say that I am able to achieve the expected result. -- You are receiving this mail because: You are the assignee for the bug.
