https://issues.apache.org/bugzilla/show_bug.cgi?id=51037--- Comment #6 from Bill Somerville <
[hidden email]> 2011-04-27 09:49:01 EDT ---
(In reply to comment #5)
> I've just added a unit test in r1092423 for the case you describe. However, it
> does all seem to be working fine for me - the column gets set up with the style
> as you'd expect. I can't replicate your problem of the style not being set.
>
> Are you able to compare my test code to yours to see what's happening
> differently?
Hi. I'm having what I think to be the same problem. The code below reliably
reproduces the problem. Note that the same code works fine (as expected) with
HSSFWorkbook, and note also the workaround:
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import java.io.FileOutputStream;
public class Test
{
public static void main(String args[])
{
try
{
Test test = new Test();
test.run();
}
catch (Exception e)
{
e.printStackTrace();
}
}
Test()
{
}
void run()
throws Exception
{
// Problem: column 0 ends up with zero width and white background in
XSSFWorkbook; looks OK in HSSFWorkbook
Workbook workbook = new XSSFWorkbook();
FileOutputStream stream = new FileOutputStream("C:\\Temp\\Foo.xlsx");
//Workbook workbook = new HSSFWorkbook();
//FileOutputStream stream = new FileOutputStream("C:\\Temp\\Foo.xls");
Sheet sheet = workbook.createSheet();
CellStyle styleGray = workbook.createCellStyle();
styleGray.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
styleGray.setFillPattern(CellStyle.SOLID_FOREGROUND);
sheet.setDefaultColumnStyle(0, styleGray);
Row row = sheet.createRow(0);
Cell cell;
int column = 0;
cell = row.createCell(column);
cell.setCellValue("I'm gray");
// Workaround: cell.setCellStyle(sheet.getColumnStyle(column));
// Workaround: sheet.autoSizeColumn(column);
cell = row.createCell(++column);
cell.setCellValue("I'm white");
workbook.write(stream);
stream.flush();
}
}
--
Configure bugmail:
https://issues.apache.org/bugzilla/userprefs.cgi?tab=email------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail:
[hidden email]
For additional commands, e-mail:
[hidden email]
Locked
