https://bugs.documentfoundation.org/show_bug.cgi?id=167675
Bug ID: 167675
Summary: Calc can not handle numbers with embedded commas in a
CSV
Product: LibreOffice
Version: 25.2.4.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Libre Office Calc can not handle FORMATTING numbers in a CSV file that are
formatted like
"$5,681.00","$0.00","$13,069.00","$1,201.00","$41,949.00"
It treats them as text and cannot convert to number or currency. Attempting
that prepends a ' character rather than the desired conversion.
Excel handles this situation with no problem. Furthermore when such a CSV is
saved as an XLSX in Excel then saved back to CSV the numbers with embedded
quotes now have a leading and training space e.g.
" $5,681.00 ", $- ," $13,069.00 "," $1,201.00 "," $41,949.00 "
I had hoped that making Libre Office do the right thing would be as simple as
adding the leading and training space before importing the CSV but alas that
did not work.
In short, Excel handles this but Libre Offie Calc does not. Additionally Calc
can't handle a formula where numbers are entered with commas whereas Excel can.
These may be two separate bugs or different manifestations of the same defect.
Steps to Reproduce:
1.Open a CSV that has numbers with embedded commas formatted like
"$5,681.00","$0.00","$13,069.00","$
2.Attempt to format the fields as currency or number
3.
Actual Results:
prepends a ' character rather than the desired conversion
Expected Results:
the field is converted to currency or number as it would be in Excel
Reproducible: Always
User Profile Reset: Yes
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Version: 25.2.4.3 (X86_64) / LibreOffice Community
Build ID: 33e196637044ead23f5c3226cde09b47731f7e27
CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render:
Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
