Spredsheet "simple" macro

Desktop editors
,
1

Can anyone assist me with creating a macro assigned to a button?

I am coming over from MS Office where I had 2 macros assigned to two buttons, one deletes current row and the other one adds a row with all the properties (formulas) from the row above.
Since I’m not a programmer I achieved this by searching the web for solutions I could apply and found them. The same does not apply for Onlyoffice, can anyone assist?

I would like to use Onlyoffice exclusively and this is the only thing basically preventing me from doing so…

2

Hello @WTF
Could you please provide us with examples of your VBA codes of mentioned macros? We will take a look at it.
As for ‘assign macro to a button’ , unfortunately there’s no ready-to-go solution for you.

1 Like
3

Here are the scripts that were running

add new row with formulas from above:

Sub InsertRow3()
Application.CutCopyMode = False
Dim rw As Long, cl As Long
Selection.EntireRow.Insert
n = ActiveCell.Row
For cl = 1 To Columns.Count
If Cells(n + 1, cl).HasFormula Then
Cells(n + 1, cl).Copy Cells(n, cl)
End If
Next
Cells(n, 1).Select
End Sub

delete row:

Sub deleteSelectedRow()
ActiveCell.EntireRow.Delete
End Sub

4

Hello @WTF
Unfortunately, there’s no way to achieve your scenario at the moment since we don’t have necessary methods for spreadsheets (internal numbers - 51771 and 51537). We are still working on it. Probably mentioned methods will be added with v.7.1
Sorry for inconvenience.

1 Like
5

No problem, thank you for your response.

6

Hi, is this possible now in 9.2?

7

Hello @Elyssaen
Yes, we added necessary methods in v.7.1. Samples:

    let oSheet = Api.GetActiveSheet();
    let oCell = oSheet.GetRange('A2');
    oCell.Delete();

…

    let oSheet = Api.GetActiveSheet();
    oSheet.GetRange('A1:B2').Copy(oSheet.GetRange('A3:B3'));
    oSheet.GetRange('A1:B1').Paste(oSheet.GetRange('A2:B2'));