https://bugs.freedesktop.org/show_bug.cgi?id=86978
Bug ID: 86978
Summary: =INDEX() fields not updated after linked files update
Product: LibreOffice
Version: 4.3.2.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 110415
--> https://bugs.freedesktop.org/attachment.cgi?id=110415&action=edit
offending spreadsheet
Attached is a fairly redacted version of a spreadsheet which tracks my
children's savings accounts. It shows that I make an automatic monthly payment
into each account, each month.
Fund prices are automatically imported from a linked CSV file, which is
automatically generated from fund prices on the bank's web site. Once the
prices are available for the first banking day of a given month, the
spreadsheet accounts for one more regular payment.
On "Sheet 3", in columns V and W, it tracks the amount paid into each child's
account during each tax year. Cells AA3 and AD3 on that sheet show the amount
paid into each account during *this* tax year, using the formulae
=INDEX($V$1:$V$22,$Y3) and =INDEX($W$1:$W$22,$Y3) respectively.
It is these cells which don't seem to get updated. First load the spreadsheet
as-is and try to make sure the link to 'stakeholder.csv' is working. The whole
of the second 'CSV_data' sheet is an import of the CSV file, if you need to
recreate that.
Observe that the amount paid in to each account this year is £8.
Now, close the spreadsheet and edit the CSV file. Add a final column with a
date of something like 2015-01-05. Now reload the spreadsheet. You'll get a
prompt saying that "This file contains links to other files. Should they be
updated?'. As you click 'yes', watch the 'Payment per tax year' field at the
right-hand side of Sheet A.
Watch it *fail* to update the 'YTD 2014/15' from £8 to £9 as the new payment
appears. Switch to Sheet 3 and see that although cell V4 contains the updated
value, cell AA3 hasn't been updated accordingly.
I don't remember this happening when I first produced this spreadsheet, which
was only a few months ago. I'll have been running Fedora 20 with LibreOffice
4.2.6.3 then. I'm on Fedora 21 with 4.3.2.2 now.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
