open csv file with fields in the format "......";
select field, apply any field format to it (like text, date, number)
field appears in the applied format
field does not change its appearance, because an apostrophe ' is added as a prefix. If this is deleted manually, the field shows its expected appearance.
Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug.
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
Created attachment 124468 [details]
CSV table with bank account data (stripped from personal information).
This isn't a bug - the formatting of the fields comes in as text. You can use an addon to fix this:
You can google "number formatted as text" and you'll get a ton of explanations as to why this happens.
Thanks for clarification.
I learn that it's called a feature.
I would call it nevertheless a problem puzzling a lot of people, forcing them to do lengthy researches and procedures to do a thing, that could as well be done simple, if only included into the core functionality.
An unsurmountable problem for the non-computer-savvy.
I'll try to make a feature request out of it.
Then it's a dupe. Also NEW is never correct for the reporter (UNCONFIRMED is the right move). But here this can be a dupe:
*** This bug has been marked as a duplicate of bug 33962 ***