[Libreoffice-bugs] [Bug 128708] New: it is important to give the user a hint if wrong results are displayed

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 128708
           Summary: it is important to give the user a hint if wrong
                    results are displayed
           Product: LibreOffice
           Version: unspecified
          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:
short: 

sometimes wrong or outdated results are stored in files, and displayed on
screen when reloading the file, 

i think it would be nice if the users gets a hint on that

>>> for military and other critical use it's a 'must have'! <<<

long: 

in my opinion libreoffice calc lacks some functionality to keep users informed
about the status of the processed file

i think three cases should be handeled

1) - the loaded file displays wrong or outdated values, for whatever reason,
something should be red in that case, green if everything is ok, and on
mousover show a note 'outdated values loaded with file, consider recalculation'
or 'values loaded from file match current calculation results', 

2) - the user changes something in a map / sheet and it's not recalculated
(e.g. reg. autocalculate being 'off' or whatever other reason), something
should be red in that case, green if everything is ok, and on mousover show a
note 'shown results not recalculated after changes, consider recalculation' or
'all changes recalculated', 

3) - the user changed something in the map / sheet and it's not saved after
that, something is! red in that case (a little floppy symbol at the bottom of
the window), that could be placed in better sight of the user, green if
everything is ok (as is it's grey when no saving is neccessary), and on
mousover it shows a note 'The document has been modified. Click to save the
document.', it's combined with functionality. 

------------ 

for 1) this is the most critical point, users may be trapped by shortcomings in
files they get from others, shortcomings in files saved with buggy versions, or
other problems out of their sight and influence, 

see: https://bugs.documentfoundation.org/show_bug.cgi?id=120013#c17

you can check the file 

http://bugs.documentfoundation.org/attachment.cgi?id=145073

by opening with a zipper proram (e.g. 7zip) and opening the file content.xml
inside with a browser (e.g. firefox), 

i couldn't find a cell reference in the entries, thus it's not too easy to find
the affected entries, i think they are the lines 

<table:table-cell table:style-name="ce111"
table:formula="of:=SUM([.C$3:.C12])-SUM([.D$3:.D12])" office:value-type="float"
office:value="1900" calcext:value-type="float">

near the end of the file, 

somewhere else Eike Rathke and others stated that it's not possible to check
whether recalculation is neccessary, i think it should be possible, just do a
recalc in background - with reduced priority to lessen impact in workflow, and
compare to displayed or stored results, 

this point affects the whole range of autocalculate off, compatibility with xls
and xlsx files and 'freshness' of calculations there, settings for recalculate
on load in options (are they removed?) and so on ... 

contrary to check and explain what happened to irritated users one by one after
they stepped into problems - consider calculating target coordinates for
missile s - it could be a better idea to keep all users informed before
problems occur. 

during the check of necessity of a recalculation (this can happen in the
background with reduced priority) the signal could be yellow with a hint-text
'processing data integrity check' 

------------

for 2) this is critical too, users may be trapped by settings done by others,
settings they forgot about, or other stuff blocking recalculation. 

------------

for 3) it could be 'nice to have' that symbol somewhere 'in sight' of the user,
perhaps a stacked 'hamburger menu symbol' in the upper right corner of the
screen, one dot (bottom) for 'loaded file lacks recalc', one (middle) for
'actual work not saved', one (top) for 'changes require recalculation', when a
user see's 'all green' he knows 'everything ok' (despite unfixed bugs). 

------------

apologize if i missed something already in the program, 

reg. 

b. 

Steps to Reproduce:
see above description

Actual Results:
user uninformed

Expected Results:
would ease use of program when user gets qualified status information, 


Reproducible: Always


User Profile Reset: No



Additional Info:
actually testing: 

Version: 6.4.0.0.alpha1+ (x64)
Build ID: d456ca6efb98d707427228e8131dfe8a5f27e2f6
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: threaded

user profile reset?: no as it's not a bug, 

opengl enabled?: no

-- 
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/20191111/9e65f78d/attachment-0001.html>