> 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>
