DocumentServer icon indicating copy to clipboard operation
DocumentServer copied to clipboard

Feature Request: Custom JS Code Execution in Table Editor

Open eSkry opened this issue 1 year ago • 2 comments

This issue is unique.

  • [X] I have used the search tool and did not find an issue describing my idea.

Your idea.

Description: Add a feature for the table editor that executes JS code.

Idea: Implement the ability to easily create custom complex calculations by writing JS code. The function should accept a variable number of arguments, which will be used in the JS code. The last argument should be the JavaScript code as a string.

Example Formula: =JSEXEC(arg1, arg2, arg3, "function myFunc(n, r, u) { for (var c = 0, f = 0; f < u; f++) c += n / f; return c; } myFunc(arg1, arg2, arg3);"). The code will likely need to be minified for string representation.

Source Code:

function(price, period, count) {
    /* calculate */
    var res = 0;
    for (var i = 0; i < count; i++) {
        res += price / i;
    }
    return res;
}

This sentence is a simplified format of my previous sentence.

eSkry avatar Jun 04 '24 12:06 eSkry

@eSkry Thanks for your issue. I have issued an enhancement #68410 on our private bug tracker

askonev avatar Jun 05 '24 16:06 askonev

The issue is actual in DocumentServer. Moving this issue to DocumentServer, because it is our main repository.

Rita-Bubnova avatar Jun 05 '24 16:06 Rita-Bubnova