ONLYOFFICE Docs v7.3 released: enhanced forms, SmartArt, new security settings, Watch Window, and more
ONLYOFFICE Docs v7.3 released

Affichage message

I don’t find an example JS macro to display a text message of 2…3 lines…
Maybe a box?

I try at all costs to get out of it … but unfortunately I’m going in circles!
The web has almost no examples of Macros Only and the can found on GitHub is uninstallable !
I tried to use these two lines that work on Google sheet… but it doesn’t work!!

var app = SpreadsheetApp ;
var classeur = app.getActiveSpreadsheet() ;

SpreadsheetApp.getUi().alert ('\t⚠️.\t  -- INCOMPLET --   \n\nLa Catégorie n"est pas renseignée ...');

There too, retrieved from your site, these lines do not work! ??

    var oDocument = Api.GetDocument();
    var oParagraph = Api.CreateParagraph();
    oParagraph.AddText("Hello world!");

Hello @Max

Unfortunately, we don’t have ready-to-go macro for this scenario.

Please correct me if I’m mistaken, but you are trying to insert data to a worksheet, aren’t you? If that’s so, then please note that the mentioned by you macro is used for Document Editor. Here is example of simple macro what will allow you to insert data into a defined cell in Spreadsheet Editor:

Thank you for your answers.
Do you know when the next evolution of the programming system will take place?

I don’t quite understand the question, could you clarify?

I was talking about the evolution of javascript which would allow, in spreadsheets, to have for example instructions allowing the insertion of text areas, or dialog boxes…

Unfortunately, I don’t know.