openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Johnny Rosenberg <>
Subject Re: Absurd thing about macro security
Date Sun, 06 Jul 2014 09:08:51 GMT
2014-07-06 2:53 GMT+02:00 Alexandro Colorado <>:

> Can you tell us what does ur macro actually do?

There are quite a few and they are different for each spreadsheet file.

> Most of these settings are declared on the XCU whicch are XML. The
> schema could have changed or something along those lines like the path
> on the ~/.openoffice/ folder.
> However maybe you run your macros within AOO which could be a
> different service, so until we dont get that information we cant tell
> which change could have an effect on your macro.

I am only talking about ordinary Basic macros written in the Basic IDE.
They are not run until I actively run them, in this case by cliocking a
giant button in the spreadsheet. It shouldn't matter what it does, and
there are more than one of them, but the most important one, for instance,
reads the clipboard and extract the text part from it. Then it fills some
cells (which ones is up the the macro to calculate) with some parts of that

Anyway, the problem isn't the macro itself. The problem is that when I open
one of those spreadsheets, Apache OpenOffice tells me that this spreadsheet
contains macros (which it does), before even finished loading the
spreadsheet at all. The dialogue then lets me open the spreadsheet with
macros disabled…

So I go into Macro security and add the path in which the link to the
spreadsheet is located, close Apache OpenOffice and try again, and this
time the macros are loaded properly without any error messages.

I don't complain about the behaviour, actually I can see that this is how
it should work. What I'm asking is WHY could I open them from that folder
BEFORE yesterday?

The document itself is stored as, let's say ~/some/path/spreadsheet.ods,
but I open it by clicking ~/another/path/link_to_some_path_spreadsheet.ods.
~/some/path/ is added to the macro security paths list, ~/another/path/ is
not. Before yesterday I could open the document by clicking the link, now I
can't and I didn't change any settings within Apache OpenOffice. I think
the correct behaviour is performed now and NOT before yesterday, but I
don't understand why this happened. Bug? Is there another macro security
setting elsewhere that I missed?

Johnny Rosenberg

> On 7/5/14, Johnny Rosenberg <> wrote:
> > I did a fresh install of my operating system a couple of weeks ago, so I
> > now run Apache OpenOffice on Ubuntu 14.04 rather than Ubuntu 12.04.
> Anyway,
> > one of the first things I did, was to throw LibreOffice out the window
> and
> > install Apache OpenOffice.
> >
> > There are a few spreadsheets that I edit every day, almost, and the first
> > thing I experience after a fresh operating system install is usually
> that I
> > need to add macro paths to the macro security paths list.
> >
> > I usually add them one by one when I need them and for now I only need to
> > run macros in spreadsheets at ”~/Kontor/Ekonomi/” (in English:
> > ~/Office/Economy/). However, to open those spreadsheets I click on a link
> > located in a folder on my desktop, ”~/Skrivbord/Frekvent använt/” (in
> > English: ”~/Desktop/Frequently used/”). All I did so far was that I added
> > the ”~/Kontor/Ekonomi/” path to the macro security list thing, and it
> > worked perfectly for those weeks. Until today.
> >
> > Now, when opening one of those spreadsheets, it says that it won't run
> any
> > of my macros.
> >
> > So now I just gave up and added ”~/Skrivbord/Frekvent använt/” and Apache
> > OpenOffice seemt to be happy with that. But why, WHY, WHY, WHY did it
> work
> > before today? I've been opening those links all the time since I put them
> > there, without any kinds of problems!
> >
> > The only thing that is different now from before, is that I moved my
> > computer a few meters and that I use two screens instead of one now. How
> > could that matter?
> >
> >
> > Best regards
> >
> > Johnny Rosenberg
> >
> --
> Alexandro Colorado
> Apache OpenOffice Contributor
> 882C 4389 3C27 E8DF 41B9  5C4C 1DB7 9D1C 7F4C 2614
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message