[Libreoffice-bugs] [Bug 54854] calc add-in functions are not evaluated as expected

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=54854

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |newbie-02 at gmx.de

--- Comment #28 from b. <newbie-02 at gmx.de> ---
some years later ... 

an attempt to boil down the issue: 

(with some bugs it's a problem that they are spotted in complex sheets /
situations and problematic for devs to recheck ...) 

@QA Team: still an issue, 

simple-sample: 

------------ 
sub bug54854

Sheet        = ThisComponent.CurrentController.ActiveSheet

Cell         = Sheet.getCellByPosition(1, 2)
Cell.Formula = "=15"

Cell         = Sheet.getCellByPosition(1, 3)
Cell.Formula = "=DEC2BIN(B3)"

end sub 'bug54854
------------ 

results in #NAME? in cell B4 for me with ver. 7.1.0.0.a0 on winx64, formula in
the cell is: "=dec2bin(B3)", lowercase!, 

entering that cell (F2 - edit mode), selecting complete content (ctrl-a),
copying (ctrl-c), and pasting into another cell on the sheet results in formula
"=DEC2BIN(B3)" in that cell and display of correct result "1111", 

works better with other functions like average, i don't know which functions
are 'native'? and which are 'add-in'?, 

might be an issue with 'formula' as appearing in tdf#129464, a dup of
tdf#82610,  and / or 'related' to plenty other bugs / requests about 'add-in'
or 'user-defined' functions, 

happy hacking ...

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200902/1740afd7/attachment-0001.htm>