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/>