|Summary:||Incorrect formula with auto-fill cells (shared formula)|
|Product:||POI||Reporter:||Khanh Tran <trancongkhanh>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
|Attachments:||This is the simple testcase that the bug occured on|
Description Khanh Tran 2007-04-01 21:11:56 UTC
When the spreadsheet contains more than 6 shared formula cell, the getCellFormula function return incorrect result: -C1: A$1+B$1 -C2 from C2: drag from C1 (autofill) - using POI to get cells formula: C1: A$1+B$1: fine C2: A$2+B$2: OPPS! C3: A$3+B$3: OPPS! The expected result is A$1+B$1 for all C1..C7 cells. The problem occurs for all POI versions. Please help me to solve this. All my livehood depend on this. Thanks.
Comment 1 Khanh Tran 2007-04-01 21:15:46 UTC
Created attachment 19865 [details] This is the simple testcase that the bug occured on
Comment 2 Nick Burch 2008-01-25 08:39:04 UTC
Some fixes for shared and relative formula references have been committed in the last few weeks Could you please re-try with a recent svn checkout from trunk, and see if the problem still remains?