https://bz.apache.org/ooo/show_bug.cgi?id=82687
--- Comment #6 from orcmid <[email protected]> --- (In reply to cheath from comment #0) > CSV import allows numbers to start with a currency symbol ($) or with zero > digits before the decimal point, but not both. For example, $.12 would be > imported as text, not 12 cents. [ ... ] > normal,9.84 > dollar,$9.84 > less than 1,.84 > only cents,$.84 > > I would expect all 4 entries in the second column to be imported as numbers, > but > OOo 2.2.1 only imports the first 3 entries as numbers. This suggests there has been a regression. It was pointed out that manual cell entry had a similar problem. I just manually entered the above into two columns (not via CSV) and the described behavior still occurs. $0.84 works. For *INPUT ENTRY* I agree, the $.84 should work. It apparently needs to make it into $0.84 though :). I left the $.84 as text and used the "Save Content as Shown" as well as quoting of text in making a CSV and I got, where the last column shows the values when I opened it in Excel 2016, "normal",9.84 9.84 "dollar",$9.84 $9.84 "less than 1",0.84 0.84 "only cents","$.84" $0.84 "alternative",$0.84 $0.84 with the additional space after the $ ones. The cell values (in the entry field) are without the $. On saving back out from Excel, there are no quotes and the "only cents" value is $0.84 with no quotes. LibreOffice 5.0.0 behaves the same as Apache OpenOffice 4.1.2 on input of the CSV. However, on entry of $.84 for cell input in the Calc UI, LibreOffice presents the value as $0.84 and as numeric. That's what Excel 2016 does too. I suspect one can make some form of remedy, although I wouldn't go so far as to have "$.84" with quotes be treated as anything but text. The Excel hack is odd in this case. -- You are receiving this mail because: You are on the CC list for the issue.
