[Bug 1263326] Re: [Upstream] IF function not evaluating correctly with cell borders in .ods
Launchpad has imported 12 comments from the remote bug at https://bugs.documentfoundation.org/show_bug.cgi?id=072969. 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 2013-12-22T13:21:33+00:00 Ray DeCampo wrote: Created attachment 91124 Example spreadsheet as in the bug description Problem description: When adding formatting, e.g. borders, to a cell, the string value of the cell is affected. Steps to reproduce: See attached spreadsheet. The first line has no formatting and behaves as expected. The second line has a border on cell B2 and the value of that cell is affected. Current behavior: Cell C2 displays the value "Failed". If the value of cell B2 is copied and pasted as text the value pasted is "foobar ". Expected behavior: Cell C2 displays the value "Passed" like the cell C1. If the value of cell B2 is copied and pasted as text the value pasted is "foobar". Operating System: Ubuntu Version: 4.1.3.2 release Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/comments/7 On 2013-12-22T13:23:54+00:00 Ray DeCampo wrote: I forgot to clarify in the original description, the issue began manifesting when I upgraded from Ubuntu 13.04 to 13.10. I believe the version of LibreOffice for 13.04 is 4.0.2. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/comments/9 On 2013-12-22T17:07:20+00:00 Christopher M. Penalver wrote: Raymond DeCampo, thank you for reporting this. Would you please be able to bibisect this problem following https://wiki.documentfoundation.org/QA/HowToBibisect ? This would help tremendously in resolving this bug. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/comments/12 On 2014-04-28T22:57:25+00:00 Kohei-d wrote: I just tested this using the latest versions of 4.1 and 4.2 (and master), and this no longer happens. To verify, you need to hit F9 after loading the submitted document because the formula results are initially cached. Once the cells get recalculated, the reported problem no longer happens. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/comments/14 On 2014-04-29T11:33:24+00:00 Christopher M. Penalver wrote: Kohei Yoshida, thanks for taking a look at this. Unfortunately, the issue noted in the Description is reproducible in: Version: 4.2.3.3 Build ID: 882f8a0a489bc99a9e60c7905a60226254cb6ff0 Microsoft Windows Vista Business x86 6.0.6002 Service Pack 2 Build 6002 As well, F9 does not update the calculation. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/comments/16 On 2014-11-06T00:06:40+00:00 Jmadero-dev wrote: There is some confusion about this issue as Kohei couldn't reproduce. Moving to UNCONFIRMED to get fresh eyes on it. Thanks for understanding. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/comments/18 On 2014-11-06T02:04:45+00:00 Christopher M. Penalver wrote: The steps noted in the Description https://bugs.freedesktop.org/show_bug.cgi?id=72969#c0 are still confirmed verbatim in MASTER: Version: 4.4.0.0.alpha1+ Build ID: b7d8a58ff2698ffc6e22943f64aa97c5ea253bd9 TinderBox: Win-x86@42, Branch:master, Time: 2014-11-05_00:40:38 Microsoft Windows Vista Business x86 6.0.6002 Service Pack 2 Build 6002 As I'm a member of LibreOffice QA, I've marked myself the QA contact if you would have any further questions on the scope of this report. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/comments/20 On 2014-11-06T02:38:31+00:00 Jmadero-dev wrote: Apologies Christopher - didn't recognize your name :) Thanks for confirming! Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/comments/22 On 2015-12-20T16:13:39+00:00 Qa-admin-q wrote: ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes
[Bug 1263326] Re: [Upstream] IF function not evaluating correctly with cell borders in .ods
Synchronising bug status with upstream. ** Changed in: libreoffice (Ubuntu) Status: Triaged => Fix Released ** Bug watch added: Document Foundation Bugzilla #72969 https://bugs.documentfoundation.org/show_bug.cgi?id=72969 ** Bug watch added: Document Foundation Bugzilla #072969 https://bugs.documentfoundation.org/show_bug.cgi?id=072969 ** Changed in: df-libreoffice Importance: Medium => Unknown ** Changed in: df-libreoffice Status: Confirmed => Unknown ** Changed in: df-libreoffice Remote watch: Document Foundation Bugzilla #72969 => Document Foundation Bugzilla #072969 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: [Upstream] IF function not evaluating correctly with cell borders in .ods To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326]
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.4 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-12-20 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: [Upstream] IF function not evaluating correctly with cell borders in .ods To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326] Re: [Upstream] IF function not evaluating correctly with cell borders in .ods
** Bug watch removed: freedesktop.org Bugzilla #72969 https://bugs.freedesktop.org/show_bug.cgi?id=72969 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: [Upstream] IF function not evaluating correctly with cell borders in .ods To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326] Re: [Upstream] IF function not evaluating correctly with cell borders in .ods
** Bug watch added: freedesktop.org Bugzilla #72969 https://bugs.freedesktop.org/show_bug.cgi?id=72969 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: [Upstream] IF function not evaluating correctly with cell borders in .ods To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326]
The steps noted in the Description https://bugs.freedesktop.org/show_bug.cgi?id=72969#c0 are still confirmed verbatim in MASTER: Version: 4.4.0.0.alpha1+ Build ID: b7d8a58ff2698ffc6e22943f64aa97c5ea253bd9 TinderBox: Win-x86@42, Branch:master, Time: 2014-11-05_00:40:38 Microsoft Windows Vista Business x86 6.0.6002 Service Pack 2 Build 6002 As I'm a member of LibreOffice QA, I've marked myself the QA contact if you would have any further questions on the scope of this report. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: [Upstream] IF function not evaluating correctly with cell borders in .ods To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326]
Apologies Christopher - didn't recognize your name :) Thanks for confirming! -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: [Upstream] IF function not evaluating correctly with cell borders in .ods To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326]
There is some confusion about this issue as Kohei couldn't reproduce. Moving to UNCONFIRMED to get fresh eyes on it. Thanks for understanding. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: [Upstream] IF function not evaluating correctly with cell borders in .ods To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326]
I just tested this using the latest versions of 4.1 and 4.2 (and master), and this no longer happens. To verify, you need to hit F9 after loading the submitted document because the formula results are initially cached. Once the cells get recalculated, the reported problem no longer happens. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: [Upstream] IF function not evaluating correctly with cell borders in .ods To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326]
Kohei Yoshida, thanks for taking a look at this. Unfortunately, the issue noted in the Description is reproducible in: Version: 4.2.3.3 Build ID: 882f8a0a489bc99a9e60c7905a60226254cb6ff0 Microsoft Windows Vista Business x86 6.0.6002 Service Pack 2 Build 6002 As well, F9 does not update the calculation. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: [Upstream] IF function not evaluating correctly with cell borders in .ods To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326] Re: [Upstream] IF function not evaluating correctly with cell borders in .ods
** Description changed: 1) lsb_release -rd Description: Ubuntu Trusty Tahr (development branch) Release: 14.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:4.1.3-0ubuntu2 Candidate: 1:4.1.3-0ubuntu2 Version table: *** 1:4.1.3-0ubuntu2 0 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages 100 /var/lib/dpkg/status 3) What is expected to happen via a terminal: - cd ~/Desktop && wget https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+attachment/3934242/+files/bug-format-affects-value.ods && localc --nologo bug.ods + cd ~/Desktop && wget https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+attachment/3934242/+files/bug-format-affects-value.ods && localc --nologo bug-format-affects-value.ods is that cells C1 and C2 both show Passed. 4) What happens instead is that cell C2 shows Failed. WORKAROUND: Insert a row, and then remove the row. ProblemType: Bug DistroRelease: Ubuntu 13.10 Package: libreoffice-calc 1:4.1.3-0ubuntu1 ProcVersionSignature: Ubuntu 3.11.0-14.21-generic 3.11.7 Uname: Linux 3.11.0-14-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.12.5-0ubuntu2.2 Architecture: amd64 Date: Sat Dec 21 07:59:29 2013 InstallationDate: Installed on 2012-11-18 (397 days ago) InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Release amd64 (20121017.5) MarkForUpload: True ProcEnviron: LANGUAGE=en_US PATH=(custom, no user) XDG_RUNTIME_DIR= LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: [Upstream] IF function not evaluating correctly with cell borders in .ods To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326] Re: [Upstream] IF function not evaluating correctly with cell borders in .ods
Launchpad has imported 3 comments from the remote bug at https://www.libreoffice.org/bugzilla/show_bug.cgi?id=72969. 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 2013-12-22T13:21:33+00:00 Ray DeCampo wrote: Created attachment 91124 Example spreadsheet as in the bug description Problem description: When adding formatting, e.g. borders, to a cell, the string value of the cell is affected. Steps to reproduce: See attached spreadsheet. The first line has no formatting and behaves as expected. The second line has a border on cell B2 and the value of that cell is affected. Current behavior: Cell C2 displays the value "Failed". If the value of cell B2 is copied and pasted as text the value pasted is "foobar ". Expected behavior: Cell C2 displays the value "Passed" like the cell C1. If the value of cell B2 is copied and pasted as text the value pasted is "foobar". Operating System: Ubuntu Version: 4.1.3.2 release Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/comments/6 On 2013-12-22T13:23:54+00:00 Ray DeCampo wrote: I forgot to clarify in the original description, the issue began manifesting when I upgraded from Ubuntu 13.04 to 13.10. I believe the version of LibreOffice for 13.04 is 4.0.2. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/comments/7 On 2013-12-22T17:07:20+00:00 Christopher M. Penalver wrote: Raymond DeCampo, thank you for reporting this. Would you please be able to bibisect this problem following https://wiki.documentfoundation.org/QA/HowToBibisect ? This would help tremendously in resolving this bug. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/comments/9 ** Changed in: df-libreoffice Status: Unknown => Confirmed ** Changed in: df-libreoffice Importance: Unknown => Medium -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: [Upstream] IF function not evaluating correctly with cell borders in .ods To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326] Re: [Upstream] IF function not evaluating correctly with cell borders in .ods
** Summary changed: - IF function not evaluating correctly with cell borders in .ods + [Upstream] IF function not evaluating correctly with cell borders in .ods -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: [Upstream] IF function not evaluating correctly with cell borders in .ods To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326] Re: #VALUE propagates incorrectly subtracting text from numbers
** Summary changed: - #VALUE doesn't propagate correctly subtracting text from numbers + #VALUE propagates incorrectly subtracting text from numbers ** Also affects: df-libreoffice via https://www.libreoffice.org/bugzilla/show_bug.cgi?id=72969 Importance: Unknown Status: Unknown ** Summary changed: - #VALUE propagates incorrectly subtracting text from numbers + IF function not evaluating correctly with cell borders in .ods ** Description changed: 1) lsb_release -rd Description: Ubuntu Trusty Tahr (development branch) Release: 14.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:4.1.3-0ubuntu2 Candidate: 1:4.1.3-0ubuntu2 Version table: *** 1:4.1.3-0ubuntu2 0 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages 100 /var/lib/dpkg/status 3) What is expected to happen via a terminal: - cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+attachment/3933694/+files/bug.ods && localc --nologo bug.ods + cd ~/Desktop && wget https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+attachment/3934242/+files/bug-format-affects-value.ods && localc --nologo bug.ods - is that cell H6 shows the expected value of $4081.03. + is that cells C1 and C2 both show Passed. - 4) What happens instead is it shows #VALUE. + 4) What happens instead is that cell C2 shows Failed. - WORKAROUND: if one inserts a row, and then removes the row, it shows the - expected $4081.03. - - WORKAROUND: Change all formulas containing: - "" - - to the number zero: - 0 + WORKAROUND: Insert a row, and then remove the row. ProblemType: Bug DistroRelease: Ubuntu 13.10 Package: libreoffice-calc 1:4.1.3-0ubuntu1 ProcVersionSignature: Ubuntu 3.11.0-14.21-generic 3.11.7 Uname: Linux 3.11.0-14-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.12.5-0ubuntu2.2 Architecture: amd64 Date: Sat Dec 21 07:59:29 2013 InstallationDate: Installed on 2012-11-18 (397 days ago) InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Release amd64 (20121017.5) MarkForUpload: True ProcEnviron: LANGUAGE=en_US PATH=(custom, no user) XDG_RUNTIME_DIR= LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) ** Changed in: libreoffice (Ubuntu) Importance: Low => Medium -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: IF function not evaluating correctly with cell borders in .ods To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326] Re: #VALUE doesn't propagate correctly subtracting text from numbers
Further research reveals the issue is with formatting, in particular borders, affecting the value of cells. I will attach a new spreadsheet demonstrating the issue. I have also filed a bug at LibreOffice: https://www.libreoffice.org/bugzilla/show_bug.cgi?id=72969 Steps to reproduce: See attached spreadsheet (bug-format-affects-value.ods). The first line has no formatting and behaves as expected. The second line has a border on cell B2 and the value of that cell is affected. Current behavior: Cell C2 displays the value "Failed". If the value of cell B2 is copied and pasted as text the value pasted is "foobar ". Expected behavior: Cell C2 displays the value "Passed" like the cell C1. If the value of cell B2 is copied and pasted as text the value pasted is "foobar". ** Bug watch added: LibreOffice Bugzilla #72969 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=72969 ** Attachment added: "Simplified example spreadsheet demonstrating the issue" https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+attachment/3934242/+files/bug-format-affects-value.ods -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: #VALUE doesn't propagate correctly subtracting text from numbers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326] Re: #VALUE doesn't propagate correctly subtracting text from numbers
Ray DeCampo, thank you for your comments. I'm comparing the results to Excel from a feature parity expectation perspective, so this is why my expectations were different. However, LibreOffice has on a number of occasions developed past Excel for the better (ex. making functions more precise than equivalent ones in Excel, letting functions calculate larger values than Excel functions, etc.), and this would be an example of that. In Microsoft Office Excel Viewer (12.0.6219.1000 MSO (12.0.6213.1000), it propagates the #VALUE error due to the malformed subtracting of numbers and text. However, LibreOffice has done work to develop past this limitation. So, your expectation would be correct, in that cell H6 should show $4,081.03 despite the malformed subtraction. I'll correct the Bug Description to this. Hence, the issue you are reporting is an upstream one. It would be nice if somebody having it could send the bug to the developers of the software by following the instructions verbatim at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about the status. Thanks in advance. Helpful bug reporting tips: https://help.ubuntu.com/community/ReportingBugs ** Description changed: 1) lsb_release -rd Description: Ubuntu Trusty Tahr (development branch) Release: 14.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:4.1.3-0ubuntu2 Candidate: 1:4.1.3-0ubuntu2 Version table: *** 1:4.1.3-0ubuntu2 0 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages 100 /var/lib/dpkg/status 3) What is expected to happen via a terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+attachment/3933694/+files/bug.ods && localc --nologo bug.ods - is that cell H6 shows #VALUE no matter what, given it is a result of - subtracting text from a number. + is that cell H6 shows the expected value of $4081.03. - 4) What happens instead is if one inserts a row, and then removes the - row, it resolves to a number value. + 4) What happens instead is it shows #VALUE. + + WORKAROUND: if one inserts a row, and then removes the row, it shows the + expected $4081.03. WORKAROUND: Change all formulas containing: "" to the number zero: 0 ProblemType: Bug DistroRelease: Ubuntu 13.10 Package: libreoffice-calc 1:4.1.3-0ubuntu1 ProcVersionSignature: Ubuntu 3.11.0-14.21-generic 3.11.7 Uname: Linux 3.11.0-14-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.12.5-0ubuntu2.2 Architecture: amd64 Date: Sat Dec 21 07:59:29 2013 InstallationDate: Installed on 2012-11-18 (397 days ago) InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Release amd64 (20121017.5) MarkForUpload: True ProcEnviron: LANGUAGE=en_US PATH=(custom, no user) XDG_RUNTIME_DIR= LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) ** Tags added: regression-release -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: #VALUE doesn't propagate correctly subtracting text from numbers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326] Re: #VALUE doesn't propagate correctly subtracting text from numbers
Further investigation reveals that the issue is that the cell D6 is incorrectly evaluated to the value " " instead of the value "". This can be verified by copying the cell D6 and pasting just the text into another cell. So perhaps it is related to the same issue that is causing the cells in the F column to change from "x" to "x " and then "x ". -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: #VALUE doesn't propagate correctly subtracting text from numbers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326] Re: #VALUE doesn't propagate correctly subtracting text from numbers
Christopher, the calculation in H6 of H5-D6 is protected by the IF() function, ensuring that we do not use H5-D6 when D6 is "". In fact, the cell has the proper value when other things are changed that should not affect this bug. As I stated in my original description, this includes ordering the rows by date or re-copying the formulas in D6 and E6 to themselves. This proves that the formula in H6 is fine. Furthermore the formula for H4 and H5 are the same as H6 except for the row numbers and as you can see there is no #VALUE issue with those cells. This behavior is new, I have been using this spreadsheet since 2001 in OpenOffice/LibreOffice and never had this issue. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: #VALUE doesn't propagate correctly subtracting text from numbers To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326] Re: Formula values not updated automatically
Ray DeCampo, thank you for reporting this bug and helping make Ubuntu better. The root problem of this bug is in your attachment's cell H6 where you subtract a cell with a number (H5) from cell D6 containing text: "" The rest of the inconsistent behavior is collateral damage from poor propagation of #VALUE to the other cells utilizing this result. To WORKAROUND this problem, you would want to change all values of "" to the number zero. Given this, this bug report will focus on the root cause, improper propagation of #VALUE. Hence, the issue you are reporting is an upstream one. It would be nice if somebody having it could send the bug to the developers of the software by following the instructions verbatim at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about the status. Thanks in advance. Helpful bug reporting tips: https://help.ubuntu.com/community/ReportingBugs ** Description changed: 1) lsb_release -rd Description: Ubuntu Trusty Tahr (development branch) Release: 14.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:4.1.3-0ubuntu2 Candidate: 1:4.1.3-0ubuntu2 Version table: *** 1:4.1.3-0ubuntu2 0 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages 100 /var/lib/dpkg/status 3) What is expected to happen via a terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+attachment/3933694/+files/bug.ods && localc --nologo bug.ods is that cells H6 and I6 don't show #VALUE. 4) What happens instead is it does. This is despite hitting F9 (Recalculate). WORKAROUND: Insert a row, and then remove the row and the expected values show. However, if you do something which causes Calc to re-calculate the cells, the value will display fine. For example if you sort the rows based on the date column. Another trigger is to re-copy the formulas for D6 and E6 by selecting D5 and E5 and pulling the formula down. The issue can be reproduced by entering another line in the checkbook (all the formulas are already entered through row 1000). Entering the date in A6 causes the formulas to become live. + WORKAROUND: Change all values of: + "" + + to the number zero: + 0 + ProblemType: Bug DistroRelease: Ubuntu 13.10 Package: libreoffice-calc 1:4.1.3-0ubuntu1 ProcVersionSignature: Ubuntu 3.11.0-14.21-generic 3.11.7 Uname: Linux 3.11.0-14-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.12.5-0ubuntu2.2 Architecture: amd64 Date: Sat Dec 21 07:59:29 2013 InstallationDate: Installed on 2012-11-18 (397 days ago) InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Release amd64 (20121017.5) MarkForUpload: True ProcEnviron: LANGUAGE=en_US PATH=(custom, no user) XDG_RUNTIME_DIR= LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) ** Description changed: 1) lsb_release -rd Description: Ubuntu Trusty Tahr (development branch) Release: 14.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:4.1.3-0ubuntu2 Candidate: 1:4.1.3-0ubuntu2 Version table: *** 1:4.1.3-0ubuntu2 0 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages 100 /var/lib/dpkg/status 3) What is expected to happen via a terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+attachment/3933694/+files/bug.ods && localc --nologo bug.ods - is that cells H6 and I6 don't show #VALUE. + is that cell H6 shows #VALUE no matter what, given it is a result of + subtracting text from a number. - 4) What happens instead is it does. This is despite hitting F9 - (Recalculate). + 4) What happens instead is if one inserts a row, and then removes the + row, it resolves to a number value. - WORKAROUND: Insert a row, and then remove the row and the expected - values show. - - However, if you do something which causes Calc to re-calculate the - cells, the value will display fine. For example if you sort the rows - based on the date column. Another trigger is to re-copy the formulas for - D6 and E6 by selecting D5 and E5 and pulling the formula down. The issue - can be reproduced by entering another line in the checkbook (all the - formulas are already entered through row 1000). Entering the date in A6 - causes the formulas to become live. - - WORKAROUND: Change all values of: + WORKAROUND: Change all formulas containing: "" to the number zero: 0 ProblemType: Bug DistroRelease: Ubuntu 13.10 Package: libreoffice-calc 1:4.1.3-0ubuntu1 ProcVersionSignature: Ubuntu 3.11.0-14.21-generic 3.11.7 Uname:
[Bug 1263326] Re: Formula values not updated automatically
** Description changed: 1) lsb_release -rd Description: Ubuntu Trusty Tahr (development branch) Release: 14.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:4.1.3-0ubuntu2 Candidate: 1:4.1.3-0ubuntu2 Version table: *** 1:4.1.3-0ubuntu2 0 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages 100 /var/lib/dpkg/status 3) What is expected to happen via a terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+attachment/3933694/+files/bug.ods && localc --nologo bug.ods is that cells H6 and I6 don't show #VALUE. - 4) What happens instead is it does. However, if you do something which - causes Calc to re-calculate the cells, the value will display fine. For - example if you sort the rows based on the date column. Another trigger - is to re-copy the formulas for D6 and E6 by selecting D5 and E5 and - pulling the formula down. The issue can be reproduced by entering - another line in the checkbook (all the formulas are already entered - through row 1000). Entering the date in A6 causes the formulas to become - live. + 4) What happens instead is it does. This is despite hitting F9 + (Recalculate). + + WORKAROUND: Insert a row, and then remove the row and the expected + values show. + + However, if you do something which causes Calc to re-calculate the + cells, the value will display fine. For example if you sort the rows + based on the date column. Another trigger is to re-copy the formulas for + D6 and E6 by selecting D5 and E5 and pulling the formula down. The issue + can be reproduced by entering another line in the checkbook (all the + formulas are already entered through row 1000). Entering the date in A6 + causes the formulas to become live. ProblemType: Bug DistroRelease: Ubuntu 13.10 Package: libreoffice-calc 1:4.1.3-0ubuntu1 ProcVersionSignature: Ubuntu 3.11.0-14.21-generic 3.11.7 Uname: Linux 3.11.0-14-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.12.5-0ubuntu2.2 Architecture: amd64 Date: Sat Dec 21 07:59:29 2013 InstallationDate: Installed on 2012-11-18 (397 days ago) InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Release amd64 (20121017.5) MarkForUpload: True ProcEnviron: LANGUAGE=en_US PATH=(custom, no user) XDG_RUNTIME_DIR= LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: Formula values not updated automatically To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1263326] Re: Formula values not updated automatically
** Description changed: - I am planning on attaching an example spreadsheet which demonstrates the - issue. The example spreadsheet is a checkbook where the account is - split into three categories. Then there is a 'Total' category which is - the sum of the transactions in the other categories. The idea is to - have virtual subaccounts in the checkbook. When you open the example - you will see that cells H6 and I6 are not being calculated and display - #VALUE instead. However, if you do something which causes Calc to re- - calculate the cells, the value will display fine. For example if you - sort the rows based on the date column. Another trigger is to re-copy - the formulas for D6 and E6 by selecting D5 and E5 and pulling the - formula down. The issue can be reproduced by entering another line in - the checkbook (all the formulas are already entered through row 1000). - Entering the date in A6 causes the formulas to become live. + 1) lsb_release -rd + Description: Ubuntu Trusty Tahr (development branch) + Release: 14.04 - There is a further issue with this spreadsheet in column F. Column F is - an indicator that the bank has reflected the transaction to facilitate - balancing the checkbook. You will notice that F4 and F5 contain the - string 'x ', that is 'x' followed by two spaces. Unfortunately I have - only entered 'x' into these cells. Every time the spreadsheet is saved, - closed and re-opened another space is appended to these cells. I - haven't been successful re-producing this phenomena in another - spreadsheet and I am not sure if it is related to the issue above. + 2) apt-cache policy libreoffice-calc + libreoffice-calc: + Installed: 1:4.1.3-0ubuntu2 + Candidate: 1:4.1.3-0ubuntu2 + Version table: + *** 1:4.1.3-0ubuntu2 0 + 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages + 100 /var/lib/dpkg/status - These issues appeared with the upgrade from 13.04 to 13.10. + 3) What is expected to happen via a terminal: + cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+attachment/3933694/+files/bug.ods && localc --nologo bug.ods + + is that it doesn't show #VALUE. + + 4) What happens instead is it does. However, if you do something which + causes Calc to re-calculate the cells, the value will display fine. For + example if you sort the rows based on the date column. Another trigger + is to re-copy the formulas for D6 and E6 by selecting D5 and E5 and + pulling the formula down. The issue can be reproduced by entering + another line in the checkbook (all the formulas are already entered + through row 1000). Entering the date in A6 causes the formulas to become + live. ProblemType: Bug DistroRelease: Ubuntu 13.10 Package: libreoffice-calc 1:4.1.3-0ubuntu1 ProcVersionSignature: Ubuntu 3.11.0-14.21-generic 3.11.7 Uname: Linux 3.11.0-14-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.12.5-0ubuntu2.2 Architecture: amd64 Date: Sat Dec 21 07:59:29 2013 InstallationDate: Installed on 2012-11-18 (397 days ago) InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Release amd64 (20121017.5) MarkForUpload: True ProcEnviron: - LANGUAGE=en_US - PATH=(custom, no user) - XDG_RUNTIME_DIR= - LANG=en_US.UTF-8 - SHELL=/bin/bash + LANGUAGE=en_US + PATH=(custom, no user) + XDG_RUNTIME_DIR= + LANG=en_US.UTF-8 + SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) ** Description changed: 1) lsb_release -rd Description: Ubuntu Trusty Tahr (development branch) Release: 14.04 2) apt-cache policy libreoffice-calc libreoffice-calc: - Installed: 1:4.1.3-0ubuntu2 - Candidate: 1:4.1.3-0ubuntu2 - Version table: - *** 1:4.1.3-0ubuntu2 0 - 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages - 100 /var/lib/dpkg/status + Installed: 1:4.1.3-0ubuntu2 + Candidate: 1:4.1.3-0ubuntu2 + Version table: + *** 1:4.1.3-0ubuntu2 0 + 500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages + 100 /var/lib/dpkg/status 3) What is expected to happen via a terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+attachment/3933694/+files/bug.ods && localc --nologo bug.ods - is that it doesn't show #VALUE. + is that cells H6 and I6 don't show #VALUE. 4) What happens instead is it does. However, if you do something which causes Calc to re-calculate the cells, the value will display fine. For example if you sort the rows based on the date column. Another trigger is to re-copy the formulas for D6 and E6 by selecting D5 and E5 and pulling the formula down. The issue can be reproduced by entering another line in the checkbook (all the formulas are already entered through row 1000). Enter
[Bug 1263326] [NEW] Formula values not updated automatically
Public bug reported: I am planning on attaching an example spreadsheet which demonstrates the issue. The example spreadsheet is a checkbook where the account is split into three categories. Then there is a 'Total' category which is the sum of the transactions in the other categories. The idea is to have virtual subaccounts in the checkbook. When you open the example you will see that cells H6 and I6 are not being calculated and display #VALUE instead. However, if you do something which causes Calc to re- calculate the cells, the value will display fine. For example if you sort the rows based on the date column. Another trigger is to re-copy the formulas for D6 and E6 by selecting D5 and E5 and pulling the formula down. The issue can be reproduced by entering another line in the checkbook (all the formulas are already entered through row 1000). Entering the date in A6 causes the formulas to become live. There is a further issue with this spreadsheet in column F. Column F is an indicator that the bank has reflected the transaction to facilitate balancing the checkbook. You will notice that F4 and F5 contain the string 'x ', that is 'x' followed by two spaces. Unfortunately I have only entered 'x' into these cells. Every time the spreadsheet is saved, closed and re-opened another space is appended to these cells. I haven't been successful re-producing this phenomena in another spreadsheet and I am not sure if it is related to the issue above. These issues appeared with the upgrade from 13.04 to 13.10. ProblemType: Bug DistroRelease: Ubuntu 13.10 Package: libreoffice-calc 1:4.1.3-0ubuntu1 ProcVersionSignature: Ubuntu 3.11.0-14.21-generic 3.11.7 Uname: Linux 3.11.0-14-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.12.5-0ubuntu2.2 Architecture: amd64 Date: Sat Dec 21 07:59:29 2013 InstallationDate: Installed on 2012-11-18 (397 days ago) InstallationMedia: Ubuntu 12.10 "Quantal Quetzal" - Release amd64 (20121017.5) MarkForUpload: True ProcEnviron: LANGUAGE=en_US PATH=(custom, no user) XDG_RUNTIME_DIR= LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: libreoffice UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) ** Affects: libreoffice (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug saucy ** Attachment added: "Example exhibiting the bug (see bug description)" https://bugs.launchpad.net/bugs/1263326/+attachment/3933694/+files/bug.ods -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: Formula values not updated automatically To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
