** Description changed: - STEPS TO REPRODUCE: Type "=RATE(50,35,-250,0)" on any cell, and press Enter. - The result should be 0.1398, but LibreOffice shows -1.9474! + The result should be 0.1398, but LibreOffice shows -1.9474! - ADDITIONAL INFORMATION: - I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu 12.04, 64-bit version, with up-to-date packages. + I'm using LibreOffice 3.5.7.2, Build ID: 350m1(Build:2), on Ubuntu + 12.04, 64-bit version, with up-to-date packages. + + Reproducible in Raring. + + WORKAROUND: Use Gnumeric. + apt-cache policy gnumeric + gnumeric: + Installed: 1.12.1-1ubuntu1 + Candidate: 1.12.1-1ubuntu1 + Version table: + *** 1.12.1-1ubuntu1 0 + 500 http://archive.ubuntu.com/ubuntu/ raring/universe i386 Packages + 100 /var/lib/dpkg/status
** Tags added: amd64 i386 precise raring -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1150956 Title: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1150956/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
