Johnny Rosenberg wrote:
2014-05-26 17:56 GMT+02:00 Hannes <han...@sacramentospur.co.za>:
Hi guys
My “sum” etc calc functions are’nt working. If you want to , for example ,
add the values of say column A1 to A5 , it just says “=A1:A5” , but does’nt
do the culculation ?
Kind regards
You said that your ”sum” function doesn't work, but how do you know? As far
as I can see, you don't use it…
This is how to use the SUM function for A1:A5:
=SUM(A1:A5)
If it now displays the formula rather than the result, check ”Tools →
Options” for something like ”show formulas” and uncheck it.
Johnny Rosenberg
Correct, typing "=a1:a5" is NOT the same as "=SUM(a1:a5)".
If this doesn't help, then the next question is whether other formulas
display the formula or the value? If they also display the formula, then
go to this menu path:
Tools > Options > Calc > View
Then under "Display", see if "Formulas" is selected (checked) or not. If
it is selected, than that's your problem -- just un-check the check box.
If it is not selected, then I'm at a loss as to what's going on, but
probably someone else on this list can offer a good suggestion.
-------------------------------------------
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
