poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Greg Woolsey <greg.wool...@gmail.com>
Subject Re: error setting style
Date Thu, 20 Dec 2018 22:55:17 GMT
Can you provide a test case, sample code, or full stacktrace?  How is the
new sheet created? It looks to me from the code that the message means
exactly what it says - the style you are trying to set and the cell you are
trying to set it on come from different Workbook objects.  Both the style
and the cell hold a reference to the StylesTable object read from (or
created for) the Workbook in which they are found.  POI doesn't support
directly assigning styles across Workbook instances.  See this thread[1]
for a description of why, and what to do instead when you need to copy a
style between workbooks.

Greg

[1]
https://stackoverflow.com/questions/10773961/apache-poi-apply-one-style-to-different-workbooks

On Thu, Dec 20, 2018 at 11:58 AM Rob Sargent <robjsargent@gmail.com> wrote:

> I'm using 4.0.1 as of this morning hoping this would help.  I have
> recently begun to get:
>
>     Exception in thread "main" java.lang.IllegalArgumentException: This
>     Style does not belong to the supplied Workbook Styles Source. Are
>     you trying to assign a style from one workbook to the cell of a
>     different workbook?
>          at
>
> org.apache.poi.xssf.usermodel.XSSFCellStyle.verifyBelongsToStylesSource(XSSFCellStyle.java:121)
>          at
>     org.apache.poi.xssf.usermodel.XSSFCell.setCellStyle(XSSFCell.java:667)
>
> and I am adding style to a cell in a new sheet, same workbook. The
> immediate code is not new and had been working (in 4.0.0). Not sure what
> change I made has caused this to start.
>
> I confess the original xlsx has been touched by LibreOffice/Calc and
> saved as xlsx.  Linux file command reports:
>
>     file '/home/u0138544/tools/reform/Compicated Query for Rob Tool.xlsx'
>     /home/u0138544/tools/reform/Compicated Query for Rob Tool.xlsx:
>     Microsoft OOXML
>
> Any suggestions appreciated.
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message