CTGradientFill missing from po 3.11

2015-03-03 Thread BogdanM
Hello, i'm looking forward to set gradient color ona xssfshape, but as I see, I cannot follow this tutorial: http://thinktibits.blogspot.com.au/2014/09/apache-poi-excel-gradient-fill-example.html the line: /CTGradientFill gFill = myGradientFill.addNewGradientFill(); ///* Set Type, left, right

Re: CTGradientFill missing from po 3.11

2015-03-03 Thread Nick Burch
On Tue, 3 Mar 2015, BogdanM wrote: throws this error, and i checked the lib does not contain this class... /The type org.openxmlformats.schemas.spreadsheetml.x2006.main.CTGradientFill cannot be resolved. It is indirectly referenced from required .class files/ Did you try the faq? http://poi.apa

Re: CTGradientFill missing from po 3.11

2015-03-03 Thread BogdanM
Thanks, I missed that part, sorry, thanks for the advice, it's up and running now :) -- View this message in context: http://apache-poi.1045710.n5.nabble.com/CTGradientFill-missing-from-po-3-11-tp5718118p5718120.html Sent from the POI - User mailing list archive at Nabble.com.

Fun with XSSF Fill Colors

2015-03-03 Thread Andreas Reichel
Dear All. I built a java table component, which actually represents MS Excel files (as per HSSF or XSSF flavor). Unfortunately I spent hours for fiddeling around with simple cell background colors, as a simple XSSFCell xssfCell = (XSSFCell) cell; XSSFCellStyle xssfCellStyle = xssfCell.getCellStyl

Visio 2013 vsdx support

2015-03-03 Thread Herm Flink
Hi, Anyone here knows about plans to support the new Visio 2013 (.vsdx) format for text extraction? I know this format is not an OLE2 format, so the VisioTextExtractor cannot be used here (only supports vsd). Also, using the ExtractorFactory (from POI 3.11) does not work: Invalid OOXML Package

Re: Visio 2013 vsdx support

2015-03-03 Thread Nick Burch
On Tue, 3 Mar 2015, Herm Flink wrote: Anyone here knows about plans to support the new Visio 2013 (.vsdx) format for text extraction? I know this format is not an OLE2 format, so the VisioTextExtractor cannot be used here (only supports vsd). Also, using the ExtractorFactory (from POI 3.11) d

XSSFWorkbook File constructor not defined in 3.11

2015-03-03 Thread Zac Harvey
I am having the exact same issue reported in this StackOverflow question: http://stackoverflow.com/questions/25101559/xssfworkbook-constructor-is-undefined To reproduce, use these Gradle dependencies: dependencies { compile ( 'org.apache.camel:camel-core:2.14.1',

Re: XSSFWorkbook File constructor not defined in 3.11

2015-03-03 Thread Nick Burch
On Tue, 3 Mar 2015, Zac Harvey wrote: When that runs, you'll get: About to read a file into a handler. File C:\Users\myuser\sample.xlsx read into a handler. groovy.lang.GroovyRuntimeException: Could not find matching constructor for: org.apache.poi.xssf.usermodel.XSSFWorkbook(java.io.File)

Re: XSSFWorkbook File constructor not defined in 3.11

2015-03-03 Thread Dominik Stadler
Hi, Your dependencies contain "poi-3.8", the constructor with File did not exist in that version yet, see http://svn.apache.org/viewvc/poi/tags/REL_3_8_FINAL/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFWorkbook.java?revision=1301934&view=markup Not sure how you got the 3.11 in the output of

Re: XSSFWorkbook File constructor not defined in 3.11

2015-03-03 Thread Zac Harvey
Thanks Dominik, That was a copy n' paste error on my part. I *am* using 3.11 for all deps (earlier I had tried 3.8 and forgot to update my Gradle snippet when writing my original email). I tried Nick's suggestion and recreated the Driver as a Java source and, to my great surprise, the probl

Re: XSSFWorkbook File constructor not defined in 3.11

2015-03-03 Thread Dominik Stadler
BTW, the following works fine for me: apply plugin: 'groovy' apply plugin: 'application' version = '1.0' mainClassName='Test' repositories { mavenCentral() } dependencies { compile 'org.codehaus.groovy:groovy-all:2.0.0' compile ( 'org.apache.camel:camel-core:2.14.1',