Hello,
I don’t find an example JS macro to display a text message of 2…3 lines…
Maybe a box?
THANKS.
Cordially.
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!!
SOS !
(function()
{
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! ??
(function()
{
var oDocument = Api.GetDocument();
var oParagraph = Api.CreateParagraph();
oParagraph.AddText("Hello world!");
oDocument.InsertContent([oParagraph]);
})();
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:
https://api.onlyoffice.com/plugin/macrosamples/writedatatoworksheetcell
Hello,
Thank you for your answers.
Do you know when the next evolution of the programming system will take place?
Cordially.
Max.
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.