Description: When the Basis parameter is 1, the result from ACCRINT does not match the formula. If the same ACCRINT values are used in Excel, the result DOES match the formula. I conclude ACCRINT is not functioning properly. Steps to Reproduce: Enter the following formula: =ACCRINT("2001-2-28","2001-08-31","2001-05-01",10%,1500,2,1) Actual Results: 25.479452 Expected Results: 25.271739 This results from the following formula in your documentation: Rate * (Par/Frequency) * (DaysOfInterestEarned/DaysInPaymentPeriod) Rate = .10 Par = 1500 Frequency = 2 DaysOfInterestEarned = 62 (Settlement - Issue) DaysInPaymentPeriod = 184 (FirstInterest - Issue) ACCRINT = .10 * (1500/2) * (62/184) ACCRINT = 25.271739 Reproducible: Always User Profile Reset: No Additional Info: I believe this is not a new bug, I am sure it existed in early 7.x releases and possibly all Libre Calc releases. But, my help/about information is: Version for testing 7.3.4.2 (x64) Build: 728fec
Created attachment 181290 [details] Spreadsheet example The attached spreadsheet also demonstrates the bug, or use comments to reproduce.
I can confirm with Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a) and Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: 11937a68aecb8db9aebb1c929d940c5b85a0ecec CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Result in excel and google office is 25,27. Try to change B16 in attached file to 182.5 and you'll get result as in LO, so LO calculate Dazs in period as 182.5. Setting to New.
On pc Debian x86-64 with master sources updated today, I noticed this on gdb on the frame ScUnoAddInCall::ExecuteCallWithArgs (this=0x7ffe39f02b28, rCallArgs=uno::Sequence of length 8 = {...}) at sc/source/core/tool/addincol.cxx:1399 $1 = uno::Sequence of length 8 = {uno::Any("com.sun.star.uno.XInterface": {_vptr$XInterface = 0x34425c0}), uno::Any("long": 36950), uno::Any("long": 37134), uno::Any("long": 37012), uno::Any("double": 0.10000000000000001), uno::Any("double": 1500), uno::Any("long": 2), uno::Any("double": 1)} fRate should be just 0.1 here's more of the bt: #0 AnalysisAddIn::getAccrint(com::sun::star::uno::Reference<com::sun::star::beans::XPropertySet> const&, int, int, int, double, com::sun::star::uno::Any const&, int, com::sun::star::uno::Any const&) (this=0x36a5a50, xOpt=uno::Reference to (ScModelObj *) 0x34427f8, nIssue=36950, nSettle=37012, fRate=0.10000000000000001, rVal=uno::Any("double": 1500), nFreq=2, rOB=uno::Any("double": 1)) at scaddins/source/analysis/financial.cxx:57 #1 0x00007fcc680c8df0 in non-virtual thunk to AnalysisAddIn::getAccrint(com::sun::star::uno::Reference<com::sun::star::beans::XPropertySet> const&, int, int, int, double, com::sun::star::uno::Any const&, int, com::sun::star::uno::Any const&) () at scaddins/source/analysis/financial.cxx:62 #2 0x00007fcc75f2ec91 in gcc3::callVirtualMethod(void*, unsigned int, void*, _typelib_TypeDescriptionReference*, bool, unsigned long*, unsigned int, unsigned long*, double*) (pThis=0x36a5ab0, nVtableIndex=69, pRegisterReturn=0x7ffe39f01ee0, pReturnTypeRef=0x10889f0, bSimpleReturn=true, pStack=0x7ffe39f018e0, nStack=2, pGPR=0x7ffe39f01c20, pFPR=0x7ffe39f01be0) at bridges/source/cpp_uno/gcc3_linux_x86-64/callvirtualmethod.cxx:77 #3 0x00007fcc75f2d86c in cpp_call(bridges::cpp_uno::shared::UnoInterfaceProxy*, bridges::cpp_uno::shared::VtableSlot, _typelib_TypeDescriptionReference*, int, _typelib_MethodParameter*, void*, void**, _uno_Any**) (pThis=0x88cc450, aVtableSlot=..., pReturnTypeRef=0x10889f0, nParams=8, pParams=0x36b9ce0, pUnoReturn=0x7ffe39f01ee0, pUnoArgs=0x7ffe39f01e60, ppUnoExc=0x7ffe39f021d0) at bridges/source/cpp_uno/gcc3_linux_x86-64/uno2cpp.cxx:233 #4 0x00007fcc75f2cfc8 in unoInterfaceProxyDispatch(uno_Interface*, typelib_TypeDescription const*, void*, void**, uno_Any**) (pUnoI=0x88cc450, pMemberDescr=0x36b9bf0, pReturn=0x7ffe39f01ee0, pArgs=0x7ffe39f01e60, ppException=0x7ffe39f021d0) at bridges/source/cpp_uno/gcc3_linux_x86-64/uno2cpp.cxx:413 #5 0x00007fcc68a97f3a in stoc_corefl::(anonymous namespace)::IdlInterfaceMethodImpl::invoke(com::sun::star::uno::Any const&, com::sun::star::uno::Sequence<com::sun::star::uno::Any>&) (this=0x36cff90, rObj=uno::Any("com.sun.star.sheet.XAddIn": {<com::sun::star::lang::XLocalizable> = {<com::sun::star::uno::XInterface> = {_vptr$XInterface = 0x36a5aa0}, <No data fields>}, <No data fields>}), rArgs=uno::Sequence of length 8 = {...}) at stoc/source/corereflection/criface.cxx:672 #6 0x00007fcc68a98a07 in non-virtual thunk to stoc_corefl::(anonymous namespace)::IdlInterfaceMethodImpl::invoke(com::sun::star::uno::Any const&, com::sun::star::uno::Sequence<com::sun::star::uno::Any>&) () at stoc/source/corereflection/criface.cxx:566 #7 0x00007fcc6cf03569 in ScUnoAddInCall::ExecuteCallWithArgs(com::sun::star::uno::Sequence<com::sun::star::uno::Any>&) (this=0x7ffe39f02b28, rCallArgs=uno::Sequence of length 8 = {...}) at sc/source/core/tool/addincol.cxx:1399 #8 0x00007fcc6cf03392 in ScUnoAddInCall::ExecuteCall() (this=0x7ffe39f02b28) at sc/source/core/tool/addincol.cxx:1373 #9 0x00007fcc6d11f953 in ScInterpreter::ScExternal() (this=0x89d0210) at sc/source/core/tool/interpr4.cxx:3033 #10 0x00007fcc6d1289eb in ScInterpreter::Interpret() (this=0x89d0210) at sc/source/core/tool/interpr4.cxx:4435 #11 0x00007fcc6cd28404 in ScFormulaCell::InterpretTail(ScInterpreterContext&, ScFormulaCell::ScInterpretTailParameter) (this=0x67a9560, rContext=..., eTailParam=ScFormulaCell::SCITP_NORMAL) at sc/source/core/data/formulacell.cxx:1945 #12 0x00007fcc6cd261f0 in ScFormulaCell::Interpret(int, int) (this=0x67a9560, nStartOffset=-1, nEndOffset=-1) at sc/source/core/data/formulacell.cxx:1618 #13 0x00007fcc6c95e983 in lcl_EvalDirty(mdds::mtv::soa::multi_type_vector<mdds::mtv::custom_block_func3<mdds::mtv::default_element_block<52, svl::SharedString>, mdds::mtv::noncopyable_managed_element_block<53, EditTextObject>, mdds::mtv::noncopyable_managed_element_block<54, ScFormulaCell> >, sc::CellStoreTrait>&, int, int, ScDocument&, boost::intrusive_ptr<ScFormulaCellGroup> const&, bool, bool, bool&, bool&) (rCells=..., nRow1=17, nRow2=18, rDoc=..., mxGroup=..., bThreadingDepEval=false, bSkipRunning=true, bIsDirty=@0x7ffe39f047a7: true, bAllowThreading=@0x7ffe39f047a6: false) at sc/source/core/data/column4.cxx:1933 #14 0x00007fcc6c95e155 in ScColumn::EnsureFormulaCellResults(int, int, bool) (this=0x6780880, nRow1=17, nRow2=18, bSkipRunning=true) at sc/source/core/data/column4.cxx:1989 #15 0x00007fcc6cee5645 in ScTable::EnsureFormulaCellResults(short, int, short, int, bool) (this=0x347d040, nCol1=1, nRow1=17, nCol2=1, nRow2=18, bSkipRunning=true) at sc/source/core/data/table7.cxx:444 #16 0x00007fcc6cb02efb in ScDocument::EnsureFormulaCellResults(ScRange const&, bool) (this=0x3431260, rRange=..., bSkipRunning=true) at sc/source/core/data/document10.cxx:1010