On 2020/11/27 11:21:25, Priyanshu Mehta <priyanshumehta...@gmail.com> wrote:
> I entered a function in organizing macros but when I entered the name of
> function it shows Err:511 What I typed is here
>
> Function address()
> address()="ABC school,123 road"
> End Function
>
> But when I type =address() in any cell it shows Err:511. Pls tell what can
> I do to solve this. Pls reply
>
If I understand correctly:
1. You defined in the Basic-IDE a function named address().
2. When you invoke this function from Calc using =address()
you get Error 511 (Missing variable in function).
You get this error because - contrary to what you might expect - you
call built-in function of Calc - ADDRESS() without arguments.
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_ADDRESS_function
As you see, your function has the same name as built-in Calc function.
Change the name of your function to something unique e.g. addressPM()
and it shall work.
(of course your function must be saved in the default module).
Regards,
Czesław Wolański
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
