At 20:45 16/03/2015 +0100, Thomas Drescher wrote:
There's a severe transpose error since several versions of OpenOffice Calc:
simple table (5cols, 6rows) A3:E8; cell B6: =(B$5-$C$3)/$A6
erroneous result: =(D$5-$C$3)/$A4
the correct result should be: =($C4-$A$5)/D$3 !
Er, you need to say what yo
nis E. Hamilton"
To:
Cc:
Sent: Monday, March 16, 2015 9:56 PM
Subject: RE: OO Calc transpose error
Thomas, there seems to be a missing statement.
Where are you seeing the erroneous result formula and how was that cell
populated?
- Dennis
PS: Please reply to users@openoffice.apache.org
to me.
-Original Message-
From: Thomas Drescher [mailto:thom...@streber24.de]
Sent: Monday, March 16, 2015 12:46
To: users@openoffice.apache.org
Subject: OO Calc transpose error
There's a severe transpose error since several versions of OpenOffice Calc:
simple table (5cols, 6rows)
There's a severe transpose error since several versions of OpenOffice Calc:
simple table (5cols, 6rows) A3:E8; cell B6: =(B$5-$C$3)/$A6
erroneous result: =(D$5-$C$3)/$A4
the correct result should be: =($C4-$A$5)/D$3 !
ciao!
