Issue 98512 - Excel spreadsheet buttons not assigned to macros
Summary: Excel spreadsheet buttons not assigned to macros
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0
Hardware: PC Windows NT
: P2 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-01-27 10:34 UTC by jlczuk
Modified: 2013-01-29 21:52 UTC (History)
1 user (show)

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

Workbook with multiple sheets, buttons and VBA macros (308.00 KB, text/plain)
2009-01-27 10:36 UTC, jlczuk
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jlczuk 2009-01-27 10:34:54 UTC
When I open an Excel spreadsheet (.xls or .xlt) from either windows explorer or
from the File->Open dialog of Calc, the buttons are not connected to their
original macros when Calc finishes its import.  I should note that I have my
macro security set to medium and I responded Enable to the pop-up about macros
in the document.  Setting macro security to low didn't change anything.

I will attach a copy of the spreadsheet.  Your QA team has my permission (I'm
the copyright holder) to use this spreadsheet for testing/assurance if they so
choose.  It has a fair amount of macro processing in it and uses multiple
sheets.  They can contact me via email for instructions on how to use it.
Comment 1 jlczuk 2009-01-27 10:36:01 UTC
Created attachment 59693 [details]
Workbook with multiple sheets, buttons and VBA macros
Comment 2 larysahitekschool 2009-03-22 00:10:50 UTC
I can reproduce that as described on system Windows NT with version OOo 3.0
Comment 3 Mechtilde 2009-07-19 19:28:31 UTC
yes because Excel contains VBA-Macros and these are a bit different to the
StarBasic Macros