I’d like to propose a feature in the spreadsheet editor which is working in Excel but not in OnlyOffice.
That is, if you define a named range using a formula (i.e. the actual range of cells depends on some inputs) you cannot currently use this named range to define the x- or y-axis in a chart.
Example:
You have population data from 1901 to 2023. Years in column A1:A123, population data in column B1:B123. You have another input in C1 called "show data until: ", so for example if you only want to show the data until 1989 in the chart then you put 1989 in C1.
In Excel you’d create a named range called “chosen_range” (for example) with a formula like =OFFSET($B$1,0,0,$C$1-$A$1) or in other words your range includes all the years in column B from the year 1901 until the year 1989. Then you create a chart where you use “chosen_range” as the data source. You end up with a chart showing the population until 1989. But now the user can also put in any other number in C1 and the x-axis on the chart will adjust accordingly, without having any empty space on the right
Currently if you save such a file in Excel and open it in OnlyOffice, it will not update the chart when you change anything in C1.