i’m new to ‘online bug hunting’, pls. be so kind and give some help,
one thing first, i like libreoffice, especially calc, imho it’s much better than commercial competitors, i had massive problem with ex_el and i know why i changed, calc gave so much to me and my life, i ow it gratitude and respect!
i criticise only! to get faults out and keep it’s standard high.
imho calc autocalculate has one or plenty massive bugs in it, which exclude some cells from being recalculated after changes on them, on copies of them, in ranges they point to, and similar.
reports about this show up at least since 2013!, and since version 4.x, plenty of them mentioning ‘obstructive’, ‘randomly’, ‘hard to reproduce’.
i know!!! that working on such bugs is very!!! hard and difficult
but it’s neccessary, reliable autocalculation is one of the fundamental functions of a spreadsheet,
‘F9’ - ‘recalculate’ doesn’t help (in most cases), acc. to what i’d read while ‘autocalculate’ is on F9 recalculates only! intentionally changing cells with functions like ‘random’ and ‘now’ and their dependents, thus ‘normal’ cells and functions are not touched and not recalculated.
(irritating behaviour for users who use their private silly understanding of the word ‘recalculate’, difficult to understand without rtfm, but ok, it’s written somewhere)
(it’s not read by plenty persons, thus hints like ‘Hast Du schon mal im Menü Daten>Berechnen>Neu berechnen (F9) angestoßen, …’ fill the scene)
‘strg-shift-F9’ - ‘hard recalc’, does! correct wrong results in most cases (my limited lifetime blocks me from checking ‘all’), it is suggested as ‘help’ to irritated users … imho that’s ‘eyewash’:
acc. to it’s ‘definition’ in the online wiki ‘autocalculate’ should! recalculate every cell after any change in the sheet.
there is no help to users which cells will fail and when they have to do manual recalculation,
AND!!! … strg-shift-F9 corrects the actually shown results in mostly when you ‘fire’ it, BUT LEAVES THE AFFECTED CELLS EXCLUDED FROM AUTOCALCULATE!!! thus you have to fire it again, and again, and again …
how shall a user produce reliable results with a spreadsheet where most of the cells are autocalculated while sometimes some of them fail???
i’m adressing this problem for some days now, and it starts that i get hints like ‘you already filed bugs about it’, ‘that’s not the same bug’, ‘why do you repeat known bugs?’ ‘use hard recalc’, ‘this bug is fixed’, ‘may be open-gl related’, and so on, while it’s evident to me that the fundamental weaknesses is still present,
everytime i play around and look for errors like these i find new ones, not really new, but other situations where errors show up.
my two cents:
somebody introduced something like excluding some cells from autocalculation when they are not subject to changes, may be his intention was ‘performance’,
he strayed in decision about how to decide which cells may be excluded, especially when ‘groups’ of ‘shared formulas’ are in the game,
- since then plenty developers plastered single symptoms of that weakness, leaving the fundamental bug untouched,
it’s just my idea about the situation, i may be fundamentally wrong …
i’m not! wrong in analysis that there is! at least one fundamental bug producing errors, that it is! still present in ver. 18.104.22.168.alpha0, and that it should be obliterated!
so what shall i do???
file a new bug for every ‘new’ misbehaviour? e.g. there was a fault for ‘=SUM(of a range)’, hen a new one for there is a fault for ‘=PRODUCT(of a range)’ too?
file a new bug for every new place in a sheet i find wrong behaviour? e.g. there is a bug report for moving H7:G8 failing in one sheet, i shall write a new one for moving B1 to B2 produces a similar error in another sheet?
reopen bug reports where i find the error still occurring and get them ‘re-closed’ implying i’m incapable to understand the subject that’s written as headline of the bug report?
i think i’m able to understand ‘Cells not recalculated after moving data within ranges pointed to by a shared formula group’
write a makro to test sheets and produce bug reports automatically?
no - that can’t be the solution,
but i hope there could be a solution, how can i / can we find someone with the skills, time and mood to address this problem in detail?
imho it’s urgent, if the bug is left unfixed i have to change to another software and recommend the same to others
any help appreciated,
P.S. for those who need a detailed test case, use search or google for ‘calc’, ‘autocalculate’, ‘recalculate’, ‘wrong’, ‘fail’, ‘error’, ‘excluded’ and similar keywords, you’ll find enough of them