On 12/08/10 19:33, Johnny Rosenberg wrote:
1) Macros recorded in Calc and stored in ODF do not import to Excel
(probably Excel's issue, rather than Calc's)
Excel does not understand OpenOffice.org Basic.
Thanks Johnny. This raises two questions:
1 - How easy would it be for the Calc 'save as XLS process' to convert
OOo Basic to VBA? If Calc can import VBA and interpret it, it seems at
least theoretically possible but I don't know of the practicalities or
knock-on side effects.
2 - What is the technical reason for the ODF specification not including
macros, but leaving them up to the vendor to decide upon?
From the answers to these come the issues of:
- "What do we do about organisations who are in the middle of a
migration between Calc and Excel, but the need for Macros prevents users
who have switched to Calc from sharing data with users still on Excel
(or vice-versa)?"
- "What about organisations who, for mission-specific purposes, have a
mixture of Excel and Calc and whose legacy Excel macros are causing
problems?"
Best wishes,
Clarke
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
