[EMAIL PROTECTED] wrote:
Hi all,
this might not be a bug its just that i don�t know how its done, and
didn�t find it in the documentation. I set an Area in the Excel sheet lets
say from A1:H7 for Example, and it works perfectly. But when i try to set
up a split Area lets say from A1:B7 and C1:D7 it just doesn�t work. I
looked how Excel does the job, and saw they simply put a " ; " in between
so it looks like this: A1:B7;D1:F7. I tried to put one in between my Java
program but its still not done right in Excel when i look at the area.
This is the code sample from my Program:
// label column is in between
Point lastCell2 = new Point(labelColumn-1, lastCell.y);
Point firstCell2 = new Point(labelColumn+1, 1);
name.setReference("A1:"+ getCellName(lastCell2)+ ";"+
getCellName(firstCell2)+ ":"+ getCellName(lastCell)); // System.err.println("Data: "+ resultSheet + "!A1:" +
getCellName(lastCell2) + ";"+ resultSheet + "!" + getCellName(firstCell2) +
":$" + getCellName(lastCell));
Now I would like to know if there is a way to set a split Area in POI, and
if how it is done. Thanks for your help!!!!!!!!!!!!!!!
--
To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
-- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
