1. Forum
  2. Usenet
  3. COMP.LANG.XHARBOUR

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

    From timepro timesheet@21:1/5 to All on Sun Jul 18 22:32:57 2021
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From poopall@21:1/5 to timec...@gmail.com on Mon Nov 22 20:55:18 2021
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From poopall@21:1/5 to poopall on Mon Nov 22 21:11:21 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)