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:
dev-unsubscribe@...
For additional commands, e-mail:
dev-help@...
