Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.javascript > #17406 > unrolled thread

form field/spreadsheet question

Back to article view | Back to comp.lang.javascript

Contents

  form field/spreadsheet question "Jon" <no-reply@no-reply.com> - 2012-12-01 23:22 -0500
    Re: form field/spreadsheet question Luuk <luuk@invalid.lan> - 2012-12-02 13:55 +0100
      Re: form field/spreadsheet question Wally W. <ww84wa@aim.com> - 2012-12-02 12:19 -0500
        Re: form field/spreadsheet question Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-12-02 19:06 +0100
          Re: form field/spreadsheet question Wally W. <ww84wa@aim.com> - 2012-12-02 14:29 -0500
            Re: form field/spreadsheet question Denis McMahon <denismfmcmahon@gmail.com> - 2012-12-02 20:10 +0000
              Re: form field/spreadsheet question Wally W. <ww84wa@aim.com> - 2012-12-02 17:18 -0500
            Re: form field/spreadsheet question Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-12-02 21:22 +0100
              Re: form field/spreadsheet question Wally W. <ww84wa@aim.com> - 2012-12-02 17:15 -0500
                Re: form field/spreadsheet question Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-12-03 00:29 +0100
                  Re: form field/spreadsheet question Wally W. <ww84wa@aim.com> - 2012-12-02 19:55 -0500
                  Re: form field/spreadsheet question Dr J R Stockton <reply1249@merlyn.demon.co.uk.invalid> - 2012-12-03 18:30 +0000
                    Re: form field/spreadsheet question Andrew Poulos <ap_prog@hotmail.com> - 2012-12-04 11:26 +1100
              Re: form field/spreadsheet question John G Harris <john@nospam.demon.co.uk> - 2012-12-03 20:18 +0000
                Re: form field/spreadsheet question Andrew Poulos <ap_prog@hotmail.com> - 2012-12-04 07:43 +1100
                  Re: form field/spreadsheet question John G Harris <john@nospam.demon.co.uk> - 2012-12-04 09:10 +0000
                    Re: form field/spreadsheet question Andrew Poulos <ap_prog@hotmail.com> - 2012-12-04 20:31 +1100
                      Re: form field/spreadsheet question Scott Sauyet <scott.sauyet@gmail.com> - 2012-12-04 06:15 -0800
                      Re: form field/spreadsheet question John G Harris <john@nospam.demon.co.uk> - 2012-12-04 14:34 +0000
    Re: form field/spreadsheet question Martin Leese <please@see.Web.for.e-mail.INVALID> - 2012-12-02 11:27 -0700
      Re: form field/spreadsheet question "Jon" <no-reply@no-reply.com> - 2012-12-02 19:01 -0500
        spreadsheet-to-Javascript translator "Jon" <no-reply@no-reply.com> - 2012-12-02 20:06 -0500
          Re: spreadsheet-to-Javascript translator Patricia Shanahan <pats@acm.org> - 2012-12-03 10:26 -0800
      Re: form field/spreadsheet question Ben Bacarisse <ben.usenet@bsb.me.uk> - 2012-12-03 02:42 +0000

Page 2 of 2 — ← Prev page 1 [2]

#17425

"Martin Leese" <please@see.Web.for.e-mail.INVALID> wrote in message 
news:k9g6id$otv$1@dont-email.me...
> Jon wrote:
>> Please go to my web page and see what I'm trying to do:
>>
>> http://3d-triangulation-calculator.bravehost.com/
>>
>> The user enters 12 values into the Input form fields, clicks on 
>> "Calculate" and the page displays the answer as 6 values in the Output 
>> table.
>>
>> It doesn't do that yet, but it is what I'd like it to do.
>>
>> The Input values need to automatically enter into D24:F26 and I24:K24 of 
>> the embedded spreadsheet.  The spreadsheet equations (long and complex) 
>> calculate the solution and are automatically entered in the Output table 
>> from D28:F29 on the embedded spreadsheet.
>>
>> The embedded spreadsheet displayed on the page is a ZOHO spreadsheet 
>> linked from its site.  Below this are two links to the same spreadsheet 
>> in Excel 97 and Open Office Calc.  Below that are the actual equations 
>> used in the spreadsheet calculations.
>>
>> Can anyone help me put this together?  I have been told that there are 
>> java script programs that already do this.  Can I adapt one for this?  Do 
>> I have to have the spreadsheet on the server?  I only know a little 
>> Borland C++ and Microsoft Visual C++.
>
> I would suggest that what you are attempting
> is too ambitious.  As I understand it, your
> process flow is:
>
> 1.  User inputs values into HTML webpage and
>     hits "Calculate".
> 2.  HTML form is submitted to your Web
>     server (although, at the moment, you do
>     not have a form).
> 3.  Web server enters values into ZOHO
>     spreadsheet, and saves ZOHO spreadsheet.
> 4.  Web server converts ZOHO spreadsheet to
>     an Excel spreadsheet and saves that.
> 5.  Web server converts ZOHO spreadsheet to
>     an Open Office spreadsheet and saves
>     that.
> 6.  Web server extracts output values from
>     the spreadsheet and sends them back to
>     the browser (it is not clear whether
>     these would be pushed or pulled).
> 7.  Output values are written into HTML
>     table and displayed in the webpage.
>
> Only item 7 requires JavaScript.  Most of
> the work is done by the server, and you give
> no details of this.  Clearly, JavaScript is
> not the panacea you seem to think it is.
>
> One way to simplify things would be to dump
> the ZOHO spreadsheet and, instead, do the
> calculations in JavaScript in the browser.
> This would avoid the server stuff (items 2
> through 6, inclusive).
>
> Unfortunately, you are using PageBreeze to
> create your webpage, and this is producing
> HTML code that is messy.  This makes item 7
> more difficult than it should be.  Therefore,
> you might want to also dump PageBreeze and,
> instead, learn HTML.
>
>> Is there a tutorial where I can learn javascript for this application? 
>> Where can I find an editor/compiler/debugger for Javascript?
>
> I bought JavaScript: The Definitive Guide by
> David Flanagan, and found it most useful.
> However, JavaScript is not the panacea you
> seek.
>
> -- 
> Regards,
> Martin Leese
> E-mail: please@see.Web.for.e-mail.INVALID
> Web: http://members.tripod.com/martin_leese/

