https://bugs.documentfoundation.org/show_bug.cgi?id=100297
--- Comment #6 from Eike Rathke <[email protected]> --- (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. > 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. -- You are receiving this mail because: You are the assignee for the bug.
