[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work

Am 06.11.2010 17:16, gilles wrote:
> Le 04/11/2010 22:33, Andreas Säger a écrit :
> > Am 03.11.2010 23:12, bill woodruff wrote:
> > > mouse. And when I manually insert the range (i.e., =SUM(C2,C46))
> > > it returns a
> > > result of 0 (zero).
> >
> >
> > You try to sum numeric text (a sequence of digits).
> +1
> Perhaps an imported files with " ' " in front of each number: you don't
> see them in the sheet (let's say you have "123" in C3) but by clicking
> in it you can see: '123 in the "input line".


OK, then you should import numbers rather than text. If you import or 
enter text into your spreadsheets, Calc will treat it as text and no 
formatting will convert your values or modify them by any means.
When you re-enter all those values you see that they become numbers. 
Ctrl+F8 will highlight them in blue, they become right bound, they will 
be summed.
There is a semi-automatic method to re-enter all formulas of a selection:
Select the cells in question, apply any non-text number format and some 
appropriate number format locale (e.g. German for 1,99 decimals, English 
for 1.99 decimals, US English for 12/31 dates).
Edit>Find&Replace...
[More Options]
[x]Current Selection
[x]Regular Expressions
Search: .+
Replace: &
[Replace All]
The same method converts numbers to text when you apply a text 
formatting before the replacment.


--
E-mail to users+help@libreoffice.org for instructions on how to unsubscribe
List archives are available at http://www.libreoffice.org/lists/users/
All messages you send to this list will be publicly archived and cannot be deleted