Hello Dmitry! Am 26.02.2008 17:45 schrieb Dmitry Teslenko: > Hello! > Some time ago I've needed to implement Excel-like Offset function and > I've got this: > Private Function __CompatOffset(ByRef objSource As Object, _ > intRow As Integer, intColumn As Integer) As Object > Dim intSheet As Integer > intRow = objSource.CellAddress.Row + intRow > intColumn = objSource.CellAddress.Column + intColumn > intSheet = objSource.CellAddress.Sheet > __CompatOffset = > ThisComponent.getSheets().getByIndex(intSheet).getCellByPosition( _ > intColumn, intRow) > End Function > > It was implemented in OO Basic. Can it be implemented another way w/o > struct CellAddress and w/o dispatcher?
Please describe how do you use this macro. Calc knows also a OFFSET-function. What is the difference to Excel, so that you created this macro? Mathias -- ·-· cut here ·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·-·->8·-· --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
