Calc Scripting Framework error?

[FrogFan]

Hello,

Here is the version information I’m running:

Version: 25.8.7.3 (X86_64)
Build ID: 30742500f2d3eb4366ac312fa33d3dcabdb3eba5
CPU threads: 12; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

I’m getting this message about a “Scripting Framework” error from time to time, usually right after I edit a cell formula.

My spreadsheet seems to function normally, but I’m wondering if I’m doing anything that is causing this error and, if so, what I should do to prevent it.

Thanks for any help.

[sokol92]

How is the TestRefresh macro from the Module1 module of the Standard application library (from My Macros...) used in the document?

[FrogFan]

I never use that macro. I’ve never seen this error when running version 25.2.6.2. I only recently upgraded to 25.8.7.3.

[sokol92]

But LibreOffice wants to use this macro.
Perhaps this macro is assigned to events for this specific document or to events for all opened documents?
Open the document and look at the Menu/Tools/Customize/Events tab.
Do this for both the “Save in:” field value equal to the document name and the “Save in:” field value equal to “LibreOffice.”

[cwolan]

Is Sheet ⟶ Sheet Events worth checking out?

[sokol92]

Yes, if the first stage of troubleshooting is unsuccessful.

[FrogFan]

OK. I’ve navigated to Tools/Customize/Events. Now I’m looking at the following popup:

What do I do next? I don’t see a “Save in” option.

Thanks for the quick response!

Edited to add: There is no “Assigned action” to Save document name or Save LibreOffice. In fact, there is no Assigned action to any of the listed events

[sokol92]

The “Save in” drop-down list is at the bottom of your image. Please check all events (this may require scrolling).
If this doesn’t work, proceed to the next step.
For each sheet in the document:
Right-click the sheet tab, select “Sheet Events…” from the context menu, and look for the events to which macros are assigned.

[sokol92]

@sokol92

TestRefresh

I think I’ve found the source of the problem.

[FrogFan]

Well, hmmm. Have I caused this problem myself? Perhaps I’ve forgotten a few things in the last couple years. But I’m still confused. There is, and has never been, a macro called TestRefresh in my spreadsheet. Here is what I’ve found among sheet events:

For the sheet containing the data in my Pivot Table, I have the following

For the sheet containing the actual Pivot Table, I have this:

Here is the list of macros I have available:

Finallly, here is the actual “refresh_PivotTables” macro:

Sub refresh_PivotTables()
for each pv in ThisComponent.CurrentController.ActiveSheet.DataPilotTables
  pv.refresh()
 next
End Sub

[sokol92]

In my practice, such “bookmarks” have surfaced even after 25 years.

[FrogFan]

For what it’s worth, I’m going to remove the reference to the non-existent macro and see what happens. I have no idea how that got there, unless I created the TestRefresh macro some years ago, deleted it, and forgot to remove it from the sheet event action. The pivot table actually refreshes itself just fine using the (actually existing) refresh_PivotTables() macro.

Thanks very much for your patience and detective work!