I have circumvented the situation by using copyStyleFrom(). I posted
because a) I'm setting styles on cell in a new sheet in the origin
workbook - which to me contradicts the helpful hint and b) I had been
doing exactly that in the recent pass.
If you still want my code which generates the error I can back up a
bit. The partial stack trace I sent was all lines not in my code.
On 12/20/18 3:55 PM, Greg Woolsey wrote:
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 <[email protected]> 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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
