On Thu, 24 Apr 2008, Bhavani Kumar wrote: > Problem - When I insert 2 rows, one at B2 and the other one at B9 > I expect the formula to be =SUM(B1:B7)-B14 > and B12 formula to be =SUM(B8:B13)
If you are inserting rows, you will need to fix up any formulas afterwards. POI is just a file format library, not an excel replacment, so it won't update the formulas for you when you perform this sort of operation Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
