Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 30 Dec 2017 10:52:44 +0100csv column weirdhttps://ask.libreoffice.org/en/question/141887/csv-column-weird/I imported a csv delimitered file to a spreadsheet and there was a column of $values....$400.00...$350.00 etc.
On the above a cells formula of ...= (A1+A2) will produce 750.00 (no $)
But if I try SUM or COUNT etc on a column of such derived numerical-only cells, it fails. They all produce zero ....0.
If I do COUNTA, it will give me a figure (surely a COUNT is a COUNT of cells?)
But sum(A5:A12) = 0
I tried formatting the column to a simple numerical format, but it stayed unchanged...formatted as currency (???), and still no ability to SUM or COUNT, but still with the ability to have MATH operators on individual cells.
If I take a cell and ask for "=a5", I get A5's value...but if I try a Sum on a column of such results......0.
However if I enter the formula "= A5*2" I get a value of twice A5. So I enter "=A5*2/2" and it gives me a value of the value of A5.
....and then if I copy and paste that formula to a whole column, I can SUM(G5:G12) and it works...as does COUNT.
I am puzzled and would greatly appreciate help, please. All I wanted was to sum a column of imported, apparently numerical, figures. Even now I have a workaround it will be a nuisance.
Nick
EDIT: Further to this, if I actually enter -400.00 into a range of cells that are in my imported column, then format those cells as Numeric 1000.00, I _still_ cannot SUM them. I noticed that at the beginning of each cell's text there was a single quote. Removing that manually from each cell made SUM work.
Asking for such ideas a RIGHT (cell number) X digits still did not let SUM etc work.OldNickSat, 30 Dec 2017 10:52:44 +0100https://ask.libreoffice.org/en/question/141887/