[Desktop-packages] [Bug 1263326] Re: [Upstream] IF function not evaluating correctly with cell borders in .ods

2019-10-15 Thread Bug Watch Updater
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 htt

[Desktop-packages] [Bug 1263326] Re: [Upstream] IF function not evaluating correctly with cell borders in .ods

2019-10-15 Thread Marcus Tomlinson
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 http

[Desktop-packages] [Bug 1263326]

2015-12-23 Thread Qa-admin-q
** 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

[Desktop-packages] [Bug 1263326] Re: [Upstream] IF function not evaluating correctly with cell borders in .ods

2015-04-24 Thread Adolfo Jayme
** 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 Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: [Upstream

[Desktop-packages] [Bug 1263326] Re: [Upstream] IF function not evaluating correctly with cell borders in .ods

2014-11-07 Thread Bug Watch Updater
** 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 Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: [Upstream]

[Desktop-packages] [Bug 1263326]

2014-11-07 Thread Jmadero-dev
Apologies Christopher - didn't recognize your name :) Thanks for confirming! -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1263326 Title: [Upstream] IF function not evaluating co

[Desktop-packages] [Bug 1263326]

2014-11-07 Thread Jmadero-dev
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 Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.n

[Desktop-packages] [Bug 1263326]

2014-11-07 Thread Christopher M. Penalver
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 Busi

[Desktop-packages] [Bug 1263326]

2014-04-29 Thread Christopher M. Penalver
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 calcul

[Desktop-packages] [Bug 1263326]

2014-04-29 Thread Libreoffice-0
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. --

[Desktop-packages] [Bug 1263326] Re: [Upstream] IF function not evaluating correctly with cell borders in .ods

2014-04-29 Thread Christopher M. Penalver
** 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   

[Desktop-packages] [Bug 1263326] Re: [Upstream] IF function not evaluating correctly with cell borders in .ods

2013-12-23 Thread Bug Watch Updater
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 http

[Desktop-packages] [Bug 1263326] Re: [Upstream] IF function not evaluating correctly with cell borders in .ods

2013-12-22 Thread Christopher M. Penalver
** 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 Desktop Packages, which is subscribed to libreoffice in Ubuntu. https

[Desktop-packages] [Bug 1263326] Re: #VALUE propagates incorrectly subtracting text from numbers

2013-12-22 Thread Christopher M. Penalver
** 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 **

[Desktop-packages] [Bug 1263326] Re: #VALUE doesn't propagate correctly subtracting text from numbers

2013-12-22 Thread Ray DeCampo
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 attach

[Desktop-packages] [Bug 1263326] Re: #VALUE doesn't propagate correctly subtracting text from numbers

2013-12-21 Thread Christopher M. Penalver
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 eq

[Desktop-packages] [Bug 1263326] Re: #VALUE doesn't propagate correctly subtracting text from numbers

2013-12-21 Thread Ray DeCampo
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

[Desktop-packages] [Bug 1263326] Re: #VALUE doesn't propagate correctly subtracting text from numbers

2013-12-21 Thread Ray DeCampo
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

[Desktop-packages] [Bug 1263326] Re: Formula values not updated automatically

2013-12-21 Thread Christopher M. Penalver
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 propagatio

[Desktop-packages] [Bug 1263326] Re: Formula values not updated automatically

2013-12-21 Thread Christopher M. Penalver
** 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   

[Desktop-packages] [Bug 1263326] Re: Formula values not updated automatically

2013-12-21 Thread Christopher M. Penalver
** 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.

[Desktop-packages] [Bug 1263326] [NEW] Formula values not updated automatically

2013-12-21 Thread Ray DeCampo
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 i