Am Montag, den 06.07.2009, 11:55 +0800 schrieb 陈浩(Chen Hao): > Johnny Rosenberg sent this to the list ,months age . I think maybe it's what > you need. > > > 2009/5/22 陈浩(Chen Hao) <[email protected]>: > > When I use the MS-Excel , I offen use "Ctrl+;" to insert the current > > date to a cell or after some strings in a cell. > > But i find OOo-Calc did not supply this function or I haven't found it. > > > > So i want to write a Macro to do this , but there are two problems , > > and i think maybe someone could give me a hand. > > > > 1. how to get the current selected cell with basic ? So that i could > > modify it . > > 2. how to change the path that saving the user-defined macros? I offen > > forgot to backup those things in C-disk when i reinstall my Windows OS > > >_< > > > > Thanks very much! > > > > Chen Hao > > Dalian , China > > Here's a macro I fou(nd in a forum somewhere: > > REM ***** BASIC ***** > > Option Explicit > > Sub InsertDate > Dim oCell As Object > > oCell=ThisComponent.getCurrentController().getSelection() > If oCell.SupportsService("com.sun.star.sheet.SheetCell") Then > ' Selection is a single cell > oCell.setValue(Now()) > Else > MsgBox "You can't do that here" > EndIf > End Sub > > So obviously the currently selected cell is > ThisComponent.getCurrentController().getSelection() > > To get the current stuff from it there are things liks getValue() and > getString(). > To change the value, you can use, for example, setValue(47.3) and > setString("Hello World") respectively. > > I think there are also a getFormula() and setFormula() available, but I am > not sure. Use Xray to find out what methods are available for a specific > object. It's the most helpful tool I used so far with OpenOffice.org BASIC. > I think it is installed by default these days, if not you can find it > somewhere, use google… > > Well, I guess you got it by now. > > Johnny Rosenberg > > > > > -----邮件原件----- > 发件人: Julius [mailto:[email protected]] > 发送时间: 2009年7月5日 1:36 > 收件人: [email protected] > 主题: [users] uno python/calc > > Hi, > > i found this example > http://www.linuxjournal.com/content/python-pyuno-hello-world-addon-openoffic > e > > there they select a cell with: > cell = sheets.getByIndex(0).getCellByPosition(0, 0) > > How can i select a cell in calc and then run my script with that cells > location as argument? > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] For additional > commands, e-mail: [email protected] > > --------------------------------------------------------------------------------------------------- > Confidentiality Notice: The information contained in this e-mail and any > accompanying attachment(s) > is intended only for the use of the intended recipient and may be > confidential and/or privileged of > Neusoft Corporation, its subsidiaries and/or its affiliates. If any reader of > this communication is > not the intended recipient, unauthorized use, forwarding, printing, storing, > disclosure or copying > is strictly prohibited, and may be unlawful.If you have received this > communication in error,please > immediately notify the sender by return e-mail, and delete the original > message and all copies from > your system. Thank you. > ---------------------------------------------------------------------------------------------------
Ah, thx. Yes the method is available in pyuno. greets --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
