poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rob Sargent <robjsarg...@gmail.com>
Subject Re: error setting style
Date Thu, 20 Dec 2018 23:57:04 GMT
Off to a "Lab party" just now, but I hope to get you some chunks of my 
app (as broken).

On 12/20/18 4:53 PM, Greg Woolsey wrote:
> I'm interested to see how you are creating the new sheet, wondering if
> something lost a reference to the StylesTable somehow.  Since I have code
> that also manipulates styles and adds/removes cells, I'm interested to see
> if a bug was introduced or documentation needs improving, or perhaps some
> internal API is exposed without proper documentation or safety checks.
> Greg
> On Thu, Dec 20, 2018 at 3:05 PM Rob Sargent <robjsargent@gmail.com> wrote:
>> 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 <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.
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org

To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message