I am getting many mails regarding OpenOffice, from people I do not know. What is happening, and can you stop this flood of mail?
Regards,
E. Hansen
On 11.02.2013 02:59, Jason Cipriani wrote:
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



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Reply via email to