Comment 0 for bug 1263326
Revision history for this message
| Ray DeCampo (rdecampo) wrote Formula values not updated automatically | #0 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
1b1ed1a
(Get the code!)
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
ProcVersionSign
Uname: Linux 3.11.0-14-generic x86_64
NonfreeKernelMo
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_
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-10 (40 days ago)