Hi Steve You described exactly how I do it in Excel, but I would like to do it with HSSF.
Regards, Urban > -----Urspr�ngliche Nachricht----- > Von: Steve [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 11. September 2003 18:36 > An: POI Users List > Betreff: Re: How to use ALIGN_CENTER_SELECTION > > > 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] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
