https://bugs.freedesktop.org/show_bug.cgi?id=51136
Alex Thurgood <ipla...@yahoo.co.uk> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |ipla...@yahoo.co.uk
--- Comment #5 from Alex Thurgood <ipla...@yahoo.co.uk> 2012-06-21 23:29:21 UTC
---
(In reply to comment #0)
> I decided I did not want to have to rebuild this tool (over 1000 rows/10
> columns).
You don't have to rebuild the tool.
The problems occur where an operation is performed on a cell that is NULL. This
is evaluated as a string, thus any mathematical operations involving a NULL
string will fail and return an error.
If you type in the number '0', as you have done so already in certain places in
your sheet, then the formulae will evaluate correctly.
Also, although, I didn't try or test, it might just work if you format all of
your cells as Numbers, since I guess the default for them is now Text.
I remember reading about the rationale behind the change in this behaviour
(which was deliberate, I seem to recall), but don't recall what it was exactly,
something to do with printing sheets that had null values showing up as zeroes
or something like that.
So, for me, this is not necessarily a bug, but a new feature. However, I can
understand that it loses compatibility with the default behaviour of AOO and
all previously made OOo Calc documents.
Alex
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
