Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.javascript > #35595
| From | Ben Bacarisse <ben.usenet@bsb.me.uk> |
|---|---|
| Newsgroups | comp.lang.javascript |
| Subject | Re: Script in a Spreadsheet - how? |
| Date | 2018-09-11 15:46 +0100 |
| Organization | A noiseless patient Spider |
| Message-ID | <87pnxkay7l.fsf@bsb.me.uk> (permalink) |
| References | <bffcbf36-b975-4264-a514-1bd868728287@googlegroups.com> <f425120c-4742-4959-9537-c62da1b02ce6@googlegroups.com> |
Julio Di Egidio <julio@diegidio.name> writes: > 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. > > Anyway, LibreOffice does not support JS scripting, only some BASIC: > > <https://help.libreoffice.org/6.0/en-GB/text/sbasic/shared/main0601.html> <https://help.libreoffice.org/6.0/en-GB/text/shared/guide/scripting.html> says otherwise. To the OP: You probably don't need scripting. This short of thing is usually done by copying a formula, though scripting it can make it automatic. And I've never had much luck with JavaScript and LibreOffice calc. I've not tried hard, but even the examples seem to go wrong. I suspect the API is not maintained in the same way that Basic one is. -- Ben.
Back to comp.lang.javascript | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll 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