Re: Macro for filling in blank cells.

2013-02-11 Thread Andrew Douglas Pitonyak
AndrewMacro.odt (link to it below) provides working examples On 02/10/2013 08:26 PM, Jason Cipriani 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

Re: Macro for filling in blank cells. (Elisabeth Hansen)

2013-02-11 Thread Andrew Douglas Pitonyak
Elisabeth, You are subscribed to the openoffice mailing list where people post questions and the questions go to everyone that is subscribed. To get off the list, if you desire to do so, simply send an email to: users-unsubscr...@openoffice.apache.org On 02/11/2013 06:35 AM, Elisabeth Hans

Re: Macro for filling in blank cells.

2013-02-11 Thread Elisabeth Hansen
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/a

Re: Macro for filling in blank cells

2013-02-10 Thread Jason Cipriani
On Mon, Feb 11, 2013 at 1:55 AM, Brian Barker wrote: > At 20:26 10/02/2013 -0500, Jason Cipriani wrote: > >> 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

Re: Macro for filling in blank cells

2013-02-10 Thread Brian Barker
At 20:26 10/02/2013 -0500, Jason Cipriani wrote: 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

Re: Macro for filling in blank cells.

2013-02-10 Thread Jason Cipriani
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 prov