Bug 137780 - Visual feedback on cells with calculated results that include values from hidden cells
Summary: Visual feedback on cells with calculated results that include values from hid...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: high enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: dataLoss
Depends on:
Blocks: Calc-UX
  Show dependency treegraph
 
Reported: 2020-10-26 22:04 UTC by b.
Modified: 2024-01-26 06:44 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description b. 2020-10-26 22:04:52 UTC
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:
Comment 1 Roman Kuznetsov 2020-11-03 21:52:59 UTC
I don't think it's a good idea, but let's ask UX team too
Comment 2 Heiko Tietze 2020-11-05 10:15:00 UTC
I think such a warning is a mandatory (=> dataloss, high). We show a red triangle for cell overflow, why not have a similar information for merged content? Eike, what do you think?
Comment 3 VidlitaCamero 2024-01-26 06:44:11 UTC Comment hidden (spam)