search

myliang / x-spreadsheet

The project has been migrated to @wolf-table/table https://github.com/wolf-table/table
https://myliang.github.io/x-spreadsheet
MIT License
13.97k stars 1.67k forks source link

How to get calculated value from a formula #691

Open Brandzess123 opened 2 months ago

Brandzess123 commented 2 months ago

Hi, I have a question here, this is my value from my x-data-spreadsheet [ { "value1": "", "value2": "", "value3": "", "value4": "12", "value5": "", "value6": "", "value7": "", "value8": "", "value9": "", "value10": "" }, { "value1": "", "value2": "", "value3": "", "value4": "=sum(d1,a4)", "value5": "", "value6": "", "value7": "", "value8": "", "value9": "", "value10": "" }, { "value1": "", "value2": "", "value3": "", "value4": "a123", "value5": "", "value6": "", "value7": "", "value8": "", "value9": "", "value10": "" }, { "value1": "12", "value2": "", "value3": "", "value4": "", "value5": "", "value6": "", "value7": "", "value8": "", "value9": "", "value10": "" }, { "value1": "", "value2": "", "value3": "", "value4": "", "value5": "", "value6": "", "value7": "", "value8": "", "value9": "", "value10": "" } ] so is there any way to get exact value from excel not the formula like value4": "=sum(d1,a4) .Thanks for your help!