xlsfunc.txt

来自「encrypt/decrypt for PHP」· 文本 代码 · 共 71 行

Support XLS functions


#ifdef _MSLINK_

* Funct. cells

  xlsCELL( nRow, nCol [, lAbsRefRow] [, lAbsRefCol] )

  xlsSUM( nIniRow, nIniCol, nEndRow, nEndCol [, lAbsRefIniRow ] [, lAbsRefIniCol ] [, lAbsRefEndRow ] [, lAbsRefEndCol] )
  xlsMULT( nIniRow, nIniCol, nEndRow, nEndCol [, lAbsRefIniRow ] [, lAbsRefIniCol ] [, lAbsRefEndRow ] [, lAbsRefEndCol] )


* Funct. Math.

  xlsABS( Number )
  xlsINTE( Number )
  xlsMOD( Dividend, Divisor ) 
  xlsROUND( Number, Decimals )    
  xlsSIGN( Number )

  xlsSQRT( Number )
  xlsEXP( Number )
  xlsLN( Number )
  xlsLOG( Number )

  xlsPI()
  xlsRANDOM()

  xlsSIN( Angle )
  xlsCOS( Angle )
  xlsTAN( Angle )
  xlsASIN( Sin )
  xlsACOS( Cos )
  xlsATAN( Tan )

#else

* Funct. cells

  _CELL( nRow, nCol [, lAbsRefRow] [, lAbsRefCol] )

  _SUM( nIniRow, nIniCol, nEndRow, nEndCol [, lAbsRefIniRow ] [, lAbsRefIniCol ] [, lAbsRefEndRow ] [, lAbsRefEndCol] )
  _MULT( nIniRow, nIniCol, nEndRow, nEndCol [, lAbsRefIniRow ] [, lAbsRefIniCol ] [, lAbsRefEndRow ] [, lAbsRefEndCol] )


* Funct. Math.

  _ABS( Number )
  _INTE( Number )
  _MOD( Dividend, Divisor ) 
  _ROUND( Number, Decimals )    
  _SIGN( Number )

  _SQRT( Number )
  _EXP( Number )
  _LN( Number )
  _LOG( Number )

  _PI()
  _RANDOM()

  _SIN( Angle )
  _COS( Angle )
  _TAN( Angle )
  _ASIN( Sin )
  _ACOS( Cos )
  _ATAN( Tan )
#endif