https://bugs.documentfoundation.org/show_bug.cgi?id=140485
--- Comment #3 from Uwe Auer <[email protected]> ---
(In reply to An-Kh from comment #2)
I did understand your code, but probably you did not understand my answer. To
be precise and clear: Your code is wrong and I explained why.
> If IsMissing(pPassword) Then pPassword = "SomePassword"
is not doing what you understand / assume it is doing. It doesn *not* test
whether variable is set. Runtime function IsMissing() tests for *optional*
parameter in your function definition (i.e. it tests, whether *pPassword* has
been passed to function LockSheet(passedSheetname)) - but your function doesn't
have that optional parameter at all.
Therefore provided a solution (which you obviously did not check) to change:
- Function LockSheet(passedSheetname)
+ Function LockSheet(passedSheetname, optional pPassword )
In other words: The declaration of your function *LockSheet* is incorrect with
respect of using runtime function *IsMissing()*
Explanation
- means "remove" from your code
+ means "add" to your code
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
