[Libreoffice-bugs] [Bug 82610] CALC: MACRO: ADD-IN FUNCTIONS: 'add-in' functions can't be set from a macro | was: DEC2HEX function not working in macro, Affects Analysis AddIn functions.

[bugzilla-daemon at bugs.documentfoundation.org]

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|DEC2HEX function not        |CALC: MACRO: ADD-IN
                   |working in macro, Affects   |FUNCTIONS: 'add-in'
                   |Analysis AddIn functions.   |functions can't be set from
                   |                            |a macro | was: DEC2HEX
                   |                            |function not working in
                   |                            |macro, Affects Analysis
                   |                            |AddIn functions.
                 CC|                            |newbie-02 at gmx.de

--- Comment #14 from b. <newbie-02 at gmx.de> ---
in c#3: LeMoyne Castle wrote: 

"Affects Analysis AddIn functions."

in long: looks as if 'add-in' functions as DEC2HEX, DELTA, GESTEP ... 

are handeled differently to 'built-in'? functions as SUM or AVERAGE, 

thus a more general problem, i change the title, 

as manually keying in of 'add-in' functions works, 
and as setting of cells to plenty other functions (formulas) by a macro works, 
and as even setting cells to values "3" or strings "text" works from macros, 
and as even after a 'failed' setting with result "=dec2hex(A1)" a 'nonchanging
edit' as 'adding-a-space-and-delete-before-enter' produces a functioning
function,   

i see no reason why setting an 'add-in' function by a macro should fail ... 

... but it fails ... anybody an idea why? 

the string/cell set by the macro must contain some 'special' 'hidden'
property??, it can be copied to another cell with result there still 'bad', but
if you copy the text from the formula bar into another cell it's capitalized to
"=DEC2HEX(A1)" and works as expected, 

one more funny effect: the unchanging edit
'add-a-space-and-delete-before-enter' works to heal the defects in this case,
while other unchanging edits as 'delete-and-undo' or 'replace-and-undo' which
helped for some other fails don't help here ???

tests above done with and still repro in: 

Version: 7.0.0.0.alpha0+ (x64)
Build ID: 07b1159b79135857dd9a450c3bb9ae0a944ebcf9
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: 

reg. 

b.

-- 
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/20200220/7da3e2de/attachment-0001.htm>