Re: OO Calc transpose error

2015-03-17 Thread Brian Barker
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

Re: OO Calc transpose error

2015-03-16 Thread Thomas Drescher
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

RE: OO Calc transpose error

2015-03-16 Thread Dennis E. Hamilton
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