Issue 27451 - Cannot assign scripts to Data Validity error conditions in Calc
Summary: Cannot assign scripts to Data Validity error conditions in Calc
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: scripting (show other issues)
Version: 680m32
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: tomaisoc
QA Contact: issues@framework
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-04-05 11:54 UTC by tomaisoc
Modified: 2005-01-06 11:41 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description tomaisoc 2004-04-05 11:54:56 UTC 
Information from Thomas Benisch on an example of where the Basic specific
macro chooser dialog is used in Calc. The new Scripting Framework Macro
Selector should be used instead.


2. Data validity in a spreadsheet
   ------------------------------

   UI:

   - File / New / Spreadsheet
   - cell A1 must be selected
   - Data / Validity...
   - tab page 'Error Alert'
   - check box 'Show error message ...' must be checked
   - select 'Macro' in 'Action' combo box
   - press 'Browse...' button
   - Macro Chooser is shown
   - select a macro in the Macro Chooser
   - press 'Choose' button in Macro Chooser
   - select tab page 'Criteria' in 'Validity' dialog
   - select 'Decimal' in 'Allow' combo box
   - select 'less than' in 'Data' combo box
   - enter a value of '10' in 'Maximum' edit field
   - press 'OK' button
   - enter a value of '11' in cell A1
   - the assigned macro is then executed

   CODE:

   sc\source\ui\dbgui\validate.cxx: SfxApplication::ChooseMacro()
Comment 1 tomaisoc 2004-04-05 11:56:02 UTC 
.
Comment 2 tomaisoc 2004-05-10 14:09:58 UTC 
The new Macro Selector dialog has now been implemented. The spec for the
new dialog can be found at:

http://specs.openoffice.org/scripting_framework/MacroSelectorSpecification.sxw

When the user selects Macro in the Action combo box of the Data/Validity
dialog, they should now see the Macro Selector popping up. If they select
a macro and click OK they should see the URI for that macro appearing
in the Title edit field.
Comment 3 joerg.skottke 2004-05-13 13:09:00 UTC 
verified
Comment 4 tomaisoc 2005-01-06 11:41:42 UTC 
closing, i have verified this is still working in an m69 build