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

Groups > comp.lang.javascript > #35594

Re: Script in a Spreadsheet - how?

Show all headers | View raw

On Tuesday, September 11, 2018 at 1:23:18 PM UTC+1, Evertjan. wrote:
> Julio Di Egidio wrote on 11 Sep 2018 in comp.lang.javascript:
> > On Tuesday, 11 September 2018 10:31:22 UTC+2, Dr J R Stockton  wrote:
> >> Script in a Spreadsheet - how?
> >> 
> >> I want to enter numbers manually in columns B and D,
> >> with column C row N then being calculated as
> >>           C[N] = C[N-1] + B[N] - D[N]
> >> until line N is empty or otherwise marks the end -
> >> and I have no idea how to code that in a
> >> spreadsheet.
> > 
> > Are you kidding??  You don't need any scripting for that simple formula.
> 
> Of course you need scripting, even if your spreadsheet programme does such 
> scripting for you with some clicks or stores it as a macro.

You have been underestimating my ignorance of spreadsheet
 programming, and so it is probably without realising it
 that you have been useful !!  Perhaps a macro covering
 the whole sheet could do it.

> > Anyway, LibreOffice does not support JS scripting, only some BASIC:
> > 
> > <https://help.libreoffice.org/6.0/en-GB/text/sbasic/shared/main0601.html>


Basic is acceptable; you may have seen my VBScript Maths & Date
 pages, which would remind me sufficiently of the grammar.

I want the C column to be updated, from Row N onwards, after
 any change in fields B and D of Row N.

I can, of course, do that with JavaScript in a *local* HTML page.
 I can read any text data, including CSV, from a drive into that
 page, provided that the browser is as current Firefox - but I
 do not know how to write that back to a drive onWindowClose.

-- 
  (c) John Stockton, near London, UK.  Using Google Groups.           |
 Mail: J.R.""""""""@physics.org - or as Reply-To, if any.             |

Back to comp.lang.javascript | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Script in a Spreadsheet - how? Dr J R Stockton <J.R.Stockton@physics.org> - 2018-09-11 01:31 -0700
  Re: Script in a Spreadsheet - how? "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2018-09-11 11:03 +0200
    Re: Script in a Spreadsheet - how? Dr J R Stockton <J.R.Stockton@physics.org> - 2018-09-11 03:19 -0700
      Re: Script in a Spreadsheet - how? "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2018-09-11 14:17 +0200
        Re: Script in a Spreadsheet - how? Dr J R Stockton <J.R.Stockton@physics.org> - 2018-09-11 05:54 -0700
  Re: Script in a Spreadsheet - how? Julio Di Egidio <julio@diegidio.name> - 2018-09-11 03:41 -0700
    Re: Script in a Spreadsheet - how? "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2018-09-11 14:22 +0200
      Re: Script in a Spreadsheet - how? Dr J R Stockton <J.R.Stockton@physics.org> - 2018-09-11 06:31 -0700
    Re: Script in a Spreadsheet - how? Ben Bacarisse <ben.usenet@bsb.me.uk> - 2018-09-11 15:46 +0100
      Re: Script in a Spreadsheet - how? Dr J R Stockton <J.R.Stockton@physics.org> - 2018-09-11 11:06 -0700

csiph-web