Issue 82575 - Macros saved in XLS format are not retained, when deleted are retained
Summary: Macros saved in XLS format are not retained, when deleted are retained
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.3.0 RC1
Hardware: PC Windows 2000
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-10-13 00:04 UTC by arasaka
Modified: 2013-08-07 15:12 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 arasaka 2007-10-13 00:04:44 UTC 
Create a new document in Calc.
Create a macro (Tools -> Macros -> Organize Macros -> OpenOffice.Org Basic...)
Select the document (Untitled1, say), open the tree, select Standard, click New.
The name of the new module matters not, just click OK.
OpenOffice.org Basic opens. Just close it.
Save the file as "Test.xls" using the XLS type.
Close the document and re-open it.
Look into the OpenOffice.org Basic Macros dialog, the macro was not saved.

Repeat the same steps but chose the "ODS" format. The macro will be retained.

The reverse is true also. An XLS document with a macro inside, deleting the 
module containing the macro, or the macro itself, in the "OpenOffice.org Basic 
Macros", and saving as XLS does not delete module or macro. Works fine in ODS.
Comment 1 frank 2007-12-12 13:46:22 UTC 
Hi,

this is not a bug. OOo macros can't be run on Excel and vice versa. So saving
Macro code to XLS from OOo is not possible. On the other hand imported Excel
Macro code can't be removed to avoid problems. You're only able to Edit these
macros but you can't erase them completely. This is on purpose.

Frank
Comment 2 frank 2007-12-12 13:47:10 UTC 
closed invalid
Comment 3 arasaka 2007-12-12 15:28:28 UTC 
Thanks for your response. I think I understand what you mean, up until the next 
to last sentence. You are saying "macros from one platform cannot run in the 
other", thus, macros from Excel can be edited, but not deleted. I can't see the 
rationale behind this. If the macro cannot be run, then why bother leaving the 
possibility of editing it? If the macro can be edited, then why prevent it from 
being deleted? 

At the very least when editing or trying to delete an Excel macro, there should 
be a message saying "Deletion of the Excel macro cannot be performed". The 
current behaviour shown suggests it was deleted, but it comes back when the 
file is re-open. At the very least the interface is misleading...
Comment 4 frank 2007-12-13 13:21:14 UTC 
re-opened as development want's to evaluate the macro saving thing
Comment 5 frank 2007-12-13 13:23:59 UTC 
Hi Daniel,

as you mentioned, it may be a defect that the macro reappears in Excel so the
Excel filter ignores the deletion of the macros on export.

IMHO this is correct behaviour as the macros should be erased fom a document
using the application which implemented them.

Frank
Comment 6 arasaka 2009-02-04 20:50:21 UTC 
Just to confirm that behaviour is identical in OOo version 3.0.1