Basic syntax error. "Function not allowed within a procedure

[Radmo]

I get this: Basic syntax error. "Function not allowed within a procedure." in a modal dialogue box and clicking ok just brings it back. I effectively locked out of my spreadsheet by a procedure that was partially written (still being coded). Why was there a decision to report errors like this? a console may have been enough to prevent the error reporting landing in an infinite loop that the owner of the spreadsheet cannot deal with?
I am puzzled???

[Zizi64]

Please upload your ODF type sample file and the macro code here.

[MrProgrammer]

Why was there a decision to report errors like this?

No one here knows. We are users, just like you, not developers. Reporting bugs or suggestions

I effectively locked out of my spreadsheet by a procedure that was partially written (still being coded).

Open the options dialog (OpenOffice → Preferences on a Mac, Tools → Options on other platforms). Set OpenOffice → Security → Macro security → Security level → Very High and ensure that your spreadsheet is not in one of the Trusted Sources → Trusted File Locations. When you open your spreadsheet again, the macto is disabled and will not run, however you can still edit it. Change the security level when you have fixed the error.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know