addMergedRegion compile error at 3.14

2017-01-20 Thread Giuseppe Costagliola
I'm upgrading from 3.9 to 3.14 but this statement (that compiles fine at 3.9) : sheet.addMergedRegion(new Region(rowNum-1, (short) 0, rowNum-1, (short) iTitleCols)); gives this compile error with 3.14: addMergedRegion(org.apache.poi.ss.util.CellRangeAddress) in org.apac

Re: addMergedRegion compile error at 3.14

2017-01-20 Thread Javen O'Neal
See the 3.15 beta 1 changelog https://poi.apache.org/changes.html#3.15-beta1 Bug: 59170 Module: SS Common *Remove deprecated classes (POI 3.15) - org.apache.poi.hssf/ss.util.Region (breaks backwards compatibility)* *We have made some backwards-breaking changes in order to harmonize HSSF, XSSF, and

Re: addMergedRegion compile error at 3.14

2017-01-20 Thread Javen O'Neal
Also, make sure you're recompiling your application against each version of POI as you upgrade, as we may have unintentionally broken binary backwards compatibility. We're in the early stages of comparing POI releases for backwards compatibility using JApiCmp to find unintentional source and binar

Question about extracting text from charts in XLSX

2017-01-20 Thread Chris Bamford
Hi POI folks, I have an Excel XLSX file containing a simple chart which in turn has some text in it (title, etc.). When I try to extract the text from the file using XSSFEventBasedExcelExtractor, it fails to find the chart text. I have dug around in the code and cannot see any calls which migh

Re: Question about extracting text from charts in XLSX

2017-01-20 Thread Javen O'Neal
> When I try to extract the text from the file using XSSFEventBasedExcelExtractor, it fails to find the chart text. Our XSSFChart support is pretty limited right now, so I wouldn't be surprised if the extractor can't find the text on the chart (title, legend series names, axes labels, trending equa

RE: add spacing to footer when generating .docx

2017-01-20 Thread Murphy, Mark
Does adding a couple extra blank paragraphs in the footer work for you? From: Olga Bondareva [mailto:obondar...@objectstyle.com] Sent: Thursday, January 19, 2017 11:11 AM To: user@poi.apache.org Subject: add spacing to footer when generating .docx Hi all, Could you tell me please how to add spaci