Created attachment 126069 [details]
open attached file
ctrl+shift+F9 - recalculation
see the cell B1 - #VALUE!
formula =ODDFPRICE(D1,E1,F1,G1,H1,I1,J1,K1,L1) works in excel, but in Calc
On pc Debian x86-64 with master sources updated today, I could reproduce this.
#0 sca::analysis::GetOddfprice () at /home/julien/lo/libreoffice/scaddins/source/analysis/analysishelper.cxx:1112
#1 0x00002aaadb8a2b01 in AnalysisAddIn::getOddfprice (this=0x2a6d7e0, xOpt=uno::Reference to (ScModelObj *) 0x26a39e8, nSettle=39763, nMat=44256, nIssue=39736,
nFirstCoup=39873, fRate=0.0785, fYield=0.0625, fRedemp=100, nFreq=2, rOB=uno::Any("double": 1)) at /home/julien/lo/libreoffice/scaddins/source/analysis/financial.cxx:413
#2 0x00002aaaccd3a2bb in gcc3::callVirtualMethod (pThis=0x2a6d818, nVtableIndex=90, pRegisterReturn=0x7ffffffefd20, pReturnTypeRef=0x6f5060, bSimpleReturn=true,
pStack=0x7ffffffef830, nStack=2, pGPR=0x7ffffffef9a0, pFPR=0x7ffffffef9d0)
It corresponds to this part:
1105 double GetOddfprice( sal_Int32 /*nNullDate*/, sal_Int32 /*nSettle*/, sal_Int32 /*nMat*/, sal_Int32 /*nIssue*/,
1106 sal_Int32 /*nFirstCoup*/, double /*fRate*/, double /*fYield*/, double /*fRedemp*/, sal_Int32 /*nFreq*/,
1107 sal_Int32 /*nBase*/ ) throw( uno::RuntimeException, lang::IllegalArgumentException )
1109 // If you change this to not unconditionally throw, the
1110 // SAL_WNOUNREACHABLE_CODE_PUSH/POP around the caller in
1111 // financial.cxx can be removed.
1112 throw uno::RuntimeException();
Like this since https://cgit.freedesktop.org/libreoffice/core/commit/?id=543937297a7e936718a7e37a6ebe30dfc418e567
Winfried/Eike: thought you might be interested in this one.
*** This bug has been marked as a duplicate of bug 100749 ***