https://bugs.documentfoundation.org/show_bug.cgi?id=89269
Bug ID: 89269
Summary: Macro's in excel (.xls) files
Product: LibreOffice
Version: 4.4.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
I have an .xls file that always gives a warning that it contains macro's when
opening it. The file doesn't actually contain any macro, but it contains a
library/module with no macro's in it. (Excel also gives a warning opening that
file.)
If you go to Tools->Macro->Organize Macro's->Libreoffice basic, under the
document itself you see two items. If you then go to organizer->libraries and
select the document you can remove the 2nd item, but not the first
("standard"?) one.
However, if you save that and reopen the file and go check everything is back
as it was, as if you didn't remove the library/module.
If you open it in excel and remove the module there both excel and libreoffice
don't give a warning anymore when opening it. However if you go and look at it
again, it shows the standard one again in the dialog that you can't remove. If
you save that file using libreoffice the next time you will get the warning
again.
It also seems to be possible to have .xls files that does not contain anything
related to macro's. If you go and look at those it doesn't show anything. If
you save them and reopen them it doesn't give you a warning.
If I try to add a library to a file that doesn't have anything related to
macro's and save that and then reopen it, it doesn't seem to be saving that
library/module. It also doesn't seem to add the standard one.
As a workaround for all those problems I would be happy with the warning going
away if it doesn't actually contain any macro.
Kurt
--
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
