macros dont work in calc [closed]

asked 2014-09-14 21:47:40 +0200

II gravatar image

updated 2016-03-03 18:35:43 +0200

Alex Kemp gravatar image

Hi all, The macros in a excel file dont work in Calc - I'm looking for simple step-by-step instructions for a beginner (zero knowledge of programming). This is what I've tried so far: * installed latest version of Calc - Version: 4.3.1.2

Build ID: 958349dc3b25111dbca392fbc281a05559ef6848

*changed security level to Medium (under Tools-->Options-->Security)

*changed security level to Low (under Tools-->Options-->Security)

Error messages I see: The LibreOffice configuration has been changed. Under Tools - Options - LibreOffice - Advanced, select the Java runtime environment you want to have used by LibreOffice. (The above is seen when I select Tools-->Options-->Run Macros)

*BASIC runtime error. '1' Type: com.sun.star.lang.IndexOutOfBoundsException Message: * (The above is seen when I get the Macro Selector window-->Library-->select module-->Macro name-->Run)

A Scripting Framework error occurred while running the Basic script vnd.sun.star.script:SPOCALC.XLS.Module1.enter_front_hub?language=Basic&location=document. Message: The following Basic script could not be found: library: 'SPOCALC' module: 'XLS' method: 'Module1' location: 'document' (The above is seen when the same excel file is saved as a ods file, and reopened)

The LibreOffice configuration has been changed. Under Tools - Options - LibreOffice - Advanced, select the Java runtime environment you want to have used by LibreOffice.

(The above is seen when I run attempt to run the macro on a ods file type) I have no idea what a Java Runtime Environment is! No options seen to select one either.

Please help. This xls file has been opened with an earlier version of Calc and all macros worked.

Sorry for the long question, tried to give as much info as possible though my knowledge is limited:)

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-03-03 18:36:18.995269