Spotty access to email and short on time....
The included help does not include API level documentation since most
people have no need for it.
Sadly, I have no ability at the moment to generate an example, but, you
can find numerous examples in AndrewMacro.odt for this. I believe that
there will be a better explanation in OOME as available on my web site. If
you download that and it does not yet contain Calc examples, shoot me a
private email and I will push a copy that (although incomplete) will
contain an example of how this is done.
In brief, the idea is that you:
1. Obtain a reference to the document. If it is the current document, then
you can use the variable "ThisComponent".
2. Get a reference to the sheet containing the cell. In most cases, you
can do something like the following:
ThisComponent.sheets.getByIndex(0) ' Get the first sheet
ThisComponent.sheets.getByName("Investments") ' Get a sheet by name
Sometimes you simply want to get the currently active sheet, which is a
bit more difficult. It probably looks something like the follow (from
memory so I am probably wrong).
ThisComponent.CurrentController.ActiveSheet
After you have the sheet, then you can get the cell. Again, this is all
from memory, so I am likely totally wrong, but it probably looks something
like:
oSheet.getCellByPosition(1,2) 'Cell B3
oSheet.getCellRangeByName("B3")
A cell range with a single cell returns that cell I believe.
Next, you must decide how to get the contents of the cell. Do you want the
contained formula, a numeric value, or a string representation?
Oh, and David, I copied you with a BCC because I do not know if my post to
the list will go through based on the credentials used to send this email.
Andrew Pitonyak
On Sun, 30 Oct 2011 11:13:40 +0000 (GMT), Tom Davies
<[email protected]> wrote:
> Hi :)
> There are various books and guides about Macros. I've been told by
> various people that Andrew Pitonyak's is excellent. Hopefully the link
is
> on this page
> http://wiki.documentfoundation.org/Documentation/Publications
>
> I'm not sure if that will help with the specific problem as we might
need
> to collect links to more external resources onto that page.
> Regards from
> Tom :)
>
>
> --- On Sat, 29/10/11, David S. Crampton <[email protected]> wrote:
>
>> From: David S. Crampton <[email protected]>
>> Subject: [libreoffice-users] How may I read the value of a cell into a
>> macro variable?
>> To: [email protected]
>> Date: Saturday, 29 October, 2011, 0:44
>> 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!
>>
>> 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".
>>
>> Thank you for an orientation,
>> --David S. Crampton
>>
>> --For unsubscribe instructions e-mail to:
>> [email protected]
>> 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
>>
>>
--
For unsubscribe instructions e-mail to: [email protected]
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
