When Value starts with equal value(=) in cell, it is showing #ERROR message.

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.72k stars 824 forks source link

When Value starts with equal value(=) in cell, it is showing #ERROR message. #1604

Closed shubhamkr820 closed 1 year ago

shubhamkr820 commented 1 year ago

When cell value starts with equal value(=), it is showing #ERROR message. How to fix this ?

hodeware commented 1 year ago

string starting with = means a formula, so your formula presents error. If you don't want that you might need to disable the calculations.