On 06/13/2010 08:50 AM, Gelonida wrote:
Hi,
I'm loking for some advice how to best do following:
I'm having a spreadsheet with a cell layout, that corresponds my needs.
Now I would like to add certain behavoir as beeing known from web forms
to a few cells.
- having a select box instead of free entry for certain cells
I believe that you can do this by inserting a drop-down list box in a
cell and then associating the control with a cell in your Calc document.
- triggering en event (macro) when the contents of one of these cells
changed
I do not believe that you can tell Calc to automatically call a macro
when the value in a cell changes.
Rephrased:
1. Limited input range for cells
------------------------------------
When clicking (or doubleclicking) on the cell I would get a select box
or a minidialoge offering me the possible options.
Examples:
- numbers only from 1 to 12
- or text, but only 'Yes' and 'No'
2.) Sanity check of certain cell inputs
I do believe that you can provide for constrained input. Something
about Data > Validity and you can set constraints. I have not used it,
other than in testing and writing macros to deal with it during my
testing (some years ago).
-------------------------------------------
- after having changed the value of a cell.
- I'd like to trigger a macro, which performs some sanity checks.
Thanks for any suggestions or ideas how you attack similiar problems.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
