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

  • subtraction (in cells)

    From timepro timesheet@21:1/5 to All on Tue Dec 28 02:04:16 2021
    in xcel, how to syntax:

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

    thanks

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From poopall@21:1/5 to timec...@gmail.com on Wed Dec 29 17:49:04 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From timepro timesheet@21:1/5 to poopall on Fri Dec 31 22:12:47 2021
    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...

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From timepro timesheet@21:1/5 to All on Sat Jan 1 01:14:26 2022
    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)

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