Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

7 May, 2024: fms is rebuilding. Don't expect much in that section for quite a few days, maybe longer.

devel / comp.lang.xharbour / subtraction (in cells)

SubjectAuthor
* subtraction (in cells)timepro timesheet
`* Re: subtraction (in cells)poopall
 +- Re: subtraction (in cells)timepro timesheet
 `- Re: subtraction (in cells)timepro timesheet

1
subtraction (in cells)

<9650ed98-8c78-4e7f-884b-5d6c7f5878ffn@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:ac8:4e8a:: with SMTP id 10mr14426751qtp.43.1640685857287;
Tue, 28 Dec 2021 02:04:17 -0800 (PST)
X-Received: by 2002:a05:620a:3190:: with SMTP id bi16mr15005725qkb.168.1640685857163;
Tue, 28 Dec 2021 02:04:17 -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: Tue, 28 Dec 2021 02:04:16 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=223.177.55.71; posting-account=jZAeNwoAAABYWjMRM-FfqKkHfC3Iph0l
NNTP-Posting-Host: 223.177.55.71
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <9650ed98-8c78-4e7f-884b-5d6c7f5878ffn@googlegroups.com>
Subject: subtraction (in cells)
From: timecosting@gmail.com (timepro timesheet)
Injection-Date: Tue, 28 Dec 2021 10:04:17 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 4
 by: timepro timesheet - Tue, 28 Dec 2021 10:04 UTC

in xcel, how to syntax:

osheet:cells(12,3):value:=str((cell(3,16)-cell(5,14))*cell(19,22),14,3)

thanks

Re: subtraction (in cells)

<23ca4be7-92d5-4f98-9576-ceefebb21e07n@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:622a:4ce:: with SMTP id q14mr25596605qtx.627.1640828944829; Wed, 29 Dec 2021 17:49:04 -0800 (PST)
X-Received: by 2002:a05:622a:4c:: with SMTP id y12mr25571991qtw.21.1640828944420; Wed, 29 Dec 2021 17:49:04 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!news.uzoreto.com!tr1.eu1.usenetexpress.com!feeder.usenetexpress.com!tr1.iad1.usenetexpress.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: Wed, 29 Dec 2021 17:49:04 -0800 (PST)
In-Reply-To: <9650ed98-8c78-4e7f-884b-5d6c7f5878ffn@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: <9650ed98-8c78-4e7f-884b-5d6c7f5878ffn@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <23ca4be7-92d5-4f98-9576-ceefebb21e07n@googlegroups.com>
Subject: Re: subtraction (in cells)
From: lawrence.edelstein@gmail.com (poopall)
Injection-Date: Thu, 30 Dec 2021 01:49:04 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 11
 by: poopall - Thu, 30 Dec 2021 01:49 UTC

On Tuesday, 28 December 2021 at 9:04:17 pm UTC+11, timec...@gmail.com wrote:
> in xcel, how to syntax:
>
> osheet:cells(12,3):value:=str((cell(3,16)-cell(5,14))*cell(19,22),14,3)
>
> thanks

oSheet:Cells( 12, 3 ):Formula = "+P3-(N5*V19)"

The formula needs to be a string that looks identical to the way you would write it in Excel Cell

Re: subtraction (in cells)

<dac4fa71-9517-4cd4-8398-9b082ca5f523n@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:6214:268e:: with SMTP id gm14mr7135756qvb.24.1641017568233;
Fri, 31 Dec 2021 22:12:48 -0800 (PST)
X-Received: by 2002:a05:6214:29c8:: with SMTP id gh8mr34922151qvb.78.1641017568009;
Fri, 31 Dec 2021 22:12:48 -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: Fri, 31 Dec 2021 22:12:47 -0800 (PST)
In-Reply-To: <23ca4be7-92d5-4f98-9576-ceefebb21e07n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=223.177.55.71; posting-account=jZAeNwoAAABYWjMRM-FfqKkHfC3Iph0l
NNTP-Posting-Host: 223.177.55.71
References: <9650ed98-8c78-4e7f-884b-5d6c7f5878ffn@googlegroups.com> <23ca4be7-92d5-4f98-9576-ceefebb21e07n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <dac4fa71-9517-4cd4-8398-9b082ca5f523n@googlegroups.com>
Subject: Re: subtraction (in cells)
From: timecosting@gmail.com (timepro timesheet)
Injection-Date: Sat, 01 Jan 2022 06:12:48 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 37
 by: timepro timesheet - Sat, 1 Jan 2022 06:12 UTC

