[Libreoffice-bugs] [Bug 110750] Date format change brings ' symbol in value but doesn' t change the cell format

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from Alex Thurgood <iplaw67 at tuta.io> ---
Check in particular to see whether when you drag and drop the CSV file onto a
running instance of LibreOffice, that your import options dialog "Field between
quotes as text" unticked.


I tried this with a sample Paypal account activity export and I'm afraid I
don't encounter the problem you are seeing - the date strings are imported
correctly without an additional apostrophe, and show up as dates in the Format
dialog.

As for your link, thanks, but clicking on it informs me that it requires Flash,
which I avoid installing for various security reasons.


At least as far as I'm concerned, this is WORKSFORME, but it may be dependent
on your locale settings and the export format offered to you by Paypal (hence
playing around with the import options when opening the CSV in LibreOffice is a
good thing to try).

-- 
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/20170803/882f01aa/attachment.html>