Copy - Paste Macros about onlyoffice.github.io

[askonev]

@PranksterDr Hi! At the moment, an analogue of the Select object is not implemented in Spreeedsheets, so at the moment the implementation of copy and paste is possible using algorithms. Perhaps the ApiRange.ForEach method implementation will help you, allowing you to work comfortably with the cells of the selected area using callback. Also your solutions using this method will be sufficiently productive in view of the low-level optimization in the browser's JavaScript engine.

An article with js performance research methods.

A simple example of copying using ForEach

oSheet = Api.GetActiveSheet();
oRange = oSheet.GetRange('A1:C1');
numCurrentRow = 3;
    
oRange.ForEach(function(range) {
    
    oValue2 = range.GetValue2();
    numCol = range.GetCol();
    oCurrentRow = oSheet.GetRangeByNumber(numCurrentRow, numCol);
    oCurrentRow.SetValue(oValue2);
    
});

[ShockwaveNN]

Hi, could you describe in more details what you want to do?

You want to be able to copy some text to buffer and past in some other application?
I'm not sure if this possible, since we even have varning when you use Paste button about it working correctly only in current tab of Editors

[PranksterDr]

No. I try copy range and paste this range in other row with macros. Is it possible with JS into spreedsheet ? Ofcourse old valuei need save. (Я имею ввиду, что пытаюсь с помощью JS сделать дубликат строки. Т.е. мне необходимо создать пустую строку со сдвигом вниз и заполнить ее данными из предыдущей строки)

[PranksterDr]

Например VBA позволяет копировать и вставлять как ячейки, так и диапазоны и строки, и столбцы. Для этого есть метод Selection, который включает Copy и Paste. Можно конечно на JS сделать перебор всего массива и последующим сдвигом вниз всего массива. Но это очень ресурсоемкая операция.

[ShockwaveNN]

@askonev Please take a look at this issue, could you help to clarify that?

[PranksterDr]

@askonev Hey! Thanks for the answer ! I completed this task in the same way using a loop. But still, the copy and paste function is missing(sad). It will be very cool if it will appear in the next versions of the API. In my work I using a loop implemented a method for duplicating rows.