Calc Macros load/reload

I have a function

function hello(a as string) as string
	hello = "Oi, " & a
end function

When I call it using =hello("Fred") from a sheet I get #VALUE

It work at one stage but when I editted the function it didn’t load the changes.

How do I load/reload Basic functions into LibrCalc?

N

1 Like

Are macros allowed to run from your save location? In a newly-created spreadsheet macros will run but if you save the sheet and reopen it where macros aren’t allowed you will get the #VALUE! error.

This page provides a method. Shift-Ctrl-F9 to recalculate all formulas. Or edit the cell containing the function call, but that won’t change any other cells that have the same function.