You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by he...@polarisFT.com on 2011/11/14 07:40:39 UTC

Issue with updating formula while inserting using poi 3.6

Hi,

I have an issue when using POI 3.6

I have a template where there are cells with formulas, for e.g., formula is
at C3 cell(SUM(C1,C2)). What I am doing is I'm now reading the sheet,
inserting rows(shifting rows and creating new rows) in between and adding
data for e.g., I'm inserting a new row at 2. Now I expect that the cell C3
to become C4 and the formula to be updated to SUM(C1,C3) which is not the
case. Let me know how to get this working using poi 3.6.

Please help me with this ASAP as this is holding my development work.

Hemanth Mummadi,
Polaris Software Labs,
203 Manikonda IT Park | Hyderabad - 19 | India



This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only.  If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.

Visit us at http://www.polarisFT.com


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org