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:
This is normal, and indicates that you haven't set import options such that it would detect special numbers (like currency). You either need to select proper options at import (first of them is the said "Detect special numbers", and it might be also necessary to tweak columns if their formatting does not conform to your locale's conventions), or after such import, when all the data is text, use Data->Text to Columns. *Formatting* already existing data will never change its data type, and only can alter visual representation (if applicable). See also this FAQ: https://wiki.documentfoundation.org/Faq/Calc/How_to_convert_number_text_to_numeric_data (there another way to convert is explained, using Find & Replace, but personally I prefer Data->Text to Columns). Closing NOTABUG.