inserting excel ss that calculates

[Sandy J]

Hi, I want to be able to insert a form which will calulate
a subtotal and then a total at the end of the form. (EG:
and order form with qty/unit $ and total $. with an amount
for postage at the end, then total).

 

[Jim Buyens]

-----Original Message-----

Hi, I want to be able to insert a form which will
calulate a subtotal and then a total at the end of the
form. (EG: and order form with qty/unit $ and total $.
with an amount for postage at the end, then total).

You would need to program this in ASP, ASP.NET, or
whatever form of server-side scripting your host provides.

Coding it in JavaScript is unreliable because visitors can
turn off JavaScript, or modify the code.

Excel is a desktop application and not available to
background processes, such as those on the Web server.

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*

 

[MD WebsUnlimited.com]

Hi Sandy J.

Take a look at Form Calculator
http://www.websunlimited.com/order/Product/FormCalc/formcalc.htm

 

[MD WebsUnlimited.com]

Why? I believe that your assuming that the calculated information will not
be validated at the time the form is submitted.

 

[Jim Buyens]

-----Original Message-----
Why? I believe that your assuming that the calculated information will not
be validated at the time the form is submitted.

I tend to think in terms of solutions I can code, rather
than solutions I can buy. And I always use server-side
code if possible, because there's much more consistency
and control at the server.

Also, why cross-foot the order twice? You have to do it at
the server anyway, to get a reliable result, so why not do
it on the server only?

OK, I guess you might save a few round trips by
calculating first on the browser.

Code vs. buy isn't a question of right or wrong; it's just
a mindset.

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*

 

[MD WebsUnlimited.com]

Can you not code JavaScript? If so then you have nothing to buy. However the
majority of the folks on this NG have little or no skills at programming.
But that was not the point at all and I'm not sure why it was even brought
up.

If you wish to provide immediate feedback to the user when they are just
selecting an item, e.g. subtotal, total, etc. then programming at the client
side is the way to go. There is a place for client-side and a place for
server side if not then there never would have been a need for client side
coding at all.

 

[Jim Buyens]

Can you not code JavaScript? If so then you have nothing to buy. However the
majority of the folks on this NG have little or no skills at programming.
But that was not the point at all and I'm not sure why it was even brought
up.

If you wish to provide immediate feedback to the user when they are just
selecting an item, e.g. subtotal, total, etc. then programming at the client
side is the way to go. There is a place for client-side and a place for
server side if not then there never would have been a need for client side
coding at all.

Sorry. Apparently, I reacted to something that wasn't there.

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*