Re: NoSuchMethodError: org.apache.xmlbeans.XmlOptions.setEntityExpansionLimit

The method is here - https://github.com/apache/xmlbeans/blob/trunk/src/xmlpublic/org/apache/xmlbeans/XmlOptions.java#L881 and appears in xmlbeans 3.1.0. Maybe you have multiple versions of xmlbeans on your classpath and the older version is being picked up. -- Sent from:

Re: Legacy ooxml-schemas.1.1.jar

I replied to original message at http://apache-poi.1045710.n5.nabble.com/Compiling-ooxml-schemas-1-1-jar-in-a-different-namespace-tc5734173.html poi-user (this mailing list) is probably best place for this type of query though. -- Sent from:

Re: I tey to get POI 4.1.0 to work in Atlassian Confleuce 7.0.0 or above

Agreed about not delaying POI 4.1.1 release due to this discussion. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional

Re: I tey to get POI 4.1.0 to work in Atlassian Confleuce 7.0.0 or above

Anyone know why we omit xmlsec dependency from the poi-ooxml pom file? https://repo.maven.apache.org/maven2/org/apache/poi/poi-ooxml/4.1.0/poi-ooxml-4.1.0.pom If we don't want a full runtime/compile scope, could we add a `provided`scope? -- Sent from:

Re: sheet.removeMergedRegion throwing Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException

If you remove regions inside the loop then the array gets smaller. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands,

Re: How to Add Notes To XSLFSlide?

Have you tried XMLSlideShow#getNotesSlide(XSLFSlide slide)? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands,

Re: Issue in upgrading Poi 3.7 version to 3.17 version

Can you provide the description of the error - it was omitted in your original post. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For

Re: Loading Large XLSM file using POI without Memory issue .

Xlsx and Xlsm files are zip files. You could try using Java ZipFile or ZipInputStream to read the file. Most of the files in the zip are XML files. You could filter out the file that has the sheet data for the sheet that you want to delete. It's quite likely that some of the other XML files will

Re: Loading Large XLSM file using POI without Memory issue .

You can read the xslx file using the SAX approach you highlighted and you can use a SXSSFWorkbook to write out a new xlsx file. SXSSFWorkbook is for writing large xlsx files and it avoids keeping all the data in memory (by storing the data in temp files). You're probably going to have to use a

Re: POIXMLTextExtractor.java : IllegalStateException

The code is there to protect against https://en.wikipedia.org/wiki/Zip_bomb -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional

Re: Use different logger

I forgot about POILogger constructor issue - I raised https://bz.apache.org/bugzilla/show_bug.cgi?id=63047 - an ugly workaround is to create the custom logger in the `org.apache.poi.util` package for now. I'd like us to consider https://bz.apache.org/bugzilla/show_bug.cgi?id=63047 in the medium

Re: Use different logger

Have a look at https://github.com/apache/poi/blob/trunk/src/java/org/apache/poi/util/POILogFactory.java#L74 You can use the system property "org.apache.poi.util.POILogger" to provide a class name of an alternate implementation of org.apache.poi.util.POILogger. The new class will need to sublass

Re: how to instrument the apache bundles poi 4.0.0_1

This is the mailing list for the Apache POI project. The Service Mix POI bundle is not maintained by us. If you are working on maintaining projects with POI dependencies, I would recommend using POI 4.0,1 and removing anything to with poi-contrib which is not maintained. -- Sent from:

Re: how to instrument the apache bundles poi 4.0.0_1

Is poi-contrib still supported? I didn't think it was and I suspect that the poi-contrib 3.6 will not work with poi 4.0.x. Also, would it better to use poi* 4.0.1 - more stable than 4.0.0? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

Re: XWPF set text language

I raised a bug - https://bz.apache.org/bugzilla/show_bug.cgi?id=63013 It looks like a missing setter to me. If you can create your own subclass of XWPFRun, you could try this extra method: public void setLang(String lang) { CTRPr pr = run.isSetRPr() ? run.getRPr() : run.addNewRPr();

Re: Hyperlink() special case

How about `public final class HyplerlinkEval implements HyperlinkValueEval, StringValueEval` where HyperlinkValueEval has a `Hyperlink getHyperlinkValue()` method? This way you can treat the result as a string and get the current behaviour (to maintain compatibility) or you can treat the result as

Re: How Right to left in XMLSlideShow (Apache Po)

In many instances, Microsoft applications interpret the need for RTL rendering from the characters used. Would it be possible for you to create a pptx with Arabic text with POI and then use Powerpoint to view it? If there any rendering issues, fix it with Powerpoint. Then, send the POI team the 2

Re: support for java 8 date classes

Hi, Would it be possible for you to create an XMLBeans JIRA at https://issues.apache.org/jira/projects/XMLBEANS ? We are happy to merge contributions but this change looks like it will need quite a bit - so I suspect that it won't be taken on unless there was a lot of interest in it. -- Sent

Re: formula float point problem

