I'm trying to write this macro in BASIC but I'm finding the documentation at http://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/module-ix.htmlto be somewhat of a nightmare.
Where is "getCurrentSelection" in that documentation (I was unable to locate the service or interface that provides it) and what does it return? My simple code copied from an example in that documentation: Sub Main sel = ThisComponent.getCurrentSelection() count = sel.getCount() End Sub Fails saying "getCount" is not a method of sel (there is no "Count" property either). Is there a convenient API reference guide somewhere? E.g. what's the most direct way, given the documentation, to find the answer to the question "What does getCurrentSelection() return for an Open Office Spreadsheet?" Thanks, Jason On Sun, Feb 10, 2013 at 8:26 PM, Jason Cipriani <jason.cipri...@gmail.com>wrote: > Hi, > > I'd like to be able to go down a column, and fill every blank cell with > the same content as the first non-blank cell above it. So if I have: > > 5 > *blank* > *blank* > *blank* > 6 > 7 > 8 > *blank* > 9 > *blank* > 10 > *blank* > > I want to be able to select those cells in that column and have it changed > to: > > 5 > 5 > 5 > 5 > 6 > 7 > 8 > 8 > 9 > 9 > 10 > 10 > > Is it possible to write a macro to do this (or is there maybe something > already built in)? I have never done any work with OpenOffice macros, and > I'm not really sure how to start. > > Thanks! > Jason >
