Holger Obst wrote:
Hi,
I'm looking for a solution with relative cell reference in ods. Is there a
way to set the cell reference in the same way like OpenXML code like
=R[-1]C[2] or =R1C[3] ? How can I do this in OpenDocumentSpread XML code? I
only found =(.A4) but I am looking for row and column reference from the
current cell. For example =R[2]C[3] means "go to the zell with the current
Row plus 2 and the current column plus 3". How can I do this in
OpenDocumentsSpreadsheet?
Thanks for help
Unfortunately this syntax is not supported. You have to use the obscure
A1:B2 - syntax
Assuming some sheets "Sheet1", "Sheet2", "Sheet3" and input in B2 of Sheet2:
$Sheet1.$A$1 is the absolute reference to A1 on Sheet1
Sheet1.$A$1 is the absolute reference to A1 on (relative) previous sheet
$Sheet1.A$1 is Previous column, row 1 on Sheet1
$Sheet1.$A1 is Previous row, column 1 on Sheet1
Relative and mixed referencing applies to named references as well:
Active cell is Sheet2.B2
runningTotal =SUM(B$1:B1)
=runningTotal calculates the sum of (this column)/first row) until (this
column, previous row) on any sheet (missing sheet identifier)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
