How to copy cell styles in an XSSFWorkbook?

[laredotornado]

Hi,

I'm using

<dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>3.5-beta5</version>
</dependency>

and trying to copy information from in a worksheet from one XLSX workbook to a new worksheet in a different workbook. I am trying this ...

						final Cell newCell = newRow.createCell(colNum);
						newCell.setCellValue(oldCellValue);
						final CellStyle newCellStyle = newWorkbook.createCellStyle();
						newCellStyle.cloneStyleFrom(oldCell.getCellStyle());
						newCell.setCellStyle(newCellStyle);

However, the code is dying with

java.lang.StackOverflowError
	at org.apache.poi.xssf.usermodel.XSSFCellStyle.cloneStyleFrom(XSSFCellStyle.java:113)
	at org.apache.poi.xssf.usermodel.XSSFCellStyle.cloneStyleFrom(XSSFCellStyle.java:114)
	...

What is the correct way to copy a cell style from a cell in one workbook to a different cell in a new workbook? Thanks, - Dave

[Tolls]

It's a bug, which is not unheard of in a Beta.
This is the code for that method:

    public void cloneStyleFrom(CellStyle source) {
        if(source instanceof XSSFCellStyle) {
            this.cloneStyleFrom(source);
        }
        throw new IllegalArgumentException("Can only clone from one XSSFCellStyle to another, not between HSSFCellStyle and XSSFCellStyle");
    }

Go up to Beta6 which has this working properly.

[laredotornado]

Thanks, upgrading solved it.