[Libreoffice-bugs] [Bug 51015] EDITING: conditional formating does not update automatically

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #15 from b. <newbie-02 at gmx.de> ---
in sample 2 with ver 4.1.6.2 

A.) the conditional format is! applied to cells A2 to A8 in the copied sheet
after! input to / edit of one of these cells, not to all of them, but to all
below the changed cell, 

B.) new copies of sh1 work as buggy as sh2, 

with ver 6.3.0.0.alpha0+_2019-03-22

C.) effect A.) changes from affecting cells below the edit to affecting all
cells in the 'group' A2:A8

D.) new copies of sh1 work correctly, while sh2 still fails, 

funny side effects: 

1.) a 'non changing edit' like input of a space and deleting it before pressing
enter or just touching the cell with 'F2 and enter' affects the touched cell,
but not! the others in the 'group' to get the intended formatting, while input
of a value affects the other cells in A2:A8 as well (not visible if it's
affecting A1 as this is changed beforehand), 

2.) effect 1.) changed from affecting the whole group to only the edited cell
on real edits after changing the formula for the conditional format from '<0'
to '>0' and stayed that way when changing back to the old formula, 

this is the first / oldest occurence of: 

'autocalculate not working correctly for groups of cells'

i've found yet, not sure how much it is 'related' to other bugs like #123714,
#123736, #124270, but i assume it may be ... it's something in the area of
'having a group', and keeping most of it's definition but breaking it apart for
the 'recursion?' of autocalculate on 'actions' with or inside the the group of
cells or referenced ranges ... 

just my two cents ... 

suggestion: estimated from effect D.) there must be something stored as
'property' in the file that's 'related' to whether cells are autocalculated
correctly. as it is possible to have 'old' sheets with 'broken' content,
formatting or functionality in it, imho it would be a great idea to add a 'file
checking utility' to calc which - either triggered manually or like the
recalculation of excel files or 'not saved with lo' files on load of a file -
could run and check for occurences of 'old misbehaviour' or 'problems with
files saved by buggy versions', and either warn the user about it or correct
the fault (!with notice to the user that his file will change it's behaviour!), 

- i've read something about the usances in this community and that it's wrong
to write what follows, but feel under pressure to bring it in discussion. 

- this error is around for nearly 7 years now, and not yet fundamentally fixed.
it might be 'related' to plenty other bugs (i've heard something about 'code
re-use' in modern styles of programming), thus it might be difficult to get out
the other errors while this one is unresolved. i'd like to change the
importance to 'critical', but will let that to other users who know better if
and when steps like this are suitable. 

- you / we / the community advertise(s) with 'the spreadsheet you ever wanted'
or similar ... imho fundamental bugs in calculating (also if they 'only' affect
presentation of results, such things may be very important for the user and the
use and usability of the results) should be handled 'in time' and in a proper
way. the codebase has to be clear and reliable for all things affecting
calculations and results before! we argue about the size of triangels in
symbols and spend time for things like that ... 

reg. 

b.

-- 
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/20190324/604cf8d4/attachment-0001.html>