Just for fun; I recorded a macro in LibreOffice Basic that sets the text in a cell.

This is a sample:

  dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

  dim args1(0) as new com.sun.star.beans.PropertyValue
  args1(0).Name = "ToPoint"
  args1(0).Value = "$C$7"

  dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1())

That first line is confusing and obsolete. Sun doesn't exist any more, it is two generations of branding from being StarOffice, and good luck figuring out why the service is named after a card game. Even a programmer isn't going to figure all that out without knowing the history of the project.

Now in MS Office I'm pretty sure this would be something like ActiveSheet.Cells(1, 5) = "foo". There is nearly no discovery for the LO Basic equivalent 'sheet.getCellByPosition(3,16) = "foo"'.

It really is worlds apart. I don't see how a moderately sophisticated user can learn to write LO macros without finding a reference manual and investing hours orienting themselves. I've seen people teach themselves to a useful standard using MS Office macro recordings.

EDIT More importantly, a novice wouldn't necessarily understand that the recorded macro isn't the accepted way to select a cell. Even realising that a cell can be selected with one line is hindered by the LO macro recording.