Hi Josh, Thanks for you reply. Yeap, i do agree as POI could do the multiple reference as i've this workbook with 30 worksheets and it could more complicated formula.
Anyway, I've fixed the problem by doing some workaround (eventhough i couldn't find a good explanation). I would like to share it here so someone might need it. (I couldn't upload the spreadsheet as it has customer business detail and complex formula for their product calculation.) The Process: I'm using divide and checking strategy. To 'zoom' into formula to find which particular cell has problem, and keeping on zooming until i reach a cell (PCell) with a simple formula having 2 cell multiplying each other. These 2 cells has no problem being read through POI. So i stopped at here. Then i started to copy back formula in PCell (problematic Cell) into its parent cell. Then, copy back its parent cell formula to higher level. This process continue till few more times (the formula was a bit deep), i found out that POI could read the output correctly now. Weird but the circular reference has gone. Hope this help someone to save some time. (After spending few days and nights). Keeping to POI spirit moving ! Regards, Kok Kik --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
