See a HP12C emulator to test formulas for OpenOffice Calc
http://www.epx.com.br/ctb/hp12c.php
> Date: Sat, 29 Aug 2009 12:26:32 +
> From: fernando_sto...@hotmail.com
> To: fernando_sto...@hotmail.com
> Subject: RE: [Bug 420614] [NEW] Bug on OpenOffice Calc Financial
> Calculator Formulas gives wrong value to Interest Rate Calc
>
>
> See other exemple attached.
> Financial Calculation for "i" with following data: nper = 1000; pv = -2000;
> fv = 0; pmt = 600; type = 1 and other with type = 0; estimation = 0% and
> estimation = 100%.
>
> > Date: Fri, 28 Aug 2009 16:14:48 +
> > From: fernando_sto...@hotmail.com
> > To: fernando_sto...@hotmail.com
> > Subject: [Bug 420614] [NEW] Bug on OpenOffice Calc Financial Calculator
> > Formulas gives wrong value to Interest Rate Calc
> >
> > Public bug reported:
> >
> > Binary package hint: openoffice.org
> >
> > When I try to calc the interest rate from data bellow, I get wrong answer
> > to i = -185,49%
> > to nper = 12; fv = 0; pv = -1500; pmt = 500; type = 0; estimation = 0%.
> > But when I change estimation from 0% to 100% I get the write answer i =
> > 32,16%.
> > I know that both in mathematics the data above has two solutions and both
> > answers solve the same data problem.
> > But, with my HP 12 C, I do not need to worry about that because it always
> > gives me the wright answer.
> >
> > ProblemType: Bug
> > Architecture: amd64
> > DistroRelease: Ubuntu 9.04
> > Package: openoffice.org-core 1:3.0.1-9ubuntu3
> > ProcEnviron:
> > PATH=(custom, no user)
> > LANG=pt_BR.UTF-8
> > SHELL=/bin/bash
> > SourcePackage: openoffice.org
> > Uname: Linux 2.6.28-15-generic x86_64
> >
> > ** Affects: openoffice.org (Ubuntu)
> > Importance: Undecided
> > Status: New
> >
> >
> > ** Tags: amd64 apport-bug
> >
> > --
> > Bug on OpenOffice Calc Financial Calculator Formulas gives wrong value to
> > Interest Rate Calc
> > https://bugs.launchpad.net/bugs/420614
> > You received this bug notification because you are a direct subscriber
> > of the bug.
> >
> > Status in “openoffice.org” package in Ubuntu: New
> >
> > Bug description:
> > Binary package hint: openoffice.org
> >
> > When I try to calc the interest rate from data bellow, I get wrong answer
> > to i = -185,49%
> > to nper = 12; fv = 0; pv = -1500; pmt = 500; type = 0; estimation = 0%.
> > But when I change estimation from 0% to 100% I get the write answer i =
> > 32,16%.
> > I know that both in mathematics the data above has two solutions and both
> > answers solve the same data problem.
> > But, with my HP 12 C, I do not need to worry about that because it always
> > gives me the wright answer.
> >
> > ProblemType: Bug
> > Architecture: amd64
> > DistroRelease: Ubuntu 9.04
> > Package: openoffice.org-core 1:3.0.1-9ubuntu3
> > ProcEnviron:
> > PATH=(custom, no user)
> > LANG=pt_BR.UTF-8
> > SHELL=/bin/bash
> > SourcePackage: openoffice.org
> > Uname: Linux 2.6.28-15-generic x86_64
>
> _
> Deixe suas conversas mais divertidas. Baixe agora mesmo novos emoticons. É
> grátis!
> http://specials.br.msn.com/ilovemessenger/pacotes.aspx
>
> ** Attachment added: "Bug_OpenOffice_Calc.ods"
>http://launchpadlibrarian.net/30966130/Bug_OpenOffice_Calc.ods
>
> --
> Bug on OpenOffice Calc Financial Calculator Formulas gives wrong value to
> Interest Rate Calc
> https://bugs.launchpad.net/bugs/420614
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “openoffice.org” package in Ubuntu: New
>
> Bug description:
> Binary package hint: openoffice.org
>
> When I try to calc the interest rate from data bellow, I get wrong answer to
> i = -185,49%
> to nper = 12; fv = 0; pv = -1500; pmt = 500; type = 0; estimation = 0%.
> But when I change estimation from 0% to 100% I get the write answer i =
> 32,16%.
> I know that both in mathematics the data above has two solutions and both
> answers solve the same data problem.
> But, with my HP 12 C, I do not need to worry about that because it always
> gives me the wright answer.
>
> ProblemType: Bug
> Architecture: amd64
> DistroRelease: Ubuntu 9.04
> Package: openoffice.org-core 1:3.0.1-9ubuntu3
> ProcEnviron:
> PATH=(custom, no user)
> LANG=pt_BR.UTF-8
> SHELL=/bin/bash
> SourcePackage: openoffice.org
> Uname: Linux 2.6.28-15-generic x86_64
_
Conheça os novos produtos Windows Live! Clique aqui.
http://www.windowslive.com.br
--
Bug on OpenOffice Calc Financial Calculator Formulas gives wrong value to
Interest Rate Calc
https://bugs.launchpad.net/bugs/420614
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