You could also use Java DecimalFormat class to format Doubles are Strings with the decimal precision set. See https://www.mkyong.com/java/java-display-double-in-2-decimal-points/ -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

Re: formula float point problem

This is what the DataFormatter class is for - could you try it? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands,

Re: formula float point problem

You can use https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DataFormatter.html -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org

Re: java.lang.ClassCastException: com.ibm.xml.xlxp2.api.stax.XMLEventFactoryImpl incompatible with javax.xml.stream.XMLEventFactory

It looks like that IBM pull parser is incompatible with what POI needs. Could you try adding https://github.com/FasterXML/woodstox to your classpath to see if that is loaded in preference to the IBM one? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

Re: Urgent:POI4.0.0 causes org.apache.poi.javax.xml.parsers.FactoryConfigurationError

Try adding xercesImpl 2.12.0 jar to your classpath -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail:

Re: Urgent:POI4.0.0 causes org.apache.poi.javax.xml.parsers.FactoryConfigurationError

The latest nightly build is at https://builds.apache.org/view/P/view/POI/job/POI-DSL-1.8/lastSuccessfulBuild/artifact/build/dist/ -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe,

Re: Urgent:POI4.0.0 causes org.apache.poi.javax.xml.parsers.FactoryConfigurationError

This issue will be fixed in POI 4.0.1 (fix already committed) -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands,

Re: POI 4.0.0 Jar files for Android

https://github.com/centic9/poi-on-android/issues/44 poi-on-android is a separate project and only currently supports POI 3.17 -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe,

Re: new to POI, help needed!!

https://commons.apache.org/proper/commons-compress/download_compress.cgi - download v1.18 -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org

Re: contact info for Dominik Stadler

It would be better to work through the forum. Many people like to keep their email details private. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail:

Re: Not on Android: Provider com.bea.xml.stream.EventFactory not found

