Bug 54632

Summary:	Excel internal-link won't be updated when change cell's content which is linked by other cells
Product:	POI	Reporter:	oscar.ye
Component:	XSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED INVALID
Severity:	normal
Priority:	P2
Version:	3.9-dev
Target Milestone:	---
Hardware:	PC
OS:	All

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.