On Thu August 24 2006 11:18, + 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?
As you are not subscribed you may not have seen that:
On Thu August 24 2006 11:43, Andreas Saeger wrote:
>
> 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)
Please reply to users@openoffice.org only.
--
CPH : openoffice.org contributor
Maybe your question has been answered already?
http://user-faq.openoffice.org/#FAQ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
