Issue 75624 - Calc: thinks a file has macros, when in fact it does not seem to
Summary: Calc: thinks a file has macros, when in fact it does not seem to
Status: CLOSED DUPLICATE of issue 52324
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0.1
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-03-22 02:48 UTC by zhongqiyao
Modified: 2007-03-30 13:41 UTC (History)
2 users (show)

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

Attachments
warning for macros (15.50 KB, application/octet-stream)
2007-03-22 02:49 UTC, zhongqiyao 		no flags Details
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 zhongqiyao 2007-03-22 02:48:05 UTC 
Windows XP Home, Chinese (Traditional characters).
OpenOffice Calc 2.0.1, Chinese (Traditional characters).

1. Open the attachment, separately in Microsoft Excel 2003 and
OpenOffice Calc 2.0.1.

2. In Excel it does not warn for macros. It was plainly typed and so
should not contain any macros.

3. In OpenOffice Calc it wars for macros. It seem to think that it
has macros.

Thanks.

Qiyao
Comment 1 zhongqiyao 2007-03-22 02:49:24 UTC 
Created attachment 43845 [details]
warning for macros
Comment 2 andreschnabel 2007-03-22 14:07:01 UTC 
confirmed with OOo 2.2RC3 

calc is importing a makro in Module thisWorkbook 
macros2.Standard.thisWorkbook will show:
----
Rem Attribute VBA_ModuleType=VBADocumentModule
Option VBASupport 1
Sub ThisWorkbook
Rem 
End Sub
----

Excel does not find any line of code in the file. 
Tested with Excel 2003. Opened the file, in VB Editor, direct input I tried the
following code:

for i=1 to activeworkbook.VBProject.VBComponents.Count : _
? activeworkbook.VBProject.VBComponents(i).CodeModule.CountOfLines, _
  activeworkbook.VBProject.VBComponents(i).Name : _
next i

and got:

 0            ThisWorkbook
 0            Sheet1
 0            Sheet2

I could not reproduce this with any other excel file, so lowering Priority
Comment 3 zhongqiyao 2007-03-23 02:42:52 UTC 
Thanks for looking at this problem.
Comment 4 frank 2007-03-30 13:41:23 UTC 
Hi, this is not a defect.

Excel form controls add an entry to the Macro section of an workbook if one was
defined and do not remove it completly if this button is erased from the sheet.
Saving this document will bring up the warning in Calc.

Also a duplicate to Issue 52324.

Frank

*** This issue has been marked as a duplicate of 52324 ***
Comment 5 frank 2007-03-30 13:41:46 UTC 
closed double