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 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
