Macros in Database Documents

From Apache OpenOffice Wiki
Revision as of 09:33, 28 November 2007 by Frank Schoenheit (Talk | contribs)

Jump to: navigation, search
Specification Status
Author Frank Schönheit
Last Change 2007-11-27
Status (Help) Preliminary

Abstract

OpenOffice.org Base, unlike the other OpenOffice.org applications, is currently not able to embed macros and scripts into its documents. We will empower Base users to use macros and scripts (StarBasic, JavaScript, BeanShell, Python) in their database documents the very same way they can use them in all other application's documents.

Detailed Specification

Accessing Macros and Scripts

  • Macro and Script Organizers (Template:Menuitem) will show opened database documents, and allow editing/creating macros/scripts therein.
  • The Basic IDE will treat macros in database documents the very same way as macros in other application's documents.
  • The Macro Selector (Template:Menuitem) will show opened database documents, and allow to run them.
  • The UI customization dialog (Template:Menuitem) will allow access to the current database document's macros and scripts, when invoked for this document.

Unavailable Functionality

  • For the moment, it will not be possible to sign macros embedded in database documents. This is up to a later step.
  • macro recording will not be possible in database documents. This is a separate topic, which requires implementations in a completely different area.
Help | User Interface Element Templates | Example Spec

Database Document Macros vs. Macros in Embedded Documents.

Migration

<START TYPING HERE --- If this part is irrelevant state a reason for its absence.>

Configuration

<START TYPING HERE --- If this part is irrelevant state a reason for its absence.>

File Format

<START TYPING HERE --- If this part is irrelevant state a reason for its absence.>

Milestones

Definition and Timeline

The development of this feature will produce the following milestones:

Milestone Due
M1 embedding/organizing/running macros/scripts works t.b.d.
M2 sub documents cannot contain macros/scripts anymore, old documents which still do are handled appropriately t.b.d.
M3 Assigning macros to database document events (Template:Menuitem) works. For instance, it is possible to assign a macro to the OnLoad event of an DB document itself. t.b.d.
M4 TODO t.b.d.
M5 TODO t.b.d.

Tasks

Task Status M
<area>
<lengthy task description> planned M1
<lengthy task description> planned M1
<area>
<lengthy task description> planned M1
<lengthy task description> planned M2

Open Issues

none so far

Appendix

Acronyms and Abbreviations

Acronym / Abbreviation Definition

References

Reference Document Check Location (URL)
Specification Process Entry Check [passed/failed] n/a
Product Requirement, RFE, Issue ID (required) available

Possibility to put macros in *.odb files
Impossible to bind a macro to an OpenOffice.org Base document
RFE: add database specific event for macros to the database

Test case specification (required) not available

Contacts

Role Name
Developer Frank Schönheit
Quality Assurance Marc Neumann
Documentation Uwe Fischer
User Experience Bettina Haberer
Personal tools