Re: gnumeric-list digest, Vol 1 #752 - 1 msg

["Stan J. Klimas" <a prod shaw ca>]

> Date: 18 Nov 2002 17:35:09 -0000
> From: Morten Welinder <terra diku dk>
> To: gnumeric-list gnome org
> Subject: qpro importer help needed

Hi. Some notes are in the text.

Best regards,

Stan J. Klimas
Deep River, Ontario

> Hi there,
>
> I need some help with the qpro importer from someone who happens to
> have a manual lying around or remembers well...
>
> A.  How many arguments do these functions take?
> B1. What Gnumeric function, if any, do they correspond to?
> B2. If none, what do they do?
>
> Thanks,
>
> Morten


Based on my manual for QP 6.0 (Novell Perfect Office) 
> { "err", ARGS_UNKNOWN },
@ERR   
no arguments, no brackets returns the value ERR
Similar functions (with no brackets):
@NA
@VERSION
@PI
> { "pmt", ARGS_UNKNOWN },
(pv,Rate,Nper)
The payment amount for loan, kept for compatiblity)
> { "pv", ARGS_UNKNOWN },
(pmt, Rate, Nper) 
The present value of an annuity, kept for backwards compatilibty.
> { "fv", ARGS_UNKNOWN },
(pmt, Rate, Nper)
The future value of an annuity, kept for backwards compatiblity.
> { "round", ARGS_UNKNOWN },
(X, num)
X rounded to the number of digits specificed by num (up to 15 digits)
> { "isnum", ARGS_UNKNOWN },
I cannot find this one. There is one called
@isnumber(X)
1 if X is a numeric value, 0 otherwise.
and another one:
@isna(X)
1 if X is NA, 0 otherwise.
> { "isstr", ARGS_UNKNOWN },
@isstring(X)
1 if X is a string, 0 othewise.
> { "len", ARGS_UNKNOWN },
@length(string)
a number of characters in a string.
> { "value", ARGS_UNKNOWN },
@value(string)
numeric value of string
> { "string", ARGS_UNKNOWN },
@string(X, num)
numeric value of X as a string, with num decimal places.
> { "mid", ARGS_UNKNOWN },
@mid(string, startNumber, number)
num characters of string, begining with startNumber character positions.
> { "find", ARGS_UNKNOWN },
@find(subString, String,StartNumber)
The character positon of the first subString found in String
> { "dateval", ARGS_UNKNOWN },
@datevalue(datestring)
a date serial number
> { "timeval", ARGS_UNKNOWN },
@timevalue(timestring)
a time serial number
> { "cellptr", ARGS_UNKNOWN },
@cellpointer(attribute)
the requested attribute of the current cell
> { "npv1", ARGS_UNKNOWN },
@npv(Rate,Block,<Type>)
the present value of future cash flow
> { "irr", ARGS_UNKNOWN },
@irr(guess,block)
the internal rate of return
> { "hlookup", ARGS_UNKNOWN },
@hlookup(X,Block,Row)
The contents of the cell Row number of rows beneath X in the index row of 
Block.
> { "dsum", ARGS_UNKNOWN },
@dsum(Block,Column,criteria)
Database function. Sum of values in Column of Block that meets Criteria).
> { "davg", ARGS_UNKNOWN },
@davg(Block, Column,Criteria)
> { "dcount", ARGS_UNKNOWN },
(Block, Column,Criteria)
> { "dmin", ARGS_UNKNOWN },
(Block, Column, Criteria)
> { "dmax", ARGS_UNKNOWN },
(Block, Column, Criteria)
> { "dvar", ARGS_UNKNOWN },
(Block, Column, Criteria)
> { "dstd", ARGS_UNKNOWN },
(Block, Column, Criteria)
> { "index2d", ARGS_UNKNOWN },
Don't have this one. But:
@index(Block, Column, Row, <Page>)
> { "cols", ARGS_UNKNOWN },
@cols(Block)
The number of columns in Block.
> { "rows", ARGS_UNKNOWN },
@rows(Block)
> { "repeat", ARGS_UNKNOWN },
@repeat(String, num)
String, repeated num times.
> { "replace", ARGS_UNKNOWN },
@replace(String,StartNum,Num,NewString)
> { "proper", ARGS_UNKNOWN },
@proper(String)
String with the first letter of each word capitalized.
> { "cell", ARGS_UNKNOWN },
@cell(attribute,Block)
the requested attribute of Block.
> { "s", ARGS_UNKNOWN },
@s(Block)
The string value of the upper left cell in Block (blank, if it is a value 
entry).
> { "n", ARGS_UNKNOWN },
@n(block)
The numberic vlue of the upper lwft cell in Block (0, if it is a label or 
blank).
> { "exact", ARGS_UNKNOWN },
@exact(string1, string2)
1 if the strings are identical; 0 otherwise.
> { "call", ARGS_UNKNOWN },
Cannot find it.
> { "at", ARGS_UNKNOWN },
@@(Cell)
The contents of the cell specified by the cell address label in Cell.
> { "rate", ARGS_UNKNOWN },
@rate(Fv,Pv,Nper)
> { "term", ARGS_UNKNOWN },
@term(Pmt,Rate,Fv)
> { "cterm", ARGS_UNKNOWN },
@cterm(Rate,Fv,Pv)
> { "sln", ARGS_UNKNOWN },
@sln(cost,salvage,life)
Straight-line depreciation allowance.
> { "syd", ARGS_UNKNOWN },
(cost,salvage,life,period)
> { "ddb", ARGS_UNKNOWN },
(cost,salvage,life,period)
> { "dstds", ARGS_UNKNOWN },
(Block, Column, Criteria)
> { "dvars", ARGS_UNKNOWN },
(Block, Column, Criteria)
> { "pval", ARGS_UNKNOWN },
(Rate,Nper,Pmt,<Fv>,<Type>)
The present value of an annuity.
> { "paymt", ARGS_UNKNOWN },
(Rate,Nper,Pv,<Fv>,<Type>)
The payment amount of loan.
> { "fval", ARGS_UNKNOWN },
(Rate,Nper,Pmt,<Fv>,<Type>)
The future value of an annuity.
> { "nper", ARGS_UNKNOWN },
(Rate,Pmt,Pv,<Fv><Type>)
The number of periods.
> { "irate", ARGS_UNKNOWN },
(Nper,Pmt,Pv,<Fv>,<Type>)
The periodic interest rate.
> { "ipaymt", ARGS_UNKNOWN },
(Rate,Per,Nper,Pv,<Fv>,<Type>)
The portion of the payment amount of loan that is interest.
> { "ppaymt", ARGS_UNKNOWN },
(Rate,Per,Nper,Pv,<Fv>,<Type>)
The portion of loan payment amount that is principal.
> { "sumproduct", ARGS_UNKNOWN },
@sumproduct(Block1,Block2)
The dot (scalar) prodcut of the vectors corresponding to blocks.
> { "memavail", ARGS_UNKNOWN },
The amount of conventional memory currently available.
> { "mememsavail", ARGS_UNKNOWN },
The amount of expanded (EMS) memory currently avaialble (included for 
compatiblity with QP for DOS, always regurs NA)
> { "fileexists", ARGS_UNKNOWN },
@fileexists(FileName)
1 if the filename exists, 0 othewise.
> { "curvalue", ARGS_UNKNOWN },
@curvalue(generalAction,specificAction)
The current value of the given Quattro9 Pro for Dos menu equivalent.
> { "hex2dec", ARGS_UNKNOWN },
I only have these:
HEXTONUM(Hex)
HEXTONUM64(Hex,<signed>)
The decimal equivalent of the hexadecimal number. The second function is up to 
64 bits.
> { "dec2hex", ARGS_UNKNOWN },
@numtohex(Decimal)
@numtohex64(Decimal, <places>)
> { "npv2", ARGS_UNKNOWN },
don't have this one, NPV was describe before.
> { "cellindex2d", ARGS_UNKNOWN },
@Cellindex(attribute,Block, Column,Row,<Page>)
> { "version", ARGS_UNKNOWN },
@VERSION
The version number of QuattroPro. Please note no brackets.
> { "sheets", ARGS_UNKNOWN },
@sheets(Block)
The number of pages in Block.
> { "index3d", ARGS_UNKNOWN },
@index(Block, Column,Row,<Page>
The contents of the cell located at the specified column and row in Block.
> { "cellindex3d", ARGS_UNKNOWN },
> { "property", ARGS_UNKNOWN },
@property(ObjectName.property)
The value of the given perperty.
> { "ddelink", ARGS_UNKNOWN },
@ddelink([AppName | Topic] "DateToReceive", <nCols>,<nRows>,<nSheets>)
The requested data from the specified applicaton and DDE topic, retrieved to a 
block whose top left cell is the one containing @DDELINK, optional arguments 
limit the size of the data block, otherwise the block remains its original 
size.
> { "command", ARGS_UNKNOWN }
@command(CommandEquivalent)
The current setting of the given Quattro Pro for Windows command equivalent.
> --__--__--