Re: how to sum a column in openoffice calc

[Siard <shiems146@kpnplanet.nl>]

Li Wei wrote:
> I have attach the calc file, it's in Chinese, (sorry)
> my question is how to display sum(N1:N8) in cell N9

I can see it now.  N1:N8 do not contain numbers; they contain
alphanumeric strings.  If you select N1, then this is what you see in
the formula bar:  '-755.68
The apostroph it starts with, shows that this string is alphanumeric.

I don't know how you got those numbers there in the first place. There
must be a better way.
But there is a workaround.  Insert a new column O (next to N) and put
this formula in O1:  =N1+0   (0 = zero)
In LibreOffice, an addition like this converts the alphanumeric string
into a number.
Now copy O1 to O2:O8 and you'll see that SUM(O1:O8) in O9 works.