Hello,
I am using ONLYOFFICE Desktop Editors Community Edition 9.1.0.167. I want to achieve the following using a macro, which I can assign to a button:
Create a table (Table object) on a spreadsheet.
Ensure that when data is entered into this table, new rows are automatically added so that the data never goes outside the table.
This way, all data will always remain within the table structure.
The goal:
I have two sheets; one is a form sheet where data is entered, and the other is a target sheet where the data will be stored. The entered data should be added to a table in the target sheet via a button. Each new entry should be added to the next row within the table, so that all data stays inside the same table.
Note: I do not want to manually add rows to the table; all row additions should happen automatically