search

jspreadsheet / ce

Jspreadsheet is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with other spreadsheet software.
https://bossanova.uk/jspreadsheet/v4
MIT License
6.66k stars 818 forks source link

Formula automatic updates range but not the result value #1649

Closed ps91 closed 9 months ago

ps91 commented 9 months ago

Hi,

I'm testing a simple formula SUM(B1:B4) where the column B is of type number and the formula is in the last line in another column. I want to be able to add a new line in the spreadsheet and see the formula update it's value but that's not happening. The formula updates the range when I add a new line like SUM(B1:B5) but never takes into account the value I put in column B for that new line. If I change the other lines that already exist it updates but the new line it doesn't do anything. If updates the range of the formula when I add a new column why doesn't it update the value accordingly with the value of the new line?

paulorodalves commented 9 months ago

Hi,

This feature is only available on the Pro version: https://jspreadsheet.com/docs/