Ask Your Question
0

my calc macro needs to be reloaded each time the file is reopened - why and how to fix please [closed]

asked 2012-05-09 05:03:01 +0200

MikeVV gravatar image

updated 2013-10-07 20:21:14 +0200

manj_k gravatar image

My calc macro needs to be reloaded each time my file is reopened - why? I have a calc workbook that contains a Basic script and a java script. The Basic and java scripts are included in a module / library within the Calc file (not under "MyMacros" or "LibreOffice" macros). Each time I open the file I receive an error message indicating that "A BASIC runtime error has occurred of type: com.sun.star.script.provider.Script.Framework.ErrorException Message: Macro Library Library1 not found." This is the location of the java script code. The cells containing macro function callouts are blank and I cannot get them to recalculate unless I retype them. Then they work.
Why isn't the library found when the file opens? Thanks! MikeVV

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-16 00:21:16.739495

Comments

@MikeVV, could you please try new 4.0 release and if it is still a problem, attach an example file to the bug fdo#61045 (or close it, if everything works fine).

mahfiaz gravatar imagemahfiaz ( 2013-02-18 09:56:01 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2012-05-09 15:35:04 +0200

mahfiaz gravatar image

This is a bug in application startup order. But doesn't Tools → Cell content → Calculate again (F9) work without need to retype?

edit flag offensive delete link more

Comments

Hi @mahfiaz, could you please post the bug # here so we can resolve this question as "Moved to bugzilla". Thanks!

qubit gravatar imagequbit ( 2013-01-27 09:14:43 +0200 )edit

I filed this bug as: fdo#61045

mahfiaz gravatar imagemahfiaz ( 2013-02-18 09:54:02 +0200 )edit

Question Tools

Stats

Asked: 2012-05-09 05:03:01 +0200

Seen: 609 times

Last updated: May 09 '12