Re: Disable CDATA in XSSF workbook 5.0.0

Hi,

What happens if you call the two methods mentioned in the Bug with custom
values appropriate before you actually use Apache POI in your code?

Its a public static object, so you can access it from your code and
add/modify XML options if you need to.

Dominik.

On Thu, Aug 26, 2021 at 6:04 PM Jeremy Pennington <[email protected]>
wrote:

> I have some long formulas that are turned into CDATA (they have 5+ &'s in
> them) but I would like to disable that.
>
> I found an old comment from Yegor Kozlov with a way to disable CDATA as a
> workaround for a bug (https://bz.apache.org/bugzilla/show_bug.cgi?id=48936).
> I attempted this method in 5.0.0 with no success. I'm not sure if that's in
> part due to DEFAULT_XML_OPTIONS no longer being in POIXMLDocumentPart or
> not (I tried passing nothing to the XmlOptions constructor as well as
> POIXMLTypeLoader.DEFAULT_XML_OPTIONS).
>
> Thanks,
>
> Jeremy
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>