[Libreoffice-bugs] [Bug 79588] Macros called from within formulas doesn't survive save, close and reopen of the calc-document.

[bugzilla-daemon at bugs.documentfoundation.org]

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

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |newbie-02 at gmx.de

--- Comment #25 from b. <newbie-02 at gmx.de> ---
Created attachment 157251
  --> https://bugs.documentfoundation.org/attachment.cgi?id=157251&action=edit
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://help.libreoffice.org/6.3/en-US/text/scalc/01/06070000.html?DbPAR=CALC#bm_id3145673

"Automatically recalculates all formulas in the document.

All cells are recalculated after a sheet cell has been modified. Any charts in
the sheet will also be refreshed."

Could someone please check: 

- if i've made any mistakes, 

- whether the behaviour is 'normal' or an error, 

- if i should file a new bug for this or if the comment here is enough, 

In my opinion the error is quite important because it hinders any analysis or
corrections for plenty other 'macro-function related' bugs. 

(pls. don't ask, yes! 'autocalculate' was activated at the test)

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/20200119/b35605c3/attachment.htm>