I imported an XLS file which contained VBA macros into LibreOffice calc. It can't do VBA macros so I deleted the macros and saved the file as an ODS file. Every time I open the ODS file it warns me that "This document contains macros". I look in Tools->Macros->Organise Macros and there are no macros in the file. Presumably the ODS file still contains some trace of the macros that were in the original XLS file. How do I get rid of the warning? What is the point of warning me about traces that I can't delete of macros that I can't run?
I've noticed this before also - quite annoying. Glad you reported it :)
Minor - doesn't prevent high quality work but slows it down and is quite annoying
High - makes users think a macro exists still, anyone who had a macro and deletes it will be affected
4.2 Master built last week
Bodhi Linux x64
In order to limit the confusion between ProposedEasyHack and EasyHack and to make queries much easier we are changing ProposedEasyHack to NeedsDevEval.
Thank you and apologies for the noise
@Richard - I think that this issue has been resolved. Can you verify that this is the case with 220.127.116.11 or newer and mark the bug as RESOLVED -> WORKSFORME?
Migrating Whiteboard tags to Keywords: (needsDevEval)
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice
(5.1.6 or 5.2.3 https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the version of LibreOffice and
your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave
a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
This bug still exists in version 18.104.22.168.
I have an ODS calc file that I have deleted macros from. I tried renaming .config/libreoffice/4 in case there was a problem in there, but no change.
OS: slackware 14.2 64bit.
Just deleting all of the macro code (which to all appearances is the only way to delete this stuff) is not enough to get rid of the macro warning.
However, I just found a way to get rid of the entire VBAMacros library. Go to the Macros Organizer (Tools - Macros - Organize Dialogs), switch to the libraries tab and set the location as your file. Then you can select the VBAMacros library and delete it.
After that, no more prompts.
Created attachment 148157 [details]
Minimal example to provoke bug
This is a copy of my file from which I've deleted all the data except for two sheets, which I've renamed as sheet1 and sheet2 and deleted all the content. AS is is, opening it provokes the "has macros" message. Deleting either of the two sheets gets rid of the message
The bug is still present in LibreOffice Version: 22.214.171.124.
Tools->Macros->Run Macro... doesn't show any macros in the file.
Tools->Macros->Organise Macros->LibreOffice Basic... doesn't show any macros in the file.
Tools->Macros->Organise Macros->Python... doesn't show any macros in the file.
Tools->Macros->Organise Dialogs... doesn't show any macros in any of its tabs.
I do have a global My Macros file, but this doesn't provoke the error message with any of my other spreadsheets.
(In reply to Richard Parkins from comment #8)
> Minimal example to provoke bug
The code that identifies the "presence" of the macros is in sfx2/source/doc/docmacromode.cxx.
So, ODS files are just zip files. I believe that the presence of Basic folder with script files in it triggers the macros. I was able to unzip the file, delete the Basic folder, and re-zip the file to avoid the macro problem.
I didn't see anywhere in the code that could have accomplished this. One thing to investigate is why the "delete" button cannot delete these things in the modules area.
When editing the macros, when you double click on "sheet2", it pops up the code tab with Sub Main/End Sub. Right clicking on the tab gives a delete option, but then the empty code file is just re-created again.
if I force to module dialog code to enable the delete button (basctl/source/basicide/moduldlg.cxx), it still fails to actually delete the Document Object, so I give up.
(In reply to Justin L from comment #11)
> (In reply to Richard Parkins from comment #8)
> > Minimal example to provoke bug
> The code that identifies the "presence" of the macros is in
> So, ODS files are just zip files. I believe that the presence of Basic
> folder with script files in it triggers the macros. I was able to unzip the
> file, delete the Basic folder, and re-zip the file to avoid the macro
> I didn't see anywhere in the code that could have accomplished this. One
> thing to investigate is why the "delete" button cannot delete these things
> in the modules area.
There are several zip algorithms supported by Linux. In order to replicate the solution that you describe, I need to know which algorithm to use to re-zip the file. I tried zipinfo on the original file, but it doesn't tell me.
(In reply to Richard Parkins from comment #14)
> I need to know which algorithm to use to re-zip the file.
I just used "zip" from the command line, which is Info-Zip 3.0 in my case.
(In reply to Justin L from comment #15)
> (In reply to Richard Parkins from comment #14)
> > I need to know which algorithm to use to re-zip the file.
> I just used "zip" from the command line, which is Info-Zip 3.0 in my case.
OK, thanks. That fixes my original file, so it looks as if it a good workaround.
However IMHO the bug (deleting macros not removing the warning) still needs to be fixed.