https://issues.apache.org/bugzilla/show_bug.cgi?id=46643
--- Comment #8 from Josh Micich <[email protected]> 2009-02-02 15:07:01 PST --- Another important detail about these tokens is that the range is encoded as two 3D cell refs with an explicit range operator. From the instructions you provided, Step 2 is expected to produce token tArea(D2:D3). The obvious way to get the encoding (tRef3D(D2),tRef3D(D3),tRange) is to instead call: cell.setCellFormula("SUM(InventoryDetails!D2:InventoryDetails!D3)"); I am assuming that this is much closer to the code you actually executed. It's possible that there is some *other* bug in POI that caused the formula originally set as "SUM(D2:D3)" to transform into "SUM(InventoryDetails!D2:InventoryDetails!D3", but this doesn't seem likely to me. If you *did* call setCellFormula("SUM(D2:D3)") while creating the attachment, that would represent another bug. If so please can you open another bugzilla with exact details of the code that will produce that error. For example: cell.setCellFormula("SUM(D2:D3)"); // do specific things to cause bug ... shift rows ? // Check that the formula hasn't changed: System.out.println(cell.getCellFormula()); // anything but "SUM(D2:D3)" would indicate a bug -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
