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

Groups > comp.lang.javascript > #35581

Re: Script in a Spreadsheet - how?

Show all headers | View raw

Dr J R Stockton <J.R.Stockton@physics.org> wrote on 11 Sep 2018 in 
comp.lang.javascript:

> 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.
> 
> I can use Basic, but prefer JavaScript.
> 
> There will be roughly one line per week, starting
> in 2013, so the calculation should be fast enough
> and the sheet should have plenty of lines.
> 
> I have LibreOffice 6.0.
> 
>         I do recall that, many years ago, I tested
>         Microsoft DatePart in Excel to see whether
>         it would give ISO8601 week numbers.  It did,
>         but with three errors per 28 years and another
>         one every 400 years - no surprise there.

I would manipulate a .csv file,
as that can easily be scripted by FileSystemObject coding in JS.

[Or, more standard, use VBA in Excel.]

-- 
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

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