A web SpreadSheet project written in web language(html,css and JavaScript). It can be run completely offline... ...................................................................................................................................
Live Preview: https://nirmalpaul383.github.io/WebCell-Web-SpreadSheet/
....................................................................................................................................
About: A completely offline JavaScript-based SpreadSheet program. It has been written with pure(stock) JS. No additional 3rd party API or framework/library has been used. I have commented on every major logic's code block in this program.
It is designed in a way that it can automatically create 1300 cells(A-Z Columns and 1-50 Rows) and give a unique ID to each cell. Then this IDs have been used in the cell reference feature. It supports calculation from direct expression and cell reference and also supports all basic excel formulas(including 'if' formula). It supports value auto-update(re-calculation of all expressions whenever the user changes referenced data.)
By default, this program automatically generates A-Z columns and 1-50 rows (1300 cells), but you can change it from inside the code. It also supports cell reference (eg '=a1+5' here a1 is referencing cell A1 ). It also supports formulas, I have tried to include all common formulas. So you will find most formulas predefined. But you can also create your own functions/formulas using native JavaScript code. In fact, not only formulas but also variables, arrays, objects, and almost anything can be created and used later. Please give a start to this project♥.
....................................................................................................................................
This project is originally made by me(N Paul). My github profile https://github.com/nirmalpaul383/ My youtube page https://www.youtube.com/channel/UCY6JY8bTlR7hZEvhy6Pldxg/ ....................................................................................................................................
This is an open source program . You are welcomed to modify it... If you want to support me please give a like to our facebook page https://facebook.com/a.new.way.Technical/ Please give a start to this project♥. ....................................................................................................................................