The excel file is complex, but there's no circular reference in the excel spreadsheet. I've tried to create 2 simple worksheet and having worksheet1 cell 1 depend on worksheet 2 cell2, and worksheet 2 cell2 depends on worksheet 1 cell1, Excel immediately prompt the circular reference issue. The value will be empty and not updated.
Back to the excel file that having the problem, It looks like POI couldn't handle cell with formula that have multiple reference back to a single cell. Once i've use the formula in the single cell and update 1 level upper formula (which use the single cell), the problem gone for the row. But the issue is there are 100 rows that need to be updated. And there are few worksheets having similar issue. Couldn't send out the spreadsheet as it's customer property. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
