I have field with value 1140. It has display format and displayed as 1,140.00
While converting to .csv the value should be converted as 1140, but it is converted to '1,140'
but this cause extra CSV field because ',' is separation
Steps to Reproduce:
1. create xls file with 1140 value which have display format 1,140.00
2. save file as .csv
it results into two fields with values 1 and 140
only one field should be: 1140
User Profile Reset: No
Thank you for reporting the bug.
Please attach a sample document, as this makes it easier for us to verify the bug.
(Please note that the attachment will be public, remove any sensitive information before attaching it.
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Also, could you give a try to a recent LO version?
Last stable one is 6.1.3
No response so I'll close.
Feel free to set Unconfirmed if you attach sample document.
There was tick "save data as shown"
Without it data saved as expected.