Bug 100769 - ODDFPRICE function not working
Summary: ODDFPRICE function not working
Status: RESOLVED DUPLICATE of bug 100749
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2016-07-05 06:24 UTC by raal
Modified: 2016-07-07 09:29 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

test file (9.26 KB, application/x-zip)
2016-07-05 06:24 UTC, raal

Note You need to log in before you can comment on or make changes to this bug.
Description raal 2016-07-05 06:24:47 UTC
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
Comment 1 Julien Nabet 2016-07-05 19:42:09 UTC
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.
Comment 2 Winfried Donkers 2016-07-07 09:29:08 UTC

*** This bug has been marked as a duplicate of bug 100749 ***