a webpage like excel sheet

[totomalas]

I want to develop a webpage that works like an Excel sheet...

it has some textbox where the visitor can enter numbers inside them, then presses on a button "calculate"...then it gives the result in a textbox...

I feel this is easy,,but I dont know how to do it... I know HTML is only for designing the page...but how can i make a code and enter formulas like the ones i do in Excel (e.g. =(B2+B3)*C3)

also is there any software that will make this easy for me?... i am new to web development...

[Dormilich]

@totomalas
why do you want that? for Excel functionality you could use Excel (or open office or google docs, ...)

[totomalas]

I need it because I want to place this page on a website and it will be used by old people...so they just need something to plug in their numbers and get their total expenses and a projection of their expenses for the coming ten years....

[Dormilich]

so you have a fixed calculation formula? i.e. the user dosn’t have to insert the math?

[totomalas]

Yes a fixed calculation formula, the user only insert his number...the formulas are fixed for every user...

[Dormilich]

so you basically need some input fields in a neat layout?

[totomalas]

Yes a neat layout with input fields...and a button that once presses on will excute a code that takes the inputs, apply the formulas i programmed and give the result to the user..

[Dormilich]

so, which one is the problem (JS (the math) or HTML (the layout))?.

[totomalas]

the layout is no problem, I am using web Expression and I am able to design it...but i dont know how to make the button work, and where to write the code, and how to link the button with the textBoxes....

[Dormilich]

@totomalas
if you don’t do calculation on the server, you simply need an event listener, which executes a function when the button is pressed.

@totomalas
an external script file will be fine

@totomalas
you don’t "link" the button to the boxes, the button is rather a trigger to start some Javascript to do something (including fetching the text boxes’ values).