On 06/19/09 11:50, Johnny Rosenberg wrote:
I have a little follow up question to this:
When OpenOffice.org 3 arrived, some of my formulas stopped working,
because in some of my calculations a few empty cells were apart of it.
They told me that empty cells doesn't have the value 0 anymore, like
it had before and they also said that this is a good thing and so on.
So I had to modify a lot of formulas to make my spreadsheets work
again. Not too hard, but a lot of work. Now it seems like empty cells
are considered 0 again, at least I couldn't reproduce that ”new”
behaviour anymore.
The problem described in this thread was tested on OpenOffice.org Calc
3.1.0. I also have a OpenOffice.org Calc 3.0.1 installation on a
Mandriva system. Maybe I should try the same thing on that one too.
Maybe the outcome will be different?
Handling of empty cells in formulas was changed in 3.0
(http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=263), but
not for Basic functions. That's still valid in 3.1. It's hard to say
what causes your changed results without seeing the formulas.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
