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 18:19:23 GMT
2014-07-06 15:35 GMT+02:00 Andrew Douglas Pitonyak <>:

> I always set my macro security level to always ask
I don't (I set it to highest level), and the question isn't how to set it
up, the question is that why did a certain setup work in one way one day
and completely different the next day? That is, is there more to it than
just setting up macro security in Tools → Option → Security? No matter what
settings I use, the used one should work, otherwise it should be removed or
corrected, right?

Anyway, I think I got all the answers I possibly can to this question.
Nobody knows, simple as that. It doesn't seem to be a known bug anyway, and
that was probably what I wanted to know in the first place.

Johnny Rosenberg

> 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:
> Info:
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:

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