poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Greg Woolsey <greg.wool...@gmail.com>
Subject Re: Conditional Formatting issue
Date Wed, 18 Oct 2017 17:28:34 GMT
It took me the better part of a week to get tests running the first time I
set it up.  And I thought I was good with Ant and Eclipse, and passable
with Maven. Just a lot of moving parts.

Do you have a full stack trace for the error?  Seeing where it comes from
may help me dig into it.

I checked all the POI calls to Calendar.setTime(Date) that could pass a
null Date and trigger that NPE, and came up with these possibilities.

most of these are long shots, as they only throw an unexpected NPE from the
line you indicate when the input double is -Double.MIN_VALUE.  Probably not
very helpful.

* WorkdayCalculator.calculateWorkdays(...) -- used by various functions
* WorkdayCalculator.isWeekend(...) -- used by various functions
* WorkdayCalculator.pastDaysOfWeek(...) -- used by various functions
* These formula function implementations don't check for null/invalid
dates, can end up throwing this NPE
** WeekNum.evaluate()
** EDate.evaluate()
** EOMonth.evaluate()

On Wed, Oct 18, 2017 at 9:48 AM Blake Watson <blake.watson@pnmac.com> wrote:

> I'm using 3.17 and working on a simplest possible case. There's something
> about this particular sheet that seems to be causing an issue and I haven't
> figured out what yet. It's on a sheet with four conditional aspects in toto
> and two of the formats are white-on-white (basically making text
> invisible), but it's not particularly large or tricky. The formatting is
> all based on values on the same sheet...
> Related: I downloaded Eclipse and POI to build a test case, but I'm kind of
> at a loss. I haven't been able to run the tests from Eclipse.

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message