|Summary:||Signed cell offsets are not implemented for shared formulas|
|Product:||POI||Reporter:||Christian Eckerle <ce>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
Patch for the bug
Description Christian Eckerle 2007-02-28 05:15:54 UTC
According to the openoffice.org Excel file format specification (http://sc.openoffice.org/ excelfileformat.pdf), section 4.3.1, method [B] the relative cell addresses in Areas and References have to be interpreted as signed and relative to the current cell when contained in a shared formula.
Comment 1 Christian Eckerle 2007-02-28 05:17:24 UTC
Created attachment 19650 [details] Patch for the bug
Comment 2 Nick Burch 2008-01-09 05:59:24 UTC
Before we can apply the patch, we'll need to have a test for it. Unfortunately, I don't quite understand what's currently wrong, so I can't write one... Any chance you could upload a quick file that shows up the bug, and ideally also a quick unit test that shows we're giving the wrong formula values? Once we have that, we can commit the patch and know it's all working properly.
Comment 3 Christian Eckerle 2008-01-17 07:52:35 UTC
Created attachment 21400 [details] Improved patch
Comment 5 Nick Burch 2008-01-22 06:49:15 UTC
Thanks for the testcase, I've applied it to svn trunk