bandsp
Newbie
Joined: 18 Feb 2012
Posts: 4
Location: Telford
|
 Posted: Sun Feb 19, 2012 6:52 am Post subject: (Solved) Calc Non-numeric cells .. |
 |
|
In OO Calc , non numeric cells were treated as 0 (zero) in calculations, so If I wanted to sum a column, cells which may be for various reasons, text or null, were treated as 0 (Zero) . in LibreO these cells blow the summing function giving #VALUE!
Can't find a way round it .. is there one?
Last edited by bandsp on Sun Feb 19, 2012 9:32 am; edited 1 time in total |
|
