openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrew Douglas Pitonyak <>
Subject Re: Absurd thing about macro security
Date Sun, 06 Jul 2014 13:35:18 GMT
I always set my macro security level to always ask

On 07/06/2014 05:08 AM, Johnny Rosenberg wrote:
> 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
> text.
> 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:

Andrew Pitonyak
My Macro Document:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message