[Bug 340051] Re: [upstream] Calc precision error subtracting 3 integers
Confirmed fixed in Version: 6.1.3.2 (x64). Upstream advised fixed since 5.3 as per https://bugs.documentfoundation.org/show_bug.cgi?id=37923#c17 . ** Bug watch added: Document Foundation Bugzilla #37923 https://bugs.documentfoundation.org/show_bug.cgi?id=37923 ** Changed in: libreoffice (Ubuntu) Status: Triaged => 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/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051]
Robinson Tryon, thanks for your comment. The scope here is precision parity with Excel for this one situation. BTW, now the report allows one to set the Status to NEW. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051]
(In reply to Christopher M. Penalver from comment #14) Unfortunately, NEW is not an available Status NEW makes sense if it's possible/likely to get fixed. My guess is that most Calc devs are going to punt on it, at best. UNCONFIRMED doesn't apply I don't like to see bugs sitting in UNCONFIRMED permanently, but I haven't seen the case made for this bug yet. It's unclear to me that (aside from docs) there is some code to write here. as it's more than confirmed up and downstream, so it's REOPENED. REOPENED is a very specific state that covers bugs that have been patched/marked as FIXED by a dev, and then have been reopened because the fix didn't work or was incomplete. That's not the case here. I'm fine with this remaining open as a lowest priority enhancement request, given the scope of this report is narrow and well defined, in that it's not increase precision on everything, but an Excel calcuation parity request in a well defined case as noted in the Description, and downstream. As Markus noted, this is a pretty small component of compatibility. We're not talking about the difference between, say, 10k and 500k rows, we're talking about some nuances of floating-point math when operating on HUGE (or incredibly *small*) numbers. As well, this not being a high priority issue is both expected and understandable. However, being able to seemlessly exchange documents between colleagues using Excel, without the hassle of having to WORKAROUND compatibility issues would be fair here. Especially in light of how compatibility is a focus of the project - http://www.libreoffice.org/discover/libreoffice/ : LibreOffice is compatible with many document formats such as Microsoft® Word, Excel... LibreOffice and MS-Office will never be 100% perfectly compatible. Things like 'seamless' compatibility will be difficult when there are fonts that ship with MS-Office that we aren't legally allowed to distribute, let alone nuances in the implementation of floating-point arithmetic ;-) If you're looking for precision regarding big or small number arithmetic like this, I think that something like Sage or Octave would be an appropriate software package to use. Despite this, I've placed myself as the QA contact if you would have further questions on the scope of this report. Making yourself the QA Contact is great, but I remain skeptical that any dev will pick this up. In fact, Markus explained the problem pretty well: The only solution would be to use exact numbers instad of floating point numbers, but this will have even bigger performance impact. It's pretty clear to me that Markus doesn't think that we should trade performance for increased decimal place precision, and I'm inclined to trust his judgment. I still think this bug should be marked as a dupe and become a documented limitation of LO. Question: What's you goal here? Do you want to match the behavior of Excel, or just increase the precision of these calculations? The former seems more doable than the latter. (please change status back to 'UNCONFIRMED' after you leave a comment) Status - NEEDINFO -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051]
Robinson Tryon, thank you for your comment. I'm fine with this remaining open as a lowest priority enhancement request, given the scope of this report is narrow and well defined, in that it's not increase precision on everything, but an Excel calcuation parity request in a well defined case as noted in the Description, and downstream. As well, this not being a high priority issue is both expected and understandable. However, being able to seemlessly exchange documents between colleagues using Excel, without the hassle of having to WORKAROUND compatibility issues would be fair here. Especially in light of how compatibility is a focus of the project - http://www.libreoffice.org/discover/libreoffice/ : LibreOffice is compatible with many document formats such as Microsoft® Word, Excel... Unfortunately, NEW is not an available Status, and UNCONFIRMED doesn't apply as it's more than confirmed up and downstream, so it's REOPENED. Despite this, I've placed myself as the QA contact if you would have further questions on the scope of this report. Thank you for your understanding. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051]
(In reply to Markus Mohrhard from comment #7) @christopher I still don't think that this is really a bug, we just behave a bit different than excel. I suppose there will always be some differences between calc and excel and not all are bugs. If we're not going to regard this as a bug, I think that loss of precision different behavior from Excel = a good candidate for documentation. *** This bug has been marked as a duplicate of bug 67026 *** -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051] Re: [upstream] Calc precision error subtracting 3 integers
** Changed in: df-libreoffice Status: New = Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051]
*** Bug 67026 has been marked as a duplicate of this bug. *** -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051]
Never confirmed by QA team - moving to UNCONFIRMED. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051] Re: [upstream] Calc precision error subtracting 3 integers
** Changed in: df-libreoffice Status: Confirmed = New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051]
*** Bug 78447 has been marked as a duplicate of this bug. *** -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051]
Summary edited for clarity. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051]
*** Bug 39293 has been marked as a duplicate of this bug. *** -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051] Re: [upstream] Calc precision error subtracting 3 integers
Launchpad has imported 8 comments from the remote bug at https://bugs.freedesktop.org/show_bug.cgi?id=37923. If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. On 2011-06-04T07:57:28+00:00 Christopher M. Penalver wrote: Created attachment 47525 openoffice.summation.bug.ods Downstream bug may be found at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/340051 1) lsb_release -rd Description: Ubuntu 11.04 Release: 11.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.3.2-1ubuntu5 Candidate: 1:3.3.2-1ubuntu5 Version table: *** 1:3.3.2-1ubuntu5 0 500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages 100 /var/lib/dpkg/status 1:3.3.2-1ubuntu4 0 500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages 3) What is expected to happen in LibreOffice Calc via the Terminal: cd ~/Desktop wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/340051/+attachment/486207/+files/openoffice.summation.bug.ods localc openoffice.summation.bug.ods is that cell A1=806515533049393 cell B1=1 cell C1=806515533049393 and cell D1=A1-B1-C1=-1. 4) What happens instead is cell D1 is 0. Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/340051/comments/3 On 2011-06-04T08:40:19+00:00 Markus Mohrhard wrote: Hello Christopher, this is not a bug but a mathematical problem. Subtracting two nearly identical numbers is an ill-conditioned problem.http://en.wikipedia.org/wiki/Condition_number It's problem that every program using floating point numbers has and that can't really be solved. Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/340051/comments/4 On 2011-06-04T09:47:02+00:00 Christopher M. Penalver wrote: (In reply to comment #1) Hello Christopher, this is not a bug but a mathematical problem. Subtracting two nearly identical numbers is an ill-conditioned problem.http://en.wikipedia.org/wiki/Condition_number It's problem that every program using floating point numbers has and that can't really be solved. Markus, thank you for quickly taking a look at this. It is agreed this issue is not an easy one to deal with, and more an issue of how accurate is it? versus is it 100% accurate or not?. However, this was marked as a bug because both Excel and Gnumeric correctly yield -1. Looks like a great opportunity to improve LO! :) Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/340051/comments/5 On 2011-06-04T14:04:53+00:00 Markus Mohrhard wrote: Hello Christopher, sure it's annoying but if you try with for example Excel the limit is just a bit higher. Try with 1126515533121300 and 1. I'm really surprised that we have this problem a bit earlier but I don't think it is something we should worry about. There is no real possibility to resolve the general problem. So in my opinion this is annoying but we should not try to fix it. The only solution would be to use exact numbers instad of floating point numbers, but this will have even bigger performance impact. Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/340051/comments/6 On 2011-06-04T23:10:51+00:00 Christopher M. Penalver wrote: (In reply to comment #3) Hello Christopher, sure it's annoying but if you try with for example Excel the limit is just a bit higher. Try with 1126515533121300 and 1. I'm really surprised that we have this problem a bit earlier but I don't think it is something we should worry about. Markus, thank you for your discussion on this issue. As I have been focused on upstreaming Ubuntu bugs, my standard for downstream triaging has been What occurs in Excel in the same circumstance? Viewing it this way, ones expectation for this issue is that LO, at least, matches the precision of Excel. Anything more precise than Excel, at best, is an ENHANCEMENT request. There is no real possibility to resolve the general problem. So in my opinion this is annoying but we should not try to fix it. The only solution would be to use exact numbers instad of floating point numbers, but this will have even bigger performance impact. Regarding exact numbers v. floating point this is outside my area of expertise so I defer to your and the communities position as to if, how, and when to move forward on that. Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/340051/comments/7
[Bug 340051] Re: [upstream] Calc precision error subtracting 3 integers
** Changed in: openoffice.org (Ubuntu) Status: Triaged = Won't Fix -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051] migrating packaging from OpenOffice.org to Libreoffice
[This is an automated message.] There are no new official OpenOffice.org releases in Ubuntu packaging anymore = Won't Fix If the problem persists, please mark this bug as also affects project Libreoffice or also affects distribution Libreoffice (Ubuntu) if that has not happened already. Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051] Re: [upstream] Calc precision error subtracting 3 integers
** Changed in: openoffice.org (Ubuntu) Importance: Medium = Low -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051] Re: [upstream] Calc precision error subtracting 3 integers
** Changed in: df-libreoffice Importance: Medium = Wishlist -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051] Re: [upstream] Calc precision error subtracting 3 integers
** Changed in: df-libreoffice Status: Invalid = Confirmed ** Changed in: df-libreoffice Importance: High = Medium -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051] Re: [upstream] Calc precision error subtracting 3 integers
** Changed in: df-libreoffice Status: Confirmed = Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/340051/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051] Re: [upstream] Sum error when using three cells and a large #.
** Also affects: libreoffice (Ubuntu) Importance: Undecided Status: New ** Summary changed: - [upstream] Sum error when using three cells and a large #. + [upstream] Calc precision error subtracting 3 integers ** Description changed: Binary package hint: openoffice.org - Cell A1=806515533049393 - Cell B1=1 - Cell C1=806515533049393 - Cell D1=A1-B1-C1=0 + 1) lsb_release -rd + Description: Ubuntu 11.04 + Release: 11.04 - If the contents of B1 and C1 are swapped, the correct answer of -1 is - given. + 2) apt-cache policy libreoffice-calc + libreoffice-calc: + Installed: 1:3.3.2-1ubuntu5 + Candidate: 1:3.3.2-1ubuntu5 + Version table: + *** 1:3.3.2-1ubuntu5 0 + 500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages + 100 /var/lib/dpkg/status + 1:3.3.2-1ubuntu4 0 + 500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages - OpenOffice 2.4.1 on x86 Ubuntu 8.10 Intrepid Ibex. This error did not - occur when performing the same numerical calculation in the bash shell: - echo $((a-1-a)). + 3) What is expected to happen in LibreOffice Calc via the Terminal: + + cd ~/Desktop wget + https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/340051/+attachment/486207/+files/openoffice.summation.bug.ods + localc openoffice.summation.bug.ods + + is that cell A1=806515533049393 cell B1=1 cell C1=806515533049393 and + cell D1=A1-B1-C1=-1. + + 4) What happens instead is cell D1 is 0. + + WORKAROUND: Use Gnumeric. + + apt-cache policy gnumeric + gnumeric: + Installed: 1.10.13-1ubuntu1 + Candidate: 1.10.13-1ubuntu1 + Version table: + *** 1.10.13-1ubuntu1 0 + 500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages + 100 /var/lib/dpkg/status + + WORKAROUND: If the contents of B1 and C1 are swapped, the correct answer + of -1 is given. + + Original Reporter comments: OpenOffice 2.4.1 on x86 Ubuntu 8.10 Intrepid + Ibex. This error did not occur when performing the same numerical + calculation in the bash shell: echo $((a-1-a)). ProblemType: Bug Architecture: i386 DistroRelease: Ubuntu 8.10 NonfreeKernelModules: nvidia Package: openoffice.org-core 1:2.4.1-11ubuntu2.1 ProcEnviron: - PATH=/usr/lib/openoffice/program:/home/username/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/opt/real/RealPlayer - LANG=en_CA.UTF-8 - SHELL=/bin/bash + PATH=/usr/lib/openoffice/program:/home/username/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/opt/real/RealPlayer + LANG=en_CA.UTF-8 + SHELL=/bin/bash SourcePackage: openoffice.org Uname: Linux 2.6.27-11-generic i686 ** Tags added: lo33 ** Changed in: libreoffice (Ubuntu) Importance: Undecided = Medium ** Changed in: libreoffice (Ubuntu) Status: New = Triaged -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051] Re: [upstream] Calc precision error subtracting 3 integers
** Bug watch added: freedesktop.org Bugzilla #37923 http://bugs.freedesktop.org/show_bug.cgi?id=37923 ** Also affects: df-libreoffice via http://bugs.freedesktop.org/show_bug.cgi?id=37923 Importance: Unknown Status: Unknown -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051] Re: [upstream] Calc precision error subtracting 3 integers
** Changed in: df-libreoffice Status: Unknown = Confirmed ** Changed in: df-libreoffice Importance: Unknown = High -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/340051 Title: [upstream] Calc precision error subtracting 3 integers -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 340051] Re: [upstream] Sum error when using three cells and a large #.
** Tags added: intrepid -- [upstream] Sum error when using three cells and a large #. https://bugs.launchpad.net/bugs/340051 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
[Bug 340051] Re: [upstream] Sum error when using three cells and a large #.
** Changed in: openoffice Bugwatch: OpenOffice.org Issue Tracker #100439 = OpenOffice.org Issue Tracker #69749 Status: Confirmed = Unknown -- [upstream] Sum error when using three cells and a large #. https://bugs.launchpad.net/bugs/340051 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
[Bug 340051] Re: [upstream] Sum error when using three cells and a large #.
** Changed in: openoffice Status: Unknown = In Progress -- [upstream] Sum error when using three cells and a large #. https://bugs.launchpad.net/bugs/340051 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
[Bug 340051] Re: [upstream] Sum error when using three cells and a large #.
** Bug watch added: OpenOffice.org Issue Tracker #100439 http://qa.openoffice.org/issues/show_bug.cgi?id=100439 ** Changed in: openoffice Importance: Undecided = Unknown Bugwatch: None = OpenOffice.org Issue Tracker #100439 Status: New = Unknown -- [upstream] Sum error when using three cells and a large #. https://bugs.launchpad.net/bugs/340051 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
[Bug 340051] Re: [upstream] Sum error when using three cells and a large #.
** Changed in: openoffice Status: Unknown = Confirmed -- [upstream] Sum error when using three cells and a large #. https://bugs.launchpad.net/bugs/340051 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
[Bug 340051] Re: Sum error when using three cells and a large #.
This works on Excel but does not work on official OOo 3.0.1, so this bug needs to be sent upstream. Thanks, Chris ** Changed in: openoffice.org (Ubuntu) Importance: Undecided = Medium Status: New = Triaged ** Also affects: openoffice Importance: Undecided Status: New ** Summary changed: - Sum error when using three cells and a large #. + [upstream] Sum error when using three cells and a large #. -- [upstream] Sum error when using three cells and a large #. https://bugs.launchpad.net/bugs/340051 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
[Bug 340051] [NEW] Sum error when using three cells and a large #.
Public bug reported: Binary package hint: openoffice.org Cell A1=806515533049393 Cell B1=1 Cell C1=806515533049393 Cell D1=A1-B1-C1=0 If the contents of B1 and C1 are swapped, the correct answer of -1 is given. OpenOffice 2.4.1 on x86 Ubuntu 8.10 Intrepid Ibex. This error did not occur when performing the same numerical calculation in the bash shell: echo $((a-1-a)). ProblemType: Bug Architecture: i386 DistroRelease: Ubuntu 8.10 NonfreeKernelModules: nvidia Package: openoffice.org-core 1:2.4.1-11ubuntu2.1 ProcEnviron: PATH=/usr/lib/openoffice/program:/home/username/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/opt/real/RealPlayer LANG=en_CA.UTF-8 SHELL=/bin/bash SourcePackage: openoffice.org Uname: Linux 2.6.27-11-generic i686 ** Affects: openoffice.org (Ubuntu) Importance: Undecided Status: New ** Tags: apport-bug -- Sum error when using three cells and a large #. https://bugs.launchpad.net/bugs/340051 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
[Bug 340051] Re: Sum error when using three cells and a large #.
** Attachment added: openoffice.summation.bug.ods http://launchpadlibrarian.net/23665400/openoffice.summation.bug.ods ** Attachment added: Dependencies.txt http://launchpadlibrarian.net/23665401/Dependencies.txt -- Sum error when using three cells and a large #. https://bugs.launchpad.net/bugs/340051 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
