Created attachment 126069 [details] test file 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 B1=#VALUE!
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) at /home/julien/lo/libreoffice/bridges/source/cpp_uno/gcc3_linux_x86-64/callvirtualmethod.cxx:133 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 ) 1108 { 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(); 1113 } See http://opengrok.libreoffice.org/xref/core/scaddins/source/analysis/analysishelper.cxx#1105 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 ***