If I do all of the calculations in Javascript, I need to do the following 
matrix operations:

PRODUCT
INVERSE
TRANSPOSE

Does Javascript have these?

I basically need a Javascript spreadsheet.  I don't want to re-invent a 
spreadsheet in Javascript code.

For instance, I need to do Linear Algebra operations on a 3x9 matrix and a 
1x9 matrix.  It would also help if I could do operations on data like an 
Excel spreadsheet, only in Javascript. 

[toc] | [prev] | [next] | [standalone]

#17427 — spreadsheet-to-Javascript translator

I need a spreadsheet in Javascript that does PRODUCT, INVERSE & TRANSPOSE. 
I need the Javascript code that will, for instance, multiply a 3x9 matrix 
with its transpose, then take the inverse of the resulting matrix.

If it does the calculations within the code I don't need a spreadsheet on 
the server.

For instance, the code on this web page does inverse and product:

http://home.ubalt.edu/ntsbarsh/Business-stat/otherapplets/SysEq.htm

Isn't there a complete package somewhere that scripts all spreadsheet 
operations?  A spreadsheet-to-Javascript translator? 

[toc] | [prev] | [next] | [standalone]

#17429 — Re: spreadsheet-to-Javascript translator

On 12/2/2012 5:06 PM, Jon wrote:
> I need a spreadsheet in Javascript that does PRODUCT, INVERSE &
> TRANSPOSE. I need the Javascript code that will, for instance, multiply
> a 3x9 matrix with its transpose, then take the inverse of the resulting
> matrix.
>
> If it does the calculations within the code I don't need a spreadsheet
> on the server.
>
> For instance, the code on this web page does inverse and product:
>
> http://home.ubalt.edu/ntsbarsh/Business-stat/otherapplets/SysEq.htm
>
> Isn't there a complete package somewhere that scripts all spreadsheet
> operations?  A spreadsheet-to-Javascript translator?

The examples you give are common matrix operations. If that is all
you need, forget about spreadsheets - they are far less simple than
matrices. A search for

javascript matrix operations

got several results. The first hit was "Sylvester". Its matrix
operations, described at http://sylvester.jcoglan.com/api/matrix.html,
include multiply, transpose, and inverse.

I suggest doing your own search for similar terms, and looking over the
results.

Patricia

[toc] | [prev] | [next] | [standalone]

#17428

Martin Leese <please@see.Web.for.e-mail.INVALID> writes:

> Jon wrote:
>> Please go to my web page and see what I'm trying to do:
>>
>> http://3d-triangulation-calculator.bravehost.com/
>>
>> The user enters 12 values into the Input form fields, clicks on
>> "Calculate" and the page displays the answer as 6 values in the
>> Output table.
>>
>> It doesn't do that yet, but it is what I'd like it to do.
>>
>> The Input values need to automatically enter into D24:F26 and
>> I24:K24 of the embedded spreadsheet.  The spreadsheet equations
>> (long and complex) calculate the solution and are automatically
>> entered in the Output table from D28:F29 on the embedded
>> spreadsheet.
>>
>> The embedded spreadsheet displayed on the page is a ZOHO spreadsheet
>> linked from its site.  Below this are two links to the same
>> spreadsheet in Excel 97 and Open Office Calc.  Below that are the
>> actual equations used in the spreadsheet calculations.
>>
>> Can anyone help me put this together?  I have been told that there
>> are java script programs that already do this.  Can I adapt one for
>> this?  Do I have to have the spreadsheet on the server?  I only know
>> a little Borland C++ and Microsoft Visual C++. 
>
> I would suggest that what you are attempting
> is too ambitious.  As I understand it, your
> process flow is:
>
> 1.  User inputs values into HTML webpage and
>     hits "Calculate".
> 2.  HTML form is submitted to your Web
>     server (although, at the moment, you do
>     not have a form).
> 3.  Web server enters values into ZOHO
>     spreadsheet, and saves ZOHO spreadsheet.
> 4.  Web server converts ZOHO spreadsheet to
>     an Excel spreadsheet and saves that.
> 5.  Web server converts ZOHO spreadsheet to
>     an Open Office spreadsheet and saves
>     that.
> 6.  Web server extracts output values from
>     the spreadsheet and sends them back to
>     the browser (it is not clear whether
>     these would be pushed or pulled).
> 7.  Output values are written into HTML
>     table and displayed in the webpage.
>
> Only item 7 requires JavaScript.

Not even item 7.  The natural thing to do is for the server to return
the page with the calculated values in place.

<snip>
-- 
Ben.

[toc] | [prev] | [standalone]

Page 2 of 2 — ← Prev page 1 [2]

Back to top | Article view | comp.lang.javascript

csiph-web