These parser settings are normally either set using java system properties (eg using `-D javax.xml.stream.XMLEventFactory=com.acme.MyClass`) or jars on your classpath have META-INF/services (eg https://github.com/FasterXML/woodstox/tree/master/src/main/resources/META-INF/services).

Re: POI 4.0.0 issues with new commons-compress library "InputStream of class [..] is not implementing InputStreamStatistics"

I just logged https://issues.apache.org/jira/browse/HADOOP-15804 but it can take a long time for upgrades in hadoop dependencies due to the large number of projects and the complex relationships between them. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

Re: Help! Fatal Exception when 'wb.write(fileOut)' is called

yes, please add xerces-2.12 dependency -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail:

Re: Help! Fatal Exception when 'wb.write(fileOut)' is called

https://stackoverflow.com/questions/52218278/after-update-apache-poi-4-0-property-http-www-oracle-com-xml-jaxp-propertie -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail:

Re: xmlbeans 3.0.1 is missing source in maven repo

The source jar has a non-standard name but is there: https://bintray.com/bintray/jcenter/org.apache.xmlbeans%3Axmlbeans/3.0.0#files/org%2Fapache%2Fxmlbeans%2Fxmlbeans%2F3.0.0 https://issues.apache.org/jira/projects/XMLBEANS/issues/XMLBEANS-520 - fixed for v3.0.2 (when it's released) -- Sent

Re: Version 4.0.0

https://github.com/apache/poi/pull/85 was not merged. There is a comment (last one from June 30) that highlights a new project called `poi-shared-strings` that implements this. https://github.com/pjfanning/poi-shared-strings A snapshot has been published to sonatype maven -

Re: POI 4.0 release date

POI 4.0 should be released soon, but the date is not yet set. POI 3.17 has some changes that improve its compatibility with Java 9 and presumably Java 10. Would it be feasible for you to try 3.17 if you can't wait for 4.0? -- Sent from:

Re: How To Get/Generated XmlBean

POI now needs xmlbeans 3.0.1. It will only work with this version. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands,

Re: How To Get/Generated XmlBean

The latest poi trunk ant build will pull the xmlbeans 3.0.1 from apache staging mvn repo. The CI build for poi is working with this. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To

Re: General Support for Percentage Values?

How about adding `void setWidthType(TableWidthType widthType)` and `TableWidthType getWidthType()`? TableWidthType would be a new Enum Type that supports the values on STTblWidth.Enum. NIL, PCT, DXA, AUTO We don't like to expose the XMLBeans generated classes in our public API. -- Sent

Re: Delete specific XSLFTextParagraph in XSLFShape

https://github.com/apache/poi/blob/trunk/src/ooxml/java/org/apache/poi/xslf/usermodel/XSLFTextShape.java has an addNewTextParagraph method. There doesn't appear to be a remove paragraph method. You might be able to remove a paragraph by calling the `public Iterator iterator()` and removing the

RE: How to Resolve "Indirectly referenced from required .class files" Issue?

I've already added artificial tests to ensure the CTEm class is included in future versions of poi-ooxml-schemas.jar. The full ooxml-schemas jar is published to maven and it is just a convenience for poi to default to using the much smaller poi-ooxml-schemas.jar. -- Sent from:

Re: How to Resolve "Indirectly referenced from required .class files" Issue?

poi-ooxml depends on poi-ooxml-schemas and this latter jar has the most commonly used XMLBeans generated classes for the OOXML xsds. CTEm appears to be missing from this jar. We can add it for the 4.0.0 release. ooxml-schemas has the full set of generated classes. We will be releasing v1.4 of this

Re: XWPFFieldRun Doesn't Work for Creating DOCX

Hi Eliot, Could you log an issue in bugzilla to track this? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands,

Re: General Mechanism in WXPF Code for Managing CT IDs?

We don't seem to have set ids explicitly normally -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail:

Re: Any Active Work to Improve XWFPFootnote Methods?

If you could add the missing methods to the XWFPFootnote and submit a pull request, that would be great. We'd like to avoid exposing the underlying XMLBeans generated classes indefinitely. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

Re: How to Set Up XPath/XQuery With Latest POI and XMLBeans Using Maven?

When we release xmlbeans 3.0.0, we didn't release a new version of xmlbeans-xpath jar. The 2.6.0 version of xmlbeans-xpath should work ok with xmlbeans 3.0.0. The Saxon dependency that it has is old though. It was built with

Re: Workbook saved using POI 3.16 needs to be repaired when opening in Excel 2016

Could you try poi 3.17? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org

Re: Long XSLF Table needs splitting

https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/HyperlinkExample.java The example is xlsx files but the similar APIs exist for other document formats. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

Re: wrong format cell value

https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DataFormatter.html includes descriptions about how to set locales -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe,

Re: Question: Problem with Encryption in POI

https://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/xssf/streaming/examples/SavePasswordProtectedXlsx.java?view=markup This sample uses a custom SXSSF workbook but you could use a plain XSSFWorkbook instead. Basically you save the XSSFWorkbook to a file using

Re: Updating first row at end of creating xlsx using xssf

If you are not worried about holding the full row set in memory, then XSSFWorkbook will allow you to construct the full workbook and update the first row before saving. If you need to stream the data to avoid holding full row set in memory, then you could do the streaming twice - once to produce

Re: Specification Bug with rowIndex attribute for Rows?

Can you log an issue and provide the xlsx that causes this? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands,

Re: Is it POI error starting 3.14 version onwards

https://github.com/apache/poi/blob/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java https://github.com/apache/poi/blob/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java These are our 2 main streaming xlsx reading examples and both use

Re: Is it POI error starting 3.14 version onwards

https://github.com/apache/poi/blob/trunk/src/ooxml/java/org/apache/poi/util/SAXHelper.java org.apache.poi.util.SAXHelper has a newXMLReader() method that creates an XMLReader instance that satisfies the requirements for this use case. -- Sent from:

Re: XSSFWorkbook throws outofMemoryError

https://github.com/monitorjbl/excel-streaming-reader supports reading Excel docs but allows use of Workbook Model APIs based on the POI Workbook Model. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

POI snapshot jars

Do we publish poi snapshot jars to a maven repo? I checked http://repository.apache.org/snapshots/ but didn't find poi jars. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe,

Re: Problem using INDEX within MAX: WARNING: Incomplete code - cannot handle first arg of type (org.apache.poi.ss.formula.eval.NumberEval)

Thanks for the detailed error report. Can you create an issue so that we can track this? https://bz.apache.org/bugzilla/ -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail:

Re: Infinite loop in SectionIDMap.get() and .put()

Hi Arjohn, Could you log a bugzilla issue? Would it be possible to provide a Java test case? -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html - To unsubscribe, e-mail:

Re: RE: [ANNOUNCE] Apache POI 3.17 released

Would it be possible to consider moving the H??F code to a separate jar? That is, having the shared code in poi.jar but the X??F impls in poi-ooxml.jar and the H??F impls in poi-legacy.jar (or some better name). I would assume that a lot of the CVEs would relate to H??F code. In my team, we only

Re: ArrayStoreException when running getShapes on slide of XSLFSheet

Can I clarify? This issue occurs consistently for specific input files or is it an intermittent issue? -- View this message in context: http://apache-poi.1045710.n5.nabble.com/ArrayStoreException-when-running-getShapes-on-slide-of-XSLFSheet-tp5728358p5728359.html Sent from the POI - User

Re: corruption in xlsx spreadsheet generated by poi?

The xlsx file is a zip with XML files in it. I unzipped up your xlsx but didn't see anything obvious. Maybe, you would be able to have a look yourself. The .rels XML link to other XML files and maybe it's worth checking to see if there are relationships that are not valid (pointing to missing

Re: corruption in xlsx spreadsheet generated by poi?

The most recent version of POI is 3.17 beta1. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/corruption-in-xlsx-spreadsheet-generated-by-poi-tp5728053p5728054.html Sent from the POI - User mailing list archive at Nabble.com.