Referencing cells on 2nd sheet
When creating a formula, I can easily click on a cell in the same sheet and its reference in included in the formula. Very good. However, from what I have seen this is not the case when I want to use a cell that …
Starting from Webix 6.4.2 you can use rowHeight and columnWidth properties:
The spreadsheet does not even load in my version of IE (v11.0.9600.19356CO)
You should remove arrow functions and matchAll method (as they are not supported by IE).
Updated example: https://snippet.webix.com/01795cw3
However, in addition, I need to be able to insert a line into Sheet1 and the formulas in Sheet2 are updated.
As I already said, some formulas in the second sheet have absolute cell reference. In your case you need relative, so just not…
We are planning to rewrite the spreadsheet's mathematics, but it's a rather big part of the code, so we can't tell the timeframe.
You can attach inner onCommand event to check if row/col was added/removed, serialize spreadshee…
1) Yes, there is no such built-in feature, but you can try something like that: https://snippet.webix.com/k3ri3vc7
2) Yes, this feature isn't implemented, so it's expected behaviour. We added this to the list of features and in future v…
1) You're using combo editor while spreadsheet can correctly use only richselect, popup, date and text editors. The closest solution is to use richselect editor.
2) As I see, you modified paste, please check implementation in the source…