[Bug 947558] Re: Document Viewer (evince) fails to display certain pages on pdf documents
Sebastien -- I'm the original reporter of his bug, and it no longer affects, so please feel free to mark it as closed. Thank you. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/947558 Title: Document Viewer (evince) fails to display certain pages on pdf documents To manage notifications about this bug go to: https://bugs.launchpad.net/evince/+bug/947558/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1448519] Re: Logitech K400 cannot type in LUKS passphrase at boot
Confirmed with Logitech MK270 and K400 keyboard + mouse combos on 3.19.0-51-generic SMP 64-bit. Axel Pospischil (apos)'s workaround seems to have solved the problem for me: https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1448519/comments/8 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1448519 Title: Logitech K400 cannot type in LUKS passphrase at boot To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1448519/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1033345] Re: Darktable colors & WB with NEX-C3 underexposed photos are much worse than with UFRaw
** Changed in: darktable (Ubuntu) Status: New => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1033345 Title: Darktable colors & WB with NEX-C3 underexposed photos are much worse than with UFRaw To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/darktable/+bug/1033345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1316247] [NEW] Calculator gives wrong answers after undo
Public bug reported: On a clean installation of Ubuntu 14.04, 64-bit. Steps to reproduce: 1. Open calculator and type "5000/60" followed by . The calculator produces the right answer, 83.333... 2. Type "/60" followed by to divide by 60 again. The calculator again produces the right answer, 1.388... 3. Press -Z to undo the last calculation. 4. Press twice to delete the last "60". 5. Type "12" followed by , to divide by 12 instead. The calculator gives me the wrong answer!!! See attached screenshot. ** Affects: gnome-calculator (Ubuntu) Importance: Undecided Status: New ** Attachment added: "Screenshots" https://bugs.launchpad.net/bugs/1316247/+attachment/4105780/+files/wrong.png ** Package changed: darktable (Ubuntu) => gnome-calculator (Ubuntu) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1316247 Title: Calculator gives wrong answers after undo To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/gnome-calculator/+bug/1316247/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956] [NEW] RATE function sometimes produces incorrect results!
Public bug reported: 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! 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. ** Affects: libreoffice (Ubuntu) Importance: Undecided Status: New -- 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: RATE function sometimes produces incorrect results! To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956] Re: RATE function sometimes produces incorrect results!
** Package changed: libreoffice (Ubuntu) => df-libreoffice ** Summary changed: - RATE function sometimes produces incorrect results! + LibreOffice Calc's RATE function sometimes produces incorrect results!!! -- 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 incorrect results!!! To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1150956/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 801403] Re: [MS-7593, Realtek ALC889, Green Headphone Out, Front] No automute HP -> Line out
David -- thanks. The new alsa-info is here: http://www.alsa-project.org/db/?f=38f3964aa142e95b0c56693746526d2e01526fcd And here's the output of `modinfo snd-hda-codec`: filename: /lib/modules/3.0.0-12-generic-pae/kernel/sound/pci/hda/snd-hda-codec.ko license:GPL description:HDA codec core srcversion: BA5B1C249A0167C0AD24825 depends:snd-pcm,snd,snd-hwdep vermagic: 3.0.0-12-generic-pae SMP mod_unload modversions 686 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/801403 Title: [MS-7593, Realtek ALC889, Green Headphone Out, Front] No automute HP -> Line out To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/alsa-driver/+bug/801403/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 801403] Re: [MS-7593, Realtek ALC889, Green Headphone Out, Front] No automute HP -> Line out
Hi David -- I just upgraded to 11.10 and this problem has resurfaced -- a regression. Any suggestions? ** Changed in: alsa-driver (Ubuntu) Status: Fix Released => New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/801403 Title: [MS-7593, Realtek ALC889, Green Headphone Out, Front] No automute HP -> Line out To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/alsa-driver/+bug/801403/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1033345] [NEW] Darktable results with underexposed photos much worse than plain-vanilla UFRaw with NEX-C3
Public bug reported: STEPS TO REPEAT: take an underexposed photo with a Sony NEX-C3 camera, import into darktable, and increase exposure (ev). The results are terrible. Open the same raw file with UFRaw, increase exposure by the same amount, and the results are good. The attached screenshot shows darktable and UFRaw processing the same photo after increasing exposure (ev). Upgrading to the stable PPA version of darktable does not solve this issue. ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: darktable 0.9.3-2ubuntu1 ProcVersionSignature: Ubuntu 3.2.0-27.43-generic 3.2.21 Uname: Linux 3.2.0-27-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.0.1-0ubuntu11 Architecture: amd64 Date: Sun Aug 5 22:04:49 2012 InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release amd64 (20111012) SourcePackage: darktable UpgradeStatus: Upgraded to precise on 2012-04-26 (101 days ago) ** Affects: darktable (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug precise running-unity -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1033345 Title: Darktable results with underexposed photos much worse than plain- vanilla UFRaw with NEX-C3 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/darktable/+bug/1033345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1033345] Re: Darktable results with underexposed photos much worse than plain-vanilla UFRaw with NEX-C3
** Attachment added: "Screenshot - darktable vs UFRaw" https://bugs.launchpad.net/bugs/1033345/+attachment/3249482/+files/NEX-C3-darktable-vs-ufraw.png -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1033345 Title: Darktable results with underexposed photos much worse than plain- vanilla UFRaw with NEX-C3 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/darktable/+bug/1033345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1033345] Re: Darktable results with underexposed photos much worse than plain-vanilla UFRaw with NEX-C3
Attached is the raw image with darktable's XMP file.?field.comment=Attached is the raw image with darktable's XMP file. ** Attachment added: "Raw file and its darktable xmp file" https://bugs.launchpad.net/ubuntu/+source/darktable/+bug/1033345/+attachment/3250137/+files/raw-image-with-xmp.zip ** Summary changed: - Darktable results with underexposed photos much worse than plain-vanilla UFRaw with NEX-C3 + Darktable colors & WB with NEX-C3 underexposed photos are much worse than with UFRaw -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1033345 Title: Darktable colors & WB with NEX-C3 underexposed photos are much worse than with UFRaw To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/darktable/+bug/1033345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 801403] Re: [MS-7593, Realtek ALC889, Green Headphone Out, Front] No automute HP -> Line out
David -- thank you. I understand and appreciate your being upfront and transparent. I'll try the latest drivers and will report back. -- PS. Note that this machine is a ZaReason Limbo 7110 -- http://zareason.com/shop/Limbo-7110.html -- so this bug might be affecting a meaningful number of (unsuspecting) users. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/801403 Title: [MS-7593, Realtek ALC889, Green Headphone Out, Front] No automute HP -> Line out To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/alsa-driver/+bug/801403/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 801403] Re: [MS-7593, Realtek ALC889, Green Headphone Out, Front] No automute HP -> Line out
David -- I tried to test the latest drivers for Oneiric by following the instructions here -- https://wiki.ubuntu.com/Audio/InstallingLinuxAlsaDriverModules -- but got the following error: "Failed to fetch http://ppa.launchpad.net /ubuntu-audio-dev/ppa/ubuntu/dists/oneiric/main/source/Sources 404 Not Found." Suggestions? -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/801403 Title: [MS-7593, Realtek ALC889, Green Headphone Out, Front] No automute HP -> Line out To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/alsa-driver/+bug/801403/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 801403] Re: [MS-7593, Realtek ALC889, Green Headphone Out, Front] No automute HP -> Line out
UPDATE: After the last update and reboot, this is working fine for me, so I'm marking it as "Fix Released." ** Changed in: alsa-driver (Ubuntu) Status: Incomplete => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/801403 Title: [MS-7593, Realtek ALC889, Green Headphone Out, Front] No automute HP -> Line out To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/alsa-driver/+bug/801403/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41774] Re: Gksudo password prompt mangled onscreen when Caps Lock is on
Thanks. This has not been an issue for me for a long time... I'll mark as fix released. ** Changed in: gksu (Ubuntu) Status: Incomplete => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to the bug report. https://bugs.launchpad.net/bugs/41774 Title: Gksudo password prompt mangled onscreen when Caps Lock is on To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/gksu/+bug/41774/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 947558] [NEW] Document Viewer (evince) fails to display certain pages on pdf documents
Public bug reported: It happens only with some documents. Did not happen prior to 11.10. Attached screenshot shows same PDF document as displayed by Document Viewer (evince) on the left, and as displayed by Adobe Reader on the right. Here's an example: http://www.siv.gov.do/docs/Prospectos/SIVEM-065-PC0112-I-II-III.pdf Evince displays only the odd pages of this document correctly; Adobe Reader displays all pages correctly. ProblemType: Bug DistroRelease: Ubuntu 11.10 Package: evince 3.2.1-0ubuntu2.2 ProcVersionSignature: Ubuntu 3.0.0-16.28-generic 3.0.17 Uname: Linux 3.0.0-16-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 1.23-0ubuntu4 Architecture: amd64 Date: Mon Mar 5 17:13:24 2012 InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release amd64 (20111012) KernLog: SourcePackage: evince UpgradeStatus: No upgrade log present (probably fresh install) ** Affects: evince (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug oneiric running-unity -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/947558 Title: Document Viewer (evince) fails to display certain pages on pdf documents To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/evince/+bug/947558/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 947558] Re: Document Viewer (evince) fails to display certain pages on pdf documents
** Attachment added: "Evince on the left, Adobe Reader on the right" https://bugs.launchpad.net/bugs/947558/+attachment/2819640/+files/screenshot--evince-versus-adobe-reader.png -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/947558 Title: Document Viewer (evince) fails to display certain pages on pdf documents To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/evince/+bug/947558/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 943494] Re: Login screen shows corrupted fragments of prior user's session on dual-screen setup with proprietary nvidia drivers
** Attachment added: "Photo of login screen corruption" https://bugs.launchpad.net/bugs/943494/+attachment/2794762/+files/photo.jpg -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/943494 Title: Login screen shows corrupted fragments of prior user's session on dual-screen setup with proprietary nvidia drivers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/xorg/+bug/943494/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 943494] [NEW] Login screen shows corrupted fragments of prior user's session on dual-screen setup with proprietary nvidia drivers
Public bug reported: See attached photo. The login screen is showing screen fragments of the prior user's session -- which could contain sensitive or private information. This happens only very rarely, after prolonged multi-day use. Logging in and out gets rid of the problem. ProblemType: Bug DistroRelease: Ubuntu 11.10 Package: xorg 1:7.6+7ubuntu7.1 ProcVersionSignature: Ubuntu 3.0.0-16.28-generic 3.0.17 Uname: Linux 3.0.0-16-generic x86_64 NonfreeKernelModules: nvidia .proc.driver.nvidia.gpus.0: Error: [Errno 21] Is a directory: '/proc/driver/nvidia/gpus/0' .proc.driver.nvidia.registry: Binary: "" .proc.driver.nvidia.version: NVRM version: NVIDIA UNIX x86_64 Kernel Module 280.13 Wed Jul 27 16:53:56 PDT 2011 GCC version: gcc version 4.6.1 (Ubuntu/Linaro 4.6.1-9ubuntu3) .tmp.unity.support.test.0: ApportVersion: 1.23-0ubuntu4 Architecture: amd64 CompizPlugins: [core,bailer,detection,composite,opengl,decor,mousepoll,compiztoolbox,imgpng,snap,vpswitch,move,resize,unitymtgrabhandles,gnomecompat,wall,grid,regex,place,animation,session,workarounds,expo,fade,scale,ezoom,unityshell] CompositorRunning: compiz Date: Wed Feb 29 13:50:40 2012 DistUpgraded: Fresh install DistroCodename: oneiric DistroVariant: ubuntu DkmsStatus: nvidia-current, 280.13, 3.0.0-12-generic, x86_64: installed nvidia-current, 280.13, 3.0.0-16-generic, x86_64: installed virtualbox, 4.1.2, 3.0.0-12-generic, x86_64: installed virtualbox, 4.1.2, 3.0.0-16-generic, x86_64: installed GraphicsCard: nVidia Corporation GF106 [GeForce 450 GTS] [10de:0dc4] (rev a1) (prog-if 00 [VGA controller]) Subsystem: Micro-Star International Co., Ltd. Device [1462:2360] InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release amd64 (20111012) JockeyStatus: xorg:nvidia_current - NVIDIA accelerated graphics driver (Proprietary, Enabled, In use) xorg:nvidia_current_updates - NVIDIA accelerated graphics driver (post-release updates) (Proprietary, Disabled, Not in use) MachineType: MSI MS-7593 ProcKernelCmdLine: BOOT_IMAGE=/boot/vmlinuz-3.0.0-16-generic root=UUID=c628fd7c-55fe-46e7-931b-dfdb979e054f ro quiet splash vt.handoff=7 SourcePackage: xorg Symptom: display UpgradeStatus: No upgrade log present (probably fresh install) dmi.bios.date: 04/28/2010 dmi.bios.vendor: American Megatrends Inc. dmi.bios.version: V3.6 dmi.board.asset.tag: To Be Filled By O.E.M. dmi.board.name: MSI X58M (MS-7593) dmi.board.vendor: MSI dmi.board.version: 1.0 dmi.chassis.asset.tag: To Be Filled By O.E.M. dmi.chassis.type: 3 dmi.chassis.vendor: MICRO-STAR INTERNATIONAL CO.,LTD dmi.chassis.version: 1.0 dmi.modalias: dmi:bvnAmericanMegatrendsInc.:bvrV3.6:bd04/28/2010:svnMSI:pnMS-7593:pvr1.0:rvnMSI:rnMSIX58M(MS-7593):rvr1.0:cvnMICRO-STARINTERNATIONALCO.,LTD:ct3:cvr1.0: dmi.product.name: MS-7593 dmi.product.version: 1.0 dmi.sys.vendor: MSI version.compiz: compiz 1:0.9.6+bzr20110929-0ubuntu6.1 version.ia32-libs: ia32-libs 20090808ubuntu26 version.libdrm2: libdrm2 2.4.26-1ubuntu1 version.libgl1-mesa-dri: libgl1-mesa-dri 7.11-0ubuntu3 version.libgl1-mesa-dri-experimental: libgl1-mesa-dri-experimental N/A version.libgl1-mesa-glx: libgl1-mesa-glx 7.11-0ubuntu3 version.nvidia-graphics-drivers: nvidia-graphics-drivers N/A version.xserver-xorg: xserver-xorg 1:7.6+7ubuntu7.1 version.xserver-xorg-input-evdev: xserver-xorg-input-evdev 1:2.6.0-1ubuntu13 version.xserver-xorg-video-ati: xserver-xorg-video-ati 1:6.14.99~git20110811.g93fc084-0ubuntu1 version.xserver-xorg-video-intel: xserver-xorg-video-intel 2:2.15.901-1ubuntu2.1 version.xserver-xorg-video-nouveau: xserver-xorg-video-nouveau 1:0.0.16+git20110411+8378443-1 ** Affects: xorg (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug compiz-0.9 corruption oneiric patch running-unity ubuntu -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/943494 Title: Login screen shows corrupted fragments of prior user's session on dual-screen setup with proprietary nvidia drivers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/xorg/+bug/943494/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 943494] Re: Login screen shows corrupted fragments of prior user's session on dual-screen setup with proprietary nvidia drivers
** Tags added: lightdm -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/943494 Title: Login screen shows corrupted fragments of prior user's session on dual-screen setup with proprietary nvidia drivers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/xorg/+bug/943494/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956]
Created attachment 80500 Test files for edge cases of RATE function (ODS and CSV) The attached .tar.gz archive contains (1) an ODF file that produces bad results on edge cases with the RATE() function and (2) a CSV version of the same file but with only correct results. I'm the author of both files and hereby license them jointly under MPL and LGPL. Please let me know if this suffices. -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956]
I'm the original reporter of the bug on Launchpad. This bug looks critical to me, because it can directly lead to financial losses from incorrect rate-of-return calculations in spreadsheets. Let me explain the severity of the bug with an example. If one invests, say, $250 today in exchange for receiving an annual payment of $35 forever in perpetuity, the annual return will be 35/250 = 0.14, or 14%/year.[1] Now imagine that instead of receiving the annual payments of $35 in perpetuity, one will receive them only for a fixed number of years. In this case, the rate of return will necessarily be lower than 14%/year. The lower the number of years, the lower the rate of return; the greater the number of years, the closer to 14%/year the rate of return will be. Indeed, the rate of return asymptotically approaches 14%/year as the number of years increases to infinity.[2] This is *exactly* what I get in other spreadsheet programs, but NOT in LibreOffice. For example, when I try these formulas in Google Spreadsheets, the results asymptotically approach 14%: =RATE(10, 35, -250, 0) returns 0.06637326 =RATE(20, 35, -250, 0) returns 0.12724192 =RATE(30, 35, -250, 0) returns 0.13702841 =RATE(40, 35, -250, 0) returns 0.13923873 =RATE(50, 35, -250, 0) returns 0.13979829 =RATE(60, 35, -250, 0) returns 0.13994592 =RATE(70, 35, -250, 0) returns 0.13998544 =RATE(80, 35, -250, 0) returns 0.13999607 =RATE(90, 35, -250, 0) returns 0.13999894 =RATE(100, 35, -250, 0) returns 0.1371 When I try those formulas in LibreOffice, many of the answers are nonsensical! It would be better for LibreOffice to return an error than an incorrect number! -- [1] See formula in http://en.wikipedia.org/wiki/Time_value_of_money#Present_value_of_a_perpetuity [2] See explanation in http://en.wikipedia.org/wiki/Time_value_of_money -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956]
Christopher: To see the results asymptotically approaching 0.14, increase the number of periods, not the annuity payment (in other words, keep the annuity payment at 35) -- i.e., =RATE([change this number],35,-250,0). As I wrote above, returning an error is a *lot* better than returning the wrong number, because the RATE() function is used only for financial calculations. When there's money on the line, a non-working spreadsheet that reports an error is better than a working one that gives the user a bad answer. I would NOT have reported this bug if LibreOffice had returned an error. -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces incorrect results!!!
Christopher -- sure. I just tried this on Google Drive's Spreadsheet and on Microsoft Excel: =RATE(50,35,-250,0) The result in both cases is approximately 0.1398. When I try the same formula in LibreOffice, I get a nonsensical answer. (I sure hope no one out there is using this function to calculate important financial figures!) I'm using LibreOffice 3.5.7.2 Build ID: 350m1(Build:2) on Ubuntu 12.04 64-bit. Hope this is helpful. -- 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 incorrect results!!! To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces incorrect results!!!
Christopher: > What specific version of Excel? Excel 2003 on a Windows XP VM under VirtualBox. To get the answer, you must enable iterative calculations, increase the number of iterations, and lower the maximum change per iteration. Otherwise you will get the #NUM! error. > Unfortunately, this was not a different, exact command Try these, then: =RATE(50,36,-250,0) =RATE(50,37,-250,0) =RATE(50,38,-250,0) =RATE(50,39,-250,0) =RATE(50,40,-250,0) These RATE functions are supposed to return the internal rate of return of investing -250 in exchange for receiving a recurring payiment of respectively 36, 37, 38, 39, and 40 per period for a total of 50 periods, with no payment at the end. LibreOffice returns a nonsensical answer in ALL of these cases!!! -- 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 incorrect results!!! To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces incorrect results!!!
PS. It would be a LOT better if LibreOffice returned a #NUM! error instead of an incorrect number. -- 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 incorrect results!!! To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces incorrect results!!!
I really don't know what else to tell you... Did you try them in Google Spreadsheets? -- 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 incorrect results!!! To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1150956/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office
Björn: thank you for upstreaming it. Let me try and explain why LibreOffice returning -1.9474... as the result of =RATE(50,35,-250,0) is really a *very* bad thing, and should be marked as a CRITICAL bug. I''ll try to provide an intuitive explanation without delving into too much math. Let's start with the simplest example. If you invest $250 today in exchange for receiving an annual payment of $35 *forever in perpetuity*, your annual return will be 35/250 = 0.14, or 14%/year. You can see that the formula for a perpetual annuity is Present Value = Annuity / Rate; hence Rate = Annuity / Present Value) in lots of websites. Here's the Wikipedia page on it: http://en.wikipedia.org/wiki/Time_value_of_money#Present_value_of_a_perpetuity Now imagine that instead of receiving the annual payments of $35 in perpetuity, you will receive them only for a fixed number of years. In this case, your annual return will necessarily be lower than 14%/year. The greater the number of years, the closer to 14%/year your annual rate of return will be. Specifically, your internal rate of return will asymptotically approach 14%/year as the number of years during which you will receive the annual payments increases to infinity. This is ***EXACTLY*** what I get in other spreadsheet programs, but NOT in LibreOffice. IT'S MATH. Since you guys are having problems with Excel, try these formulas in Google Spreadsheets, and you will see how the results asymptotically approach 14%: RATE(10, 35, -250, 0) returns 0.06637326 RATE(20, 35, -250, 0) returns 0.12724192 RATE(30, 35, -250, 0) returns 0.13702841 RATE(40, 35, -250, 0) returns 0.13923873 RATE(50, 35, -250, 0) returns 0.13979829 RATE(60, 35, -250, 0) returns 0.13994592 RATE(70, 35, -250, 0) returns 0.13998544 RATE(80, 35, -250, 0) returns 0.13999607 RATE(90, 35, -250, 0) returns 0.13999894 RATE(100, 35, -250, 0) returns 0.1371 Then go and try those formulas in LibreOffice. As I wrote before, returning an error would be a *LOT* better than the wrong number!!! -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1150956] Re: LibreOffice Calc's RATE function sometimes produces different results as some versions of MS Office
Björn: will do. Sorry if my comment was too long or had too much info. Thank you so much for your help! -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 800836] Re: Screen corruption upon login using dual monitors with Nvidia Twinview
Bryce -- thank you. I can confirm this is fixed in 11.10, which I'm using exclusively now. Please feel free to close this bug (I don't think it would be right for me to do it, because it affects two other people who may still be on 11.04). -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/800836 Title: Screen corruption upon login using dual monitors with Nvidia Twinview To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/nvidia-graphics-drivers/+bug/800836/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs