First time here? Check out the FAQ!
asked 2012-08-02 17:38:15 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
Hi
Is there any manual that has details on eventhandling in basic? I'd like to use it on speadsheets for auto-correction and auto-checking when data is typed into the sheet. In MS Excel I've done it using the Worksheet_Change() function. I've found some info online here and there, but I haven't found any definitive guide.
thanks in advance istvan
I don't know if there's a definiitve guide, but Andrew Pitonyak's great book on OOo macros has some examples how to work with event listeners (chapter 10.11 and 13.05).
answered 2012-08-04 19:58:04 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
Thanks
that's a very useful reference
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-08-02 17:38:15 +0200
Seen: 75 times
Last updated: Aug 04 '12
why basic code ''ThisComponent.getCurrentSelection.formula" replaces comma with semicolon?
Filling/removing BG color of a cell range using VBA
How to Delete Conditional Formatting using Calc Macro?
How can I call a DLL function with an array as an argument?
Mail merge without .ODB file [closed]
Is there any LibreOffice equivalent to the Excel Data Analysis Toolpack?
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.