[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    Re: Formula value displayed inconsistently
From:       Cheong Kok Kik <kokkik.cheong () streamsolutions ! com ! sg>
Date:       2009-01-23 7:28:05
Message-ID: loom.20090123T071940-355 () post ! gmane ! org
[Download RAW message or body]

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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

[prev in list] [next in list] [prev in thread] [next in thread]