https://bugs.freedesktop.org/show_bug.cgi?id=71248
Priority: medium
Bug ID: 71248
Assignee: [email protected]
Summary: Excel VBA: ActiveDocument is not tracking currently
selected document
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.4.2 release
Component: BASIC
Product: LibreOffice
Created attachment 88673
--> https://bugs.freedesktop.org/attachment.cgi?id=88673&action=edit
Describes how to reproduce and a macro tells you the "active" workbook, sheet,
cell.
VBA macros in LibreOffice consider the "last opened" spreadsheet with VBA as
the active Document/Sheet/Cell. Changing to a previously opened XLS file does
not switch the active document, and closing the "last opened" spreadsheet
causes VBA references to the ActiveWhatever to Basic Runtime Error.
The test documents from Bug 54721 show this. I'm not reopening that bug based
on the comments in it - which say that a new bug should be filed instead.
In my testing, it appears that only documents that contain VBA code affect
this. Opening simple .xls files without macros doesn't break the "active"
document.
Tested on 4.0.4 (Linux) and 4.1.2 (Windows)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
