Calc will not calculate Sum

English
#1

I am attempting to calculate the total payments in a comma-delimited CSV file downloaded from Amazon payments. Calc formatted the file correctly and is displaying the payments in column F, rows 2 through 1723. However, using this formula in a cell

 =SUM(F2:F1723)

results in Calc simply displaying the formula and not the actual sum. Tools > Cell Contents > AutoCalculate is turned on. Options > LibreOffice Calc > View > Formulas is not turned on. Pressing F9 changes nothing. I am at a loss as to what could be causing this, but it very clearly seems like a bug.

#2

Hi @Craig, if your locale has comma as decimal separator, maybe the values have been imported as text. You can set up when importing, clicking on the field header and selecting ‘US number’ for import.

#3

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.