if you open excel, and do Format---Cells, you will see the option Center
Across Selection
as one of the choices for horizontal alignment. If you test this on an
excel worksheet,
it seems this gives the functionality that you want. That is, the selection
aspect is
not a problem. As to whether this is working in HSSF, I do not know. I've
never tried it.
But, it seems that the option ALIGN_CENTER_SELECTION is meant for this.
You could also put a string in one cell, and then align center, which
centers the string based
on the one cell with contents spilling into left and right cells. However,
this will not take into
account the widths of the cells to the left and right of the cell where you
put the string.
I hope this is of some help.
--steve
----- Original Message -----
From: "Urban Spielmann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 11, 2003 3:19 AM
Subject: How to use ALIGN_CENTER_SELECTION
Hi all,
How can I center a parent-title over some child-titles?
Example:
HSSFRow row02 = sheet.createRow((short) 1);
row02.createCell((short) 0).setCellValue("Title 1"); // Cell A2
row02.createCell((short) 1).setCellValue("Title 2"); // Cell B2
row02.createCell((short) 2).setCellValue("Title 3"); // Cell C2
HSSFRow row01 = sheet.createRow((short) 0);
HSSFCell cell = row01.createCell((short) 0); // Cell A1
cell.setCellValue("Parent Title");
// TODO: Alignment over Cell A1 to Cell C1
The "Parent Title" should span from cell 0 to cell 2.
Can I use the HSSFCellStyle.ALIGN_CENTER_SELECTION for that?
How do I make a selection?
I know one possibility would be to do it with merged cells. But merged
cells have the disadvantage that it is not possible to have
partial-selections on the merged region (e.g. selection over C1, C2, C3
in my example).
Thanks a lot for any help.
Best regards,
Urban
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
