https://bugs.documentfoundation.org/show_bug.cgi?id=120374
Justin L <jl...@mail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|VBA button disappears after |FILESAVE XLSM: VBA button
|resaving to XLSM, also |doesn't execute linked
|doens't work if saved to |macro after round-trip
|ODS |
Resolution|DUPLICATE |---
See Also| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=11
| |7266,
| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=12
| |4203
Status|RESOLVED |NEW
CC| |jl...@mail.com
--- Comment #6 from Justin L <jl...@mail.com> ---
This was mostly fixed by commits for bug 117266. The buttons no longer
disappear on a round-trip. However, the macro doesn't execute - probably
because "ThisWorkbook" has been duplicated. (That is also true in bug 124203.)
Removing as duplicate, since the broken VBA is not necessarily due to the same
reason as any of the others.
Round-tripping as XLS didn't work and exhibits the same duplicate ThisWorkbook1
(at least as seen in Excel 2003).
Manually running the macro code in LO works - so perhaps the first thing to
look into is why the macro-link is lost on the button. Perhaps that is caused
by something different than some of the other export issues? Ahh, probably the
name changed. It is based on a <name>_Click macro. In the round-trip it is just
getting a numberId and is losing the spid connection. So some of the
name-related commits in bug 117266 weren't good enough.
--
You are receiving this mail because:
You are the assignee for the bug.
