I may not be, let me double-check.
On Fri, Oct 20, 2017 at 11:06 AM, Greg Woolsey <greg.wool...@gmail.com>
wrote:
> I just tried opening the file you attached in the last message. It opened
> fine for me, no uncaught exceptions. When I opened it in Excel 2016, I
> noticed the date formatted cells apparently resolve to empty values, which
> are then treated as numeric 0 by Excel, and displayed as "1/0/1900".
>
> I didn't see any conditional formatting issues, in fact my processing
> appears to show them applying OK via POI.
>
> You mentioned in your first message, which I missed, that you are creating
> a new cell after parsing, in a range covered by an existing conditional
> formatting rule, then setting its value.
>
> The JavaDoc for ConditionalFormattingEvaluator notes you need to call
> clearAllCachedValues() whenever cell values change. Are you doing this?
> That could be the cause of your error.
>
> On Thu, Oct 19, 2017 at 2:31 PM Blake Watson <blake.wat...@pnmac.com>
> wrote:
>
> > So, in working out the Java for this, I've somehow got myself into a
> > condition where I can't even open the workbook (in Java). When I step
> > through this:
> >
> > FileInputStream fis = new FileInputStream("condfail.xlsx");
> > Workbook wb = new XSSFWorkbook(fis);
> >
> > I got a NoClassDefFoundError.
> >
> > Exception in thread "main" java.lang.NoClassDefFoundError:
> > org/apache/xmlbeans/XmlObject
> > Disconnected from the target VM, address: '127.0.0.1:47092', transport:
> > 'socket'
> > at com.fidnip.Main.main(Main.java:22)
> > Caused by: java.lang.ClassNotFoundException:
> org.apache.xmlbeans.XmlObject
> > at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
> > at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
> > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
> > at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
> > ... 1 more
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
> > For additional commands, e-mail: user-h...@poi.apache.org
>
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.wat...@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>
