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
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.