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