Lines Matching refs:fVal
128 double fVal; in ScIfJump() local
136 fVal = pMatVal->fVal; in ScIfJump()
137 bIsValue = ::rtl::math::isFinite( fVal ); in ScIfJump()
138 bTrue = bIsValue && (fVal != 0.0); in ScIfJump()
140 fVal = 1.0; in ScIfJump()
148 fVal = (bIsValue ? 0.0 : CreateDoubleError( errNoValue)); in ScIfJump()
154 pJumpMat->SetJump( nC, nR, fVal, in ScIfJump()
160 pJumpMat->SetJump( nC, nR, fVal, in ScIfJump()
169 pJumpMat->SetJump( nC, nR, fVal, in ScIfJump()
176 pJumpMat->SetJump( nC, nR, fVal, in ScIfJump()
261 double fVal; in ScChoseJump() local
268 fVal = pMatVal->fVal; in ScChoseJump()
269 bIsValue = ::rtl::math::isFinite( fVal ); in ScChoseJump()
272 fVal = ::rtl::math::approxFloor( fVal); in ScChoseJump()
273 if ( (fVal < 1) || (fVal >= nJumpCount)) in ScChoseJump()
276 fVal = CreateDoubleError( in ScChoseJump()
283 fVal = CreateDoubleError( errNoValue); in ScChoseJump()
287 pJumpMat->SetJump( nC, nR, fVal, in ScChoseJump()
288 pJump[ (short)fVal ], in ScChoseJump()
293 pJumpMat->SetJump( nC, nR, fVal, in ScChoseJump()
383 double fVal = GetDouble(); in JumpMatrix() local
386 fVal = CreateDoubleError( nGlobalError ); in JumpMatrix()
389 pResMat->PutDouble( fVal, nC, nR ); in JumpMatrix()
422 double fVal = GetCellValue( aAdr, pCell); in JumpMatrix() local
425 fVal = CreateDoubleError( in JumpMatrix()
429 pResMat->PutDouble( fVal, nC, nR ); in JumpMatrix()
449 double fVal; in JumpMatrix() local
454 fVal = CreateDoubleError( nGlobalError ); in JumpMatrix()
456 pResMat->PutDouble( fVal, nC, nR ); in JumpMatrix()
470 fVal = CreateDoubleError( NOTAVAILABLE ); in JumpMatrix()
471 pResMat->PutDouble( fVal, nC, nR ); in JumpMatrix()
520 double fVal; in JumpMatrix() local
524 fVal = CreateDoubleError( nGlobalError ); in JumpMatrix()
526 pResMat->PutDouble( fVal, nC, nR ); in JumpMatrix()
530 fVal = CreateDoubleError( errUnknownVariable ); in JumpMatrix()
531 pResMat->PutDouble( fVal, nC, nR ); in JumpMatrix()
540 fVal = CreateDoubleError( NOTAVAILABLE ); in JumpMatrix()
541 pResMat->PutDouble( fVal, nC, nR ); in JumpMatrix()
547 fVal = pMat->GetDouble( nC, nR ); in JumpMatrix()
548 pResMat->PutDouble( fVal, nC, nR ); in JumpMatrix()
565 double fVal = CreateDoubleError( nGlobalError); in JumpMatrix() local
567 pResMat->PutDouble( fVal, nC, nR ); in JumpMatrix()
573 double fVal = CreateDoubleError( errIllegalArgument); in JumpMatrix() local
574 pResMat->PutDouble( fVal, nC, nR ); in JumpMatrix()
1300 double fVal; in ScAnd() local
1303 if ( aValIter.GetFirst( fVal, nErr ) ) in ScAnd()
1308 nRes &= ( fVal != 0.0 ); in ScAnd()
1310 aValIter.GetNext( fVal, nErr ) ); in ScAnd()
1322 double fVal = pMat->And(); in ScAnd() local
1323 sal_uInt16 nErr = GetDoubleErrorValue( fVal ); in ScAnd()
1330 nRes &= (fVal != 0.0); in ScAnd()
1398 double fVal; in ScOr() local
1401 if ( aValIter.GetFirst( fVal, nErr ) ) in ScOr()
1406 nRes |= ( fVal != 0.0 ); in ScOr()
1408 aValIter.GetNext( fVal, nErr ) ); in ScOr()
1421 double fVal = pMat->Or(); in ScOr() local
1422 sal_uInt16 nErr = GetDoubleErrorValue( fVal ); in ScOr()
1429 nRes |= (fVal != 0.0); in ScOr()
1498 double fVal; in ScXor() local
1501 if ( aValIter.GetFirst( fVal, nErr ) ) in ScXor()
1506 nRes ^= ( fVal != 0.0 ); in ScXor()
1508 aValIter.GetNext( fVal, nErr ) ); in ScXor()
1521 double fVal = pMat->Xor(); in ScXor() local
1522 sal_uInt16 nErr = GetDoubleErrorValue( fVal ); in ScXor()
1529 nRes ^= (fVal != 0.0); in ScXor()
1820 double fVal = GetDouble(); in ScArcCosHyp() local
1821 if (fVal < 1.0) in ScArcCosHyp()
1824 PushDouble( ::boost::math::acosh( fVal)); in ScArcCosHyp()
1830 double fVal = GetDouble(); in ScArcTanHyp() local
1831 if (fabs(fVal) >= 1.0) in ScArcTanHyp()
1834 PushDouble( ::boost::math::atanh( fVal)); in ScArcTanHyp()
1883 double fVal = GetDouble(); in ScSqrt() local
1884 if (fVal >= 0.0) in ScSqrt()
1885 PushDouble(sqrt(fVal)); in ScSqrt()
2677 double fVal = 0.0; in IsEven() local
2695 fVal = GetCellValue( aAdr, pCell ); in IsEven()
2701 fVal = GetCellValue( aAdr, pCell ); in IsEven()
2713 fVal = PopDouble(); in IsEven()
2726 fVal = pMat->GetDouble( 0 ); in IsEven()
2737 fVal = pMat->GetDouble( nC, nR); in IsEven()
2750 nRes = ( fmod( ::rtl::math::approxFloor( fabs( fVal ) ), 2.0 ) < 0.5 ); in IsEven()
2778 double fVal = GetDouble(); in ScN() local
2784 PushDouble( fVal ); in ScN()
2924 double fVal; in ScValue() local
2963 ScMatValType nType = GetDoubleOrStringFromMatrix( fVal, in ScValue()
2968 fVal = 0.0; in ScValue()
2972 PushDouble( fVal); in ScValue()
2989 if (pFormatter->IsNumberFormat(aInputString, nFIndex, fVal)) in ScValue()
2990 PushDouble(fVal); in ScValue()
3028 double fVal = GetDouble(); in ScChar() local
3029 if (fVal < 0.0 || fVal >= 256.0) in ScChar()
3034 … aStr.SetChar( 0, ByteString::ConvertToUnicode( (sal_Char) fVal, gsl_getSystemTextEncoding() ) ); in ScChar()
3386 double fVal = 0.0; in IterateParameters() local
3406 if ( bTextAsZero || pFormatter->IsNumberFormat(aStr, nFIndex, fVal)) in IterateParameters()
3441 fVal = GetDouble(); in IterateParameters()
3447 if ( bNull && fVal != 0.0 ) in IterateParameters()
3450 fMem = fVal; in IterateParameters()
3453 fRes += fVal; in IterateParameters()
3455 case ifSUMSQ: fRes += fVal * fVal; break; in IterateParameters()
3456 case ifPRODUCT: fRes *= fVal; break; in IterateParameters()
3485 fVal = GetCellValue( aAdr, pCell ); in IterateParameters()
3491 if ( bNull && fVal != 0.0 ) in IterateParameters()
3494 fMem = fVal; in IterateParameters()
3497 fRes += fVal; in IterateParameters()
3499 case ifSUMSQ: fRes += fVal * fVal; break; in IterateParameters()
3500 case ifPRODUCT: fRes *= fVal; break; in IterateParameters()
3552 if (aValIter.GetFirst(fVal, nErr)) in IterateParameters()
3563 if ( bNull && fVal != 0.0 ) in IterateParameters()
3566 fMem = fVal; in IterateParameters()
3569 fRes += fVal; in IterateParameters()
3572 while (aValIter.GetNext(fVal, nErr)); in IterateParameters()
3578 fRes += fVal * fVal; in IterateParameters()
3581 while (aValIter.GetNext(fVal, nErr)); in IterateParameters()
3587 fRes *= fVal; in IterateParameters()
3590 while (aValIter.GetNext(fVal, nErr)); in IterateParameters()
3598 while (aValIter.GetNext(fVal, nErr)); in IterateParameters()
3626 fVal = pMat->GetDouble(nMatCol,nMatRow); in IterateParameters()
3631 if ( bNull && fVal != 0.0 ) in IterateParameters()
3634 fMem = fVal; in IterateParameters()
3637 fRes += fVal; in IterateParameters()
3639 case ifSUMSQ: fRes += fVal * fVal; break; in IterateParameters()
3640 case ifPRODUCT: fRes *= fVal; break; in IterateParameters()
3745 double fVal = 0.0; in GetStVarParams() local
3756 fVal = GetDouble(); in GetStVarParams()
3757 values.push_back(fVal); in GetStVarParams()
3758 fSum += fVal; in GetStVarParams()
3768 fVal = GetCellValue( aAdr, pCell ); in GetStVarParams()
3769 values.push_back(fVal); in GetStVarParams()
3770 fSum += fVal; in GetStVarParams()
3786 if (aValIter.GetFirst(fVal, nErr)) in GetStVarParams()
3790 values.push_back(fVal); in GetStVarParams()
3791 fSum += fVal; in GetStVarParams()
3794 while ((nErr == 0) && aValIter.GetNext(fVal, nErr)); in GetStVarParams()
3811 fVal= pMat->GetDouble(nMatCol,nMatRow); in GetStVarParams()
3812 values.push_back(fVal); in GetStVarParams()
3813 fSum += fVal; in GetStVarParams()
4393 double fVal; in ScMatch() local
4412 fVal = GetDouble(); in ScMatch()
4414 rEntry.nVal = fVal; in ScMatch()
4436 fVal = GetCellValue( aAdr, pCell ); in ScMatch()
4438 rEntry.nVal = fVal; in ScMatch()
4703 double fVal = 0.0; in IterateParametersIf() local
4718 fVal = GetCellValue( aAdr, pCell ); in IterateParametersIf()
4724 fVal = GetCellValue( aAdr, pCell ); in IterateParametersIf()
4735 fVal = 0.0; in IterateParametersIf()
4745 ScMatValType nType = GetDoubleOrStringFromMatrix( fVal, rString); in IterateParametersIf()
4751 fVal = GetDouble(); in IterateParametersIf()
4876 rEntry.nVal = fVal; in IterateParametersIf()
4919 fVal = pSumExtraMatrix->GetDouble( nC, nR); in IterateParametersIf()
4921 if ( bNull && fVal != 0.0 ) in IterateParametersIf()
4924 fMem = fVal; in IterateParametersIf()
4927 fSum += fVal; in IterateParametersIf()
4946 fVal = GetCellValue( aAdr, pCell ); in IterateParametersIf()
4948 if ( bNull && fVal != 0.0 ) in IterateParametersIf()
4951 fMem = fVal; in IterateParametersIf()
4954 fSum += fVal; in IterateParametersIf()
4976 fVal = pSumExtraMatrix->GetDouble( nC, nR); in IterateParametersIf()
4978 if ( bNull && fVal != 0.0 ) in IterateParametersIf()
4981 fMem = fVal; in IterateParametersIf()
4984 fSum += fVal; in IterateParametersIf()
4997 fVal = GetCellValue( aAdr, pCell ); in IterateParametersIf()
4999 if ( bNull && fVal != 0.0 ) in IterateParametersIf()
5002 fMem = fVal; in IterateParametersIf()
5005 fSum += fVal; in IterateParametersIf()
5046 double fVal = 0.0; in ScCountIf() local
5063 fVal = GetCellValue( aAdr, pCell ); in ScCountIf()
5069 fVal = GetCellValue( aAdr, pCell ); in ScCountIf()
5080 fVal = 0.0; in ScCountIf()
5087 ScMatValType nType = GetDoubleOrStringFromMatrix( fVal, rString); in ScCountIf()
5096 fVal = GetDouble(); in ScCountIf()
5171 rEntry.nVal = fVal; in ScCountIf()
5248 double fVal = 0.0; in IterateParametersIfs() local
5262 fVal = 0.0; in IterateParametersIfs()
5277 fVal = GetCellValue( aAdr, pCell ); in IterateParametersIfs()
5283 fVal = GetCellValue( aAdr, pCell ); in IterateParametersIfs()
5294 fVal = 0.0; in IterateParametersIfs()
5304 ScMatValType nType = GetDoubleOrStringFromMatrix( fVal, rString); in IterateParametersIfs()
5310 fVal = GetDouble(); in IterateParametersIfs()
5402 rEntry.nVal = fVal; in IterateParametersIfs()
5544 fVal = pMainMatrix->GetDouble( nCol, nRow); in IterateParametersIfs()
5546 if ( bNull && fVal != 0.0 ) in IterateParametersIfs()
5549 fMem = fVal; in IterateParametersIfs()
5552 fSum += fVal; in IterateParametersIfs()
5573 fVal = GetCellValue( aAdr, pCell ); in IterateParametersIfs()
5575 if ( bNull && fVal != 0.0 ) in IterateParametersIfs()
5578 fMem = fVal; in IterateParametersIfs()
5581 fSum += fVal; in IterateParametersIfs()
6869 double fVal, fCount; in ScDBStdDev() local
6870 GetDBStVarParams( fVal, fCount ); in ScDBStdDev()
6871 PushDouble( sqrt(fVal/(fCount-1))); in ScDBStdDev()
6878 double fVal, fCount; in ScDBStdDevP() local
6879 GetDBStVarParams( fVal, fCount ); in ScDBStdDevP()
6880 PushDouble( sqrt(fVal/fCount)); in ScDBStdDevP()
6887 double fVal, fCount; in ScDBVar() local
6888 GetDBStVarParams( fVal, fCount ); in ScDBVar()
6889 PushDouble(fVal/(fCount-1)); in ScDBVar()
6896 double fVal, fCount; in ScDBVarP() local
6897 GetDBStVarParams( fVal, fCount ); in ScDBVarP()
6898 PushDouble(fVal/fCount); in ScDBVarP()
7587 double fVal = GetDouble(); in ScCurrency() local
7593 if (fVal < 0.0) in ScCurrency()
7594 fVal = ceil(fVal*fFac-0.5)/fFac; in ScCurrency()
7596 fVal = floor(fVal*fFac+0.5)/fFac; in ScCurrency()
7614 fVal, in ScCurrency()
7622 pFormatter->GetOutputString(fVal, nIndex, aStr, &pColor); in ScCurrency()
7683 double fVal = GetDouble(); in ScFixed() local
7689 if (fVal < 0.0) in ScFixed()
7690 fVal = ceil(fVal*fFac-0.5)/fFac; in ScFixed()
7692 fVal = floor(fVal*fFac+0.5)/fFac; in ScFixed()
7708 fVal, in ScFixed()
8054 double fVal = 0.0; in ScText() local
8061 fVal = PopDouble(); in ScText()
8073 fVal = GetDouble(); in ScText()
8110 if (!pFormatter->GetPreviewStringGuess( sFormatString, fVal, in ScText()