Hi Dennis, thanks for the reply.
I forgot to mention that I had cut (or copied) the table A3:E8 and then
pasted it with ctrl+shift+V; then in the copy context menu selected:
all+transpose. Just to change rows and colums.
The cell e.g. B6 is populated with formula =(B$5-$C$3)/$A6 ... can be
expanded to B8. (note: A6 has to be a non zero value)
After the transpose you see all errors !REF !Err522 and
whatyoudon'twannasee.
Thanks for noticing that. - I don't have an account to file a bug report or
escalate priority.
Thomas.
----- Original Message -----
From: "Dennis E. Hamilton" <dennis.hamil...@acm.org>
To: <users@openoffice.apache.org>
Cc: <thom...@streber24.de>
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 where all volunteer users
can cooperate on your problem. I do not promise to answer mail sent
directly 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) 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!
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
