[Libreoffice-bugs] [Bug 122909] New: V 6.0.7 or earlier: After opening a CSV file in Cal, all cells appear to be text, but cannot Format $xx.xx Cells to US Currency

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 122909
           Summary: V 6.0.7 or earlier: After opening a CSV file in Cal,
                    all cells appear to be text, but cannot Format $xx.xx
                    Cells to US Currency
           Product: LibreOffice
           Version: 6.0.7.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dmnordby at gmail.com

Description:
After opening a CSV file with CALC, tried to perform calculations example:
=sum(c2:c134) the result is 0. Cells in range appear to be text, but with no
apostrophe in front of the US currency value. After trying to Format Cells to
Currency, all the cells in the range now have an apostrophe inserted! After
manually removing the apostrophes, then the cells behave as numbers/currency.

Steps to Reproduce:
1.With Calc, open CSV file containing column of numbers (US currency)
2.Attempt to calculated sum of cells. [Cells are apparently test format.]
3.Format cells to US Currency
4.Look at cell content and note that each has an embedded "'" apostrophe,
indicating that they are  text!!!

Actual Results:
Cannot format apparently text cells to number, even though the cell content
appears to be a number, except the Format Cells Currency has added an
apostrophe ' designating the cell as text!!!

Expected Results:
Should be able to calculate.


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
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/20190123/7f570e8b/attachment.html>