Bug 54632 - Excel internal-link won't be updated when change cell's content which is linked by other cells
Summary: Excel internal-link won't be updated when change cell's content which is link...
Status: RESOLVED INVALID
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.9-dev
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-03-04 08:00 UTC by oscar.ye
Modified: 2013-03-05 01:28 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description oscar.ye 2013-03-04 08:00:38 UTC 
Hi all,

I am using normal writing method in 'XSSF' to change cell's content, and save as a new file.

The cell(eg:A1) that I change, which is linked by other cells(eg:B1,C2,or =Sheet1!A1 etc.)

After run the writing-content code without any error, then open the new-saved file. The content of other cells are not updated but the one I change.

Thanks
Oscar
Comment 1 Nick Burch 2013-03-04 12:38:22 UTC 
Formula values are cached, so you must update that by doing an evaluation when you're done, see http://poi.apache.org/spreadsheet/eval.html
Comment 2 oscar.ye 2013-03-05 01:28:35 UTC 
Thanks for the solution.