[Libreoffice-bugs] [Bug 81295] Name Scope Handling is Incorrect

[bugzilla-daemon at bugs.documentfoundation.org]

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

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

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

--- Comment #4 from b. <newbie-02 at gmx.de> ---
hello, 

@Joel: 

sorry for stepping into an old bug ... 

would be nice if the user has any possibility, besides guessing, to check the
'adoption' of 'Aggregation.colB' as target for 'Criterion'? 

@Albrecht: 

> BTW: Why do the values change to 7, 5 and 3? 

maybe calc compares the 'new reference' 'Criterion-row-x' now found on
'Aggregation.colB' to the 'target' '=Bx' on Aggregation, which - oh wonder -
match because being the same, and pulls the value from row-x of col 'Values' -
which it finds on Raw Data - into the cell. 

nice side-effect: when you restrict the scope of criterion to Raw Data and!
delete the content of Aggregation.B1, calc can still calculate with formulas
like 

=SUMIF(#NAME?B$1;"=" & B3;Values )

in Aggregation.colB ... not only show former values but update them on changes
in col values on Raw Data ... funny ...  

function wizard calculates a different result (err:509) than the sheet with
autocalculate on (="Raw Data".B3), and in a way points graphical to the
relevant cells e.g. B1 and B3 for C3 ... 

to classify such behavior as 'notabug' seems to me ... disconcerting ... 

tested with ver. 6.4.0.1 

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/20200119/0c18ea84/attachment.htm>