Hypothesis: if you set colors for the borders it should work. I bet
we're initiallizing them to 0x0 for black instead of the *real* black.
I regard this as a bug. I'll create a new one for 1.5.1.
-Andy
Ian McIntosh wrote:
>Yeah after some testing, it does appear to be the borders that are the
>culprits rather than the color setting, which is a bummer because my entire
>sheet is riddled with them. See the example code below which should help
>isolate the problem.
>cheers,
>Ian
>
>****************************************************************************
>// java
>import java.io.*;
>
>// poi
>import org.apache.poi.hssf.usermodel.*;
>
>public class TestFormatCell {
>
> public static void main(String[] args) {
>
> try{
> FileOutputStream out = new
>FileOutputStream("./TestFormatCell.xls");// create new file
> HSSFWorkbook wb = new HSSFWorkbook(); // create a new workbook
> HSSFSheet sheet = wb.createSheet(); // create new sheets
> wb.setSheetName(0, "sheet one");
>
> HSSFFont font10Bold = wb.createFont();
> font10Bold.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); // make it bold
>
> // create some cell styles to use
> HSSFCellStyle cellStyleOne = wb.createCellStyle();
> cellStyleOne.setFont(font10Bold);
> cellStyleOne.setBorderRight(HSSFCellStyle.BORDER_THICK);
> cellStyleOne.setAlignment(HSSFCellStyle.ALIGN_CENTER);
>
> HSSFCellStyle cellStyleTwo = wb.createCellStyle();
> cellStyleTwo.setBorderRight(HSSFCellStyle.BORDER_THIN);
> cellStyleTwo.setBorderLeft(HSSFCellStyle.BORDER_THIN);
> cellStyleTwo.setBorderTop(HSSFCellStyle.BORDER_THIN);
> cellStyleTwo.setBorderBottom(HSSFCellStyle.BORDER_THIN);
>
> HSSFRow r = null; // declare a row object reference
> HSSFCell c = null; // declare a cell object reference
> short rownum = (short)0;
>
> r = sheet.createRow(rownum);
> c = r.createCell((short)0);
> c.setCellValue("This is the cell with the thick right border");
> c.setCellStyle(cellStyleOne);
>
> // let's skip a few rows to make sure we're out of the way of the
>last cell
> rownum = (short)5;
> r = sheet.createRow(rownum);
> c = r.createCell((short)0);
> c.setCellValue("This is the cell with the thin borders");
> c.setCellStyle(cellStyleTwo);
>
> wb.write(out); // write the workbook to the output stream
> out.close();
> }
> catch (Exception e) {
> System.out.println("Exception " + e);
> }
> }
>}
>
>
>
>-----Original Message-----
>From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
>Sent: 07 May 2002 2:12
>To: POI Users List
>Subject: Re: Bug 6802 - Format Cells... dialog does not popup
>
>
>Lets see some code that exposes this. I'm particuarly interested in the
>color setting.
>
>Basically this happens when a cell or font or what-have-you is set to
>the improper color. Originally this happened often as we'd mis-aligned
>BLACK to be 0x0. This WAS fixed. It is possible that we guessed wrong
>on another color and you've exposed this... I tested this not to many
>nights ago and it was working fine... So you may have stubled upon
>another problem (or color) with the same symptom.
>
>-Andy
>
>Ian McIntosh wrote:
>
>>Hi,
>>
>>Re: bug 6802 - "Format Cells... dialog does not popup" - the next to last
>>comment in the bug description says that this should be included in the 1.5
>>release. I've retried my code with the new release and it doesn't seem to
>>have fixed the problem. I still get no dialog box when I right click and
>>select Format Cells. Did it scrape through into the build or not?
>>
>>By the way, the new build certainly fixed some others - well done all
>>concerned and keep up the good work.
>>
>>cheers,
>>Ian
>>
>>
>>________________________________________________________________________
>>This email has been scanned for all viruses by the MessageLabs service.
>>________________________________________________________________________
>>
>
>
>
>
>--
>To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
>For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
>
>________________________________________________________________________
>This email has been scanned for all viruses by the MessageLabs service.
>
>
>________________________________________________________________________
>This email has been scanned for all viruses by the MessageLabs service.
>________________________________________________________________________
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
