Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

All the simple programs have been written.

devel / comp.lang.xharbour / Re: MINUS...in excel (a la SUM)

SubjectAuthor
* MINUS...in excel (a la SUM)timepro timesheet
`* Re: MINUS...in excel (a la SUM)poopall
 `- Re: MINUS...in excel (a la SUM)poopall

1
MINUS...in excel (a la SUM)

<3cafb4f0-af3f-4e0e-a0cf-f1c6cdee5632n@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=16719&group=comp.lang.xharbour#16719

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:622a:1910:: with SMTP id w16mr20030814qtc.227.1626672777359;
Sun, 18 Jul 2021 22:32:57 -0700 (PDT)
X-Received: by 2002:a05:620a:1090:: with SMTP id g16mr6850608qkk.256.1626672777248;
Sun, 18 Jul 2021 22:32:57 -0700 (PDT)
Path: i2pn2.org!i2pn.org!paganini.bofh.team!usenet.pasdenom.info!usenet-fr.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Sun, 18 Jul 2021 22:32:57 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=2409:4040:e0f:66a0:4837:9190:fb8e:4a8d;
posting-account=jZAeNwoAAABYWjMRM-FfqKkHfC3Iph0l
NNTP-Posting-Host: 2409:4040:e0f:66a0:4837:9190:fb8e:4a8d
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <3cafb4f0-af3f-4e0e-a0cf-f1c6cdee5632n@googlegroups.com>
Subject: MINUS...in excel (a la SUM)
From: timecosting@gmail.com (timepro timesheet)
Injection-Date: Mon, 19 Jul 2021 05:32:57 +0000
Content-Type: text/plain; charset="UTF-8"
 by: timepro timesheet - Mon, 19 Jul 2021 05:32 UTC

hello all:

syntax to minus cellX from cellY and write the value in cellZ
my sum func:
for xx=xs1 to xs2
oSheet:Cells(xrow,xx):Value="=SUM("+oSheet:Range(oSheet:Cells(nstart,xx),oSheet:Cells(xrow-1,xx)):Address( .F.,.F.)+")"
next

how to copy/replicate all data(cells) from one sheet(tab) to another of the same excel file.

Re: MINUS...in excel (a la SUM)

<d5986b91-0030-4d27-a820-b9576acc779fn@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=16822&group=comp.lang.xharbour#16822

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:620a:a47:: with SMTP id j7mr2083184qka.439.1637643319011;
Mon, 22 Nov 2021 20:55:19 -0800 (PST)
X-Received: by 2002:a05:622a:8b:: with SMTP id o11mr3059525qtw.306.1637643318767;
Mon, 22 Nov 2021 20:55:18 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Mon, 22 Nov 2021 20:55:18 -0800 (PST)
In-Reply-To: <3cafb4f0-af3f-4e0e-a0cf-f1c6cdee5632n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=119.18.31.162; posting-account=zx0oKAkAAABMkjQR74hmeFvHN7cev7io
NNTP-Posting-Host: 119.18.31.162
References: <3cafb4f0-af3f-4e0e-a0cf-f1c6cdee5632n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <d5986b91-0030-4d27-a820-b9576acc779fn@googlegroups.com>
Subject: Re: MINUS...in excel (a la SUM)
From: lawrence.edelstein@gmail.com (poopall)
Injection-Date: Tue, 23 Nov 2021 04:55:19 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 9
 by: poopall - Tue, 23 Nov 2021 04:55 UTC

On Monday, 19 July 2021 at 3:32:58 pm UTC+10, timec...@gmail.com wrote:
> hello all:
>
> syntax to minus cellX from cellY and write the value in cellZ
> my sum func:
> for xx=xs1 to xs2
> oSheet:Cells(xrow,xx):Value="=SUM("+oSheet:Range(oSheet:Cells(nstart,xx),oSheet:Cells(xrow-1,xx)):Address( .F.,.F.)+")"
> next
>
> how to copy/replicate all data(cells) from one sheet(tab) to another of the same excel file.

Re: MINUS...in excel (a la SUM)

<0f0b801a-6be4-4238-9abf-83e84bf660fdn@googlegroups.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=16823&group=comp.lang.xharbour#16823

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:ac8:5b89:: with SMTP id a9mr2986433qta.363.1637644281946;
Mon, 22 Nov 2021 21:11:21 -0800 (PST)
X-Received: by 2002:a05:622a:587:: with SMTP id c7mr3064478qtb.354.1637644281729;
Mon, 22 Nov 2021 21:11:21 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Mon, 22 Nov 2021 21:11:21 -0800 (PST)
In-Reply-To: <d5986b91-0030-4d27-a820-b9576acc779fn@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=119.18.31.162; posting-account=zx0oKAkAAABMkjQR74hmeFvHN7cev7io
NNTP-Posting-Host: 119.18.31.162
References: <3cafb4f0-af3f-4e0e-a0cf-f1c6cdee5632n@googlegroups.com> <d5986b91-0030-4d27-a820-b9576acc779fn@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <0f0b801a-6be4-4238-9abf-83e84bf660fdn@googlegroups.com>
Subject: Re: MINUS...in excel (a la SUM)
From: lawrence.edelstein@gmail.com (poopall)
Injection-Date: Tue, 23 Nov 2021 05:11:21 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 31
 by: poopall - Tue, 23 Nov 2021 05:11 UTC

On Tuesday, 23 November 2021 at 3:55:19 pm UTC+11, poopall wrote:
> On Monday, 19 July 2021 at 3:32:58 pm UTC+10, timec...@gmail.com wrote:
> > hello all:
> >
> > syntax to minus cellX from cellY and write the value in cellZ
> > my sum func:
> > for xx=xs1 to xs2
> > oSheet:Cells(xrow,xx):Value="=SUM("+oSheet:Range(oSheet:Cells(nstart,xx),oSheet:Cells(xrow-1,xx)):Address( .F.,.F.)+")"
> > next
> >
> > how to copy/replicate all data(cells) from one sheet(tab) to another of the same excel file.
oSheet:Cells(xrow,xx):Value = "

Example:

If you wanted a formula which ADDS then

oSheet:Range("C1" ):Formula = "=A1+B1"

If you wanted a formula which SUBTRACTS then

oSheet:Range("C1" ):Formula = "=A1-B1"

If you want to create a SUM formula then

oSheet:Range("E1" ):Formula = "=sum(A1:D1)"

etc

Anything that you want excel to have you can write as :Formula

Hope that helps

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor