Hello Martin, On Sunday 23 May 2010, 16:46, Martin Dobiasch wrote: > The addin should find the area in which the sheet is filled. > This thing will be used for educational use. So it should help > People who don't have much experience with calc. The specify the > Starting cell and use the function to access the area. So the can > Add data to the range without caring about the address. > > I'm doing this for a teacher ... > > He has written this for Excel. Where it looks like this (Basic-Code): > > Public Function CSDRightFrom(startcell As Range) As Range > Set CSDRightFrom = Range(startcell, startcell.End(xlToRight)) > End Function > Public Function CSDRangeAddress(arg As Range) As String > CSDRangeAddress = arg.Address > End Function > > To use it he calls > CSDRangeAddress(CSDRightFrom(A1)) > In that AddOn there are some functions which are reading cell ranges.
this looks as if you wanted to get a cell range as parameter, and in this cell range write your result. This is possible, but IMHO is a NO-NO. As you've been told on Tuesday, you can get a cell range as parameter to your function, but it isn't " the area in which the sheet is filled" by your function's result. IMHO an Add-In should not modify the document (a sheet, a range, etc). OOo Calc Developers read this mailing list, so sure they will give on Monday a more accurate opinion. Regards -- Ariel Constenla-Haile La Plata, Argentina
signature.asc
Description: This is a digitally signed message part.