In the launchpad bug report (the link above) there is a discussion about
why OOo now behaves like this. I understood from this discussion that
upstream deliberate made this change for improved Excel compatibility.
I'm an experienced Excel user, and I certainly expect Excel to behave
the way OOo now
I'm still trying to understand the report:
> My suggestion woyld be to have an option where the user can choose that
> string values when present in an arithmetic formula are
> a. evaluated as real ( so "1.2"+3 equals 4.2)
> b. evaluated as integer ( so "1.2"+3 equals 4 )
> c. evaluated as
Yes, the bug i report is the same you mention.
The real severity of the bug (that otherwise should have been a wish list
item) is that the versions i download from openofficeorg behave
differently than the ones you get from debian site, and a file that have
expected results from one does not ha
Hi,
Leonardo Boselli wrote:
> Yes, the bug i report is the same you mention.
> The real severity of the bug (that otherwise should have been a wish list
> item) is that the versions i download from openofficeorg behave
> differently than the ones you get from debian site, and a file that have
To simplify this, I think you are saying that in v2.4, you see that a
formula like this
=if(A1-B1<>0;1;C1) returns an error 529 when C1 contains "" and A1 and
B1 are empty
I made a simplied test case in OOo 2.4 (the lenny version)
The formula behaves the same in 2.4 and 3.0. My 3.0 is the experiem
To simplify this, I think you are saying that in v2.4, you see that a
formula like this
=if(A1-B1<>0;1;C1) returns an error 529 when C1 contains "" and A1 and
B1 are empty
I made a simplied test case in OOo 2.4 (the lenny version)
The formula behaves the same in 2.4 and 3.0. My 3.0 is the experiem
> If you wish to submit further information on this problem, please
> send it to [EMAIL PROTECTED], as before.
additional notes:
I know that is a poor programming practice summing number and strings,
assuming strings are counted as 0 when summed, but nonetheless is the same
behaviour that other pr
Yes, it ist bug https://bugs.launchpad.net/openoffice/+bug/210153
but you miss one row in my line:
To simplify this, I think you are saying that in v2.4, you see that a
formula like this
=if(A1-B1<>0;1;C1) returns an error 529 when C1 contains "" and A1 and
B1 are empty
no, it is ok, but when C1
severity 504604 normal
thanks
The "data loss" rationale in this bug report is fairly weak.
The offending file (which you even didn't send to the bug report) is
not destroyed nor lost.
I'm not the package maintainer but, from the bug discussion, I don't
think this bugs deserves to be release crit
On Sat, 8 Nov 2008, Christian Perrier wrote:
The "data loss" rationale in this bug report is fairly weak.
The offending file (which you even didn't send to the bug report) is
not destroyed nor lost.
No, the file has not lost, but since one expect that between version of he
same program there is
Package: openoffice.org-calc
Version: 1:2.4.1-11
Severity: grave
Justification: causes non-serious data loss
Actually: it does not even read files made whit 2.3
i prepared an xls file usind a 2.0 version of ooo.
i updated many times, until about 20 days ago was ok.
now it is no longer read.
I
11 matches
Mail list logo