On Thursday, December 30, 2021 at 7:19:05 AM UTC+5:30, poopall wrote:
> On Tuesday, 28 December 2021 at 9:04:17 pm UTC+11, timec...@gmail.com wrote:
> > in xcel, how to syntax:
> >
> > osheet:cells(12,3):value:=str((cell(3,16)-cell(5,14))*cell(19,22),14,3)
> >
> > thanks
> oSheet:Cells( 12, 3 ):Formula = "+P3-(N5*V19)"
>
> The formula needs to be a string that looks identical to the way you would write it in Excel Cell

thanks poopall,

is there a syntax, instead of :Formula="P3-(N...
i can code :Formula="cell(3,16)-cell(5,14)*...

else, i will have to get the values from a udf:
func converttoalpha(var)
if var=1
xcol='A'
elseif var=2
xcol='B'
elseif var=27
xcol='AA'
....
....
end
retu xcol
OR
create a multidim array 1,A ; 2,B; 3,C .....27,AA...and then xcol=ascan(...

and then:
xcolrow=xcol+alltrim(str(xrow,2))
oSheet:Cells(xx,yy):Formula = "&xcolrow-(&xcolrow1*&xcolrow2)..."

also, only after the report is processed, it can determine what will be the last column...
-so cannot decide how may combinations(1,A...) to be stored in the array...

Re: subtraction (in cells)

<44e34329-5aea-4d76-a718-c285ed450605n@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.lang.xharbour
X-Received: by 2002:a05:620a:4107:: with SMTP id j7mr27024237qko.645.1641028466710;
Sat, 01 Jan 2022 01:14:26 -0800 (PST)
X-Received: by 2002:ad4:5f8c:: with SMTP id jp12mr34122241qvb.68.1641028466464;
Sat, 01 Jan 2022 01:14:26 -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: Sat, 1 Jan 2022 01:14:26 -0800 (PST)
In-Reply-To: <23ca4be7-92d5-4f98-9576-ceefebb21e07n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=223.177.55.71; posting-account=jZAeNwoAAABYWjMRM-FfqKkHfC3Iph0l
NNTP-Posting-Host: 223.177.55.71
References: <9650ed98-8c78-4e7f-884b-5d6c7f5878ffn@googlegroups.com> <23ca4be7-92d5-4f98-9576-ceefebb21e07n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <44e34329-5aea-4d76-a718-c285ed450605n@googlegroups.com>
Subject: Re: subtraction (in cells)
From: timecosting@gmail.com (timepro timesheet)
Injection-Date: Sat, 01 Jan 2022 09:14:26 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 14
 by: timepro timesheet - Sat, 1 Jan 2022 09:14 UTC

thanks poopall:

*how do define/syntax a variable in 'sum' or 'formula'

code:
AGSSTAX=(netttax/currentsales)-commission && (almost always 18.00)
oSheet:cells(T16):value="=(sum("+"P16"+")"+"-sum("+"Q16"))"+"*3"+"-sum("+"R16+")"+"/AGSSTAX"

output:
T16 cell shows =(SUM(P16)-SUM(Q16))*3-SUM(R16)/AGSSTAX

does not convert 'agsttax' to it's value (for every cell agsstax value may be different/same)
(even :formula="P... shows 'agsstax' as a string not the value)

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor