[Libreoffice-bugs] [Bug 129896] New: CALC: UI: MACRO: array function not working from macro

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 129896
           Summary: CALC: UI: MACRO: array function not working from macro
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: newbie-02 at gmx.de

Description:
for the Bug Hunting Session 6.4 RC1: 

this: 

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

quite old bug is still virulent in RC1. 

the sheet to show doesn't need to be as complex as there, see next comment, 



Steps to Reproduce:
1. open sample sheet from next comment, 

2. compare results in C4:D4 with C6:D6, 

3. play with values in B4, B6, try to trigger recalculation, 

4. save sheet with altered values in B4, B6, 

5. load again and observe C4:D4 updated - calculation possible, 

6. observe C6:D6 not correct but same values as C4:D4, 

7. observe again: no recalc possible, 


Actual Results:
result for array function not correct, 

Expected Results:
both arrays calculated correctly and changed on change of input values, 



Reproducible: Always


User Profile Reset: Yes



Additional Info:
it looks as if the array-macro-function is calculated only once on load of
file, 

Version: 6.4.0.1 (x64)
Build ID: 1b6477b31f0334bd8620a96f0aeeb449b587be9f
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:

-- 
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/20200109/2efe0ebe/attachment-0001.htm>