https://bugs.documentfoundation.org/show_bug.cgi?id=35538
--- Comment #88 from Robert Deck <baiamer1...@gmail.com> --- Created attachment 157251 [details] function_not_evaluated_on_change_in_reference 'macro function not auto-recalculated on changes in referenced cell', while testing old bugs i came across that: the function from comment #11 Function GETCELL(sheetName As String, cellReference As String) oSheet = ThisComponent.Sheets.getByName(sheetName) oCell = oSheet.getCellRangeByName(cellReference).String 'Msgbox(oCell) GETCELL = oCell End Function in ver. 6.4.0.1 is calculated when the file is loaded, but later it is excluded from 'autocalculate'. A recalculation works with F9 with focus in the cell, or ctrl-shift-F9, or save-reload, but not regular on changes in the referenced cell. steps to reproduce: 1. load attached sheet, allow macros, 2. change content of A1, 3. observe B1 not changed, 4a. click on B1, then press F9, or 4b. hard recalc (ctrl-shift-F9), 5. observe B1 changed, 6. repeat from 2., still no autocalculation, I think this violates the statement for autocalculate in: https://daschet.com/ -- You are receiving this mail because: You are the assignee for the bug.