[libreoffice-users] Re: How may I read the value of a cell into a macro variable?

Le 29/10/2011 00:44, David S. Crampton a écrit :

Hi David,


> This question has two parts: simple and more complex:
>
> simple: I wish to read the value of the currently selected cell (in
> Calc, of course) into a variable in the macro language (Libre Basic).
> Script example please. and thank you!

I can't answer your question, but if you come from the world of VBA, 
this document might be of use :

http://documentation.openoffice.org/HOW_TO/various_topics/VbaStarBasicXref.pdf


> more complex: AFAIK the LibreHelp does not document the stuff like:
>
> dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args2())
>
> I used to be pretty skilled at recording macros and then modifying them.
> Where do I go to find things related to "uno:GoToCell"? Universal
> Network Objects? Can't find the "starting point".

Your best bet would probably be to read the API documentation :

http://api.libreoffice.org/

or alternatively the Sun OOo Basic Programming Guide :

http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide

or buy one of the books on Macro programming :
- OpenOffice.org Macros Explained by Andrew Pitonyak
- Learn Openoffice.Org Spreadsheet Macro Programming by Mark Bain



Alex


--
For 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