Re: showInPane does not work

2015-09-28 Thread Bengt Rodehav
Hello Mark, I am already using Sheet.setActiveCell() but it doesn't help. The cell becomes selected but it is not in view. My use case is a bit different. I read an existing Excel document which is a template for the Excel document I create. The source Excel sometimes has sheets that are scrolled

Re: Diagonal border

2015-09-28 Thread Bengt Rodehav
Thank you Mark and Dominik. I will try to get this information from the cell style. /Bengt 2015-09-25 18:22 GMT+02:00 Dominik Stadler : > Hi, > > There was a discussion about how to set diagonal border styling a few > weeks ago, see > http://mail-archives.apache.org/mod_mbox/poi-user/201508.mbox

Re: Shape containing "strikethrough" is converted into an image in HSLF, ppt

2015-09-28 Thread teresa
Thank you Andi Your code works for me. I am not sure how I've got into this strange behaviour, and more importantly how to avoid this. Thanks for looking into my problem. Thanks T. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Shape-containing-strikethrough-is-conv

Re: Diagonal border

2015-09-28 Thread Bengt Rodehav
I got it to work as follows: * private boolean isCrossedOut(Sheet theSheet, int theRow, int theCol) {* *Row row = theSheet.getRow(theRow - 1);* *Cell cell = row.getCell(theCol - 1);* *XSSFCellStyle style = (XSSFCellStyle) (cell.getCellStyle());* *CTXf cxf = style.getCoreXf();* *

Re: Diagonal border

2015-09-28 Thread Bengt Rodehav
BTW, the mExcelReader is just an instance of a utility class of mine that encapsulates a few things like the workbook. /Bengt 2015-09-28 11:02 GMT+02:00 Bengt Rodehav : > I got it to work as follows: > > * private boolean isCrossedOut(Sheet theSheet, int theRow, int theCol) {* > > *Row row

[ANNOUNCE] Apache POI 3.13 released

2015-09-28 Thread Andreas Beeker
The Apache POI project is pleased to announce the release of POI 3.13. Featured are a handful of new areas of functionality, and numerous bug fixes. See the downloads page for binary and source distributions: http://poi.apache.org/download.html Note: The Apache Software Foundation uses an extensi

Re: What cells are referenced by this formula?

2015-09-28 Thread Blake Watson
No suggestions? I'm looking for a way to say "If this cell (or set of cells) has changed, this other cell (or set of cells) are dependent and must be re-evaluated." On Tue, Sep 22, 2015 at 8:00 AM, Blake Watson wrote: > Is there a way to know, given a formula, what cells and named ranges are > u

Re: Shape containing "strikethrough" is converted into an image inHSLF, ppt

2015-09-28 Thread John
-- Original -- From: "Andreas Beeker";; Date: Mon, Sep 28, 2015 04:39 AM To: "POI Users List"; Subject: Re: Shape containing "strikethrough" is converted into an image inHSLF, ppt Hi Teresa, you are dealing with some strange metro-blobs [1]. I've written a