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=<set>
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 Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1263326
Title:
Formula values not updated automatically
Status in “libreoffice” package in Ubuntu:
New
Bug 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)
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1263326/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
