Connecting Tech Pros Worldwide Help | Site Map

a webpage like excel sheet

Newbie
 
Join Date: Aug 2009
Posts: 30
#1: Aug 4 '09
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's Avatar
Moderator
 
Join Date: Aug 2008
Location: Leipzig, Germany
Posts: 3,629
#2: Aug 4 '09

re: a webpage like excel sheet


Quote:

Originally Posted by totomalas View Post

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

why do you want that? for Excel functionality you could use Excel (or open office or google docs, ...)
Newbie
 
Join Date: Aug 2009
Posts: 30
#3: Aug 4 '09

re: a webpage like excel sheet


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's Avatar
Moderator
 
Join Date: Aug 2008
Location: Leipzig, Germany
Posts: 3,629
#4: Aug 4 '09

re: a webpage like excel sheet


so you have a fixed calculation formula? i.e. the user dosn’t have to insert the math?
Newbie
 
Join Date: Aug 2009
Posts: 30
#5: Aug 5 '09

re: a webpage like excel sheet


Yes a fixed calculation formula, the user only insert his number...the formulas are fixed for every user...
Dormilich's Avatar
Moderator
 
Join Date: Aug 2008
Location: Leipzig, Germany
Posts: 3,629
#6: Aug 5 '09

re: a webpage like excel sheet


so you basically need some input fields in a neat layout?
Newbie
 
Join Date: Aug 2009
Posts: 30
#7: Aug 5 '09

re: a webpage like excel sheet


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's Avatar
Moderator
 
Join Date: Aug 2008
Location: Leipzig, Germany
Posts: 3,629
#8: Aug 5 '09

re: a webpage like excel sheet


so, which one is the problem (JS (the math) or HTML (the layout))?.
Newbie
 
Join Date: Aug 2009
Posts: 30
#9: Aug 5 '09

re: a webpage like excel sheet


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's Avatar
Moderator
 
Join Date: Aug 2008
Location: Leipzig, Germany
Posts: 3,629
#10: Aug 5 '09

re: a webpage like excel sheet


Quote:

Originally Posted by totomalas View Post

but i dont know how to make the button work,

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

Quote:

Originally Posted by totomalas View Post

and where to write the code,

an external script file will be fine

Quote:

Originally Posted by totomalas View Post

and how to link the button with the textBoxes....

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).
Reply