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:
I don't think it's a good idea, but let's ask UX team too
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?
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