Ask Your Question

Calc Macros load/reload [closed]

asked 2013-10-13 16:37:03 +0200

mort gravatar image

updated 2013-10-13 19:35:33 +0200

L-user gravatar image

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?


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-11 07:32:57.827392


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.

w_whalley gravatar imagew_whalley ( 2013-10-13 21:47:12 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-10-13 18:58:07 +0200

w_whalley gravatar image

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.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-10-13 16:37:03 +0200

Seen: 470 times

Last updated: Oct 13 '13