Bug 137780

Summary:	Visual feedback on cells with calculated results that include values from hidden cells
Product:	LibreOffice	Reporter:	b. <newbie-02>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	erack, heiko.tietze
Priority:	high	Keywords:	dataLoss
Version:	Inherited From OOo
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=147837
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108019

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)

The mockup takes the known design principle with a list of presets at left, the attributes in the middle, and a preview right-hand.
The line style Position is a multi-selection toggle button, one selects all the border lines that should be modified. In contrast to the current configure and apply (on click at the preview) this workflow would apply the modifications immediately. Meaning if some positions are selected (toggle button active) and the vertical left line is added now, it will become blue. To keep the left line's color (and use it also at right) one has to uncheck both horizontal first. If none is selected the attributes are taken from the selection.

In the first iteration, the alternative approach was to apply line attributes only individually via dropdown. This idea was rejected as regression to the current solution with multiple selection.

Previously it was possible to click repeatedly on the preview and disable a border line. This is replaced in the mockup with a checkbox. The preview is not clickable.

For the padding a dropdown allows to set the distance for all sides (currently done via "synchronously") or individually for each side. Thus, the dropdown has 5 items.

The mockup is done with Penpot, publicly available at https://1strankdirectory.com/
[tag] [reply] [−]Comment