2013-12-21 13:17:58 |
Ray DeCampo |
bug |
|
|
added bug |
2013-12-21 13:17:58 |
Ray DeCampo |
attachment added |
|
Example exhibiting the bug (see bug description) https://bugs.launchpad.net/bugs/1263326/+attachment/3933694/+files/bug.ods |
|
2013-12-21 20:55:45 |
penalvch |
description |
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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
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 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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
|
2013-12-21 20:58:51 |
penalvch |
description |
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 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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
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.
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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
|
2013-12-21 21:24:43 |
penalvch |
description |
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.
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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
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.
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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
|
2013-12-21 22:19:33 |
penalvch |
description |
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.
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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
|
2013-12-21 22:23:42 |
penalvch |
description |
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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
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.
4) What happens instead is if one inserts a row, and then removes the row, it resolves to a number value.
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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
|
2013-12-21 22:24:10 |
penalvch |
summary |
Formula values not updated automatically |
#VALUE doesn't propagate correctly subtracting text from numbers |
|
2013-12-21 22:25:12 |
penalvch |
libreoffice (Ubuntu): importance |
Undecided |
Low |
|
2013-12-21 22:25:12 |
penalvch |
libreoffice (Ubuntu): status |
New |
Triaged |
|
2013-12-21 22:26:53 |
penalvch |
tags |
amd64 apport-bug saucy |
amd64 apport-bug saucy trusty |
|
2013-12-22 00:17:26 |
penalvch |
description |
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.
4) What happens instead is if one inserts a row, and then removes the row, it resolves to a number value.
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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
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 the expected value of $4081.03.
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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
|
2013-12-22 00:17:35 |
penalvch |
tags |
amd64 apport-bug saucy trusty |
amd64 apport-bug regression-release saucy trusty |
|
2013-12-22 13:27:16 |
Ray DeCampo |
bug watch added |
|
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=72969 |
|
2013-12-22 13:27:16 |
Ray DeCampo |
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 |
|
2013-12-22 16:52:47 |
penalvch |
summary |
#VALUE doesn't propagate correctly subtracting text from numbers |
#VALUE propagates incorrectly subtracting text from numbers |
|
2013-12-22 16:53:06 |
penalvch |
bug task added |
|
df-libreoffice |
|
2013-12-22 16:57:29 |
penalvch |
summary |
#VALUE propagates incorrectly subtracting text from numbers |
IF function not evaluating correctly with cell borders in .ods |
|
2013-12-22 16:59:18 |
penalvch |
description |
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 the expected value of $4081.03.
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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
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
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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
|
2013-12-22 16:59:38 |
penalvch |
libreoffice (Ubuntu): importance |
Low |
Medium |
|
2013-12-22 17:16:44 |
penalvch |
summary |
IF function not evaluating correctly with cell borders in .ods |
[Upstream] IF function not evaluating correctly with cell borders in .ods |
|
2013-12-23 14:44:38 |
Bug Watch Updater |
df-libreoffice: status |
Unknown |
Confirmed |
|
2013-12-23 14:44:38 |
Bug Watch Updater |
df-libreoffice: importance |
Unknown |
Medium |
|
2014-04-29 11:02:38 |
penalvch |
description |
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
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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
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-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=<set>
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago) |
|
2014-11-07 21:47:39 |
Bug Watch Updater |
bug watch added |
|
https://bugs.freedesktop.org/show_bug.cgi?id=72969 |
|
2015-04-24 12:57:57 |
Adolfo Jayme Barrientos |
bug watch removed |
https://bugs.freedesktop.org/show_bug.cgi?id=72969 |
|
|
2019-10-15 17:06:46 |
Marcus Tomlinson |
libreoffice (Ubuntu): status |
Triaged |
Fix Released |
|
2019-10-15 17:08:20 |
Marcus Tomlinson |
bug watch added |
|
https://bugs.documentfoundation.org/show_bug.cgi?id=72969 |
|
2019-10-15 17:09:28 |
Marcus Tomlinson |
bug watch added |
|
https://bugs.documentfoundation.org/show_bug.cgi?id=072969 |
|
2019-10-15 17:09:28 |
Marcus Tomlinson |
df-libreoffice: importance |
Medium |
Unknown |
|
2019-10-15 17:09:28 |
Marcus Tomlinson |
df-libreoffice: status |
Confirmed |
Unknown |
|
2019-10-15 17:09:28 |
Marcus Tomlinson |
df-libreoffice: remote watch |
Document Foundation Bugzilla #72969 |
Document Foundation Bugzilla #072969 |
|
2019-10-16 00:24:13 |
Bug Watch Updater |
df-libreoffice: status |
Unknown |
Fix Released |
|
2019-10-16 00:24:13 |
Bug Watch Updater |
df-libreoffice: importance |
Unknown |
Medium |
|
2019-10-16 00:24:21 |
Bug Watch Updater |
bug watch added |
|
https://bugs.freedesktop.org/show_bug.cgi?id=72969 |
|