https://bugs.documentfoundation.org/show_bug.cgi?id=100297
--- Comment #8 from Wolfgang Jäger <[email protected]> --- (In reply to Eike Rathke from comment #6) > (In reply to Wolfgang Jäger from comment #2) > > It is still unclear which properties of cells allow chagnes by SIDE-EFFECTs > > of user functions called during the evaluation of a formula IN THE SAME > > SHEET. > > > > The classical restriction was (and still is in AOO) that no changes at all > > are allowed. > Best would be to go back to that behaviour.. least surprises. > > > LibreOffice since V5.1 (at least) loosened this restriction: > > .String > > .Value > > .Formula e.g. > > accept assignments, .Formula with the exception of new content "". > Which IMHO is *wrong*. Any modification to content while a calculation is > running cries for undefined behaviour. I also see risks, but why can changes to cells in other sheets by side-effects of calculations (also by UDFs) be accepted though the "current" sheet may contain cells depending on them? For the time the restriction was relieved: Were there actually reports about related malfunctions? ... > > Other properties, in specific those containing hard attributes and the > > .CellStyle > > property refuse to accept an assignment. > Even those, with conditional formatting and the dreaded STYLE() function and > CELL() obtaining formatting, can clash with calculations. > > > Above statements are made after testing with V5.4.1 and V5.4.2 today. > > > > Is there any specification concerning this? > No. It depends on implementation and actual spreadsheet content / formulas > what could work and what not. The safe side is to not allow any > modifications. > > Even modifications on other sheets than the user defined function being > called from aren't safe, they are just less likely to interfere with less > inter-sheets references, and it is possible to build well behaving documents > when knowing the implications. Yes. See above. Nevertheless such side-effects are accepted, and I can't remember (e.g.) lots of questions in the ask site related to the issue. Also: I didn't want to ask about ODF specifications, but about rules developers have to regard. There must be such rules, and "my bug" is about the rules that are defined for the implementation called LibreOffice. -- You are receiving this mail because: You are the assignee for the bug.
