trying to create a plugin oI see no way to do so.

[ungentilgarcon]

BUG
What is the current behavior?
when I try to download your examples of code (under sdkjs) and create plugins out of it, it doesn't import them.
also, documentation to do so is really scarce, is there another source of documeentation for doing so?

If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem.
DL the code under this section, create a Plugin file ,try to import it with the add plugin button .

[ShockwaveNN]

Do you read this documentation

Creating plugin is not the easiest task, but it's documented rather good

[ShockwaveNN]

@ungentilgarcon You definitely heard and my colleagues get back to you as soon as them got free time

[ungentilgarcon]

Thank you, we are thinking of moving our city to OO, we'll ask for devs of macros/plugin actually (talked with artem Avdeev about it) but I wanted to try and see what's realistic and what isn't.

[ShockwaveNN]

if you really think about that I think all question should be handled via [email protected] or [email protected] since those task have a higher priority, that support of opensource users

[ungentilgarcon]

well I think it's important that your documentation actually include informations about this.

Regards

[ShockwaveNN]

I'm not saying we'll not include any additional docs after we figure out this situation, more than figuring out stage for paid customers has higher priority, of couse

[askonev]

@ungentilgarcon hello!

To answer your questions

1. Fully implemented support for ECMAScript 2015
2. At the moment it is not possible to add custom functions to the table editor.
3. there is currently a limitation in working with plugins. You cannot get the result of scripts for a macro in the context of a plugin. In other words it is not possible to manipulate table cells directly from plugin.

Based on the above, I can offer to implement a macro that overwrites data from the active cell.

Macros code

(function()
{

//...code implemented here https://jsbin.com/qesiwelesa/edit?html,js,output

  var oWorksheet = Api.GetActiveSheet();
  var oActiveCell = oWorksheet.GetActiveCell();
  oActiveCell.SetValue(removeDiacritics(oActiveCell.GetValue()));
})();

The next step is to realize the following non-visual plugin

config.json parameter

https://api.onlyoffice.com/plugin/config#isVisual

You can imagine using this plugin step by step in the following way:

1.Activate the cell
2.Click on the plugin icon in the editor interface

Result:

Plugin using the method https://api.onlyoffice.com/plugin/callcommand
updated the data in the selected cell

[askonev]

@ungentilgarcon As for methods to determine the number of cells with a certain color, I think that this functionality is redundant. Try to implement this script yourself and if it fails, then create a new issue in which I will implement the example

[ungentilgarcon]

@askonev
why are you saying it is redundant? is there anything implemented already?.

I see nothing of that sort

[ungentilgarcon]

If you say redundant I'd ask you what you think it is redundant with? ;)

regards

[askonev]

@ungentilgarcon Can you show an analogue implemented by microsoft or google?

Best regards

[ungentilgarcon]

@askonev I've described it thoroughly @ https://helpdesk.onlyoffice.com/hc/requests/35504

[trofim24]

@ungentilgarcon you can use GetActiveCell for get active cell in a worksheet. You can use GetFillColor for get background color of cell.
Also we added a lot of samples. Thanks