RE: [Bug 420614] [NEW] Bug on OpenOffice Calc Financial Calculator Formulas gives wrong value to Interest Rate Calc

2009-08-29 Thread Fernando

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 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

RE: [Bug 420614] [NEW] Bug on OpenOffice Calc Financial Calculator Formulas gives wrong value to Interest Rate Calc

2009-08-29 Thread Fernando

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