https://bugs.documentfoundation.org/show_bug.cgi?id=101631
Aron Budea <ba...@caesar.elte.hu> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |ba...@caesar.elte.hu
Component|Calc |BASIC
Version|unspecified |5.1.4.2 release
Summary|Strange auto-modifying |VBA function parameter is
|behaviour when EDITING in |passed by reference by
|Calc |default
Whiteboard| |interoperability
--- Comment #1 from Aron Budea <ba...@caesar.elte.hu> ---
The direct reason for the self-modifying behavior is that function "stableford"
modifies the "score" parameter, which is apparently passed by reference.
I can't tell if it's the correct behavior or not, got confused by different
VB-related MS resources that state contradicting things:
https://msdn.microsoft.com/en-us/library/aa263527(v=vs.60).aspx "Passing by
reference is the default in Visual Basic."
https://msdn.microsoft.com/en-us/library/ddck1z30.aspx "The default in Visual
Basic is to pass arguments by value."
They're for different VB versions, and not VBA, either, but it's still weird.
Until this is clarified, as a workaround you can copy the parameter to a local
variable, and modify that.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs