William Case wrote:
Hi;
Does anybody have a suggestion where I could find a pre-built drop down
calendar I can use as a macro or plugin or whatever in Calc.
Under specific conditions, when a user activates a given cell, I would
like to display a calendar that they can use as a date picker.
Building one myself would be a major project for me in itself.
View>Toolbars>Form COntrols
2nd button "Design Mode" = on
2nd last button "More Controls"
Pick "Calendar Field from toolbar "More Controls"
Draw the control on the sheet.
If some wizzard pops up: Cancel (no database connection here)
In the control's properties: "Dropdwon" = Yes
Next problem is: How to put the selected data into a cell? Unlike many
other controls a date field has no property "Linked Cell". But this
could be solved with a very simple macro.
All suggestions gratefully received. I have checked
OpenOffice.org API - Code Snippet Base, OpenOffice Calc Tips and Help.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
