OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

CALC: Worksheet change event & Calc access to macros

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
Glenn1000
Newbie
Newbie


Joined: 16 Jun 2005
Posts: 1

PostPosted: Thu Jun 16, 2005 5:42 pm    Post subject: CALC: Worksheet change event & Calc access to macros Reply with quote

I am en engineer migrating some macros from VB to OO. Generally everything has gone OK except for two problems:

1. In Excel we have spreadhseet which would call a macro whenever the spreadsheet data was changed. This macro would then check what was changed and if it was relevant perform some calculations and write the results back to the spreadsheet. In Calc I can find no similar event which a macro can be assigned to. Any suggestions?

2. We have a number of common macros used by a number of spreadsheets - these have been stored in a library in My Macros. When a spreadsheet opens it runs a macro which loads the library. The macros in the library are then exposed OK to basic macros in the spreadsheet, but don't seem to be available to the spreadsheet cell as a formula. Any suggestions as to how these can be exposed?
Back to top
View user's profile Send private message
ms777
Super User
Super User


Joined: 07 Feb 2004
Posts: 1355

PostPosted: Thu Jun 16, 2005 11:57 pm    Post subject: Reply with quote

Quote:
1. In Excel we have spreadhseet which would call a macro whenever the spreadsheet data was changed. This macro would then check what was changed and if it was relevant perform some calculations and write the results back to the spreadsheet. In Calc I can find no similar event which a macro can be assigned to. Any suggestions?


I believe the nearest UNO API functionality is the ModifyListener. See this thread http://www.oooforum.org/forum/viewtopic.phtml?t=6773

ms777
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group