Re: [libreoffice-users] Python Equivalents for some BASIC uno calls

If you're using BASIC, use 'rem'


sent from mobile device

-----Original Message-----
From: Tom Davies <tomdavies04@yahoo.co.uk>
Date: Mon, 1 Aug 2011 12:34:14 
To: <users@global.libreoffice.org>
Reply-To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Python Equivalents for some BASIC uno calls

Hi :)
Is it possible to write comments into a macro?  Comments (that don't get 
executed) can help people reading the code to understand nuances more easily.
Regards from
Tom :)



________________________________
From: Onyeibo Oku <twohotis@gmail.com>
To: users@global.libreoffice.org
Cc: Andrew Douglas Pitonyak <andrew@pitonyak.org>
Sent: Mon, 1 August, 2011 10:54:24
Subject: Re: [libreoffice-users] Python Equivalents for some BASIC uno calls

On 01/08/2011 02:57, Andrew Douglas Pitonyak wrote:
> I do believe that you have seen AndrewMacro, which contains an example
> that demonstrates that yes, you can. Just OR the values together. I
> likely show the same thing in OOME. I am currently working through the
> Calc chapter as time permits. I need to hurry, because the German
> translator is translating faster than I am creating more content.

I saw it.  I just discovered that same effect can be achieved by adding
the values of the constants so I have something like:

.sheet.getCellRangeByName('A1:E20').clearContents(5) ... # 1 OR 4, for
Values & Strings according to your book.

That makes sense, but that will be confusing to read in the future so I
think I'll use defined constants as per Andreas' response:

.sheet.getCellRangeByName('A1:E20').clearContents(VALUE + STRING)

Thanks to all of you.

Onyeibo

-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted