I imported a csv file from bank and it was properly imported into calc - all data was there and properly formatted. However, the SUM function when used to total columns of numeric data, returned a 0. Other simple operations like add, subtract, etc work fine. The SUM function works fine on a new worksheet or a Microsoft Office Excel file but not the CSV imported file.
Steps to Reproduce:
1.Import a CSV file into Calc
2.Choose a column of numbers and use the SUM function to total values.
3.All other operations like add, subtract seem to work fi
SUM of data was always 0
User Profile Reset: No
Returned the sum of the chosen numbers.
please attach your csv file and add info from Help->About LibreOffice dialog here
please enable Menu "View - Value Highlighting" to check if the values have been imported as "text" instead of values.
sum function will not work with "text" values.
it turns out, that the values have been imported as "text" instead of values.