Hello! On Sat, Mar 1, 2008 at 3:32 PM, Mathias Röllig <[EMAIL PROTECTED]> wrote: > Calc knows also a OFFSET-function. What is the difference to Excel, so > that you created this macro?
I've created it because I couldn't find OO analogue. I have a legacy Excel Macro that I has been porting to OO. There was a trick in that macro: one obtains named range object then obtains neighbor cells with <named range>.Offset(). OO's proposed analogue to Offset is .getCellByPosition(). But in this case neighbor cell is clearly lies outside named range, so .getCellByPosition() throws IndexOutOfBounds exception while MS Excel swallows it.
