Hey there! I totally get where you're coming from—adapting Excel exercises to LibreOffice can have some quirky differences, especially when it comes to macros. Let's break down why your recorded macro isn't working, and how to fix it.

The Core Issue #

LibreOffice Calc's macro recorder doesn't natively record direct formula input into cells—this is a key difference from Excel's recorder. When you type =RAND() and hit enter, the recorder just doesn't translate that action into usable Basic code, which is why you're seeing empty or non-functional macro files even after testing other built-in functions.

The recorder is designed to capture UI-based actions (like applying formatting, inserting rows, or using menu-driven function inserts), but direct formula typing slips through the cracks.

How to Make It Work (Manual Macro Approach) #

Since recording won't cut it here, you'll need to write a simple Basic macro to insert the formula instead. Here's a straightforward example for inserting =RAND():

Sub InsertRandFormula
    ' Get the active sheet
    Dim oActiveSheet As Object
    oActiveSheet = ThisComponent.CurrentController.ActiveSheet
    
    ' Get the currently selected cell (or specify a cell by position)
    Dim oTargetCell As Object
    oTargetCell = ThisComponent.CurrentController.Selection
    
    ' Set the formula for the cell
    oTargetCell.Formula = "=RAND()"
End Sub

Quick breakdown of the code:

• ThisComponent.CurrentController.ActiveSheet grabs the sheet you're working on
• ThisComponent.CurrentController.Selection targets whatever cell you have selected when running the macro (you can also hardcode a cell position like oActiveSheet.GetCellByPosition(2,3) for cell D4 if needed)
• Setting the Formula property to your desired function string tells Calc to insert and evaluate the formula

If you want to test other built-in functions, just replace "=RAND()" with something like "=SUM(A1:A10)" or "=AVERAGE(B2:B5)".

A (Less Reliable) Recording Workaround #

If you really want to try recording instead of coding, some versions of Calc will record function inserts if you use the menu:

• Select your target cell
• Go to Insert > Function
• Search for and select RAND from the function list
• Click OK to insert it

This might get captured by the recorder, but results can vary depending on your LibreOffice version. Manual coding is always more consistent here.

Even though you know non-macro methods are easier, it's great you're experimenting with macros—this kind of deep dive helps you understand how Calc's automation works under the hood!

内容的提问来源于stack exchange，提问作者Jay