LibreOffice Module sc (master) 1
|
#include <interpre.hxx>
Public Types | |
enum | VolatileType { VOLATILE , VOLATILE_MACRO , NOT_VOLATILE } |
Static Public Member Functions | |
static void | SetGlobalConfig (const ScCalcConfig &rConfig) |
static const ScCalcConfig & | GetGlobalConfig () |
static void | GlobalExit () |
static utl::SearchParam::SearchType | DetectSearchType (std::u16string_view rStr, const ScDocument &rDoc) |
Detect if string should be used as regular expression or wildcard expression or literal string. More... | |
static double | div (const double &fNumerator, const double &fDenominator) |
Fail safe division, returning a FormulaError::DivisionByZero coded into a double if denominator is 0.0. More... | |
static double | ScGetGCD (double fx, double fy) |
static double | phi (double x) |
static double | integralPhi (double x) |
static double | gaussinv (double x) |
static double | GetPercentile (::std::vector< double > &rArray, double fPercentile) |
Private Member Functions | |
void | MakeMatNew (ScMatrixRef &rMat, SCSIZE nC, SCSIZE nR) |
void | MergeCalcConfig () |
Merge global and document specific settings. More... | |
bool | MustHaveParamCount (short nAct, short nMust) |
bool | MustHaveParamCount (short nAct, short nMust, short nMax) |
bool | MustHaveParamCountMin (short nAct, short nMin) |
bool | MustHaveParamCountMinWithStackCheck (short nAct, short nMin) |
void | PushParameterExpected () |
void | PushIllegalParameter () |
void | PushIllegalArgument () |
void | PushNoValue () |
void | PushNA () |
void | ReplaceCell (ScAddress &) |
bool | IsTableOpInRange (const ScRange &) |
sal_uInt32 | GetCellNumberFormat (const ScAddress &rPos, ScRefCellValue &rCell) |
double | ConvertStringToValue (const OUString &) |
double | GetCellValue (const ScAddress &, ScRefCellValue &rCell) |
double | GetCellValueOrZero (const ScAddress &, ScRefCellValue &rCell) |
double | GetValueCellValue (const ScAddress &, double fOrig) |
Only ValueCell, formula cells already store the result rounded. More... | |
void | GetCellString (svl::SharedString &rStr, ScRefCellValue &rCell) |
bool | CreateDoubleArr (SCCOL nCol1, SCROW nRow1, SCTAB nTab1, SCCOL nCol2, SCROW nRow2, SCTAB nTab2, sal_uInt8 *pCellArr) |
bool | CreateStringArr (SCCOL nCol1, SCROW nRow1, SCTAB nTab1, SCCOL nCol2, SCROW nRow2, SCTAB nTab2, sal_uInt8 *pCellArr) |
bool | CreateCellArr (SCCOL nCol1, SCROW nRow1, SCTAB nTab1, SCCOL nCol2, SCROW nRow2, SCTAB nTab2, sal_uInt8 *pCellArr) |
void | Push (const formula::FormulaToken &r) |
Does substitute with formula::FormulaErrorToken in case nGlobalError is set and the token passed is not formula::FormulaErrorToken. More... | |
void | PushWithoutError (const formula::FormulaToken &r) |
Does not substitute with formula::FormulaErrorToken in case nGlobalError is set. More... | |
void | PushTempToken (formula::FormulaToken *) |
Does substitute with formula::FormulaErrorToken in case nGlobalError is set and the token passed is not formula::FormulaErrorToken. More... | |
void | PushTokenRef (const formula::FormulaConstTokenRef &) |
Pushes the token or substitutes with formula::FormulaErrorToken in case nGlobalError is set and the token passed is not formula::FormulaErrorToken. More... | |
void | PushTempTokenWithoutError (const formula::FormulaToken *) |
Does not substitute with formula::FormulaErrorToken in case nGlobalError is set. More... | |
bool | IfErrorPushError () |
If nGlobalError is set push formula::FormulaErrorToken. More... | |
void | PushCellResultToken (bool bDisplayEmptyAsString, const ScAddress &rAddress, SvNumFormatType *pRetTypeExpr, sal_uInt32 *pRetIndexExpr, bool bFinalResult=false) |
Obtain cell result / content from address and push as temp token. More... | |
formula::FormulaConstTokenRef | PopToken () |
void | Pop () |
void | PopError () |
double | PopDouble () |
const svl::SharedString & | PopString () |
void | ValidateRef (const ScSingleRefData &rRef) |
void | ValidateRef (const ScComplexRefData &rRef) |
void | ValidateRef (const ScRefList &rRefList) |
void | SingleRefToVars (const ScSingleRefData &rRef, SCCOL &rCol, SCROW &rRow, SCTAB &rTab) |
void | PopSingleRef (ScAddress &) |
void | PopSingleRef (SCCOL &rCol, SCROW &rRow, SCTAB &rTab) |
void | DoubleRefToRange (const ScComplexRefData &, ScRange &, bool bDontCheckForTableOp=false) |
void | PopDoubleRef (ScRange &rRange, short &rParam, size_t &rRefInList) |
If formula::StackVar formula::svDoubleRef pop ScDoubleRefToken and return values of ScComplexRefData. More... | |
void | PopDoubleRef (ScRange &, bool bDontCheckForTableOp=false) |
void | DoubleRefToVars (const formula::FormulaToken *p, SCCOL &rCol1, SCROW &rRow1, SCTAB &rTab1, SCCOL &rCol2, SCROW &rRow2, SCTAB &rTab2) |
ScDBRangeBase * | PopDBDoubleRef () |
void | PopDoubleRef (SCCOL &rCol1, SCROW &rRow1, SCTAB &rTab1, SCCOL &rCol2, SCROW &rRow2, SCTAB &rTab2) |
const ScComplexRefData * | GetStackDoubleRef (size_t rRefInList=0) |
void | PopExternalSingleRef (sal_uInt16 &rFileId, OUString &rTabName, ScSingleRefData &rRef) |
void | PopExternalSingleRef (ScExternalRefCache::TokenRef &rToken, ScExternalRefCache::CellFormat *pFmt=nullptr) |
Guarantees that nGlobalError is set if rToken could not be obtained. More... | |
void | PopExternalSingleRef (sal_uInt16 &rFileId, OUString &rTabName, ScSingleRefData &rRef, ScExternalRefCache::TokenRef &rToken, ScExternalRefCache::CellFormat *pFmt=nullptr) |
Guarantees that nGlobalError is set if rToken could not be obtained. More... | |
void | PopExternalDoubleRef (sal_uInt16 &rFileId, OUString &rTabName, ScComplexRefData &rRef) |
void | PopExternalDoubleRef (ScExternalRefCache::TokenArrayRef &rArray) |
void | PopExternalDoubleRef (ScMatrixRef &rMat) |
void | GetExternalDoubleRef (sal_uInt16 nFileId, const OUString &rTabName, const ScComplexRefData &aData, ScExternalRefCache::TokenArrayRef &rArray) |
bool | PopDoubleRefOrSingleRef (ScAddress &rAdr) |
void | PopDoubleRefPushMatrix () |
void | PopRefListPushMatrixOrRef () |
bool | ConvertMatrixParameters () |
void | MatrixJumpConditionToMatrix () |
void | ConvertMatrixJumpConditionToMatrix () |
bool | MatrixParameterConversion () |
bool | IsInArrayContext () const |
ScMatrixRef | PopMatrix () |
sc::RangeMatrix | PopRangeMatrix () |
void | QueryMatrixType (const ScMatrixRef &xMat, SvNumFormatType &rRetTypeExpr, sal_uInt32 &rRetIndexExpr) |
formula::FormulaToken * | CreateFormulaDoubleToken (double fVal, SvNumFormatType nFmt=SvNumFormatType::NUMBER) |
formula::FormulaToken * | CreateDoubleOrTypedToken (double fVal) |
void | PushDouble (double nVal) |
void | PushInt (int nVal) |
void | PushStringBuffer (const sal_Unicode *pString) |
void | PushString (const OUString &rStr) |
void | PushString (const svl::SharedString &rString) |
void | PushSingleRef (SCCOL nCol, SCROW nRow, SCTAB nTab) |
void | PushDoubleRef (SCCOL nCol1, SCROW nRow1, SCTAB nTab1, SCCOL nCol2, SCROW nRow2, SCTAB nTab2) |
void | PushExternalSingleRef (sal_uInt16 nFileId, const OUString &rTabName, SCCOL nCol, SCROW nRow, SCTAB nTab) |
void | PushExternalDoubleRef (sal_uInt16 nFileId, const OUString &rTabName, SCCOL nCol1, SCROW nRow1, SCTAB nTab1, SCCOL nCol2, SCROW nRow2, SCTAB nTab2) |
void | PushSingleRef (const ScRefAddress &rRef) |
void | PushDoubleRef (const ScRefAddress &rRef1, const ScRefAddress &rRef2) |
void | PushMatrix (const sc::RangeMatrix &rMat) |
void | PushMatrix (const ScMatrixRef &pMat) |
void | PushError (FormulaError nError) |
formula::StackVar | GetRawStackType () |
Raw stack type without default replacements. More... | |
formula::StackVar | GetStackType () |
Stack type with replacement of defaults, e.g. svMissing and formula::svEmptyCell will result in formula::svDouble. More... | |
formula::StackVar | GetStackType (sal_uInt8 nParam) |
sal_uInt8 | GetByte () const |
void | ReverseStack (sal_uInt8 nParamCount) |
bool | DoubleRefToPosSingleRef (const ScRange &rRange, ScAddress &rAdr) |
double | GetDoubleFromMatrix (const ScMatrixRef &pMat) |
double | GetDouble () |
double | GetDoubleWithDefault (double nDefault) |
bool | IsMissing () const |
sal_Int32 | double_to_int32 (double fVal) |
sal_Int32 | GetInt32 () |
if GetDouble() not within int32 limits sets nGlobalError and returns SAL_MAX_INT32 More... | |
sal_Int32 | GetInt32WithDefault (sal_Int32 nDefault) |
if GetDoubleWithDefault() not within int32 limits sets nGlobalError and returns SAL_MAX_INT32 More... | |
sal_Int16 | GetInt16 () |
if GetDouble() not within int16 limits sets nGlobalError and returns SAL_MAX_INT16 More... | |
sal_uInt32 | GetUInt32 () |
if GetDouble() not within uint32 limits sets nGlobalError and returns SAL_MAX_UINT32 More... | |
bool | GetBool () |
bool | GetDoubleOrString (double &rValue, svl::SharedString &rString) |
returns TRUE if double (or error, check nGlobalError), else FALSE More... | |
svl::SharedString | GetString () |
svl::SharedString | GetStringFromMatrix (const ScMatrixRef &pMat) |
svl::SharedString | GetStringFromDouble (const double fVal) |
ScMatValType | GetDoubleOrStringFromMatrix (double &rDouble, svl::SharedString &rString) |
ScMatrixRef | CreateMatrixFromDoubleRef (const formula::FormulaToken *pToken, SCCOL nCol1, SCROW nRow1, SCTAB nTab1, SCCOL nCol2, SCROW nRow2, SCTAB nTab2) |
ScTokenMatrixMap & | GetTokenMatrixMap () |
ScMatrixRef | GetMatrix () |
ScMatrixRef | GetMatrix (short &rParam, size_t &rInRefList) |
sc::RangeMatrix | GetRangeMatrix () |
void | ScTableOp () |
void | CurFmtToFuncFmt () |
sal_Int32 | GetStringPositionArgument () |
Obtain a sal_Int32 suitable as string position or length argument. More... | |
bool | CheckStringResultLen (OUString &rResult, sal_Int32 nIncrease) |
bool | CheckStringResultLen (OUStringBuffer &rResult, sal_Int32 nIncrease) |
void | TreatDoubleError (double &rVal) |
bool | LookupQueryWithCache (ScAddress &o_rResultPos, const ScQueryParam &rParam, const ScComplexRefData *refData) const |
void | ScIfJump () |
void | ScIfError (bool bNAonly) |
void | ScChooseJump () |
bool | JumpMatrix (short nStackLevel) |
double | Compare (ScQueryOp eOp) |
sc::RangeMatrix | CompareMat (ScQueryOp eOp, sc::CompareOptions *pOptions=nullptr) |
ScMatrixRef | QueryMat (const ScMatrixRef &pMat, sc::CompareOptions &rOptions) |
void | ScEqual () |
void | ScNotEqual () |
void | ScLess () |
void | ScGreater () |
void | ScLessEqual () |
void | ScGreaterEqual () |
void | ScAnd () |
void | ScOr () |
void | ScXor () |
void | ScNot () |
void | ScNeg () |
void | ScPercentSign () |
void | ScIntersect () |
void | ScRangeFunc () |
void | ScUnionFunc () |
void | ScPi () |
void | ScRandom () |
void | ScRandbetween () |
void | ScRandomImpl (const std::function< double(double fFirst, double fLast)> &RandomFunc, double fFirst, double fLast) |
void | ScTrue () |
void | ScFalse () |
void | ScDeg () |
void | ScRad () |
void | ScSin () |
void | ScCos () |
void | ScTan () |
void | ScCot () |
void | ScArcSin () |
void | ScArcCos () |
void | ScArcTan () |
void | ScArcCot () |
void | ScSinHyp () |
void | ScCosHyp () |
void | ScTanHyp () |
void | ScCotHyp () |
void | ScArcSinHyp () |
void | ScArcCosHyp () |
void | ScArcTanHyp () |
void | ScArcCotHyp () |
void | ScCosecant () |
void | ScSecant () |
void | ScCosecantHyp () |
void | ScSecantHyp () |
void | ScExp () |
void | ScLn () |
void | ScLog10 () |
void | ScSqrt () |
void | ScIsEmpty () |
bool | IsString () |
void | ScIsString () |
void | ScIsNonString () |
void | ScIsLogical () |
void | ScType () |
void | ScCell () |
void | ScCellExternal () |
void | ScIsRef () |
void | ScIsValue () |
void | ScIsFormula () |
void | ScFormula () |
void | ScRoman () |
void | ScArabic () |
void | ScIsNV () |
void | ScIsErr () |
void | ScIsError () |
bool | IsEven () |
void | ScIsEven () |
void | ScIsOdd () |
void | ScN () |
void | ScCode () |
void | ScTrim () |
void | ScUpper () |
void | ScProper () |
void | ScLower () |
void | ScLen () |
void | ScT () |
void | ScValue () |
void | ScNumberValue () |
void | ScClean () |
void | ScChar () |
void | ScJis () |
void | ScAsc () |
void | ScUnicode () |
void | ScUnichar () |
void | ScMin (bool bTextAsZero=false) |
void | ScMax (bool bTextAsZero=false) |
size_t | GetRefListArrayMaxSize (short nParamCount) |
Check for array of references to determine the maximum size of a return column vector if in array context. More... | |
bool | SwitchToArrayRefList (ScMatrixRef &xResMat, SCSIZE nMatRows, double fCurrent, const std::function< void(SCSIZE i, double fCurrent)> &MatOpFunc, bool bDoMatOp) |
Switch to array reference list if current TOS is one and create/init or update matrix and return true. More... | |
void | IterateParameters (ScIterFunc, bool bTextAsZero=false) |
void | ScSumSQ () |
void | ScSum () |
void | ScProduct () |
void | ScAverage (bool bTextAsZero=false) |
void | ScCount () |
void | ScCount2 () |
void | GetStVarParams (bool bTextAsZero, double(*VarResult)(double fVal, size_t nValCount)) |
void | ScVar (bool bTextAsZero=false) |
void | ScVarP (bool bTextAsZero=false) |
void | ScStDev (bool bTextAsZero=false) |
void | ScStDevP (bool bTextAsZero=false) |
void | ScRawSubtract () |
The purpose of RAWSUBTRACT() is exactly to not apply any error correction, approximation etc. More... | |
void | ScColumns () |
void | ScRows () |
void | ScSheets () |
void | ScColumn () |
void | ScRow () |
void | ScSheet () |
void | ScMatch () |
void | IterateParametersIf (ScIterFuncIf) |
void | ScCountIf () |
void | ScSumIf () |
void | ScAverageIf () |
void | IterateParametersIfs (double(*ResultFunc)(const sc::ParamIfsResult &rRes)) |
void | ScSumIfs () |
void | ScAverageIfs () |
void | ScCountIfs () |
void | ScCountEmptyCells () |
void | ScLookup () |
void | ScHLookup () |
void | ScVLookup () |
void | ScSubTotal () |
std::unique_ptr< ScDBQueryParamBase > | GetDBParams (bool &rMissingField) |
void | DBIterator (ScIterFunc) |
void | ScDBSum () |
void | ScDBCount () |
void | ScDBCount2 () |
void | ScDBAverage () |
void | ScDBGet () |
void | ScDBMax () |
void | ScDBMin () |
void | ScDBProduct () |
void | GetDBStVarParams (double &rVal, double &rValCount) |
void | ScDBStdDev () |
void | ScDBStdDevP () |
void | ScDBVar () |
void | ScDBVarP () |
void | ScIndirect () |
void | ScAddressFunc () |
void | ScOffset () |
void | ScIndex () |
void | ScMultiArea () |
void | ScAreas () |
void | ScCurrency () |
void | ScReplace () |
void | ScFixed () |
void | ScFind () |
void | ScExact () |
void | ScLeft () |
void | ScRight () |
void | ScSearch () |
void | ScMid () |
void | ScText () |
void | ScSubstitute () |
void | ScRept () |
void | ScRegex () |
void | ScConcat () |
void | ScConcat_MS () |
void | ScTextJoin_MS () |
void | ScIfs_MS () |
void | ScSwitch_MS () |
void | ScMinIfs_MS () |
void | ScMaxIfs_MS () |
void | ScExternal () |
void | ScMissing () |
void | ScMacro () |
bool | SetSbxVariable (SbxVariable *pVar, const ScAddress &) |
FormulaError | GetErrorType () |
void | ScErrorType () |
void | ScErrorType_ODF () |
void | ScDBArea () |
void | ScColRowNameAuto () |
void | ScGetPivotData () |
void | ScHyperLink () |
void | ScBahtText () |
void | ScBitAnd () |
void | ScBitOr () |
void | ScBitXor () |
void | ScBitRshift () |
void | ScBitLshift () |
void | ScTTT () |
void | ScDebugVar () |
double | GetDateSerial (sal_Int16 nYear, sal_Int16 nMonth, sal_Int16 nDay, bool bStrict) |
Obtain the date serial number for a given date. More... | |
void | ScGetActDate () |
void | ScGetActTime () |
void | ScGetYear () |
void | ScGetMonth () |
void | ScGetDay () |
void | ScGetDayOfWeek () |
void | ScGetWeekOfYear () |
void | ScGetIsoWeekOfYear () |
void | ScWeeknumOOo () |
void | ScEasterSunday () |
FormulaError | GetWeekendAndHolidayMasks (const sal_uInt8 nParamCount, const sal_uInt32 nNullDate, ::std::vector< double > &rSortArray, bool bWeekendMask[7]) |
FormulaError | GetWeekendAndHolidayMasks_MS (const sal_uInt8 nParamCount, const sal_uInt32 nNullDate, ::std::vector< double > &rSortArray, bool bWeekendMask[7], bool bWorkdayFunction) |
void | ScNetWorkdays (bool bOOXML_Version) |
void | ScWorkday_MS () |
void | ScGetHour () |
void | ScGetMin () |
void | ScGetSec () |
void | ScPlusMinus () |
void | ScAbs () |
void | ScInt () |
void | ScEven () |
void | ScOdd () |
void | ScCeil (bool bODFF) |
tdf69552 ODFF1.2 function CEILING and Excel function CEILING.MATH In essence, the difference between the two is that ODFF-CEILING needs to have arguments value and significance of the same sign and with CEILING.MATH the sign of argument significance is irrevelevant. More... | |
void | ScCeil_MS () |
void | ScCeil_Precise () |
void | ScFloor (bool bODFF) |
tdf69552 ODFF1.2 function FLOOR and Excel function FLOOR.MATH In essence, the difference between the two is that ODFF-FLOOR needs to have arguments value and significance of the same sign and with FLOOR.MATH the sign of argument significance is irrevelevant. More... | |
void | ScFloor_MS () |
void | ScFloor_Precise () |
void | RoundNumber (rtl_math_RoundingMode eMode) |
void | ScRound () |
void | ScRoundUp () |
void | ScRoundDown () |
void | ScGetDateValue () |
void | ScGetTimeValue () |
void | ScArcTan2 () |
void | ScLog () |
void | ScGetDate () |
void | ScGetTime () |
void | ScGetDiffDate () |
void | ScGetDiffDate360 () |
void | ScGetDateDif () |
void | ScPower () |
void | ScAmpersand () |
void | ScAdd () |
void | ScSub () |
void | ScMul () |
void | ScDiv () |
void | ScPow () |
void | ScCurrent () |
void | ScStyle () |
void | ScDde () |
void | ScBase () |
void | ScDecimal () |
void | ScConvertOOo () |
void | ScEuroConvert () |
void | ScRoundSignificant () |
void | ScNPV () |
void | ScIRR () |
void | ScMIRR () |
void | ScISPMT () |
void | ScPV () |
void | ScSYD () |
void | ScDDB () |
void | ScDB () |
void | ScVDB () |
void | ScPDuration () |
void | ScSLN () |
void | ScPMT () |
void | ScRRI () |
void | ScFV () |
void | ScNper () |
void | ScRate () |
double | ScGetIpmt (double fRate, double fPer, double fNper, double fPv, double fFv, bool bPayInAdvance, double &fPmt) |
void | ScIpmt () |
void | ScPpmt () |
void | ScCumIpmt () |
void | ScCumPrinc () |
void | ScEffect () |
void | ScNominal () |
void | ScMod () |
void | ScIntercept () |
void | ScGCD () |
void | ScLCM () |
void | ScMatValue () |
void | ScMatDet () |
void | ScMatInv () |
void | ScMatMult () |
void | ScMatTrans () |
void | ScEMat () |
void | ScMatRef () |
ScMatrixRef | MatConcat (const ScMatrixRef &pMat1, const ScMatrixRef &pMat2) |
void | ScSumProduct () |
void | ScSumX2MY2 () |
void | ScSumX2DY2 () |
void | ScSumXMY2 () |
void | ScGrowth () |
bool | CalculateSkew (KahanSum &fSum, double &fCount, std::vector< double > &values) |
void | CalculateSkewOrSkewp (bool bSkewp) |
void | CalculateSlopeIntercept (bool bSlope) |
void | CalculateSmallLarge (bool bSmall) |
void | CalculatePearsonCovar (bool _bPearson, bool _bStexy, bool _bSample) |
bool | CalculateTest (bool _bTemplin, const SCSIZE nC1, const SCSIZE nC2, const SCSIZE nR1, const SCSIZE nR2, const ScMatrixRef &pMat1, const ScMatrixRef &pMat2, double &fT, double &fF) |
void | CalculateLookup (bool bHLookup) |
bool | FillEntry (ScQueryEntry &rEntry) |
void | CalculateAddSub (bool _bSub) |
void | CalculateTrendGrowth (bool _bGrowth) |
void | CalculateRGPRKP (bool _bRKP) |
void | CalculateSumX2MY2SumX2DY2 (bool _bSumX2DY2) |
void | CalculateMatrixValue (const ScMatrix *pMat, SCSIZE nC, SCSIZE nR) |
bool | CheckMatrix (bool _bLOG, sal_uInt8 &nCase, SCSIZE &nCX, SCSIZE &nCY, SCSIZE &nRX, SCSIZE &nRY, SCSIZE &M, SCSIZE &N, ScMatrixRef &pMatX, ScMatrixRef &pMatY) |
void | ScLinest () |
void | ScLogest () |
void | ScForecast () |
void | ScForecast_Ets (ScETSType eETSType) |
void | ScFourier () |
void | ScNoName () |
void | ScBadName () |
double | GetBetaDist (double x, double alpha, double beta) |
double | GetBetaDistPDF (double fX, double fA, double fB) |
double | GetChiDist (double fChi, double fDF) |
You must ensure fDF>0.0. More... | |
double | GetChiSqDistCDF (double fX, double fDF) |
You must ensure fDF>0.0. More... | |
double | GetFDist (double x, double fF1, double fF2) |
double | GetTDist (double T, double fDF, int nType) |
double | Fakultaet (double x) |
double | GetGamma (double x) |
You must ensure non integer arguments for fZ<1. More... | |
double | GetBeta (double fAlpha, double fBeta) |
double | GetBinomDistPMF (double x, double n, double p) |
double | GetHypGeomDist (double x, double n, double M, double N) |
Calculates a value of the hypergeometric distribution. More... | |
void | ScLogGamma () |
void | ScGamma () |
void | ScPhi () |
void | ScGauss () |
void | ScStdNormDist () |
void | ScStdNormDist_MS () |
void | ScFisher () |
void | ScFisherInv () |
void | ScFact () |
void | ScNormDist (int nMinParamCount) |
void | ScGammaDist (bool bODFF) |
void | ScGammaInv () |
void | ScExpDist () |
void | ScBinomDist () |
void | ScPoissonDist (bool bODFF) |
void | ScCombin () |
void | ScCombinA () |
void | ScPermut () |
void | ScPermutationA () |
void | ScB () |
void | ScHypGeomDist (int nMinParamCount) |
Calculates a value of the hypergeometric distribution. More... | |
void | ScLogNormDist (int nMinParamCount) |
void | ScLogNormInv () |
void | ScTDist () |
void | ScTDist_MS () |
void | ScTDist_T (int nTails) |
void | ScFDist () |
void | ScFDist_LT () |
void | ScChiDist (bool bODFF) |
void | ScChiSqDist () |
void | ScChiSqDist_MS () |
void | ScChiSqInv () |
void | ScWeibull () |
void | ScBetaDist () |
void | ScBetaDist_MS () |
Microsoft version has parameters in different order Also, upper and lowerbound are optional and have default values and different constraints apply. More... | |
void | ScFInv () |
void | ScFInv_LT () |
void | ScTInv (int nType) |
void | ScChiInv () |
void | ScBetaInv () |
void | ScCritBinom () |
void | ScNegBinomDist () |
void | ScNegBinomDist_MS () |
void | ScKurt () |
void | ScHarMean () |
void | ScGeoMean () |
void | ScStandard () |
void | ScSkew () |
void | ScSkewp () |
void | ScMedian () |
double | GetMedian (::std::vector< double > &rArray) |
double | GetPercentileExclusive (::std::vector< double > &rArray, double fPercentile) |
std::vector< double > | GetRankNumberArray (SCSIZE &rCol, SCSIZE &rRow) |
void | GetNumberSequenceArray (sal_uInt8 nParamCount, ::std::vector< double > &rArray, bool bConvertTextInArray) |
void | GetSortArray (sal_uInt8 nParamCount, ::std::vector< double > &rSortArray, ::std::vector< tools::Long > *pIndexOrder, bool bConvertTextInArray, bool bAllowEmptyArray) |
void | ScModalValue () |
void | ScModalValue_MS (bool bSingle) |
void | ScAveDev () |
void | ScAggregate () |
void | ScDevSq () |
void | ScZTest () |
void | ScTTest () |
void | ScFTest () |
void | ScChiTest () |
void | ScRank (bool bAverage) |
void | ScPercentile (bool bInclusive) |
void | ScPercentrank (bool bInclusive) |
void | ScLarge () |
void | ScSmall () |
void | ScFrequency () |
void | ScQuartile (bool bInclusive) |
void | ScNormInv () |
void | ScSNormInv () |
void | ScConfidence () |
void | ScConfidenceT () |
void | ScTrimMean () |
void | ScProbability () |
void | ScCorrel () |
void | ScCovarianceP () |
void | ScCovarianceS () |
void | ScPearson () |
void | ScRSQ () |
void | ScSTEYX () |
void | ScSlope () |
void | ScTrend () |
void | ScInfo () |
void | ScLenB () |
void | ScRightB () |
void | ScLeftB () |
void | ScMidB () |
void | ScReplaceB () |
void | ScFindB () |
void | ScSearchB () |
void | ScFilterXML () |
void | ScWebservice () |
void | ScEncodeURL () |
Returns a string in which all non-alphanumeric characters except stroke and underscore (-_) have been replaced with a percent (%) sign followed by hex digits. More... | |
void | ScColor () |
void | ScErf () |
void | ScErfc () |
double | GetGammaContFraction (double fA, double fX) |
You must ensure fA>0.0 && fX>0.0 valid results only if fX > fA+1.0 uses continued fraction with odd items. More... | |
double | GetGammaSeries (double fA, double fX) |
You must ensure fA>0.0 && fX>0.0 valid results only if fX <= fA+1.0 uses power series. More... | |
double | GetLowRegIGamma (double fA, double fX) |
You must ensure fA>0.0 && fX>0.0) More... | |
double | GetUpRegIGamma (double fA, double fX) |
You must ensure fA>0.0 && fX>0.0) More... | |
double | GetGammaDistPDF (double fX, double fAlpha, double fLambda) |
Gamma distribution, probability density function. More... | |
double | GetGammaDist (double fX, double fAlpha, double fLambda) |
Gamma distribution, cumulative distribution function. More... | |
double | GetTInv (double fAlpha, double fSize, int nType) |
Static Private Member Functions | |
static ScCalcConfig & | GetOrCreateGlobalConfig () |
static FormulaError | GetCellErrCode (const ScRefCellValue &rCell) |
static bool | CheckStringPositionArgument (double &fVal) |
Check if a double is suitable as string position or length argument. More... | |
static sal_Int16 | GetDayOfWeek (sal_Int32 n) |
static void | RoundSignificant (double fX, double fDigits, double &fRes) |
static double | ScGetPV (double fRate, double fNper, double fPmt, double fFv, bool bPayInAdvance) |
static double | ScGetDDB (double fCost, double fSalvage, double fLife, double fPeriod, double fFactor) |
static double | ScInterVDB (double fCost, double fSalvage, double fLife, double fLife1, double fPeriod, double fFactor) |
static double | ScGetPMT (double fRate, double fNper, double fPv, double fFv, bool bPayInAdvance) |
static double | ScGetFV (double fRate, double fNper, double fPmt, double fPv, bool bPayInAdvance) |
static bool | RateIteration (double fNper, double fPayment, double fPv, double fFv, bool bPayType, double &fGuess) |
static void | MEMat (const ScMatrixRef &mM, SCSIZE n) |
static double | taylor (const double *pPolynom, sal_uInt16 nMax, double x) |
static double | gauss (double x) |
static double | GetChiSqDistPDF (double fX, double fDF) |
static double | BinomKoeff (double n, double k) |
static double | GetLogGamma (double x) |
You must ensure fZ>0. More... | |
static double | GetLogBeta (double fAlpha, double fBeta) |
static void | QuickSort (::std::vector< double > &rSortArray, ::std::vector< tools::Long > *pIndexOrder) |
static double | GetPercentrank (::std::vector< double > &rArray, double fVal, bool bInclusive) |
Private Attributes | |
ScCalcConfig | maCalcConfig |
formula::FormulaTokenIterator | aCode |
ScAddress | aPos |
ScTokenArray * | pArr |
ScInterpreterContext & | mrContext |
ScDocument & | mrDoc |
sfx2::LinkManager * | mpLinkManager |
svl::SharedStringPool & | mrStrPool |
formula::FormulaConstTokenRef | xResult |
ScJumpMatrix * | pJumpMatrix |
ScTokenMatrixMap | maTokenMatrixMap |
ScFormulaCell * | pMyFormulaCell |
SvNumberFormatter * | pFormatter |
const formula::FormulaToken * | pCur |
ScTokenStack * | pStackObj |
const formula::FormulaToken ** | pStack |
FormulaError | nGlobalError |
sal_uInt16 | sp |
sal_uInt16 | maxsp |
sal_uInt32 | nFuncFmtIndex |
sal_uInt32 | nCurFmtIndex |
sal_uInt32 | nRetFmtIndex |
SvNumFormatType | nFuncFmtType |
SvNumFormatType | nCurFmtType |
SvNumFormatType | nRetFmtType |
FormulaError | mnStringNoValueError |
SubtotalFlags | mnSubTotalFlags |
sal_uInt8 | cPar |
bool | bCalcAsShown |
bool | bMatrixFormula |
VolatileType | meVolatileType |
Static Private Attributes | |
static ScCalcConfig * | mpGlobalConfig = nullptr |
static thread_local std::unique_ptr< ScTokenStack > | pGlobalStack |
static thread_local bool | bGlobalStackInUse = false |
static const double | fMaxGammaArgument = 171.624376956302 |
Friends | |
class | ScGammaDistFunction |
class | ScBetaDistFunction |
class | ScTDistFunction |
class | ScFDistFunction |
class | ScChiDistFunction |
class | ScChiSqDistFunction |
Definition at line 137 of file interpre.hxx.
Enumerator | |
---|---|
VOLATILE | |
VOLATILE_MACRO | |
NOT_VOLATILE |
Definition at line 166 of file interpre.hxx.
ScInterpreter::ScInterpreter | ( | ScFormulaCell * | pCell, |
ScDocument & | rDoc, | ||
ScInterpreterContext & | rContext, | ||
const ScAddress & | rPos, | ||
ScTokenArray & | r, | ||
bool | bForGroupThreading = false |
||
) |
Definition at line 3803 of file interpr4.cxx.
References ALL, bGlobalStackInUse, bMatrixFormula, Formula, ScFormulaCell::GetMatrixFlag(), MergeCalcConfig(), mrContext, NoValue, pGlobalStack, pMyFormulaCell, ScTokenStack::pPointer, pStack, and pStackObj.
ScInterpreter::~ScInterpreter | ( | ) |
Definition at line 3858 of file interpr4.cxx.
References bGlobalStackInUse, pGlobalStack, and pStackObj.
void ScInterpreter::AssertFormulaMatrix | ( | ) |
Definition at line 4809 of file interpr4.cxx.
References bMatrixFormula.
Referenced by ScSimpleFormulaCalculator::Calculate().
|
staticprivate |
Definition at line 460 of file interpr3.cxx.
References n.
Referenced by ScCombin(), and ScCombinA().
|
private |
Definition at line 1217 of file interpr5.cxx.
References GetDouble(), GetMatrix(), GetNewMat(), GetStackType(), lcl_GetDiffDateTimeFmtType(), lcl_MatrixCalculation(), nCurFmtIndex, nCurFmtType, nFuncFmtIndex, nFuncFmtType, PushDouble(), PushIllegalArgument(), PushMatrix(), PushNoValue(), SAL_MAX_INT32, and svMatrix.
|
private |
!!!!!!
!!!!!!
Definition at line 7385 of file interpr1.cxx.
References ScQueryParamBase::bByRow, ScQueryEntry::bDoQuery, ScQueryEntry::ByString, CollatorWrapper::compareString(), DetectSearchType(), ScQueryEntry::eOp, ScQueryParamBase::eSearchType, eType, FillEntry(), ScQueryCellIterator< accessType >::FindEqualOrSortedLastInRange(), GetBool(), GetByte(), ScQueryCellIterator< accessType >::GetCol(), ScGlobal::GetCollator(), svl::SharedString::getDataIgnoreCase(), GetDouble(), ScQueryParamBase::GetEntry(), ScQueryCellIterator< accessType >::GetFirst(), GetMatrix(), ScQueryEntry::GetQueryItem(), GetStackDoubleRef(), GetStackType(), svl::SharedString::getString(), i, LookupQueryWithCache(), ScQueryEntry::Item::maString, ScQueryEntry::Item::meType, ScQueryEntry::Item::mfVal, mrContext, mrDoc, MustHaveParamCount(), ScQueryParamTable::nCol1, ScQueryParamTable::nCol2, ScQueryEntry::nField, nGlobalError, ScQueryParamTable::nRow1, ScQueryParamTable::nRow2, ScQueryParamTable::nTab, PopDoubleRef(), PopSingleRef(), PushCellResultToken(), PushDouble(), PushIllegalArgument(), PushIllegalParameter(), PushNA(), PushString(), ScAddress::Row(), SC_LESS_EQUAL, SCSIZE_MAX, ScQueryCellIteratorBase< accessType, queryType >::SetAdvanceQueryParamEntryField(), svDoubleRef, svExternalDoubleRef, svExternalSingleRef, svMatrix, and svSingleRef.
Referenced by ScHLookup(), and ScVLookup().
Definition at line 693 of file interpr5.cxx.
References ScMatrixValue::fVal, ScMatrix::Get(), ScMatrix::GetDimensions(), ScMatrixValue::GetString(), ScMatrix::IsNonValueType(), ScMatrixValue::nType, PushDouble(), PushNoValue(), and PushString().
Referenced by ScMatValue().
|
private |
Definition at line 4553 of file interpr3.cxx.
References KahanSum::get(), get(), GetByte(), GetMatrix(), i, MustHaveParamCount(), PushDouble(), PushError(), PushIllegalArgument(), PushIllegalParameter(), and PushNoValue().
Referenced by ScCovarianceP(), ScCovarianceS(), ScPearson(), and ScSTEYX().
|
private |
Definition at line 2342 of file interpr5.cxx.
References CheckMatrix(), col, get(), GetBool(), GetByte(), GetMatrix(), GetNewMat(), i, IsMissing(), MustHaveParamCount(), N, Pop(), PushError(), PushIllegalParameter(), PushMatrix(), and PushNoValue().
Referenced by ScLinest(), and ScLogest().
|
private |
Definition at line 3211 of file interpr3.cxx.
References GetByte(), GetCellValue(), GetDouble(), ScValueIterator::GetFirst(), GetMatrix(), ScValueIterator::GetNext(), GetStackType(), ScRefCellValue::hasNumeric(), mnSubTotalFlags, mrContext, mrDoc, MustHaveParamCountMin(), nCount, nGlobalError, PopDoubleRef(), PopSingleRef(), PushError(), SetError(), svDouble, svDoubleRef, svExternalDoubleRef, svExternalSingleRef, svMatrix, svRefList, svSingleRef, and values.
Referenced by CalculateSkewOrSkewp(), and ScKurt().
|
private |
Definition at line 3316 of file interpr3.cxx.
References CalculateSkew(), KahanSum::get(), PushDouble(), PushError(), PushIllegalArgument(), v, and values.
|
private |
Definition at line 4667 of file interpr3.cxx.
References KahanSum::get(), GetByte(), GetMatrix(), i, MustHaveParamCount(), PushDouble(), PushError(), PushIllegalArgument(), PushIllegalParameter(), and PushNoValue().
Referenced by ScIntercept(), and ScSlope().
|
private |
Definition at line 3635 of file interpr3.cxx.
References CreateDoubleError(), GetByte(), GetNewMat(), GetNumberSequenceArray(), GetRankNumberArray(), i, MustHaveParamCount(), n, nGlobalError, PushDouble(), PushMatrix(), and PushNoValue().
|
private |
Definition at line 1736 of file interpr5.cxx.
References KahanSum::get(), GetByte(), GetMatrix(), i, MustHaveParamCount(), PushDouble(), PushIllegalParameter(), and PushNoValue().
Referenced by ScSumX2DY2(), and ScSumX2MY2().
|
private |
Definition at line 2580 of file interpr3.cxx.
References KahanSum::get(), get(), i, and PushNoValue().
Referenced by ScTTest().
|
private |
Definition at line 2866 of file interpr5.cxx.
References CheckMatrix(), col, GetBool(), GetByte(), GetMatrix(), GetNewMat(), i, IsMissing(), MustHaveParamCount(), N, Pop(), PushError(), PushIllegalArgument(), PushIllegalParameter(), PushMatrix(), and PushNoValue().
Referenced by ScGrowth(), and ScTrend().
|
private |
Definition at line 2225 of file interpr5.cxx.
References GetNewMat(), i, log, M, N, and PushIllegalArgument().
Referenced by CalculateRGPRKP(), and CalculateTrendGrowth().
|
inlinestaticprivate |
Check if a double is suitable as string position or length argument.
If fVal is Inf or NaN it is changed to -1, if it is less than 0 it is sanitized to 0, if it is greater than some implementation defined max string length it is sanitized to that max.
Definition at line 1089 of file interpre.hxx.
References SAL_MAX_INT32.
Referenced by GetStringPositionArgument(), and ScRegex().
|
inlineprivate |
Definition at line 1120 of file interpre.hxx.
References kScInterpreterMaxStrLen, and SetError().
Referenced by ScAmpersand(), ScConcat(), ScConcat_MS(), ScReplace(), ScSubstitute(), and ScTextJoin_MS().
|
inlineprivate |
Definition at line 1131 of file interpre.hxx.
References kScInterpreterMaxStrLen, and SetError().
|
private |
Definition at line 885 of file interpr1.cxx.
References aStr, sc::CompareFunc(), GetCellString(), GetCellValue(), ScDocument::GetDocOptions(), GetDouble(), GetMatrix(), GetRawStackType(), GetString(), ScRefCellValue::hasEmptyValue(), ScRefCellValue::hasString(), i, ScDocOptions::IsIgnoreCase(), sc::Compare::maCells, sc::Compare::Cell::maStr, sc::Compare::Cell::mbEmpty, sc::Compare::mbIgnoreCase, sc::Compare::Cell::mbValue, sc::Compare::meOp, sc::Compare::Cell::mfValue, mrDoc, nCurFmtType, nFuncFmtType, nGlobalError, Pop(), PopDoubleRefOrSingleRef(), PopError(), SetError(), svDouble, svDoubleRef, svEmptyCell, svExternalDoubleRef, svExternalSingleRef, svMissing, svSingleRef, and svString.
Referenced by ScEqual(), ScGreater(), ScGreaterEqual(), ScLess(), ScLessEqual(), and ScNotEqual().
|
private |
pOptions | NULL means case sensitivity document option is to be used! |
Definition at line 982 of file interpr1.cxx.
References aStr, sc::CompareFunc(), ScMatrix::CompareMatrix(), GetCellString(), GetCellValue(), ScDocument::GetDocOptions(), GetDouble(), GetNewMat(), GetRangeMatrix(), GetRawStackType(), GetString(), ScRefCellValue::hasEmptyValue(), ScRefCellValue::hasString(), i, ScDocOptions::IsIgnoreCase(), sc::Compare::maCells, sc::Compare::Cell::maStr, sc::Compare::Cell::mbEmpty, sc::Compare::mbIgnoreCase, sc::Compare::Cell::mbValue, sc::Compare::meOp, sc::Compare::Cell::mfValue, sc::RangeMatrix::mnCol1, sc::RangeMatrix::mnCol2, sc::RangeMatrix::mnRow1, sc::RangeMatrix::mnRow2, sc::RangeMatrix::mnTab1, sc::RangeMatrix::mnTab2, sc::RangeMatrix::mpMat, mrDoc, nCurFmtType, nFuncFmtType, nGlobalError, Pop(), PopError(), PopSingleRef(), SAL_WARN, SC_EQUAL, SC_GREATER, SC_GREATER_EQUAL, SC_LESS, SC_LESS_EQUAL, SC_NOT_EQUAL, SetError(), svDouble, svDoubleRef, svEmptyCell, svExternalDoubleRef, svExternalSingleRef, svMatrix, svMissing, svSingleRef, and svString.
Referenced by QueryMat(), ScEqual(), ScGreater(), ScGreaterEqual(), ScLess(), ScLessEqual(), and ScNotEqual().
|
private |
Definition at line 1438 of file interpr4.cxx.
References GetMatrix(), GetStackType(), GetTokenMatrixMap(), PushIllegalParameter(), PushMatrix(), svDoubleRef, svJumpMatrix, svMatrix, and svUnknown.
Referenced by MatrixJumpConditionToMatrix().
|
private |
Definition at line 1457 of file interpr4.cxx.
References aCode, CreateMatrixFromDoubleRef(), DoubleRefToVars(), eType, ScMatrix::GetDimensions(), GetExternalDoubleRef(), formula::FormulaToken::GetMatrix(), formula::FormulaToken::GetOpCode(), formula::FormulaToken::GetParamCount(), ScParameterClassification::GetParameterType(), formula::FormulaTokenIterator::GetPC(), GetTokenMatrixMap(), i, formula::FormulaToken::IncRef(), IsInArrayContext(), formula::FormulaTokenIterator::Jump(), o3tl::make_unsigned(), maTokenMatrixMap, nGlobalError, ocMissing, ocPush, p, pCur, pStack, PushTempTokenWithoutError(), SAL_WARN, SAL_WARN_IF, SetError(), sp, svDouble, svDoubleRef, svEmptyCell, svError, svExternalDoubleRef, svExternalSingleRef, svMatrix, svMissing, svRefList, svSingleRef, and svString.
Referenced by MatrixParameterConversion().
|
private |
Definition at line 163 of file interpr4.cxx.
References ScGlobal::ConvertStringToValue(), maCalcConfig, mnStringNoValueError, nCurFmtType, pFormatter, and SetError().
Referenced by ScMatrixImpl::ExecuteBinaryOp(), GetCellValueOrZero(), GetDouble(), GetNumberSequenceArray(), and IterateParameters().
double ScInterpreter::ConvertStringToValue | ( | const OUString & | rStr, |
FormulaError & | rError, | ||
SvNumFormatType & | rCurFmtType | ||
) |
For matrix back calls into the current interpreter.
Uses rError instead of nGlobalError and rCurFmtType instead of nCurFmtType.
Definition at line 173 of file interpr4.cxx.
References ScGlobal::ConvertStringToValue(), maCalcConfig, mnStringNoValueError, and pFormatter.
|
private |
Definition at line 461 of file interpr4.cxx.
References aStr, CELLTYPE_EDIT, CELLTYPE_FORMULA, CELLTYPE_STRING, CELLTYPE_VALUE, ScRefCellValue::getDouble(), ScFormulaCell::GetErrCode(), ScRefCellValue::getFormula(), ScFormulaCell::GetString(), svl::SharedString::getString(), ScRefCellValue::getString(), ScRefCellValue::getType(), ScFormulaCell::GetValue(), GetValueCellValue(), ScRefCellValue::isEmpty(), ScFormulaCell::IsValue(), MAXARRSIZE, MAXCOLCOUNT, MAXCOLCOUNT_JUMBO, mrDoc, nCount, nPos, nType, OUStringToOString(), p, SAL_MAX_UINT16, ScAddress::SetCol(), ScAddress::SetRow(), and ScAddress::SetTab().
Referenced by ScExternal().
|
private |
Definition at line 280 of file interpr4.cxx.
References CELLTYPE_FORMULA, CELLTYPE_VALUE, ScRefCellValue::getDouble(), ScFormulaCell::GetErrCode(), ScRefCellValue::getFormula(), ScRefCellValue::getType(), ScFormulaCell::GetValue(), GetValueCellValue(), ScRefCellValue::isEmpty(), ScFormulaCell::IsValue(), MAXARRSIZE, MAXCOLCOUNT, MAXCOLCOUNT_JUMBO, mrDoc, nCount, nPos, p, SAL_MAX_UINT16, ScAddress::SetCol(), ScAddress::SetRow(), and ScAddress::SetTab().
Referenced by ScExternal().
|
private |
Definition at line 1791 of file interpr4.cxx.
References CreateFormulaDoubleToken(), and nFuncFmtType.
Referenced by PushDouble(), and PushInt().
|
private |
Definition at line 1766 of file interpr4.cxx.
References ScInterpreterContext::maTokens, ScInterpreterContext::mnTokenCachePos, mrContext, p, and TOKEN_CACHE_SIZE.
Referenced by CreateDoubleOrTypedToken(), Interpret(), PushCellResultToken(), and QueryMatrixType().
|
private |
Definition at line 302 of file interpr5.cxx.
References bCalcAsShown, CELLTYPE_VALUE, ScAddress::Col(), ScDocument::FillMatrix(), ScCellIterator::first(), formula::FormulaToken::GetDoubleRef(), ScFormulaCell::GetErrCode(), ScRefCellValue::getFormula(), GetMatrix(), GetNewMat(), ScDocument::GetNumberFormat(), ScCellIterator::GetPos(), ScCellIterator::getRefCellValue(), ScRefCellValue::getString(), ScRefCellValue::getType(), ScRefCellValue::getValue(), ScRefCellValue::hasEmptyValue(), ScRefCellValue::hasError(), ScRefCellValue::hasNumeric(), ScRefCellValue::hasString(), svl::SharedStringPool::intern(), ScCellIterator::isEmpty(), ScMatrix::IsSizeAllocatable(), ScComplexRefData::IsTrimToData(), maTokenMatrixMap, mrContext, mrDoc, mrStrPool, ScCellIterator::next(), nGlobalError, ScDocument::RoundValueAsShown(), ScAddress::Row(), SetError(), and ScDocument::ShrinkToDataArea().
Referenced by ConvertMatrixParameters(), and GetMatrix().
|
private |
Definition at line 363 of file interpr4.cxx.
References aStr, CELLTYPE_EDIT, CELLTYPE_FORMULA, CELLTYPE_STRING, ScFormulaCell::GetErrCode(), ScRefCellValue::getFormula(), ScFormulaCell::GetString(), svl::SharedString::getString(), ScRefCellValue::getString(), ScRefCellValue::getType(), ScRefCellValue::isEmpty(), ScFormulaCell::IsValue(), MAXARRSIZE, MAXCOLCOUNT, MAXCOLCOUNT_JUMBO, mrDoc, nCount, nPos, OUStringToOString(), p, and SAL_MAX_UINT16.
Referenced by ScExternal().
|
inlineprivate |
Definition at line 454 of file interpre.hxx.
References nCurFmtIndex, nCurFmtType, nFuncFmtIndex, and nFuncFmtType.
Referenced by IterateParameters(), ScMax(), and ScMin().
|
private |
Definition at line 7995 of file interpr1.cxx.
References div(), KahanSum::get(), GetDBParams(), ScDBQueryDataIterator::GetFirst(), ScDBQueryDataIterator::GetNext(), ifAVERAGE, ifCOUNT, ifMAX, ifMIN, ifPRODUCT, ifSUM, ifSUMSQ, MAXDOUBLE, ScDBQueryDataIterator::Value::mfValue, ScDBQueryDataIterator::Value::mnError, mrContext, mrDoc, nCount, PushDouble(), and SetError().
Referenced by ScDBAverage(), ScDBMax(), ScDBMin(), ScDBProduct(), and ScDBSum().
|
static |
Detect if string should be used as regular expression or wildcard expression or literal string.
Definition at line 10181 of file interpr1.cxx.
References eType, ScDocument::GetDocOptions(), ScDocOptions::GetFormulaSearchType(), MayBeRegExp(), MayBeWildcard(), utl::SearchParam::Normal, utl::SearchParam::Regexp, and utl::SearchParam::Wildcard.
Referenced by CalculateLookup(), GetDBParams(), IterateParametersIf(), IterateParametersIfs(), ScCountIf(), ScLookup(), ScMatch(), ScSearch(), and ScSearchB().
|
inlinestatic |
Fail safe division, returning a FormulaError::DivisionByZero coded into a double if denominator is 0.0.
Definition at line 1155 of file interpre.hxx.
References sc::div().
Referenced by DBIterator(), GetPercentrank(), IterateParametersIf(), ScDiv(), ScMIRR(), and ScSLN().
|
private |
Definition at line 2187 of file interpr4.cxx.
References GetDoubleErrorValue(), SAL_MAX_INT32, SAL_MIN_INT32, and SetError().
Referenced by GetInt32(), and GetInt32WithDefault().
Definition at line 2017 of file interpr4.cxx.
References ScRange::aEnd, aPos, ScRange::aStart, ScAddress::Col(), ScCompiler::DoubleRefToPosSingleRefScalarCase(), ScJumpMatrix::GetPos(), pJumpMatrix, ScAddress::Row(), ScAddress::SetCol(), SetError(), ScAddress::SetRow(), ScAddress::SetTab(), and ScAddress::Tab().
Referenced by GetDouble(), GetErrorType(), GetString(), Interpret(), and PopDoubleRefOrSingleRef().
|
private |
Definition at line 1026 of file interpr4.cxx.
References ScRange::aEnd, ScRange::aStart, IsTableOpInRange(), ScDocument::m_TableOpList, mrDoc, ScRange::PutInOrder(), ScComplexRefData::Ref1, ScComplexRefData::Ref2, ScAddress::Set(), SetError(), and SingleRefToVars().
Referenced by GetErrorType(), IterateParametersIfs(), PopDoubleRef(), and ScIndex().
|
private |
Definition at line 944 of file interpr4.cxx.
References IsTableOpInRange(), ScDocument::m_TableOpList, mrDoc, p, PutInOrder(), ScComplexRefData::Ref1, ScComplexRefData::Ref2, SetError(), and SingleRefToVars().
Referenced by ConvertMatrixParameters(), and PopDoubleRef().
|
private |
|
private |
Definition at line 7650 of file interpr1.cxx.
References aStr, ScQueryEntry::ByString, ScQueryEntry::ByValue, GetCellString(), GetCellValue(), GetDouble(), GetDoubleOrStringFromMatrix(), ScQueryEntry::GetQueryItem(), GetStackType(), GetString(), ScRefCellValue::hasNumeric(), ScMatrix::IsNonValueType(), ScQueryEntry::Item::maString, ScQueryEntry::Item::meType, ScQueryEntry::Item::mfVal, mrDoc, nType, PopDoubleRefOrSingleRef(), PushIllegalParameter(), PushInt(), svDouble, svDoubleRef, svExternalDoubleRef, svExternalSingleRef, svMatrix, svSingleRef, and svString.
Referenced by CalculateLookup(), and ScLookup().
|
staticprivate |
|
static |
Definition at line 268 of file interpr3.cxx.
Referenced by ScConfidence(), ScLogNormInv(), ScNormInv(), and ScSNormInv().
|
private |
Definition at line 800 of file interpr3.cxx.
References fMaxGammaArgument, GetGamma(), and lcl_getLanczosSum().
Referenced by GetBetaDistPDF(), GetTDist(), and ScFDist_LT().
|
private |
Definition at line 985 of file interpr3.cxx.
References GetBetaDistPDF(), GetLogBeta(), lcl_GetBetaHelperContFrac(), and log.
Referenced by GetFDist(), GetTDist(), ScBetaDistFunction::GetValue(), ScB(), ScBetaDist(), ScBetaDist_MS(), ScBinomDist(), and ScNegBinomDist_MS().
|
private |
Definition at line 862 of file interpr3.cxx.
References GetBeta(), GetLogBeta(), log, and SetError().
Referenced by GetBetaDist(), GetBinomDistPMF(), ScBetaDist(), ScBetaDist_MS(), and ScCritBinom().
|
private |
Definition at line 1232 of file interpr3.cxx.
References GetBetaDistPDF(), i, max, n, p, and x.
Referenced by ScB(), and ScBinomDist().
|
inlineprivate |
Definition at line 434 of file interpre.hxx.
References GetDouble().
Referenced by CalculateLookup(), CalculateRGPRKP(), CalculateTrendGrowth(), ScBetaDist(), ScBetaDist_MS(), ScBinomDist(), ScCeil(), ScChiSqDist(), ScChiSqDist_MS(), ScEuroConvert(), ScFDist_LT(), ScFixed(), ScFloor(), ScFourier(), ScFV(), ScGammaDist(), ScGetDiffDate360(), ScHypGeomDist(), ScIfJump(), ScIfs_MS(), ScIpmt(), ScLogNormDist(), ScNegBinomDist_MS(), ScNormDist(), ScNper(), ScPMT(), ScPoissonDist(), ScPpmt(), ScPV(), ScRank(), ScRate(), ScStdNormDist_MS(), ScTDist_MS(), and ScVDB().
|
inlineprivate |
Definition at line 416 of file interpre.hxx.
References cPar.
Referenced by CalculateLookup(), CalculatePearsonCovar(), CalculateRGPRKP(), CalculateSkew(), CalculateSlopeIntercept(), CalculateSmallLarge(), CalculateSumX2MY2SumX2DY2(), CalculateTrendGrowth(), GetDBParams(), GetStVarParams(), IterateParameters(), IterateParametersIf(), IterateParametersIfs(), RoundNumber(), ScAddressFunc(), ScAggregate(), ScAnd(), ScArcTan2(), ScAreas(), ScAsc(), ScAveDev(), ScAverageIfs(), ScB(), ScBadName(), ScBahtText(), ScBase(), ScBetaDist(), ScBetaDist_MS(), ScBetaInv(), ScBinomDist(), ScBitAnd(), ScBitLshift(), ScBitOr(), ScBitRshift(), ScBitXor(), ScCeil(), ScCeil_MS(), ScCeil_Precise(), ScCell(), ScChiDist(), ScChiInv(), ScChiSqDist(), ScChiSqDist_MS(), ScChiSqInv(), ScChiTest(), ScColor(), ScColumn(), ScColumns(), ScCombin(), ScCombinA(), ScConcat(), ScConcat_MS(), ScConfidence(), ScConfidenceT(), ScConvertOOo(), ScCountEmptyCells(), ScCountIf(), ScCountIfs(), ScCritBinom(), ScCumIpmt(), ScCumPrinc(), ScCurrency(), ScDB(), ScDDB(), ScDde(), ScDebugVar(), ScDecimal(), ScEasterSunday(), ScEffect(), ScEMat(), ScEncodeURL(), ScErf(), ScErfc(), ScEuroConvert(), ScExact(), ScExpDist(), ScExternal(), ScFDist(), ScFDist_LT(), ScFilterXML(), ScFind(), ScFindB(), ScFInv(), ScFInv_LT(), ScFixed(), ScFloor(), ScFloor_MS(), ScFloor_Precise(), ScForecast(), ScForecast_Ets(), ScFourier(), ScFrequency(), ScFTest(), ScFV(), ScGammaDist(), ScGammaInv(), ScGCD(), ScGeoMean(), ScGetDate(), ScGetDateDif(), ScGetDayOfWeek(), ScGetDiffDate(), ScGetDiffDate360(), ScGetIsoWeekOfYear(), ScGetPivotData(), ScGetTime(), ScGetWeekOfYear(), ScHarMean(), ScHyperLink(), ScHypGeomDist(), ScIfs_MS(), ScIndex(), ScIndirect(), ScInfo(), ScIpmt(), ScIRR(), ScISPMT(), ScJis(), ScLCM(), ScLeft(), ScLeftB(), ScLog(), ScLogNormDist(), ScLogNormInv(), ScLookup(), ScMacro(), ScMatch(), ScMatDet(), ScMatInv(), ScMatMult(), ScMatTrans(), ScMatValue(), ScMax(), ScMaxIfs_MS(), ScMedian(), ScMid(), ScMidB(), ScMin(), ScMinIfs_MS(), ScMIRR(), ScMod(), ScModalValue(), ScModalValue_MS(), ScMultiArea(), ScNegBinomDist(), ScNegBinomDist_MS(), ScNetWorkdays(), ScNominal(), ScNormDist(), ScNormInv(), ScNper(), ScNPV(), ScNumberValue(), ScOffset(), ScOr(), ScPDuration(), ScPercentile(), ScPercentrank(), ScPermut(), ScPermutationA(), ScPMT(), ScPoissonDist(), ScPower(), ScPpmt(), ScProbability(), ScPV(), ScQuartile(), ScRandbetween(), ScRank(), ScRate(), ScRawSubtract(), ScRegex(), ScReplace(), ScReplaceB(), ScRept(), ScRight(), ScRightB(), ScRoman(), ScRoundSignificant(), ScRow(), ScRows(), ScRRI(), ScSearch(), ScSearchB(), ScSheet(), ScSheets(), ScSLN(), ScStandard(), ScStdNormDist_MS(), ScStyle(), ScSubstitute(), ScSubTotal(), ScSumIfs(), ScSumProduct(), ScSumXMY2(), ScSwitch_MS(), ScSYD(), ScTableOp(), ScTDist(), ScTDist_MS(), ScTDist_T(), ScText(), ScTextJoin_MS(), ScTInv(), ScTrimMean(), ScTTest(), ScTTT(), ScUnichar(), ScUnicode(), ScVDB(), ScWebservice(), ScWeeknumOOo(), ScWeibull(), ScWorkday_MS(), ScXor(), and ScZTest().
|
staticprivate |
Definition at line 158 of file interpr4.cxx.
References CELLTYPE_FORMULA, ScFormulaCell::GetErrCode(), ScRefCellValue::getFormula(), and ScRefCellValue::getType().
Referenced by IsEven(), IsString(), ScHyperLink(), ScIfError(), ScIsErr(), ScIsError(), ScIsLogical(), ScIsNV(), ScIsValue(), ScT(), and ScType().
|
private |
Definition at line 125 of file interpr4.cxx.
References CELLTYPE_FORMULA, ScFormulaCell::GetErrCode(), ScRefCellValue::getFormula(), ScDocument::GetNumberFormat(), ScRefCellValue::getType(), ScRefCellValue::isEmpty(), mrContext, mrDoc, and SetError().
Referenced by ScIsLogical(), and ScType().
|
private |
Definition at line 245 of file interpr4.cxx.
References CELLTYPE_EDIT, CELLTYPE_FORMULA, CELLTYPE_STRING, CELLTYPE_VALUE, ScRefCellValue::getDouble(), svl::SharedString::getEmptyString(), ScFormulaCell::GetErrCode(), ScRefCellValue::getFormula(), ScFormulaCell::GetString(), ScRefCellValue::getString(), GetStringFromDouble(), ScRefCellValue::getType(), ScFormulaCell::GetValue(), svl::SharedStringPool::intern(), ScFormulaCell::IsValue(), mrDoc, mrStrPool, and SetError().
Referenced by Compare(), CompareMat(), FillEntry(), GetDBParams(), GetDoubleOrString(), GetMatrix(), GetString(), IterateParametersIf(), IterateParametersIfs(), JumpMatrix(), PushCellResultToken(), ScCell(), ScConcat_MS(), ScCountIf(), ScExternal(), ScHyperLink(), ScLookup(), ScMatch(), ScMatValue(), ScSwitch_MS(), ScT(), ScTableOp(), ScTextJoin_MS(), and ScValue().
|
private |
Definition at line 178 of file interpr4.cxx.
References GetCellValueOrZero(), and nGlobalError.
Referenced by CalculateSkew(), Compare(), CompareMat(), FillEntry(), GetDBParams(), GetDouble(), GetDoubleOrString(), GetMatrix(), GetNumberSequenceArray(), GetRankNumberArray(), GetStVarParams(), IsEven(), IterateParameters(), IterateParametersIf(), IterateParametersIfs(), JumpMatrix(), PushCellResultToken(), ScAnd(), ScAveDev(), ScCell(), ScCountIf(), ScExternal(), ScGeoMean(), ScHarMean(), ScHyperLink(), ScLookup(), ScMatch(), ScMatValue(), ScMax(), ScMin(), ScNPV(), ScOr(), ScSwitch_MS(), ScTableOp(), ScValue(), ScXor(), and ScZTest().
|
private |
Definition at line 188 of file interpr4.cxx.
References aStr, bCalcAsShown, CELLTYPE_EDIT, CELLTYPE_FORMULA, CELLTYPE_NONE, CELLTYPE_STRING, CELLTYPE_VALUE, ConvertStringToValue(), eType, ScRefCellValue::getDouble(), ScFormulaCell::GetErrCode(), ScRefCellValue::getFormula(), ScDocument::GetNumberFormat(), ScDocument::GetNumberFormatInfo(), ScInterpreterContext::GetNumberFormatType(), ScFormulaCell::GetString(), svl::SharedString::getString(), ScRefCellValue::getString(), ScRefCellValue::getType(), ScFormulaCell::GetValue(), ScFormulaCell::IsValue(), mrContext, mrDoc, nCurFmtIndex, nCurFmtType, ScDocument::RoundValueAsShown(), and SetError().
Referenced by GetCellValue().
|
private |
You must ensure fDF>0.0.
Definition at line 669 of file interpr3.cxx.
References GetUpRegIGamma().
Referenced by ScChiDistFunction::GetValue(), ScChiDist(), and ScChiTest().
|
private |
You must ensure fDF>0.0.
Definition at line 681 of file interpr3.cxx.
References GetLowRegIGamma().
Referenced by ScChiSqDistFunction::GetValue(), ScChiSqDist(), and ScChiSqDist_MS().
|
staticprivate |
Definition at line 689 of file interpr3.cxx.
References GetLogGamma(), and log.
Referenced by ScChiSqDist(), and ScChiSqDist_MS().
|
private |
Obtain the date serial number for a given date.
bStrict | If false, nYear < 100 takes the two-digit year setting into account, and rollover of invalid calendar dates takes place, e.g. 1999-02-31 => 1999-03-03. If true, the date passed must be a valid Gregorian calendar date. No two-digit expanding or rollover is done. |
Date must be Gregorian, i.e. >= 1582-10-15.
Definition at line 61 of file interpr2.cxx.
References Date::AddDays(), SvNumberFormatter::ExpandTwoDigitYear(), SvNumberFormatter::GetNullDate(), Date::IsValidAndGregorian(), pFormatter, and SetError().
Referenced by ScEasterSunday(), and ScGetDate().
|
inlinestaticprivate |
Definition at line 1160 of file interpre.hxx.
References n.
Referenced by ScNetWorkdays(), and ScWorkday_MS().
|
private |
Definition at line 7857 of file interpr1.cxx.
References aStr, ScQueryEntry::bDoQuery, ScQueryEntry::ByString, ScQueryEntry::ByValue, DetectSearchType(), GetByte(), GetCellString(), GetCellValue(), GetDouble(), ScQueryEntry::GetQueryItem(), GetStackType(), GetString(), svl::SharedString::getString(), ScRefCellValue::hasNumeric(), i, SvNumberFormatter::IsNumberFormat(), ScQueryEntry::Item::maString, ScQueryEntry::Item::meType, ScQueryEntry::Item::mfVal, mrDoc, nCount, nGlobalError, nIndex, utl::SearchParam::Normal, pFormatter, PopDBDoubleRef(), PopDoubleRef(), PopError(), PopSingleRef(), SetError(), svDouble, svDoubleRef, svMissing, svSingleRef, svString, and ScDocument::ValidCol().
Referenced by DBIterator(), GetDBStVarParams(), ScDBCount(), ScDBCount2(), and ScDBGet().
|
private |
Definition at line 8175 of file interpr1.cxx.
References KahanSum::get(), GetDBParams(), ScDBQueryDataIterator::GetFirst(), ScDBQueryDataIterator::GetNext(), ScDBQueryDataIterator::Value::mfValue, ScDBQueryDataIterator::Value::mnError, mrContext, mrDoc, SetError(), v, and values.
Referenced by ScDBStdDev(), ScDBStdDevP(), ScDBVar(), and ScDBVarP().
|
private |
Definition at line 2097 of file interpr4.cxx.
References ConvertStringToValue(), DoubleRefToPosSingleRef(), GetCellValue(), GetDoubleFromMatrix(), GetRawStackType(), getString(), mrDoc, nCurFmtIndex, nCurFmtType, nFuncFmtIndex, nFuncFmtType, nGlobalError, Pop(), PopDouble(), PopDoubleRef(), PopError(), PopExternalDoubleRef(), PopExternalSingleRef(), PopMatrix(), PopSingleRef(), PopString(), SetError(), svDouble, svDoubleRef, svEmptyCell, svError, svExternalDoubleRef, svExternalSingleRef, svMatrix, svMissing, svSingleRef, and svString.
Referenced by CalculateAddSub(), CalculateLookup(), CalculateSkew(), Compare(), CompareMat(), FillEntry(), GetBool(), GetDBParams(), GetDoubleWithDefault(), GetInt16(), GetInt32(), GetInt32WithDefault(), GetMatrix(), GetStringPositionArgument(), GetStVarParams(), GetUInt32(), IterateParameters(), IterateParametersIf(), IterateParametersIfs(), JumpMatrix(), RoundNumber(), ScAbs(), ScArcCos(), ScArcCosHyp(), ScArcCot(), ScArcCotHyp(), ScArcSin(), ScArcSinHyp(), ScArcTan(), ScArcTan2(), ScArcTanHyp(), ScAveDev(), ScB(), ScBahtText(), ScBase(), ScBetaDist(), ScBetaDist_MS(), ScBetaInv(), ScBinomDist(), ScBitAnd(), ScBitLshift(), ScBitOr(), ScBitRshift(), ScBitXor(), ScCeil(), ScCeil_MS(), ScCeil_Precise(), ScChar(), ScChiDist(), ScChiInv(), ScChiSqDist(), ScChiSqDist_MS(), ScChiSqInv(), ScColor(), ScCombin(), ScCombinA(), ScConfidence(), ScConfidenceT(), ScConvertOOo(), ScCos(), ScCosecant(), ScCosecantHyp(), ScCosHyp(), ScCot(), ScCotHyp(), ScCountIf(), ScCritBinom(), ScCumIpmt(), ScCumPrinc(), ScCurrency(), ScDB(), ScDDB(), ScDecimal(), ScDeg(), ScDiv(), ScEffect(), ScErf(), ScErfc(), ScEuroConvert(), ScEven(), ScExp(), ScExpDist(), ScExternal(), ScFact(), ScFDist(), ScFDist_LT(), ScFind(), ScFInv(), ScFInv_LT(), ScFisher(), ScFisherInv(), ScFixed(), ScFloor(), ScFloor_MS(), ScFloor_Precise(), ScForecast(), ScFourier(), ScFV(), ScGamma(), ScGammaDist(), ScGammaInv(), ScGauss(), ScGCD(), ScGeoMean(), ScGetDiffDate(), ScGetHour(), ScGetMin(), ScGetSec(), ScGetTime(), ScHarMean(), ScHyperLink(), ScHypGeomDist(), ScIndirect(), ScInt(), ScIpmt(), ScIRR(), ScISPMT(), ScLCM(), ScLn(), ScLog(), ScLog10(), ScLogGamma(), ScLogNormDist(), ScLogNormInv(), ScLookup(), ScMacro(), ScMatch(), ScMax(), ScMin(), ScMIRR(), ScMod(), ScMul(), ScN(), ScNeg(), ScNegBinomDist(), ScNegBinomDist_MS(), ScNominal(), ScNormDist(), ScNormInv(), ScNot(), ScNper(), ScNPV(), ScOdd(), ScPDuration(), ScPercentile(), ScPercentrank(), ScPermut(), ScPermutationA(), ScPhi(), ScPlusMinus(), ScPMT(), ScPoissonDist(), ScPow(), ScPpmt(), ScProbability(), ScPV(), ScQuartile(), ScRad(), ScRandbetween(), ScRank(), ScRate(), ScRawSubtract(), ScRoman(), ScRoundSignificant(), ScRRI(), ScSecant(), ScSecantHyp(), ScSin(), ScSinHyp(), ScSLN(), ScSNormInv(), ScSqrt(), ScStandard(), ScStdNormDist(), ScStdNormDist_MS(), ScStyle(), ScSwitch_MS(), ScSYD(), ScTan(), ScTanHyp(), ScTDist(), ScTDist_MS(), ScTDist_T(), ScText(), ScTextJoin_MS(), ScTInv(), ScTrimMean(), ScTTest(), ScVDB(), ScWeibull(), and ScZTest().
|
private |
Definition at line 2056 of file interpr4.cxx.
References GetDoubleErrorValue(), ScJumpMatrix::GetPos(), pJumpMatrix, and SetError().
Referenced by GetDouble().
|
private |
returns TRUE if double (or error, check nGlobalError), else FALSE
Definition at line 2274 of file interpr4.cxx.
References GetCellString(), GetCellValue(), GetDoubleOrStringFromMatrix(), GetRawStackType(), ScRefCellValue::hasNumeric(), ScMatrix::IsValueType(), mrDoc, nCurFmtIndex, nCurFmtType, nFuncFmtIndex, nFuncFmtType, nType, Pop(), PopDouble(), PopDoubleRefOrSingleRef(), PopError(), PopString(), SetError(), svDouble, svDoubleRef, svEmptyCell, svError, svExternalDoubleRef, svExternalSingleRef, svMatrix, svMissing, svSingleRef, and svString.
Referenced by GetWeekendAndHolidayMasks_MS(), ScGetPivotData(), and ScRegex().
|
private |
Definition at line 2435 of file interpr4.cxx.
References Empty, eType, ScMatrixValue::fVal, svl::SharedString::getEmptyString(), ScMatrixValue::GetError(), GetMatrix(), ScJumpMatrix::GetPos(), GetStackType(), ScMatrixValue::GetString(), ScMatrix::IsValueType(), ScMatrixValue::nType, pJumpMatrix, PopError(), SetError(), svExternalDoubleRef, svExternalSingleRef, and svMatrix.
Referenced by FillEntry(), GetDoubleOrString(), IterateParametersIf(), IterateParametersIfs(), ScCountIf(), ScHyperLink(), ScIfError(), ScIsLogical(), ScMatch(), ScSwitch_MS(), ScT(), and ScValue().
|
private |
Definition at line 2178 of file interpr4.cxx.
References GetDouble(), and IsMissing().
Referenced by ScAddressFunc(), ScCeil_Precise(), ScCumIpmt(), ScCumPrinc(), ScFixed(), ScFloor_Precise(), and ScForecast_Ets().
|
inline |
Definition at line 1015 of file interpre.hxx.
References nGlobalError.
Referenced by ScFormulaCell::InterpretTail(), ScExternal(), and ScSubstitute().
|
private |
Definition at line 10021 of file interpr1.cxx.
References DoubleRefToPosSingleRef(), DoubleRefToRange(), ScDocument::GetErrCode(), GetStackType(), mrDoc, n, nGlobalError, PopDoubleRef(), PopError(), PopSingleRef(), PopToken(), svDoubleRef, svRefList, svSingleRef, and x.
Referenced by ScErrorType(), and ScErrorType_ODF().
|
private |
Definition at line 1284 of file interpr4.cxx.
References aData, ScRange::aEnd, aPos, ScRange::aStart, ScAddress::Col(), formula::FormulaTokenArrayPlainIterator::First(), ScExternalRefManager::getDoubleRefTokens(), formula::FormulaToken::GetError(), ScExternalRefManager::getExternalFileName(), ScDocument::GetExternalRefManager(), formula::FormulaToken::GetType(), ScSingleRefData::IsTabRel(), mrDoc, formula::FormulaTokenArrayPlainIterator::Next(), ScComplexRefData::Ref1, ScComplexRefData::Ref2, ScAddress::Row(), SetError(), svError, svMatrix, and ScDocument::ValidColRow().
Referenced by ConvertMatrixParameters(), and PopExternalDoubleRef().
|
private |
Definition at line 640 of file interpr3.cxx.
References alpha, GetBetaDist(), and x.
Referenced by ScFDistFunction::GetValue(), ScFDist(), ScFDist_LT(), and ScFTest().
|
private |
You must ensure non integer arguments for fZ<1.
Definition at line 585 of file interpr3.cxx.
References fMaxGammaArgument, lcl_GetGammaHelper(), lcl_GetLogGammaHelper(), log, and SetError().
Referenced by GetBeta(), GetGammaDistPDF(), and ScGamma().
|
private |
You must ensure fA>0.0 && fX>0.0 valid results only if fX > fA+1.0 uses continued fraction with odd items.
Definition at line 44 of file interpr6.cxx.
References fHalfMachEps, and SetError().
Referenced by GetLowRegIGamma(), and GetUpRegIGamma().
|
private |
Gamma distribution, cumulative distribution function.
fLambda is "scale" parameter You must ensure fAlpha>0.0 and fLambda>0.0
Definition at line 198 of file interpr6.cxx.
References GetLowRegIGamma().
Referenced by ScGammaDistFunction::GetValue(), and ScGammaDist().
|
private |
Gamma distribution, probability density function.
fLambda is "scale" parameter You must ensure fAlpha>0.0 and fLambda>0.0
Definition at line 144 of file interpr6.cxx.
References fMaxGammaArgument, GetGamma(), GetLogGamma(), log, and SetError().
Referenced by ScGammaDist().
|
private |
You must ensure fA>0.0 && fX>0.0 valid results only if fX <= fA+1.0 uses power series.
Definition at line 96 of file interpr6.cxx.
References fHalfMachEps, nCount, and SetError().
Referenced by GetLowRegIGamma(), and GetUpRegIGamma().
|
static |
Definition at line 3902 of file interpr4.cxx.
References GetOrCreateGlobalConfig().
Referenced by ScTokenArray::CheckToken(), ScModelObj::disableAutomaticDeviceSelection(), ScModelObj::enableAutomaticDeviceSelection(), ScModelObj::enableOpenCL(), sc::FormulaGroupInterpreter::getStatic(), ScFormulaCell::InterpretFormulaGroup(), and sc::FormulaGroupInterpreter::MergeCalcConfig().
|
private |
Calculates a value of the hypergeometric distribution.
The algorithm is designed to avoid unnecessary multiplications and division by expanding all factorial elements (9 of them). It is done by excluding those ranges that overlap in the numerator and the denominator. This allows for a fast calculation for large values which would otherwise cause an overflow in the intermediate values.
Definition at line 1895 of file interpr3.cxx.
References lcl_PutFactorialElements(), M, N, n, PushNoValue(), and x.
Referenced by ScHypGeomDist().
|
private |
if GetDouble() not within int16 limits sets nGlobalError and returns SAL_MAX_INT16
Definition at line 2229 of file interpr4.cxx.
References GetDouble(), GetDoubleErrorValue(), SAL_MAX_INT16, SAL_MIN_INT16, and SetError().
Referenced by RoundNumber(), ScAddressFunc(), ScChooseJump(), ScEasterSunday(), ScGetDate(), ScGetDayOfWeek(), ScGetWeekOfYear(), ScIndex(), and ScWeeknumOOo().
|
private |
if GetDouble() not within int32 limits sets nGlobalError and returns SAL_MAX_INT32
Definition at line 2215 of file interpr4.cxx.
References double_to_int32(), and GetDouble().
Referenced by ScAddressFunc(), ScAggregate(), ScExternal(), ScGetDateDif(), ScGetDay(), ScGetDayOfWeek(), ScGetDiffDate360(), ScGetIsoWeekOfYear(), ScGetMonth(), ScGetWeekOfYear(), ScGetYear(), ScIndex(), ScOffset(), ScSubTotal(), ScWeeknumOOo(), and ScWorkday_MS().
|
private |
if GetDoubleWithDefault() not within int32 limits sets nGlobalError and returns SAL_MAX_INT32
Definition at line 2220 of file interpr4.cxx.
References double_to_int32(), GetDouble(), and IsMissing().
Referenced by ScAddressFunc().
|
staticprivate |
Definition at line 833 of file interpr3.cxx.
References lcl_getLanczosSum(), and log.
Referenced by GetBetaDist(), and GetBetaDistPDF().
|
staticprivate |
You must ensure fZ>0.
Definition at line 629 of file interpr3.cxx.
References fMaxGammaArgument, lcl_GetGammaHelper(), lcl_GetLogGammaHelper(), and log.
Referenced by GetChiSqDistPDF(), GetGammaDistPDF(), GetLowRegIGamma(), GetUpRegIGamma(), ScLogGamma(), and ScPoissonDist().
|
private |
You must ensure fA>0.0 && fX>0.0)
Definition at line 119 of file interpr6.cxx.
References GetGammaContFraction(), GetGammaSeries(), GetLogGamma(), and log.
Referenced by GetChiSqDistCDF(), and GetGammaDist().
|
private |
Definition at line 464 of file interpr5.cxx.
References aStr, CreateDoubleError(), CreateMatrixFromDoubleRef(), GetCellString(), GetCellValue(), GetDouble(), GetNewMat(), GetRawStackType(), GetString(), ScRefCellValue::hasEmptyValue(), ScRefCellValue::hasNumeric(), mrDoc, nGlobalError, p, PopDoubleRef(), PopError(), PopExternalDoubleRef(), PopExternalSingleRef(), PopMatrix(), PopSingleRef(), pStack, SetError(), sp, svDouble, svDoubleRef, svError, svExternalDoubleRef, svExternalSingleRef, svMatrix, svMissing, svSingleRef, and svString.
Referenced by CalculateAddSub(), CalculateLookup(), CalculatePearsonCovar(), CalculateRGPRKP(), CalculateSkew(), CalculateSlopeIntercept(), CalculateSumX2MY2SumX2DY2(), CalculateTrendGrowth(), Compare(), ConvertMatrixJumpConditionToMatrix(), CreateMatrixFromDoubleRef(), GetDoubleOrStringFromMatrix(), GetMatrix(), GetNumberSequenceArray(), GetRangeMatrix(), GetRankNumberArray(), GetStVarParams(), IsEven(), IsString(), IterateParametersIf(), IterateParametersIfs(), JumpMatrix(), PopDoubleRefPushMatrix(), PopMatrix(), PopRangeMatrix(), ScAmpersand(), ScAnd(), ScAveDev(), ScChiTest(), ScConcat_MS(), ScCountEmptyCells(), ScCountIf(), ScDiv(), ScForecast(), ScForecast_Ets(), ScFourier(), ScFTest(), ScGCD(), ScGeoMean(), ScHarMean(), ScIndex(), ScIRR(), ScIsEmpty(), ScIsErr(), ScIsError(), ScIsNV(), ScIsValue(), ScLCM(), ScLookup(), ScMacro(), ScMatDet(), ScMatInv(), ScMatMult(), ScMatTrans(), ScMax(), ScMin(), ScMIRR(), ScMul(), ScNeg(), ScNot(), ScNPV(), ScOr(), ScPow(), ScProbability(), ScSumProduct(), ScSumXMY2(), ScTextJoin_MS(), ScTTest(), ScXor(), and ScZTest().
|
private |
Definition at line 578 of file interpr5.cxx.
References CreateMatrixFromDoubleRef(), GetMatrix(), GetRawStackType(), ScRange::GetVars(), ScAddress::INITIALIZE_INVALID, nGlobalError, PopDoubleRef(), and svRefList.
|
private |
Definition at line 3366 of file interpr3.cxx.
References nGlobalError, and SetError().
Referenced by ScMedian(), and ScQuartile().
ScMatrixRef ScInterpreter::GetNewMat | ( | SCSIZE | nC, |
SCSIZE | nR, | ||
bool | bEmpty = false |
||
) |
Definition at line 284 of file interpr5.cxx.
References MakeMatNew().
Referenced by CalculateAddSub(), CalculateRGPRKP(), CalculateSmallLarge(), CalculateTrendGrowth(), CheckMatrix(), CompareMat(), CreateMatrixFromDoubleRef(), GetMatrix(), GetStVarParams(), IterateParameters(), IterateParametersIf(), IterateParametersIfs(), lcl_MatrixCalculation(), MatConcat(), PopRefListPushMatrixOrRef(), ScAmpersand(), ScColumn(), ScCountEmptyCells(), ScCountIf(), ScDde(), ScDiv(), ScEMat(), ScFilterXML(), ScForecast_Ets(), ScFormula(), ScFourier(), ScFrequency(), ScHyperLink(), ScIndex(), ScIsFormula(), ScLookup(), ScMacro(), ScMatInv(), ScMatMult(), ScMatTrans(), ScModalValue_MS(), ScMul(), ScNeg(), ScNot(), ScPow(), ScRandomImpl(), ScRow(), and SwitchToArrayRefList().
ScMatrixRef ScInterpreter::GetNewMat | ( | SCSIZE | nC, |
SCSIZE | nR, | ||
const std::vector< double > & | rValues | ||
) |
Definition at line 295 of file interpr5.cxx.
References MakeMatNew().
|
private |
Definition at line 3960 of file interpr3.cxx.
References ScRange::aEnd, ScRange::aStart, aStr, ScAddress::Col(), ConvertStringToValue(), CreateDoubleError(), GetCellValue(), ScValueIterator::GetFirst(), GetMatrix(), ScValueIterator::GetNext(), GetStackType(), ScRefCellValue::hasError(), ScRefCellValue::hasNumeric(), i, IgnoreErrVal, mnSubTotalFlags, mrContext, mrDoc, nCount, nGlobalError, PopDouble(), PopDoubleRef(), PopError(), PopSingleRef(), ScRange::PutInOrder(), ReverseStack(), ScAddress::Row(), SetError(), svDouble, svDoubleRef, svExternalDoubleRef, svExternalSingleRef, svMatrix, svRefList, and svSingleRef.
Referenced by CalculateSmallLarge(), GetSortArray(), GetWeekendAndHolidayMasks(), ScMedian(), ScModalValue_MS(), ScPercentile(), and ScQuartile().
|
inline |
Definition at line 1018 of file interpre.hxx.
References xResult.
Referenced by ScFormulaCell::InterpretTail().
|
staticprivate |
Definition at line 3890 of file interpr4.cxx.
References mpGlobalConfig.
Referenced by GetGlobalConfig(), MergeCalcConfig(), and SetGlobalConfig().
|
static |
Definition at line 3400 of file interpr3.cxx.
References nIndex.
Referenced by ScPercentile(), and ScQuartile().
|
private |
Definition at line 3429 of file interpr3.cxx.
References nGlobalError, nIndex, and SetError().
Referenced by ScPercentile(), and ScQuartile().
|
staticprivate |
Definition at line 3772 of file interpr3.cxx.
Referenced by ScPercentrank().
|
private |
Definition at line 601 of file interpr5.cxx.
References GetMatrix(), GetRawStackType(), sc::RangeMatrix::mpMat, PopRangeMatrix(), and svMatrix.
Referenced by CompareMat().
Definition at line 3858 of file interpr3.cxx.
References ScRange::aEnd, ScRange::aStart, ScAddress::Col(), CreateDoubleError(), GetCellValue(), ScValueIterator::GetFirst(), GetMatrix(), ScValueIterator::GetNext(), GetStackType(), ScRefCellValue::hasNumeric(), i, mnSubTotalFlags, mrContext, mrDoc, nCount, nGlobalError, PopDouble(), PopDoubleRef(), PopError(), PopSingleRef(), ScAddress::Row(), SetError(), svDouble, svDoubleRef, svExternalDoubleRef, svExternalSingleRef, svMatrix, svSingleRef, and ScAddress::Tab().
Referenced by CalculateSmallLarge().
|
private |
Raw stack type without default replacements.
Definition at line 1963 of file interpr4.cxx.
References formula::FormulaToken::GetType(), pStack, SetError(), sp, and svUnknown.
Referenced by Compare(), CompareMat(), GetDouble(), GetDoubleOrString(), GetMatrix(), GetRangeMatrix(), GetString(), IsString(), ScGetPivotData(), ScIsEmpty(), ScIsValue(), and ScValue().
|
private |
Check for array of references to determine the maximum size of a return column vector if in array context.
Definition at line 421 of file interpr6.cxx.
References GetStackType(), i, IsInArrayContext(), p, pStack, sp, and svRefList.
Referenced by GetStVarParams(), IterateParameters(), IterateParametersIf(), IterateParametersIfs(), ScCountEmptyCells(), ScCountIf(), ScMax(), and ScMin().
|
inline |
Definition at line 1019 of file interpre.hxx.
References xResult.
Referenced by ScSimpleFormulaCalculator::Calculate(), ScFormulaCell::InterpretInvariantFormulaGroup(), and ScFormulaCell::InterpretTail().
|
inline |
Definition at line 1016 of file interpre.hxx.
References xResult.
Referenced by ScFormulaCell::InterpretTail().
|
inline |
Definition at line 1021 of file interpre.hxx.
References nRetFmtIndex.
Referenced by ScFormulaCell::InterpretTail().
|
inline |
Definition at line 1020 of file interpre.hxx.
References nRetFmtType.
Referenced by ScSimpleFormulaCalculator::Calculate(), and ScFormulaCell::InterpretTail().
|
private |
Definition at line 4143 of file interpr3.cxx.
References GetNumberSequenceArray(), ScDocument::GetSheetLimits(), MAX_COUNT_DOUBLE_FOR_SORT(), mrDoc, nGlobalError, QuickSort(), and SetError().
Referenced by GetWeekendAndHolidayMasks(), GetWeekendAndHolidayMasks_MS(), ScFrequency(), ScModalValue(), ScPercentrank(), ScRank(), and ScTrimMean().
|
private |
Definition at line 1118 of file interpr4.cxx.
References p, pStack, size, sp, svDoubleRef, and svRefList.
Referenced by CalculateLookup(), IterateParametersIfs(), ScCountIf(), and ScMatch().
|
private |
Stack type with replacement of defaults, e.g. svMissing and formula::svEmptyCell will result in formula::svDouble.
Definition at line 1978 of file interpr4.cxx.
References formula::FormulaToken::GetType(), pStack, SetError(), sp, svDouble, svEmptyCell, svMissing, and svUnknown.
Referenced by CalculateAddSub(), CalculateLookup(), CalculateSkew(), ConvertMatrixJumpConditionToMatrix(), FillEntry(), GetDBParams(), GetDoubleOrStringFromMatrix(), GetErrorType(), GetNumberSequenceArray(), GetRankNumberArray(), GetRefListArrayMaxSize(), GetStVarParams(), GetWeekendAndHolidayMasks_MS(), Interpret(), IsEven(), IterateParameters(), IterateParametersIf(), IterateParametersIfs(), JumpMatrix(), PopDBDoubleRef(), PopDoubleRefOrSingleRef(), PopDoubleRefPushMatrix(), PopRefListPushMatrixOrRef(), ScAmpersand(), ScAnd(), ScAreas(), ScAveDev(), ScCell(), ScChooseJump(), ScColumn(), ScColumns(), ScConcat_MS(), ScCountEmptyCells(), ScCountIf(), ScDiv(), ScEqual(), ScExternal(), ScFilterXML(), ScFormula(), ScGCD(), ScGeoMean(), ScGetPivotData(), ScGreater(), ScGreaterEqual(), ScHarMean(), ScHyperLink(), ScIfError(), ScIfJump(), ScIndex(), ScIRR(), ScIsErr(), ScIsError(), ScIsFormula(), ScIsLogical(), ScIsNV(), ScIsRef(), ScLCM(), ScLess(), ScLessEqual(), ScLookup(), ScMacro(), ScMatch(), ScMatValue(), ScMax(), ScMin(), ScMIRR(), ScMul(), ScNeg(), ScNot(), ScNotEqual(), ScNPV(), ScNumberValue(), ScOffset(), ScOr(), ScPow(), ScRandomImpl(), ScRow(), ScRows(), ScRSQ(), ScSheet(), ScSheets(), ScSwitch_MS(), ScT(), ScText(), ScTextJoin_MS(), ScType(), ScXor(), and ScZTest().
Definition at line 1995 of file interpr4.cxx.
References formula::FormulaToken::GetType(), pStack, sp, svDouble, svEmptyCell, svMissing, and svUnknown.
|
private |
Definition at line 2334 of file interpr4.cxx.
References DoubleRefToPosSingleRef(), GetCellString(), svl::SharedString::getEmptyString(), GetRawStackType(), GetStringFromDouble(), GetStringFromMatrix(), mrDoc, nGlobalError, Pop(), PopDouble(), PopDoubleRef(), PopError(), PopExternalDoubleRef(), PopExternalSingleRef(), PopMatrix(), PopSingleRef(), PopString(), SetError(), svDouble, svDoubleRef, svEmptyCell, svError, svExternalDoubleRef, svExternalSingleRef, svMatrix, svMissing, svSingleRef, and svString.
Referenced by Compare(), CompareMat(), FillEntry(), GetDBParams(), GetMatrix(), IterateParametersIf(), IterateParametersIfs(), JumpMatrix(), ScAddressFunc(), ScAmpersand(), ScArabic(), ScAsc(), ScCell(), ScCellExternal(), ScClean(), ScCode(), ScConcat(), ScConcat_MS(), ScConvertOOo(), ScCountIf(), ScDde(), ScDebugVar(), ScDecimal(), ScEncodeURL(), ScEuroConvert(), ScExact(), ScExternal(), ScFilterXML(), ScFind(), ScFindB(), ScGetDateDif(), ScGetDateValue(), ScGetPivotData(), ScGetTimeValue(), ScHyperLink(), ScIndirect(), ScInfo(), ScJis(), ScLeft(), ScLeftB(), ScLen(), ScLenB(), ScLookup(), ScLower(), ScMacro(), ScMatch(), ScMid(), ScMidB(), ScNumberValue(), ScProper(), ScRegex(), ScReplace(), ScReplaceB(), ScRept(), ScRight(), ScRightB(), ScSearch(), ScSearchB(), ScStyle(), ScSubstitute(), ScSwitch_MS(), ScText(), ScTextJoin_MS(), ScTrim(), ScUnicode(), ScUpper(), ScValue(), and ScWebservice().
|
private |
Definition at line 2496 of file interpr4.cxx.
References aStr, ScGlobal::eLnge, SvNumberFormatter::GetInputLineString(), SvNumberFormatter::GetStandardFormat(), svl::SharedStringPool::intern(), mrStrPool, nIndex, and pFormatter.
Referenced by GetCellString(), and GetString().
|
private |
Definition at line 2413 of file interpr4.cxx.
References svl::SharedString::getEmptyString(), ScJumpMatrix::GetPos(), pFormatter, pJumpMatrix, and SetError().
Referenced by GetString().
|
inlineprivate |
Obtain a sal_Int32 suitable as string position or length argument.
Returns -1 if the number is Inf or NaN or less than 0 or greater than some implementation defined max string length. In these cases also sets nGlobalError to FormulaError::IllegalArgument, if not already set.
Definition at line 1109 of file interpre.hxx.
References CheckStringPositionArgument(), GetDouble(), and SetError().
Referenced by ScFindB(), ScLeft(), ScLeftB(), ScMid(), ScMidB(), ScReplace(), ScReplaceB(), ScRept(), ScRight(), ScRightB(), ScSearch(), ScSearchB(), and ScSubstitute().
const svl::SharedString & ScInterpreter::GetStringResult | ( | ) | const |
Definition at line 4814 of file interpr4.cxx.
References xResult.
Referenced by ScFormulaCell::InterpretTail().
|
private |
Definition at line 3999 of file interpr1.cxx.
References CreateDoubleError(), KahanSum::get(), get(), GetByte(), GetCellValue(), GetDouble(), ScValueIterator::GetFirst(), GetMatrix(), GetNewMat(), ScValueIterator::GetNext(), GetRefListArrayMaxSize(), GetStackType(), ScRefCellValue::hasNumeric(), ScRefCellValue::hasString(), i, IgnoreErrVal, mnSubTotalFlags, mrContext, mrDoc, n, nGlobalError, p, Pop(), PopDoubleRef(), PopError(), PopSingleRef(), pStack, PushDouble(), PushMatrix(), SetError(), sp, svDouble, svDoubleRef, svExternalDoubleRef, svExternalSingleRef, svMatrix, svRefList, svSingleRef, svString, and values.
Referenced by ScDevSq(), ScStDev(), ScStDevP(), ScVar(), and ScVarP().
|
private |
Definition at line 648 of file interpr3.cxx.
References GetBeta(), GetBetaDist(), nType, R, SetError(), and X.
Referenced by ScTDistFunction::GetValue(), ScTDist(), ScTDist_MS(), ScTDist_T(), and ScTTest().
|
private |
Definition at line 2288 of file interpr3.cxx.
References lcl_IterateInverse(), nType, and SetError().
Referenced by ScConfidenceT(), and ScTInv().
|
inlineprivate |
Definition at line 1043 of file interpre.hxx.
References maTokenMatrixMap.
Referenced by ConvertMatrixJumpConditionToMatrix(), ConvertMatrixParameters(), ScChooseJump(), ScIfError(), and ScIfJump().
|
private |
if GetDouble() not within uint32 limits sets nGlobalError and returns SAL_MAX_UINT32
Definition at line 2258 of file interpr4.cxx.
References GetDouble(), GetDoubleErrorValue(), SAL_MAX_UINT32, and SetError().
Referenced by ScDde(), ScEMat(), ScIndex(), ScMatValue(), ScNetWorkdays(), ScUnichar(), and ScWorkday_MS().
|
private |
You must ensure fA>0.0 && fX>0.0)
Definition at line 130 of file interpr6.cxx.
References GetGammaContFraction(), GetGammaSeries(), GetLogGamma(), and log.
Referenced by GetChiDist(), and ScPoissonDist().
|
private |
Only ValueCell, formula cells already store the result rounded.
Definition at line 148 of file interpr4.cxx.
References bCalcAsShown, ScDocument::GetNumberFormat(), mrContext, mrDoc, and ScDocument::RoundValueAsShown().
Referenced by CreateCellArr(), and CreateDoubleArr().
|
inline |
Definition at line 172 of file interpre.hxx.
References meVolatileType.
Referenced by ScFormulaCell::HandleStuffAfterParallelCalculation(), ScFormulaCell::InterpretTail(), and LookupQueryWithCache().
|
private |
Definition at line 344 of file interpr2.cxx.
References GetNumberSequenceArray(), GetSortArray(), i, nGlobalError, SATURDAY, and SUNDAY.
Referenced by ScNetWorkdays().
|
private |
Definition at line 384 of file interpr2.cxx.
References FRIDAY, GetDoubleOrString(), svl::SharedString::getLength(), GetSortArray(), GetStackType(), svl::SharedString::getString(), i, svl::SharedString::isEmpty(), IsMissing(), MONDAY, Pop(), SATURDAY, SUNDAY, svDoubleRef, svExternalDoubleRef, THURSDAY, TUESDAY, and WEDNESDAY.
Referenced by ScNetWorkdays(), and ScWorkday_MS().
|
static |
Definition at line 3913 of file interpr4.cxx.
References bGlobalStackInUse, and pGlobalStack.
Referenced by ScGlobal::Clear().
|
inlineprivate |
If nGlobalError is set push formula::FormulaErrorToken.
If nGlobalError is not set do nothing. Used in PushTempToken() and alike to simplify handling.
Definition at line 293 of file interpre.hxx.
References nGlobalError, and PushTempTokenWithoutError().
Referenced by PushCellResultToken(), PushDouble(), PushDoubleRef(), PushExternalDoubleRef(), PushExternalSingleRef(), PushInt(), PushSingleRef(), and PushString().
void ScInterpreter::Init | ( | ScFormulaCell * | pCell, |
const ScAddress & | rPos, | ||
ScTokenArray & | rTokArray | ||
) |
Definition at line 3866 of file interpr4.cxx.
References aCode, aPos, cPar, maTokenMatrixMap, maxsp, mnStringNoValueError, mnSubTotalFlags, nCurFmtIndex, nCurFmtType, nFuncFmtIndex, nFuncFmtType, nGlobalError, NONE, nRetFmtIndex, nRetFmtType, pArr, pCur, pJumpMatrix, pMyFormulaCell, formula::FormulaTokenIterator::ReInit(), sp, and xResult.
Referenced by ScFormulaCell::HandleStuffAfterParallelCalculation(), and ScFormulaCell::InterpretTail().
|
static |
Definition at line 200 of file interpr3.cxx.
References x.
Referenced by ScLogNormDist(), ScNormDist(), ScStdNormDist(), and ScStdNormDist_MS().
StackVar ScInterpreter::Interpret | ( | ) |
Definition at line 3972 of file interpr4.cxx.
References aCode, aPos, bMatrixFormula, ScAddress::Col(), cPar, CreateFormulaDoubleToken(), DoubleRefToPosSingleRef(), etsAdd, etsMult, etsPIAdd, etsPIMult, etsSeason, etsStatAdd, etsStatMult, eType, formula::FormulaTokenArrayPlainIterator::FirstRPN(), FORCE_DOC, ScAddress::Format(), formula::FormulaToken::GetByte(), formula::FormulaToken::GetDoubleType(), formula::FormulaToken::GetError(), formula::FormulaToken::GetOpCode(), formula::FormulaToken::GetParamCount(), GetStackType(), formula::FormulaToken::GetType(), formula::FormulaTokenIterator::IsEndOfPath(), sc::RangeMatrix::isRangeValid(), JumpMatrix(), maTokenMatrixMap, MatrixParameterConversion(), maxsp, ScExternalRefCache::CellFormat::mbIsSet, meVolatileType, ScExternalRefCache::CellFormat::mnIndex, mnSubTotalFlags, ScExternalRefCache::CellFormat::mnType, sc::RangeMatrix::mpMat, mrDoc, nCurFmtIndex, nCurFmtType, formula::FormulaTokenIterator::Next(), formula::FormulaTokenArrayPlainIterator::NextRPN(), nFuncFmtIndex, nFuncFmtType, nGlobalError, NONE, nRetFmtIndex, nRetFmtType, ocAbs, ocAdd, ocAddress, ocAggregate, ocAmpersand, ocAnd, ocArabic, ocArcCos, ocArcCosHyp, ocArcCot, ocArcCotHyp, ocArcSin, ocArcSinHyp, ocArcTan, ocArcTan2, ocArcTanHyp, ocAreas, ocAsc, ocAveDev, ocAverage, ocAverageA, ocAverageIf, ocAverageIfs, ocB, ocBad, ocBahtText, ocBase, ocBetaDist, ocBetaDist_MS, ocBetaInv, ocBetaInv_MS, ocBinomDist, ocBinomDist_MS, ocBinomInv, ocBitAnd, ocBitLshift, ocBitOr, ocBitRshift, ocBitXor, ocCall, ocCeil, ocCeil_ISO, ocCeil_Math, ocCeil_MS, ocCeil_Precise, ocCell, ocChar, ocChiDist, ocChiDist_MS, ocChiInv, ocChiInv_MS, ocChiSqDist, ocChiSqDist_MS, ocChiSqInv, ocChiSqInv_MS, ocChiTest, ocChiTest_MS, ocChoose, ocClean, ocClose, ocCode, ocColor, ocColRowNameAuto, ocColumn, ocColumns, ocCombin, ocCombinA, ocConcat, ocConcat_MS, ocConfidence, ocConfidence_N, ocConfidence_T, ocConvertOOo, ocCorrel, ocCos, ocCosecant, ocCosecantHyp, ocCosHyp, ocCot, ocCotHyp, ocCount, ocCount2, ocCountEmptyCells, ocCountIf, ocCountIfs, ocCovar, ocCovarianceP, ocCovarianceS, ocCritBinom, ocCumIpmt, ocCumPrinc, ocCurrency, ocCurrent, ocDB, ocDBArea, ocDBAverage, ocDBCount, ocDBCount2, ocDBGet, ocDBMax, ocDBMin, ocDBProduct, ocDBStdDev, ocDBStdDevP, ocDBSum, ocDBVar, ocDBVarP, ocDDB, ocDde, ocDebugVar, ocDecimal, ocDeg, ocDevSq, ocDiv, ocEasterSunday, ocEffect, ocEncodeURL, ocEqual, ocErf_MS, ocErfc_MS, ocErrorType, ocErrorType_ODF, ocEuroConvert, ocEven, ocExact, ocExp, ocExpDist, ocExpDist_MS, ocExternal, ocFact, ocFalse, ocFDist, ocFDist_LT, ocFDist_RT, ocFilterXML, ocFind, ocFindB, ocFInv, ocFInv_LT, ocFInv_RT, ocFisher, ocFisherInv, ocFixed, ocFloor, ocFloor_Math, ocFloor_MS, ocFloor_Precise, ocForecast, ocForecast_ETS_ADD, ocForecast_ETS_MUL, ocForecast_ETS_PIA, ocForecast_ETS_PIM, ocForecast_ETS_SEA, ocForecast_ETS_STA, ocForecast_ETS_STM, ocForecast_LIN, ocFormula, ocFourier, ocFrequency, ocFTest, ocFTest_MS, ocFV, ocGamma, ocGammaDist, ocGammaDist_MS, ocGammaInv, ocGammaInv_MS, ocGammaLn, ocGammaLn_MS, ocGauss, ocGCD, ocGeoMean, ocGetActDate, ocGetActTime, ocGetDate, ocGetDateDif, ocGetDateValue, ocGetDay, ocGetDayOfWeek, ocGetDiffDate, ocGetDiffDate360, ocGetHour, ocGetMin, ocGetMonth, ocGetPivotData, ocGetSec, ocGetTime, ocGetTimeValue, ocGetYear, ocGreater, ocGreaterEqual, ocGrowth, ocHarMean, ocHLookup, ocHyperLink, ocHypGeomDist, ocHypGeomDist_MS, ocIf, ocIfError, ocIfNA, ocIfs_MS, ocIndex, ocIndirect, ocInfo, ocInt, ocIntercept, ocIntersect, ocIpmt, ocIRR, ocIsEmpty, ocIsErr, ocIsError, ocIsEven, ocIsFormula, ocIsLogical, ocIsNA, ocIsNonString, ocIsOdd, ocIsoWeeknum, ocISPMT, ocIsRef, ocIsString, ocIsValue, ocJis, ocKurt, ocLarge, ocLCM, ocLeft, ocLeftB, ocLen, ocLenB, ocLess, ocLessEqual, ocLinest, ocLn, ocLog, ocLog10, ocLogest, ocLogInv, ocLogInv_MS, ocLogNormDist, ocLogNormDist_MS, ocLookup, ocLower, ocMacro, ocMatch, ocMatDet, ocMatInv, ocMatMult, ocMatRef, ocMatrixUnit, ocMatTrans, ocMatValue, ocMax, ocMaxA, ocMaxIfs_MS, ocMedian, ocMid, ocMidB, ocMin, ocMinA, ocMinIfs_MS, ocMIRR, ocMissing, ocMod, ocModalValue, ocModalValue_MS, ocModalValue_Multi, ocMul, ocMultiArea, ocN, ocNeg, ocNegBinomDist_MS, ocNegBinomVert, ocNegSub, ocNetWorkdays, ocNetWorkdays_MS, ocNominal, ocNoName, ocNone, ocNormDist, ocNormDist_MS, ocNormInv, ocNormInv_MS, ocNot, ocNotAvail, ocNotEqual, ocNper, ocNPV, ocNumberValue, ocOdd, ocOffset, ocOr, ocPDuration, ocPearson, ocPercentile, ocPercentile_Exc, ocPercentile_Inc, ocPercentrank, ocPercentrank_Exc, ocPercentrank_Inc, ocPercentSign, ocPermut, ocPermutationA, ocPhi, ocPi, ocPlusMinus, ocPMT, ocPoissonDist, ocPoissonDist_MS, ocPow, ocPower, ocPpmt, ocProb, ocProduct, ocProper, ocPush, ocPV, ocQuartile, ocQuartile_Exc, ocQuartile_Inc, ocRad, ocRandbetweenNV, ocRandom, ocRandomNV, ocRange, ocRank, ocRank_Avg, ocRank_Eq, ocRate, ocRawSubtract, ocRegex, ocReplace, ocReplaceB, ocRept, ocRight, ocRightB, ocRoman, ocRound, ocRoundDown, ocRoundSig, ocRoundUp, ocRow, ocRows, ocRRI, ocRSQ, ocSearch, ocSearchB, ocSecant, ocSecantHyp, ocSep, ocSheet, ocSheets, ocSin, ocSinHyp, ocSkew, ocSkewp, ocSLN, ocSlope, ocSmall, ocSNormInv, ocSNormInv_MS, ocSqrt, ocStandard, ocStDev, ocStDevA, ocStDevP, ocStDevP_MS, ocStDevPA, ocStDevS, ocStdNormDist, ocStdNormDist_MS, ocSTEYX, ocStop, ocStyle, ocSub, ocSubstitute, ocSubTotal, ocSum, ocSumIf, ocSumIfs, ocSumProduct, ocSumSQ, ocSumX2DY2, ocSumX2MY2, ocSumXMY2, ocSwitch_MS, ocSYD, ocT, ocTableOp, ocTan, ocTanHyp, ocTDist, ocTDist_2T, ocTDist_MS, ocTDist_RT, ocText, ocTextJoin_MS, ocTInv, ocTInv_2T, ocTInv_MS, ocTrend, ocTrim, ocTrimMean, ocTrue, ocTrunc, ocTTest, ocTTest_MS, ocTTT, ocType, ocUnichar, ocUnicode, ocUnion, ocUpper, ocValue, ocVar, ocVarA, ocVarP, ocVarP_MS, ocVarPA, ocVarS, ocVBD, ocVLookup, ocWebservice, ocWeek, ocWeeknumOOo, ocWeibull, ocWeibull_MS, ocWorkday_MS, ocXor, ocZTest, ocZTest_MS, p, pArr, pCur, pJumpMatrix, Pop(), PopDouble(), PopDoubleRef(), PopDoubleRefPushMatrix(), PopError(), PopExternalDoubleRef(), PopExternalSingleRef(), PopMatrix(), PopRangeMatrix(), PopRefListPushMatrixOrRef(), PopSingleRef(), PopToken(), pStack, PushCellResultToken(), PushError(), PushInt(), PushNoValue(), PushTempToken(), PushTokenRef(), PushWithoutError(), QueryMatrixType(), formula::FormulaTokenIterator::Reset(), ScAddress::Row(), SAL_MATH_FPEXCEPTIONS_OFF, SAL_WARN, ScAbs(), ScAdd(), ScAddressFunc(), ScAggregate(), ScAmpersand(), ScAnd(), ScArabic(), ScArcCos(), ScArcCosHyp(), ScArcCot(), ScArcCotHyp(), ScArcSin(), ScArcSinHyp(), ScArcTan(), ScArcTan2(), ScArcTanHyp(), ScAreas(), ScAsc(), ScAveDev(), ScAverage(), ScAverageIf(), ScAverageIfs(), ScB(), ScBadName(), ScBahtText(), ScBase(), ScBetaDist(), ScBetaDist_MS(), ScBetaInv(), ScBinomDist(), ScBitAnd(), ScBitLshift(), ScBitOr(), ScBitRshift(), ScBitXor(), ScCeil(), ScCeil_MS(), ScCeil_Precise(), ScCell(), ScChar(), ScChiDist(), ScChiInv(), ScChiSqDist(), ScChiSqDist_MS(), ScChiSqInv(), ScChiTest(), ScChooseJump(), ScClean(), ScCode(), ScColor(), ScColRowNameAuto(), ScColumn(), ScColumns(), ScCombin(), ScCombinA(), ScConcat(), ScConcat_MS(), ScConfidence(), ScConfidenceT(), ScConvertOOo(), ScCorrel(), ScCos(), ScCosecant(), ScCosecantHyp(), ScCosHyp(), ScCot(), ScCotHyp(), ScCount(), ScCount2(), ScCountEmptyCells(), ScCountIf(), ScCountIfs(), ScCovarianceP(), ScCovarianceS(), ScCritBinom(), ScCumIpmt(), ScCumPrinc(), ScCurrency(), ScCurrent(), ScDB(), ScDBArea(), ScDBAverage(), ScDBCount(), ScDBCount2(), ScDBGet(), ScDBMax(), ScDBMin(), ScDBProduct(), ScDBStdDev(), ScDBStdDevP(), ScDBSum(), ScDBVar(), ScDBVarP(), ScDDB(), ScDde(), ScDebugVar(), ScDecimal(), ScDeg(), ScDevSq(), ScDiv(), ScEasterSunday(), ScEffect(), ScEMat(), ScEncodeURL(), ScEqual(), ScErf(), ScErfc(), ScErrorType(), ScErrorType_ODF(), ScEuroConvert(), ScEven(), ScExact(), ScExp(), ScExpDist(), ScExternal(), ScFact(), ScFalse(), ScFDist(), ScFDist_LT(), ScFilterXML(), ScFind(), ScFindB(), ScFInv(), ScFInv_LT(), ScFisher(), ScFisherInv(), ScFixed(), ScFloor(), ScFloor_MS(), ScFloor_Precise(), ScForecast(), ScForecast_Ets(), ScFormula(), ScFourier(), ScFrequency(), ScFTest(), ScFV(), ScGamma(), ScGammaDist(), ScGammaInv(), ScGauss(), ScGCD(), ScGeoMean(), ScGetActDate(), ScGetActTime(), ScGetDate(), ScGetDateDif(), ScGetDateValue(), ScGetDay(), ScGetDayOfWeek(), ScGetDiffDate(), ScGetDiffDate360(), ScGetHour(), ScGetIsoWeekOfYear(), ScGetMin(), ScGetMonth(), ScGetPivotData(), ScGetSec(), ScGetTime(), ScGetTimeValue(), ScGetWeekOfYear(), ScGetYear(), ScGreater(), ScGreaterEqual(), ScGrowth(), ScHarMean(), ScHLookup(), ScHyperLink(), ScHypGeomDist(), ScIfError(), ScIfJump(), ScIfs_MS(), ScIndex(), ScIndirect(), ScInfo(), ScInt(), ScIntercept(), ScIntersect(), ScIpmt(), ScIRR(), ScIsEmpty(), ScIsErr(), ScIsError(), ScIsEven(), ScIsFormula(), ScIsLogical(), ScIsNonString(), ScIsNV(), ScIsOdd(), ScISPMT(), ScIsRef(), ScIsString(), ScIsValue(), ScJis(), ScKurt(), ScLarge(), ScLCM(), ScLeft(), ScLeftB(), ScLen(), ScLenB(), ScLess(), ScLessEqual(), ScLinest(), ScLn(), ScLog(), ScLog10(), ScLogest(), ScLogGamma(), ScLogNormDist(), ScLogNormInv(), ScLookup(), ScLower(), ScMacro(), ScMatch(), ScMatDet(), ScMatInv(), ScMatMult(), ScMatRef(), ScMatTrans(), ScMatValue(), ScMax(), ScMaxIfs_MS(), ScMedian(), ScMid(), ScMidB(), ScMin(), ScMinIfs_MS(), ScMIRR(), ScMissing(), ScMod(), ScModalValue(), ScModalValue_MS(), ScMul(), ScMultiArea(), ScN(), ScNeg(), ScNegBinomDist(), ScNegBinomDist_MS(), ScNetWorkdays(), ScNominal(), ScNoName(), ScNormDist(), ScNormInv(), ScNot(), ScNotEqual(), ScNper(), ScNPV(), ScNumberValue(), ScOdd(), ScOffset(), ScOr(), ScPDuration(), ScPearson(), ScPercentile(), ScPercentrank(), ScPercentSign(), ScPermut(), ScPermutationA(), ScPhi(), ScPi(), ScPlusMinus(), ScPMT(), ScPoissonDist(), ScPow(), ScPower(), ScPpmt(), ScProbability(), ScProduct(), ScProper(), ScPV(), ScQuartile(), ScRad(), ScRandbetween(), ScRandom(), ScRangeFunc(), ScRank(), ScRate(), ScRawSubtract(), ScRegex(), ScReplace(), ScReplaceB(), ScRept(), ScRight(), ScRightB(), ScRoman(), ScRound(), ScRoundDown(), ScRoundSignificant(), ScRoundUp(), ScRow(), ScRows(), ScRRI(), ScRSQ(), ScSearch(), ScSearchB(), ScSecant(), ScSecantHyp(), ScSheet(), ScSheets(), ScSin(), ScSinHyp(), ScSkew(), ScSkewp(), ScSLN(), ScSlope(), ScSmall(), ScSNormInv(), ScSqrt(), ScStandard(), ScStDev(), ScStDevP(), ScStdNormDist(), ScStdNormDist_MS(), ScSTEYX(), ScStyle(), ScSub(), ScSubstitute(), ScSubTotal(), ScSum(), ScSumIf(), ScSumIfs(), ScSumProduct(), ScSumSQ(), ScSumX2DY2(), ScSumX2MY2(), ScSumXMY2(), ScSwitch_MS(), ScSYD(), ScT(), ScTableOp(), ScTan(), ScTanHyp(), ScTDist(), ScTDist_MS(), ScTDist_T(), ScText(), ScTextJoin_MS(), ScTInv(), ScTrend(), ScTrim(), ScTrimMean(), ScTrue(), ScTTest(), ScTTT(), ScType(), ScUnichar(), ScUnicode(), ScUnionFunc(), ScUpper(), ScValue(), ScVar(), ScVarP(), ScVDB(), ScVLookup(), ScWebservice(), ScWeeknumOOo(), ScWeibull(), ScWorkday_MS(), ScXor(), ScZTest(), SetError(), sp, svDouble, svDoubleRef, svEmptyCell, svError, svExternalDoubleRef, svExternalSingleRef, svJumpMatrix, svMatrix, svRefList, svSingleRef, svString, t, ScAddress::Tab(), TAB_3D, VALID, VOLATILE, and xResult.
Referenced by ScSimpleFormulaCalculator::Calculate(), ScFormulaCell::InterpretInvariantFormulaGroup(), and ScFormulaCell::InterpretTail().
|
private |
Definition at line 3082 of file interpr1.cxx.
References CELLTYPE_FORMULA, CELLTYPE_VALUE, GetCellErrCode(), GetCellValue(), ScRefCellValue::getFormula(), GetMatrix(), ScJumpMatrix::GetPos(), GetStackType(), ScRefCellValue::getType(), ScFormulaCell::IsValue(), mrDoc, nFuncFmtType, nGlobalError, pJumpMatrix, PopDouble(), PopDoubleRefOrSingleRef(), PopExternalSingleRef(), SetError(), svDouble, svDoubleRef, svExternalDoubleRef, svExternalSingleRef, svMatrix, and svSingleRef.
Referenced by ScIsEven(), and ScIsOdd().
|
inlineprivate |
Definition at line 1024 of file interpre.hxx.
References bMatrixFormula, formula::FormulaToken::IsInForceArray(), and pCur.
Referenced by ConvertMatrixParameters(), GetRefListArrayMaxSize(), MatrixJumpConditionToMatrix(), MatrixParameterConversion(), ScFilterXML(), ScFormula(), and ScIsFormula().
|
private |
Definition at line 1958 of file interpr4.cxx.
References formula::FormulaToken::GetType(), pStack, sp, and svMissing.
Referenced by CalculateRGPRKP(), CalculateTrendGrowth(), GetDoubleWithDefault(), GetInt32WithDefault(), GetWeekendAndHolidayMasks_MS(), ScCeil(), ScExternal(), ScFDist_LT(), ScFloor(), ScFourier(), ScGetDate(), ScIndex(), ScOffset(), and ScRegex().
|
private |
Definition at line 2033 of file interpr1.cxx.
References CELLTYPE_EDIT, CELLTYPE_FORMULA, CELLTYPE_STRING, GetCellErrCode(), ScRefCellValue::getFormula(), GetMatrix(), ScJumpMatrix::GetPos(), GetRawStackType(), ScRefCellValue::getType(), ScFormulaCell::IsEmpty(), ScFormulaCell::IsValue(), mrDoc, nFuncFmtType, nGlobalError, pJumpMatrix, Pop(), PopDoubleRefOrSingleRef(), PopExternalSingleRef(), svDoubleRef, svExternalDoubleRef, svExternalSingleRef, svMatrix, svSingleRef, and svString.
Referenced by ScIsNonString(), and ScIsString().
|
private |
Definition at line 107 of file interpr4.cxx.
References ScRange::aEnd, ScInterpreterTableOpParams::aOld1, ScInterpreterTableOpParams::aOld2, ScRange::aStart, ScRange::Contains(), i, ScDocument::m_TableOpList, and mrDoc.
Referenced by DoubleRefToRange(), and DoubleRefToVars().
|
private |
Definition at line 460 of file interpr6.cxx.
References aStr, bCalcAsShown, CELLTYPE_NONE, ConvertStringToValue(), CurFmtToFuncFmt(), eType, sc::RangeColumnSpanSet::executeColumnAction(), ScCellIterator::first(), KahanSum::get(), GetByte(), GetCellValue(), ScValueIterator::GetCurNumFmtInfo(), GetDouble(), ScValueIterator::GetFirst(), GetNewMat(), ScValueIterator::GetNext(), ScInterpreterContext::GetNumberFormatType(), GetRefListArrayMaxSize(), GetStackType(), svl::SharedString::getString(), ScRefCellValue::getType(), ScRefCellValue::hasNumeric(), ScRefCellValue::hasString(), i, ifAVERAGE, ifCOUNT, ifCOUNT2, ifPRODUCT, ifSUM, ifSUMSQ, IgnoreErrVal, IgnoreFiltered, IgnoreHidden, IgnoreNestedStAg, ScRefCellValue::isEmpty(), ScCellIterator::isEmpty(), IterateMatrix(), lcl_IterResult(), ScExternalRefCache::CellFormat::mbIsSet, ScExternalRefCache::CellFormat::mnIndex, mnSubTotalFlags, ScExternalRefCache::CellFormat::mnType, mrContext, mrDoc, nCount, ScCellIterator::next(), nFuncFmtIndex, nFuncFmtType, nGlobalError, NONE, ocAggregate, ocSubTotal, p, Pop(), PopDoubleRef(), PopError(), PopExternalDoubleRef(), PopExternalSingleRef(), PopMatrix(), PopSingleRef(), PopString(), pStack, PushDouble(), PushError(), PushMatrix(), ScAddress::Row(), ScDocument::RowFiltered(), ScDocument::RowHidden(), SetError(), sp, svDouble, svDoubleRef, svEmptyCell, svError, svExternalDoubleRef, svExternalSingleRef, svMatrix, svRefList, svSingleRef, svString, and ScAddress::Tab().
Referenced by ScAverage(), ScCount(), ScCount2(), ScProduct(), ScSum(), and ScSumSQ().
|
private |
Definition at line 5287 of file interpr1.cxx.
References ScQueryEntry::bDoQuery, ScQueryEntry::ByString, ScQueryEntry::ByValue, CELLTYPE_EDIT, CELLTYPE_FORMULA, CELLTYPE_STRING, CELLTYPE_VALUE, DetectSearchType(), div(), ScQueryEntry::eOp, ScQueryParamBase::eSearchType, ScQueryParamBase::FillInExcelSyntax(), KahanSum::get(), GetByte(), GetCellString(), GetCellValue(), ScQueryCellIterator< accessType >::GetCol(), GetDouble(), GetDoubleOrStringFromMatrix(), ScQueryParamBase::GetEntry(), ScQueryCellIterator< accessType >::GetFirst(), ScRefCellValue::getFormula(), GetMatrix(), GetNewMat(), ScQueryCellIterator< accessType >::GetNext(), ScQueryEntry::GetQueryItem(), GetRefListArrayMaxSize(), ScQueryCellIterator< accessType >::GetRow(), ScDocument::GetSharedStringPool(), GetStackType(), GetString(), svl::SharedString::getString(), ScRefCellValue::getType(), ScRange::GetVars(), ScRefCellValue::hasNumeric(), ifAVERAGEIF, ifSUMIF, ScMatrix::IsRealStringType(), ScFormulaCell::IsValue(), ScQueryEntry::Item::maString, ScDocument::MaxCol(), ScDocument::MaxRow(), ScQueryEntry::Item::meType, ScQueryEntry::Item::mfVal, mrContext, mrDoc, MustHaveParamCount(), ScQueryParamTable::nCol1, ScQueryParamTable::nCol2, ScQueryEntry::nField, nGlobalError, ScQueryParamTable::nRow1, ScQueryParamTable::nRow2, nType, pFormatter, PopDoubleRef(), PopDoubleRefOrSingleRef(), PopExternalDoubleRef(), PopExternalSingleRef(), PopMatrix(), PopSingleRef(), PushDouble(), PushError(), PushMatrix(), QueryMat(), SC_EQUAL, ScQueryCellIteratorBase< accessType, queryType >::SetAdvanceQueryParamEntryField(), ScAddress::SetCol(), SetError(), ScAddress::SetRow(), ScAddress::SetTab(), svDouble, svDoubleRef, svExternalDoubleRef, svExternalSingleRef, svMatrix, svRefList, svSingleRef, and svString.
Referenced by ScAverageIf(), and ScSumIf().
|
private |
Definition at line 5911 of file interpr1.cxx.
References ScRange::aEnd, ScRange::aStart, ScQueryEntry::bDoQuery, ScQueryEntry::ByString, ScQueryEntry::ByValue, ScQueryCellIteratorSortedCache::CanBeUsed(), CELLTYPE_EDIT, CELLTYPE_FORMULA, CELLTYPE_STRING, CELLTYPE_VALUE, col, ScAddress::Col(), DetectSearchType(), DoubleRefToRange(), end, ScQueryEntry::eOp, ScQueryParamBase::eSearchType, ScQueryParamBase::FillInExcelSyntax(), GetByte(), GetCellString(), GetCellValue(), ScQueryCellIterator< accessType >::GetCol(), ScDocument::GetDataAreaSubrange(), GetDouble(), GetDoubleErrorValue(), GetDoubleOrStringFromMatrix(), formula::FormulaToken::GetDoubleRef(), ScQueryParamBase::GetEntry(), ScQueryCellIterator< accessType >::GetFirst(), ScRefCellValue::getFormula(), GetMatrix(), GetNewMat(), ScQueryCellIterator< accessType >::GetNext(), ScQueryEntry::GetQueryItem(), ScQueryEntry::GetQueryItems(), GetRefListArrayMaxSize(), ScQueryCellIterator< accessType >::GetRow(), ScDocument::GetSharedStringPool(), GetStackDoubleRef(), GetStackType(), GetString(), svl::SharedString::getString(), formula::FormulaToken::GetType(), ScRefCellValue::getType(), ScRange::GetVars(), ScRefCellValue::hasNumeric(), i, ScComplexRefData::IsDeleted(), ScQueryEntry::IsQueryByEmpty(), ScMatrix::IsRealStringType(), ScFormulaCell::IsValue(), ScInterpreterContext::maConditions, o3tl::make_unsigned(), ScQueryEntry::Item::maString, ScQueryEntry::Item::mbMatchEmpty, ScQueryEntry::Item::meType, sc::ParamIfsResult::mfCount, sc::ParamIfsResult::mfMax, sc::ParamIfsResult::mfMin, sc::ParamIfsResult::mfSum, ScQueryEntry::Item::mfVal, mrContext, mrDoc, n, ScQueryParamTable::nCol1, ScQueryParamTable::nCol2, ScQueryEntry::nField, nGlobalError, nIndex, ScQueryParamTable::nRow1, ScQueryParamTable::nRow2, nType, p, pFormatter, pMyFormulaCell, PopDoubleRef(), PopDoubleRefOrSingleRef(), PopError(), PopExternalSingleRef(), PopSingleRef(), pos, pStack, PushDouble(), PushError(), PushMatrix(), QueryMat(), ScAddress::Row(), SAL_WARN_IF, SC_EQUAL, ScQueryCellIteratorBase< accessType, queryType >::SetAdvanceQueryParamEntryField(), ScAddress::SetCol(), ScAddress::SetRow(), ScAddress::SetTab(), sp, svDouble, svDoubleRef, svExternalDoubleRef, svExternalSingleRef, svMatrix, svRefList, svSingleRef, svString, and ScAddress::Tab().
Referenced by ScAverageIfs(), ScCountIfs(), ScMaxIfs_MS(), ScMinIfs_MS(), and ScSumIfs().
|
private |
Definition at line 545 of file interpr1.cxx.
References aCode, ScRange::aEnd, ScRange::aStart, aStr, ScAddress::Col(), CreateDoubleError(), GetCellString(), GetCellValue(), GetDouble(), GetDoubleErrorValue(), formula::FormulaToken::GetInForceArray(), ScJumpMatrix::GetJump(), formula::FormulaToken::GetJumpMatrix(), ScJumpMatrix::GetJumpParameters(), GetMatrix(), ScJumpMatrix::GetOpCode(), ScParameterClassification::GetParameterType(), ScJumpMatrix::GetPos(), ScJumpMatrix::GetRefList(), ScJumpMatrix::GetResultMatrix(), GetStackType(), GetString(), ScRefCellValue::hasEmptyValue(), ScRefCellValue::hasNumeric(), ScJumpMatrix::HasResultMatrix(), formula::FormulaTokenIterator::HasStacked(), i, formula::FormulaTokenIterator::Jump(), lcl_AdjustJumpMatrix(), lcl_storeJumpMatResult(), o3tl::make_unsigned(), maTokenMatrixMap, mrDoc, ScJumpMatrix::Next(), nGlobalError, pCur, formula::FormulaTokenIterator::PeekNextOperator(), pJumpMatrix, formula::FormulaTokenIterator::Pop(), Pop(), PopDoubleRef(), PopError(), PopExternalSingleRef(), PopSingleRef(), pStack, PushMatrix(), PushTokenRef(), PushWithoutError(), ScJumpMatrix::PutResultDouble(), ScJumpMatrix::PutResultEmpty(), ScJumpMatrix::PutResultEmptyPath(), ScJumpMatrix::PutResultString(), ScComplexRefData::Ref1, ScComplexRefData::Ref2, ScAddress::Row(), SAL_MAX_UINT16, ScAddress::SetCol(), SetError(), ScAddress::SetRow(), sp, svDouble, svDoubleRef, svEmptyCell, svError, svExternalDoubleRef, svExternalSingleRef, svMatrix, svSingleRef, and svString.
Referenced by Interpret().
|
private |
Definition at line 10271 of file interpr1.cxx.
References aPos, ScLookupCache::CRITERIA_DIFFERENT, ScLookupCache::FOUND, ScQueryParamBase::GetEntry(), ScDocument::GetLookupCache(), GetVolatileType(), ScLookupCache::insert(), ScLookupCache::QueryCriteria::isEmptyStringQuery(), lcl_getPrevRowWithEmptyValueLookup(), lcl_LookupQuery(), ScLookupCache::lookup(), mrContext, mrDoc, ScQueryParamTable::nCol1, ScQueryParamTable::nCol2, ScQueryEntry::nField, ScLookupCache::NOT_AVAILABLE, ScLookupCache::NOT_CACHED, NOT_VOLATILE, ScQueryParamTable::nRow1, ScQueryParamTable::nRow2, ScQueryParamTable::nTab, pMyFormulaCell, and ScAddress::SetRow().
Referenced by CalculateLookup(), and ScMatch().
|
private |
|
private |
Definition at line 1168 of file interpr5.cxx.
References GetNewMat(), ScDocument::GetSharedStringPool(), lcl_GetMinExtent(), mrDoc, and pFormatter.
Referenced by ScAmpersand().
|
inlineprivate |
Definition at line 1029 of file interpre.hxx.
References ConvertMatrixJumpConditionToMatrix(), and IsInArrayContext().
Referenced by ScChooseJump(), ScIfError(), and ScIfJump().
|
inlineprivate |
Definition at line 1035 of file interpre.hxx.
References ConvertMatrixParameters(), formula::FormulaToken::GetOpCode(), ScParameterClassification::HasForceArray(), IsInArrayContext(), pCur, pJumpMatrix, and sp.
Referenced by Interpret().
|
staticprivate |
|
private |
Merge global and document specific settings.
Definition at line 3907 of file interpr4.cxx.
References ScDocument::GetCalcConfig(), GetOrCreateGlobalConfig(), maCalcConfig, ScCalcConfig::MergeDocumentSpecific(), and mrDoc.
Referenced by ScInterpreter().
|
inlineprivate |
Definition at line 1048 of file interpre.hxx.
References PushIllegalParameter(), and PushParameterExpected().
Referenced by CalculateLookup(), CalculatePearsonCovar(), CalculateRGPRKP(), CalculateSlopeIntercept(), CalculateSmallLarge(), CalculateSumX2MY2SumX2DY2(), CalculateTrendGrowth(), IterateParametersIf(), RoundNumber(), ScAddressFunc(), ScArcTan2(), ScAreas(), ScAsc(), ScB(), ScBahtText(), ScBase(), ScBetaDist(), ScBetaDist_MS(), ScBetaInv(), ScBinomDist(), ScBitAnd(), ScBitLshift(), ScBitOr(), ScBitRshift(), ScBitXor(), ScCeil(), ScCeil_MS(), ScCeil_Precise(), ScCell(), ScChiDist(), ScChiInv(), ScChiSqDist(), ScChiSqDist_MS(), ScChiSqInv(), ScChiTest(), ScColor(), ScColumn(), ScCombin(), ScCombinA(), ScConfidence(), ScConfidenceT(), ScConvertOOo(), ScCountEmptyCells(), ScCountIf(), ScCritBinom(), ScCumIpmt(), ScCumPrinc(), ScCurrency(), ScDB(), ScDDB(), ScDde(), ScDebugVar(), ScDecimal(), ScEasterSunday(), ScEffect(), ScEMat(), ScEncodeURL(), ScErf(), ScErfc(), ScEuroConvert(), ScExact(), ScExpDist(), ScFDist(), ScFDist_LT(), ScFilterXML(), ScFind(), ScFindB(), ScFInv(), ScFInv_LT(), ScFixed(), ScFloor(), ScFloor_MS(), ScFloor_Precise(), ScForecast(), ScForecast_Ets(), ScFourier(), ScFrequency(), ScFTest(), ScFV(), ScGammaDist(), ScGammaInv(), ScGetDate(), ScGetDateDif(), ScGetDayOfWeek(), ScGetDiffDate(), ScGetDiffDate360(), ScGetIsoWeekOfYear(), ScGetTime(), ScGetWeekOfYear(), ScHyperLink(), ScHypGeomDist(), ScIndex(), ScIndirect(), ScInfo(), ScIpmt(), ScIRR(), ScISPMT(), ScJis(), ScLeft(), ScLeftB(), ScLog(), ScLogNormDist(), ScLogNormInv(), ScLookup(), ScMatch(), ScMatDet(), ScMatInv(), ScMatMult(), ScMatTrans(), ScMatValue(), ScMid(), ScMidB(), ScMIRR(), ScMod(), ScNegBinomDist(), ScNegBinomDist_MS(), ScNetWorkdays(), ScNominal(), ScNormDist(), ScNormInv(), ScNper(), ScNumberValue(), ScOffset(), ScPDuration(), ScPercentile(), ScPercentrank(), ScPermut(), ScPermutationA(), ScPMT(), ScPoissonDist(), ScPower(), ScPpmt(), ScProbability(), ScPV(), ScQuartile(), ScRandbetween(), ScRank(), ScRate(), ScRegex(), ScReplace(), ScReplaceB(), ScRept(), ScRight(), ScRightB(), ScRoman(), ScRoundSignificant(), ScRow(), ScRRI(), ScSearch(), ScSearchB(), ScSheet(), ScSLN(), ScStandard(), ScStdNormDist_MS(), ScStyle(), ScSubstitute(), ScSumXMY2(), ScSYD(), ScTDist(), ScTDist_MS(), ScTDist_T(), ScText(), ScTInv(), ScTrimMean(), ScTTest(), ScUnichar(), ScUnicode(), ScVDB(), ScWebservice(), ScWeeknumOOo(), ScWeibull(), ScWorkday_MS(), and ScZTest().
|
inlineprivate |
Definition at line 1059 of file interpre.hxx.
References PushIllegalParameter(), and PushParameterExpected().
|
inlineprivate |
Definition at line 1070 of file interpre.hxx.
References PushParameterExpected().
Referenced by CalculateSkew(), MustHaveParamCountMinWithStackCheck(), ScAnd(), ScAveDev(), ScGCD(), ScGetPivotData(), ScLCM(), ScMax(), ScMedian(), ScMin(), ScModalValue(), ScModalValue_MS(), ScMultiArea(), ScNPV(), ScOr(), ScRawSubtract(), ScSumProduct(), ScSwitch_MS(), ScTextJoin_MS(), and ScXor().
|
inlineprivate |
Definition at line 1078 of file interpre.hxx.
References MustHaveParamCountMin(), PushError(), and sp.
Referenced by ScAggregate(), and ScSubTotal().
|
static |
Definition at line 195 of file interpr3.cxx.
References x.
Referenced by gauss(), ScLogNormDist(), ScNormDist(), and ScPhi().
|
private |
Definition at line 744 of file interpr4.cxx.
References SetError(), and sp.
Referenced by CalculateRGPRKP(), CalculateTrendGrowth(), Compare(), CompareMat(), GetDouble(), GetDoubleOrString(), GetString(), GetStVarParams(), GetWeekendAndHolidayMasks_MS(), Interpret(), IsString(), IterateParameters(), JumpMatrix(), ScAggregate(), ScAnd(), ScExternal(), ScFDist_LT(), ScFourier(), ScHyperLink(), ScIfError(), ScIfs_MS(), ScIsEmpty(), ScIsFormula(), ScIsRef(), ScIsValue(), ScMax(), ScMin(), ScOr(), ScSubTotal(), ScSwitch_MS(), ScTTT(), ScValue(), and ScXor().
|
private |
Definition at line 962 of file interpr4.cxx.
References eType, GetStackType(), mrDoc, nGlobalError, PopDoubleRef(), PopError(), PopExternalDoubleRef(), PopMatrix(), SetError(), svDoubleRef, svError, svExternalDoubleRef, svMatrix, and svUnknown.
Referenced by GetDBParams().
|
private |
Definition at line 781 of file interpr4.cxx.
References nCurFmtIndex, nCurFmtType, nGlobalError, nType, p, pStack, SetError(), sp, svDouble, svEmptyCell, svError, and svMissing.
Referenced by GetDouble(), GetDoubleOrString(), GetNumberSequenceArray(), GetRankNumberArray(), GetString(), Interpret(), IsEven(), ScAnd(), ScOr(), ScRSQ(), ScText(), and ScXor().
|
private |
Definition at line 1003 of file interpr4.cxx.
References DoubleRefToVars(), nGlobalError, p, pStack, SetError(), sp, svDoubleRef, and svError.
|
private |
Definition at line 1096 of file interpr4.cxx.
References DoubleRefToRange(), nGlobalError, p, pStack, SetError(), sp, svDoubleRef, and svError.
|
private |
If formula::StackVar formula::svDoubleRef pop ScDoubleRefToken and return values of ScComplexRefData.
Else if StackVar svRefList return values of the ScComplexRefData where rRefInList is pointing to. rRefInList is incremented. If rRefInList was the last element in list pop ScRefListToken and set rRefInList to 0, else rParam is incremented (!) to allow usage as in while(nParamCount–) PopDoubleRef(aRange,nParamCount,nRefInList);
Definition at line 1044 of file interpr4.cxx.
References DoubleRefToRange(), formula::FormulaToken::GetDoubleRef(), formula::FormulaToken::GetError(), formula::FormulaToken::GetRefList(), formula::FormulaToken::GetType(), ScComplexRefData::IsDeleted(), nGlobalError, pStack, SetError(), size, sp, svDoubleRef, svError, and svRefList.
Referenced by CalculateLookup(), CalculateSkew(), GetDBParams(), GetDouble(), GetErrorType(), GetMatrix(), GetNumberSequenceArray(), GetRankNumberArray(), GetString(), GetStVarParams(), Interpret(), IterateParameters(), IterateParametersIf(), IterateParametersIfs(), JumpMatrix(), PopDBDoubleRef(), PopDoubleRefOrSingleRef(), ScAnd(), ScAveDev(), ScCell(), ScColumn(), ScColumns(), ScConcat_MS(), ScCountEmptyCells(), ScCountIf(), ScExternal(), ScFormula(), ScGCD(), ScGeoMean(), ScGetPivotData(), ScHarMean(), ScIndex(), ScIRR(), ScIsFormula(), ScIsRef(), ScLCM(), ScLookup(), ScMacro(), ScMatch(), ScMatValue(), ScMax(), ScMin(), ScMIRR(), ScNPV(), ScOffset(), ScOr(), ScRow(), ScRows(), ScSheet(), ScSheets(), ScTextJoin_MS(), ScXor(), and ScZTest().
|
private |
Definition at line 1342 of file interpr4.cxx.
References DoubleRefToPosSingleRef(), GetStackType(), PopDoubleRef(), PopError(), PopSingleRef(), SetError(), svDoubleRef, and svSingleRef.
Referenced by Compare(), FillEntry(), GetDoubleOrString(), IsEven(), IsString(), IterateParametersIf(), IterateParametersIfs(), ScCountIf(), ScExternal(), ScFormula(), ScHyperLink(), ScIfError(), ScIsEmpty(), ScIsErr(), ScIsError(), ScIsFormula(), ScIsLogical(), ScIsNV(), ScIsValue(), ScMatch(), ScSwitch_MS(), ScT(), ScType(), and ScValue().
|
private |
Definition at line 1364 of file interpr4.cxx.
References GetMatrix(), GetStackType(), PushIllegalParameter(), PushMatrix(), SetError(), and svDoubleRef.
Referenced by Interpret().
|
private |
Definition at line 754 of file interpr4.cxx.
References formula::FormulaToken::GetError(), nGlobalError, pStack, SetError(), sp, and svError.
Referenced by Compare(), CompareMat(), GetDBParams(), GetDouble(), GetDoubleOrString(), GetDoubleOrStringFromMatrix(), GetErrorType(), GetMatrix(), GetNumberSequenceArray(), GetRankNumberArray(), GetString(), GetStVarParams(), Interpret(), IterateParameters(), IterateParametersIfs(), JumpMatrix(), PopDBDoubleRef(), PopDoubleRefOrSingleRef(), ScAnd(), ScBadName(), ScCell(), ScColumns(), ScConcat_MS(), ScCountIf(), ScExternal(), ScFormula(), ScGeoMean(), ScHyperLink(), ScIfError(), ScIndex(), ScIsErr(), ScIsError(), ScIsLogical(), ScIsNV(), ScMatValue(), ScMax(), ScMin(), ScOffset(), ScOr(), ScRawSubtract(), ScRegex(), ScRows(), ScRSQ(), ScSheets(), ScSwitch_MS(), ScT(), ScText(), ScTextJoin_MS(), ScType(), and ScXor().
|
private |
Definition at line 1220 of file interpr4.cxx.
References eType, nGlobalError, p, pStack, SetError(), sp, svError, and svExternalDoubleRef.
Referenced by GetDouble(), GetMatrix(), GetString(), Interpret(), IterateParameters(), IterateParametersIf(), PopDBDoubleRef(), PopExternalDoubleRef(), ScColumn(), ScColumns(), ScIsRef(), ScMatch(), ScOffset(), ScRow(), ScRows(), and ScSheets().
|
private |
Definition at line 1249 of file interpr4.cxx.
References aData, GetExternalDoubleRef(), nGlobalError, and PopExternalDoubleRef().
|
private |
Definition at line 1263 of file interpr4.cxx.
References nGlobalError, p, PopExternalDoubleRef(), SetError(), and svMatrix.
|
private |
Definition at line 1141 of file interpr4.cxx.
References eType, nGlobalError, p, pStack, SetError(), sp, svError, and svExternalSingleRef.
Referenced by GetDouble(), GetMatrix(), GetString(), Interpret(), IsEven(), IsString(), IterateParameters(), IterateParametersIf(), IterateParametersIfs(), JumpMatrix(), PopExternalSingleRef(), ScCellExternal(), ScColumn(), ScIsErr(), ScIsError(), ScIsNV(), ScIsRef(), ScIsValue(), ScMacro(), ScMatch(), ScOffset(), and ScRow().
|
private |
Guarantees that nGlobalError is set if rToken could not be obtained.
Definition at line 1178 of file interpr4.cxx.
References aPos, ScExternalRefManager::getExternalFileName(), ScDocument::GetExternalRefManager(), ScExternalRefManager::getSingleRefToken(), ScSingleRefData::IsTabRel(), mrDoc, nGlobalError, PopExternalSingleRef(), SetError(), svError, and ScSingleRefData::toAbs().
|
private |
Guarantees that nGlobalError is set if rToken could not be obtained.
Definition at line 1170 of file interpr4.cxx.
References aData, and PopExternalSingleRef().
|
private |
Definition at line 1642 of file interpr4.cxx.
References GetMatrix(), nGlobalError, p, pStack, SetError(), ScMatrix::SetErrorInterpreter(), sp, svError, and svMatrix.
Referenced by GetDouble(), GetMatrix(), GetString(), Interpret(), IterateParameters(), IterateParametersIf(), PopDBDoubleRef(), PopRangeMatrix(), ScChooseJump(), ScColumns(), ScExternal(), ScIfError(), ScIfJump(), ScMatch(), ScMatValue(), ScRows(), and ScType().
|
private |
Definition at line 1674 of file interpr4.cxx.
References ScSingleRefData::Col(), GetMatrix(), ScSingleRefData::IsColRel(), ScSingleRefData::IsRowRel(), MATRIX_TOKEN_HAS_RANGE, sc::RangeMatrix::mnCol1, sc::RangeMatrix::mnCol2, sc::RangeMatrix::mnRow1, sc::RangeMatrix::mnRow2, sc::RangeMatrix::mnTab1, sc::RangeMatrix::mnTab2, sc::RangeMatrix::mpMat, p, PopMatrix(), pStack, ScComplexRefData::Ref1, ScComplexRefData::Ref2, ScSingleRefData::Row(), SetError(), sp, svMatrix, and ScSingleRefData::Tab().
Referenced by GetRangeMatrix(), and Interpret().
|
private |
Definition at line 1378 of file interpr4.cxx.
References bMatrixFormula, ScFormulaCell::GetErrCode(), ScRefCellValue::getFormula(), GetNewMat(), formula::FormulaToken::GetRefList(), ScDocument::GetSheetLimits(), GetStackType(), ScRefCellValue::getString(), ScRefCellValue::getValue(), ScRefCellValue::hasEmptyValue(), ScRefCellValue::hasError(), ScRefCellValue::hasString(), i, svl::SharedStringPool::intern(), mrDoc, mrStrPool, nGlobalError, pStack, PushMatrix(), PushTempTokenWithoutError(), Ref1, SetError(), SingleRefToVars(), sp, and svRefList.
Referenced by Interpret().
|
private |
Definition at line 907 of file interpr4.cxx.
References ScSingleRefData::IsDeleted(), ScDocument::m_TableOpList, mrDoc, nGlobalError, p, pStack, ReplaceCell(), ScAddress::Set(), SetError(), SingleRefToVars(), sp, svError, and svSingleRef.
Referenced by CalculateLookup(), CalculateSkew(), CompareMat(), GetDBParams(), GetDouble(), GetErrorType(), GetMatrix(), GetNumberSequenceArray(), GetRankNumberArray(), GetString(), GetStVarParams(), Interpret(), IterateParameters(), IterateParametersIf(), IterateParametersIfs(), JumpMatrix(), PopDoubleRefOrSingleRef(), PopSingleRef(), ScAnd(), ScAveDev(), ScCell(), ScColumn(), ScConcat_MS(), ScCountEmptyCells(), ScCountIf(), ScExternal(), ScGeoMean(), ScGetPivotData(), ScHarMean(), ScIndex(), ScIsRef(), ScLookup(), ScMacro(), ScMatch(), ScMatRef(), ScMatValue(), ScMax(), ScMin(), ScNPV(), ScOffset(), ScOr(), ScRow(), ScSheet(), ScTableOp(), ScTextJoin_MS(), ScXor(), and ScZTest().
Definition at line 898 of file interpr4.cxx.
References ScAddress::Col(), PopSingleRef(), ScAddress::Row(), and ScAddress::Tab().
|
private |
Definition at line 813 of file interpr4.cxx.
References svl::SharedString::getEmptyString(), nCurFmtIndex, nCurFmtType, nGlobalError, p, pStack, SetError(), sp, svEmptyCell, svError, svMissing, and svString.
Referenced by GetDouble(), GetDoubleOrString(), GetString(), IterateParameters(), and ScSheet().
|
private |
Definition at line 766 of file interpr4.cxx.
References nGlobalError, p, pStack, SetError(), sp, and svError.
Referenced by GetErrorType(), Interpret(), ScAggregate(), ScAreas(), ScCurrent(), ScIfs_MS(), ScIndex(), ScIntersect(), ScIsEmpty(), ScIsRef(), ScRangeFunc(), ScSubTotal(), ScSwitch_MS(), ScText(), and ScUnionFunc().
|
private |
Does substitute with formula::FormulaErrorToken in case nGlobalError is set and the token passed is not formula::FormulaErrorToken.
Increments RefCount of the original token if not substituted.
Definition at line 600 of file interpr4.cxx.
References formula::FormulaToken::GetType(), MAXSTACK, nGlobalError, PushTempTokenWithoutError(), PushWithoutError(), SetError(), sp, and svError.
Referenced by ScMatRef().
|
private |
Obtain cell result / content from address and push as temp token.
bDisplayEmptyAsString | is passed to ScEmptyCell in case of an empty cell result. |
pRetTypeExpr | |
pRetIndexExpr | Obtain number format and type if both, type and index pointer, are not NULL. |
bFinalResult | If TRUE, only a standard FormulaDoubleToken is pushed. If FALSE, PushDouble() is used that may push either a FormulaDoubleToken or a FormulaTypedDoubleToken. |
Definition at line 687 of file interpr4.cxx.
References CELLTYPE_FORMULA, CreateFormulaDoubleToken(), GetCellString(), GetCellValue(), ScFormulaCell::GetErrCode(), ScRefCellValue::getFormula(), ScDocument::GetNumberFormatInfo(), ScRefCellValue::getType(), ScRefCellValue::hasEmptyValue(), ScRefCellValue::hasString(), IfErrorPushError(), mrContext, mrDoc, nCurFmtIndex, nCurFmtType, PushDouble(), PushError(), PushString(), PushTempToken(), PushTempTokenWithoutError(), and TreatDoubleError().
Referenced by CalculateLookup(), Interpret(), and ScLookup().
|
private |
Definition at line 1801 of file interpr4.cxx.
References CreateDoubleOrTypedToken(), IfErrorPushError(), PushTempTokenWithoutError(), and TreatDoubleError().
Referenced by CalculateAddSub(), CalculateLookup(), CalculateMatrixValue(), CalculatePearsonCovar(), CalculateSkewOrSkewp(), CalculateSlopeIntercept(), CalculateSmallLarge(), CalculateSumX2MY2SumX2DY2(), DBIterator(), GetStVarParams(), IterateParameters(), IterateParametersIf(), IterateParametersIfs(), PushCellResultToken(), QueryMat(), RoundNumber(), ScAbs(), ScArcCos(), ScArcCosHyp(), ScArcCot(), ScArcCotHyp(), ScArcSin(), ScArcSinHyp(), ScArcTan(), ScArcTan2(), ScArcTanHyp(), ScAreas(), ScAveDev(), ScB(), ScBetaDist(), ScBetaDist_MS(), ScBetaInv(), ScBinomDist(), ScBitAnd(), ScBitLshift(), ScBitOr(), ScBitRshift(), ScBitXor(), ScCeil(), ScCeil_MS(), ScCeil_Precise(), ScCell(), ScChiDist(), ScChiInv(), ScChiSqDist(), ScChiSqDist_MS(), ScChiSqInv(), ScChiTest(), ScColor(), ScColumn(), ScColumns(), ScCombin(), ScCombinA(), ScConfidence(), ScConfidenceT(), ScConvertOOo(), ScCos(), ScCosecant(), ScCosecantHyp(), ScCosHyp(), ScCot(), ScCotHyp(), ScCountEmptyCells(), ScCountIf(), ScCritBinom(), ScCumIpmt(), ScCumPrinc(), ScDB(), ScDBCount(), ScDBCount2(), ScDBGet(), ScDBStdDev(), ScDBStdDevP(), ScDBVar(), ScDBVarP(), ScDDB(), ScDebugVar(), ScDecimal(), ScDeg(), ScDiv(), ScEasterSunday(), ScEffect(), ScErf(), ScErfc(), ScErrorType(), ScErrorType_ODF(), ScEuroConvert(), ScEven(), ScExp(), ScExpDist(), ScExternal(), ScFact(), ScFDist(), ScFDist_LT(), ScFilterXML(), ScFind(), ScFindB(), ScFInv(), ScFInv_LT(), ScFisher(), ScFisherInv(), ScFloor(), ScFloor_MS(), ScFloor_Precise(), ScForecast(), ScForecast_Ets(), ScFTest(), ScFV(), ScGamma(), ScGammaDist(), ScGammaInv(), ScGauss(), ScGCD(), ScGeoMean(), ScGetActDate(), ScGetActTime(), ScGetDate(), ScGetDateDif(), ScGetDateValue(), ScGetDay(), ScGetDiffDate(), ScGetDiffDate360(), ScGetHour(), ScGetMin(), ScGetMonth(), ScGetPivotData(), ScGetSec(), ScGetTime(), ScGetTimeValue(), ScGetYear(), ScHarMean(), ScHypGeomDist(), ScIndex(), ScInfo(), ScInt(), ScIpmt(), ScIRR(), ScISPMT(), ScKurt(), ScLCM(), ScLen(), ScLenB(), ScLn(), ScLog(), ScLog10(), ScLogGamma(), ScLogNormDist(), ScLogNormInv(), ScLookup(), ScMacro(), ScMatch(), ScMatDet(), ScMatRef(), ScMatValue(), ScMax(), ScMedian(), ScMin(), ScMIRR(), ScMod(), ScModalValue(), ScModalValue_MS(), ScMul(), ScN(), ScNeg(), ScNegBinomDist(), ScNegBinomDist_MS(), ScNetWorkdays(), ScNominal(), ScNormDist(), ScNormInv(), ScNper(), ScNPV(), ScNumberValue(), ScOdd(), ScPDuration(), ScPercentile(), ScPercentrank(), ScPermut(), ScPermutationA(), ScPhi(), ScPi(), ScPMT(), ScPoissonDist(), ScPow(), ScPpmt(), ScProbability(), ScPV(), ScQuartile(), ScRad(), ScRandomImpl(), ScRank(), ScRate(), ScRawSubtract(), ScRoundSignificant(), ScRow(), ScRows(), ScRRI(), ScRSQ(), ScSearch(), ScSearchB(), ScSecant(), ScSecantHyp(), ScSheet(), ScSheets(), ScSin(), ScSinHyp(), ScSLN(), ScSNormInv(), ScSqrt(), ScStandard(), ScStdNormDist(), ScStdNormDist_MS(), ScStyle(), ScSumProduct(), ScSumXMY2(), ScSYD(), ScTableOp(), ScTan(), ScTanHyp(), ScTDist(), ScTDist_MS(), ScTDist_T(), ScTInv(), ScTrimMean(), ScTTest(), ScUnicode(), ScValue(), ScVDB(), ScWeibull(), ScWorkday_MS(), and ScZTest().
|
private |
Definition at line 1892 of file interpr4.cxx.
References aPos, ScDocument::GetSheetLimits(), IfErrorPushError(), ScComplexRefData::InitFromRefAddresses(), mrDoc, and PushTempTokenWithoutError().
|
private |
Definition at line 1846 of file interpr4.cxx.
References ScDocument::GetSheetLimits(), IfErrorPushError(), ScComplexRefData::InitRange(), mrDoc, and PushTempTokenWithoutError().
Referenced by ScIndex(), ScIndirect(), ScIntersect(), and ScOffset().
|
private |
Definition at line 1927 of file interpr4.cxx.
References nGlobalError, PushTempTokenWithoutError(), and SetError().
Referenced by CalculatePearsonCovar(), CalculateRGPRKP(), CalculateSkew(), CalculateSkewOrSkewp(), CalculateSlopeIntercept(), CalculateTrendGrowth(), Interpret(), IterateParameters(), IterateParametersIf(), IterateParametersIfs(), MustHaveParamCountMinWithStackCheck(), PushCellResultToken(), PushIllegalArgument(), PushIllegalParameter(), PushNA(), PushNoValue(), PushParameterExpected(), ScArabic(), ScAveDev(), ScAverageIfs(), ScBadName(), ScBahtText(), ScBase(), ScBetaInv(), ScCellExternal(), ScChiDist(), ScChiTest(), ScColRowNameAuto(), ScConfidenceT(), ScConvertOOo(), ScCountIfs(), ScCurrent(), ScDBArea(), ScDebugVar(), ScEasterSunday(), ScEMat(), ScEncodeURL(), ScEuroConvert(), ScExternal(), ScFilterXML(), ScForecast(), ScForecast_Ets(), ScGamma(), ScGeoMean(), ScGetDateDif(), ScGetDiffDate360(), ScGetPivotData(), ScHarMean(), ScIfError(), ScIfJump(), ScIfs_MS(), ScIndex(), ScIndirect(), ScIntersect(), ScIRR(), ScIsFormula(), ScISPMT(), ScKurt(), ScLookup(), ScMacro(), ScMatch(), ScMatDet(), ScMatInv(), ScMatRef(), ScMatValue(), ScMax(), ScMaxIfs_MS(), ScMid(), ScMin(), ScMinIfs_MS(), ScMIRR(), ScMod(), ScNetWorkdays(), ScNoName(), ScNumberValue(), ScOffset(), ScRandomImpl(), ScRank(), ScRegex(), ScRept(), ScRoman(), ScStandard(), ScSubstitute(), ScSumIfs(), ScSumProduct(), ScSwitch_MS(), ScT(), ScText(), ScTTest(), ScTTT(), ScWebservice(), ScWorkday_MS(), and ScZTest().
|
private |
Definition at line 1869 of file interpr4.cxx.
References ScDocument::GetSharedStringPool(), IfErrorPushError(), ScComplexRefData::InitRange(), svl::SharedStringPool::intern(), mrDoc, and PushTempTokenWithoutError().
Referenced by ScIndirect(), and ScOffset().
|
private |
Definition at line 1857 of file interpr4.cxx.
References ScDocument::GetSharedStringPool(), IfErrorPushError(), ScSingleRefData::InitAddress(), svl::SharedStringPool::intern(), mrDoc, and PushTempTokenWithoutError().
Referenced by ScIndirect(), and ScOffset().
|
private |
Definition at line 1943 of file interpr4.cxx.
References PushError().
Referenced by CalculateAddSub(), CalculateLookup(), CalculatePearsonCovar(), CalculateSkewOrSkewp(), CalculateSlopeIntercept(), CalculateTrendGrowth(), CheckMatrix(), ScAddressFunc(), ScAggregate(), ScAmpersand(), ScArabic(), ScArcCosHyp(), ScArcCotHyp(), ScArcTanHyp(), ScB(), ScBase(), ScBetaDist(), ScBetaDist_MS(), ScBetaInv(), ScBinomDist(), ScBitAnd(), ScBitLshift(), ScBitOr(), ScBitRshift(), ScBitXor(), ScCeil(), ScCeil_MS(), ScCell(), ScChar(), ScChiDist(), ScChiInv(), ScChiSqDist(), ScChiSqDist_MS(), ScChiSqInv(), ScChiTest(), ScChooseJump(), ScColor(), ScCombin(), ScCombinA(), ScConfidence(), ScConfidenceT(), ScCritBinom(), ScCumIpmt(), ScCumPrinc(), ScCurrency(), ScDB(), ScDBGet(), ScDDB(), ScDde(), ScDecimal(), ScDiv(), ScEasterSunday(), ScEffect(), ScEMat(), ScEuroConvert(), ScExpDist(), ScFact(), ScFDist(), ScFDist_LT(), ScFindB(), ScFInv(), ScFInv_LT(), ScFisher(), ScFixed(), ScFloor(), ScFloor_MS(), ScForecast(), ScForecast_Ets(), ScFourier(), ScFrequency(), ScGamma(), ScGammaDist(), ScGammaInv(), ScGCD(), ScGetDate(), ScGetDateDif(), ScGetDateValue(), ScGetTime(), ScGetTimeValue(), ScGetWeekOfYear(), ScHypGeomDist(), ScIfJump(), ScIndex(), ScInfo(), ScIntersect(), ScIpmt(), ScIsFormula(), ScLCM(), ScLeft(), ScLeftB(), ScLn(), ScLog(), ScLog10(), ScLogGamma(), ScLogNormDist(), ScLogNormInv(), ScMacro(), ScMatDet(), ScMatInv(), ScMatMult(), ScMatTrans(), ScMid(), ScMidB(), ScMul(), ScNeg(), ScNegBinomDist(), ScNegBinomDist_MS(), ScNetWorkdays(), ScNominal(), ScNormDist(), ScNormInv(), ScNot(), ScNPV(), ScNumberValue(), ScOffset(), ScPDuration(), ScPercentile(), ScPercentrank(), ScPermut(), ScPermutationA(), ScPoissonDist(), ScPow(), ScPpmt(), ScQuartile(), ScRandbetween(), ScRangeFunc(), ScRate(), ScRegex(), ScReplace(), ScReplaceB(), ScRept(), ScRight(), ScRightB(), ScRoman(), ScRoundSignificant(), ScRRI(), ScSearch(), ScSearchB(), ScSNormInv(), ScSqrt(), ScSubstitute(), ScSubTotal(), ScSwitch_MS(), ScTDist(), ScTDist_MS(), ScTDist_T(), ScText(), ScTextJoin_MS(), ScTInv(), ScTrimMean(), ScTTest(), ScType(), ScUnichar(), ScUnionFunc(), ScValue(), ScVDB(), ScWeibull(), ScWorkday_MS(), and ScZTest().
|
private |
Definition at line 1938 of file interpr4.cxx.
References PushError().
Referenced by CalculateLookup(), CalculatePearsonCovar(), CalculateRGPRKP(), CalculateSlopeIntercept(), CalculateSumX2MY2SumX2DY2(), CalculateTrendGrowth(), ConvertMatrixJumpConditionToMatrix(), FillEntry(), MustHaveParamCount(), PopDoubleRefPushMatrix(), ScCell(), ScCellExternal(), ScChiTest(), ScChooseJump(), ScCountIf(), ScDBCount(), ScDBCount2(), ScDBGet(), ScDebugVar(), ScEqual(), ScExternal(), ScFilterXML(), ScForecast(), ScForecast_Ets(), ScFourier(), ScFTest(), ScGreater(), ScGreaterEqual(), ScIfJump(), ScIRR(), ScLess(), ScLessEqual(), ScLookup(), ScMatch(), ScMatDet(), ScMatInv(), ScMatMult(), ScMatTrans(), ScMatValue(), ScNeg(), ScNot(), ScNotEqual(), ScOffset(), ScProbability(), ScSumProduct(), ScSumXMY2(), ScTableOp(), ScTTest(), and ScUnicode().
|
private |
Definition at line 1808 of file interpr4.cxx.
References CreateDoubleOrTypedToken(), IfErrorPushError(), and PushTempTokenWithoutError().
Referenced by FillEntry(), Interpret(), ScAnd(), ScArabic(), ScCeil(), ScCeil_MS(), ScCeil_Precise(), ScCell(), ScCellExternal(), ScCode(), ScCountIf(), ScEqual(), ScExact(), ScExpDist(), ScFalse(), ScFloor(), ScFloor_MS(), ScFloor_Precise(), ScGammaInv(), ScGetDateDif(), ScGetDayOfWeek(), ScGetIsoWeekOfYear(), ScGetWeekOfYear(), ScGreater(), ScGreaterEqual(), ScIfJump(), ScIsEmpty(), ScIsErr(), ScIsError(), ScIsEven(), ScIsFormula(), ScIsLogical(), ScIsNonString(), ScIsNV(), ScIsOdd(), ScIsRef(), ScIsString(), ScIsValue(), ScLess(), ScLessEqual(), ScMatch(), ScMatDet(), ScMatRef(), ScNot(), ScNotEqual(), ScOr(), ScPercentSign(), ScPermut(), ScPlusMinus(), ScT(), ScTrue(), ScType(), ScValue(), ScWeeknumOOo(), and ScXor().
|
private |
Definition at line 1902 of file interpr4.cxx.
References sc::RangeMatrix::isRangeValid(), sc::RangeMatrix::mpMat, nGlobalError, PushMatrix(), and PushTempTokenWithoutError().
Referenced by CalculateAddSub(), CalculateRGPRKP(), CalculateSmallLarge(), CalculateTrendGrowth(), ConvertMatrixJumpConditionToMatrix(), GetStVarParams(), IterateParameters(), IterateParametersIf(), IterateParametersIfs(), JumpMatrix(), PopDoubleRefPushMatrix(), PopRefListPushMatrixOrRef(), PushMatrix(), QueryMat(), ScAmpersand(), ScColumn(), ScCountEmptyCells(), ScCountIf(), ScDde(), ScDiv(), ScEMat(), ScEqual(), ScExternal(), ScFilterXML(), ScForecast_Ets(), ScFormula(), ScFourier(), ScFrequency(), ScGreater(), ScGreaterEqual(), ScHyperLink(), ScIndex(), ScIsFormula(), ScLess(), ScLessEqual(), ScMacro(), ScMatInv(), ScMatMult(), ScMatTrans(), ScMax(), ScMin(), ScModalValue_MS(), ScMul(), ScNeg(), ScNot(), ScNotEqual(), ScPow(), ScRandomImpl(), and ScRow().
|
private |
Definition at line 1916 of file interpr4.cxx.
References nGlobalError, and PushTempTokenWithoutError().
|
private |
Definition at line 1948 of file interpr4.cxx.
References PushError().
Referenced by CalculateLookup(), ScConvertOOo(), ScDde(), ScErrorType(), ScErrorType_ODF(), ScExternal(), ScIfs_MS(), ScInfo(), ScLookup(), ScMatch(), ScMatRef(), ScProbability(), and ScSwitch_MS().
|
private |
Definition at line 1953 of file interpr4.cxx.
References PushError().
Referenced by CalculateAddSub(), CalculateMatrixValue(), CalculatePearsonCovar(), CalculateRGPRKP(), CalculateSlopeIntercept(), CalculateSmallLarge(), CalculateSumX2MY2SumX2DY2(), CalculateTest(), CalculateTrendGrowth(), GetHypGeomDist(), Interpret(), ScAddressFunc(), ScAmpersand(), ScAnd(), ScChiTest(), ScCritBinom(), ScDBGet(), ScDde(), ScDiv(), ScExternal(), ScFilterXML(), ScFind(), ScFindB(), ScForecast(), ScFourier(), ScFrequency(), ScFTest(), ScIfs_MS(), ScMacro(), ScMatDet(), ScMatInv(), ScMatMult(), ScMatValue(), ScModalValue(), ScModalValue_MS(), ScMul(), ScNormInv(), ScNumberValue(), ScOr(), ScPercentile(), ScPercentrank(), ScPow(), ScProbability(), ScQuartile(), ScRank(), ScRSQ(), ScSearch(), ScSearchB(), ScSNormInv(), ScSumProduct(), ScSumXMY2(), ScTrimMean(), ScTTest(), and ScXor().
|
private |
Definition at line 1933 of file interpr4.cxx.
References PushError().
Referenced by MustHaveParamCount(), MustHaveParamCountMin(), ScForecast_Ets(), and ScIfs_MS().
|
private |
Definition at line 1882 of file interpr4.cxx.
References aPos, ScDocument::GetSheetLimits(), IfErrorPushError(), ScSingleRefData::InitFromRefAddress(), mrDoc, and PushTempTokenWithoutError().
Definition at line 1836 of file interpr4.cxx.
References ScDocument::GetSheetLimits(), IfErrorPushError(), ScSingleRefData::InitAddress(), mrDoc, and PushTempTokenWithoutError().
Referenced by ScIndex(), ScIndirect(), ScIntersect(), and ScOffset().
|
private |
Definition at line 1825 of file interpr4.cxx.
References ScDocument::GetSharedStringPool(), svl::SharedStringPool::intern(), mrDoc, and PushString().
Referenced by CalculateLookup(), CalculateMatrixValue(), PushCellResultToken(), PushString(), PushStringBuffer(), QueryMat(), ScAddressFunc(), ScAmpersand(), ScAsc(), ScBahtText(), ScCell(), ScCellExternal(), ScChar(), ScClean(), ScConcat(), ScConcat_MS(), ScCurrency(), ScDBGet(), ScEncodeURL(), ScExternal(), ScFilterXML(), ScFixed(), ScFormula(), ScIndex(), ScInfo(), ScJis(), ScLeft(), ScLeftB(), ScLookup(), ScLower(), ScMacro(), ScMatRef(), ScMatValue(), ScMid(), ScMidB(), ScProper(), ScRegex(), ScReplace(), ScReplaceB(), ScRept(), ScRight(), ScRightB(), ScRoman(), ScSubstitute(), ScT(), ScTableOp(), ScText(), ScTextJoin_MS(), ScTrim(), ScUnichar(), ScUpper(), and ScWebservice().
|
private |
Definition at line 1830 of file interpr4.cxx.
References IfErrorPushError(), and PushTempTokenWithoutError().
|
private |
Definition at line 1814 of file interpr4.cxx.
References svl::SharedString::getEmptyString(), ScDocument::GetSharedStringPool(), svl::SharedStringPool::intern(), mrDoc, and PushString().
Referenced by ScBase().
|
private |
Does substitute with formula::FormulaErrorToken in case nGlobalError is set and the token passed is not formula::FormulaErrorToken.
Increments RefCount of the original token if not substituted. ATTENTION! The token had to be allocated with ‘new’ and must not be used after this call if no RefCount was set because possibly it gets immediately deleted in case of a FormulaError::StackOverflow or if substituted with formula::FormulaErrorToken!
Definition at line 618 of file interpr4.cxx.
References MAXSTACK, nGlobalError, p, PushTempTokenWithoutError(), SetError(), sp, and svError.
Referenced by Interpret(), PushCellResultToken(), QueryMatrixType(), ScColRowNameAuto(), ScDBArea(), ScIntersect(), ScMatRef(), and ScMissing().
|
private |
Does not substitute with formula::FormulaErrorToken in case nGlobalError is set.
Used to push tokens from within PushTempToken() or tokens that are already explicit formula::FormulaErrorToken. Increments RefCount. ATTENTION! The token had to be allocated with ‘new’ and must not be used after this call if no RefCount was set because possibly it gets immediately decremented again and thus deleted in case of a FormulaError::StackOverflow!
Definition at line 647 of file interpr4.cxx.
References formula::FormulaToken::DecRef(), maxsp, MAXSTACK, p, pStack, SetError(), and sp.
Referenced by ConvertMatrixParameters(), IfErrorPushError(), PopRefListPushMatrixOrRef(), Push(), PushCellResultToken(), PushDouble(), PushDoubleRef(), PushError(), PushExternalDoubleRef(), PushExternalSingleRef(), PushInt(), PushMatrix(), PushSingleRef(), PushString(), PushTempToken(), and PushTokenRef().
|
private |
Pushes the token or substitutes with formula::FormulaErrorToken in case nGlobalError is set and the token passed is not formula::FormulaErrorToken.
Increments RefCount of the original token if not substituted.
Definition at line 667 of file interpr4.cxx.
References MAXSTACK, nGlobalError, PushTempTokenWithoutError(), SetError(), sp, svError, and x.
Referenced by Interpret(), JumpMatrix(), ScAggregate(), ScChooseJump(), ScCurrent(), ScIfError(), ScIfJump(), ScIfs_MS(), ScIndirect(), ScIntersect(), ScRangeFunc(), ScSubTotal(), ScSwitch_MS(), ScText(), and ScUnionFunc().
|
private |
Does not substitute with formula::FormulaErrorToken in case nGlobalError is set.
Used to push RPN tokens or from within Push() or tokens that are already explicit formula::FormulaErrorToken. Increments RefCount.
Definition at line 584 of file interpr4.cxx.
References formula::FormulaToken::DecRef(), formula::FormulaToken::IncRef(), maxsp, MAXSTACK, pStack, SetError(), and sp.
Referenced by Interpret(), JumpMatrix(), Push(), ScAggregate(), and ScSubTotal().
|
private |
Definition at line 1144 of file interpr1.cxx.
References sc::CompareOptions::aQueryEntry, ScQueryEntry::ByString, CompareMat(), ScQueryEntry::eOp, ScQueryEntry::GetQueryItem(), svl::SharedString::getString(), ScQueryEntry::Item::maString, ScQueryEntry::Item::meType, ScQueryEntry::Item::mfVal, sc::RangeMatrix::mpMat, nCurFmtType, nFuncFmtType, nGlobalError, PushDouble(), PushMatrix(), PushString(), and SetError().
Referenced by IterateParametersIf(), IterateParametersIfs(), and ScCountIf().
|
private |
Definition at line 1714 of file interpr4.cxx.
References CreateFormulaDoubleToken(), ScMatrixValue::fVal, GetDoubleErrorValue(), ScMatrixValue::GetString(), ScMatrix::IsNonValueType(), ScMatrixValue::nType, PushTempToken(), and SetError().
Referenced by Interpret().
|
staticprivate |
Definition at line 4210 of file interpr3.cxx.
References i, lcl_QuickSort(), n, and comphelper::rng::uniform_size_distribution().
Referenced by GetSortArray(), and ScModalValue_MS().
|
staticprivate |
Definition at line 2037 of file interpr2.cxx.
References nCount, and SCdEpsilon.
Referenced by ScRate().
|
private |
Definition at line 88 of file interpr4.cxx.
References ScInterpreterTableOpParams::aNew1, ScInterpreterTableOpParams::aNew2, ScInterpreterTableOpParams::aOld1, ScInterpreterTableOpParams::aOld2, i, ScDocument::m_TableOpList, and mrDoc.
Referenced by PopSingleRef().
|
private |
Definition at line 2009 of file interpr4.cxx.
Referenced by GetNumberSequenceArray(), ScConcat(), ScConcat_MS(), ScIfs_MS(), ScNPV(), ScRawSubtract(), ScSwitch_MS(), and ScTextJoin_MS().
|
private |
Definition at line 955 of file interpr2.cxx.
References eMode, GetByte(), GetDouble(), GetInt16(), MustHaveParamCount(), nGlobalError, and PushDouble().
Referenced by ScRound(), ScRoundDown(), and ScRoundUp().
|
staticprivate |
Definition at line 1038 of file interpr2.cxx.
Referenced by ScRoundSignificant().
|
private |
Definition at line 945 of file interpr2.cxx.
References GetDouble(), and PushDouble().
Referenced by Interpret().
|
private |
Definition at line 1212 of file interpr5.cxx.
References CalculateAddSub().
Referenced by Interpret().
|
private |
Definition at line 8489 of file interpr1.cxx.
References aPos, ScCompiler::CheckTabQuotes(), ScAddress::Col(), COL_ABS, COL_VALID, ScAddress::Format(), ScDocument::GetAddressConvention(), GetByte(), ScCompiler::GetDocTabPos(), GetDoubleWithDefault(), GetInt16(), GetInt32(), GetInt32WithDefault(), GetString(), svl::SharedString::getString(), maCalcConfig, ScCalcConfig::meStringRefAddressSyntax, mrDoc, MustHaveParamCount(), n, nGlobalError, nPos, PushIllegalArgument(), PushNoValue(), PushString(), ScAddress::Row(), ROW_ABS, ROW_VALID, u, VALID,