[Libreoffice-bugs] [Bug 137780] New: ui: implement a signal when calculated results include values from hidden cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 137780
           Summary: ui: implement a signal when calculated results include
                    values from hidden cells
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: newbie-02 at gmx.de

Description:
for the bug hunting session 2020-10, 

and as a follow up to tdf#30456 and it's dups, 

the sheet in https://bugs.documentfoundation.org/attachment.cgi?id=39043
contains hidden cells (hidden by merging) whose values contribute to the sum, 

for a simple minded user it's hard to spot that there are additional cells, and
hard to know that they might contain numbers included in the sum, 

as we want to keep users informed - not only those who construct such sh... -
but also other who may get it pre-prepared, 

add a little sign somewhere, or a mouseover popup or whatever which says 'there
is more on the sheet and calculated than visible to you', 

(or did i miss something?)

should be individual for each affected result, a global warning would likely be
'always on', 

Steps to Reproduce:
1. load linked sheet, 
2. see result '28' and range calculated showing numbers sufficient only for
'19', 
3. be irritated

Actual Results:
no warning or hint for the user

Expected Results:
anything providing info 'the calculation includes values from not visible
cells'



Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.0.0.alpha1+ (x64)
Build ID: b61bf7c7cfcf97a5ade6d130873af146670bc2ee
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win
Locale: de-DE (de_DE); UI: 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/20201026/2ddc3c63/attachment.htm>