poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Blake Watson <blake.wat...@pnmac.com>
Subject Re: Conditional Formatting issue
Date Mon, 23 Oct 2017 21:00:54 GMT
Greg--

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

This is exactly right. The error is in EDate.java which is calling
calendar.setTime(-1).

So, the workbook has a cell, Model!A4 which resolves to a -1 (but not null)
date. But, when EData calls getJavaDate(-1), that returns "nil" which is
then passed to calendar.setTime. I'm going to try to really simplify the
example, which...maybe is only incidental to conditional formatting? Or
there's something that the conditional formatting isn't catching that it
should?



On Mon, Oct 23, 2017 at 9:57 AM, Blake Watson <blake.watson@pnmac.com>
wrote:

> OK: I was not doing it for my example, but adding it in didn't change
> anything. I am creating a cell object, but I'm not changing any values (or
> formats).
>
> I was able to open the file as well, after some fussing around. I think it
> was just something I didn't get about FileInputStream. So I now have the
> code in Java and with a stack trace. This produces the error. I'll put the
> whole thing up in Bugzilla, then I'll go back and try to find the exact
> cause.
>
> public class Main {
>     public static void main(String[] args) {
>             try {
>                 Workbook wb = WorkbookFactory.create(new File("condfail.xlsx"));
>                 Sheet sheet = (wb.getSheet("IRPPCalc"));
>                 Row row = (sheet.getRow(11));
>                 XSSFCell cell = (XSSFCell) row.getCell(18);
>                 WorkbookEvaluatorProvider fe = (WorkbookEvaluatorProvider) wb.getCreationHelper().createFormulaEvaluator();
>                 System.out.println("&&&&");
>                 ConditionalFormattingEvaluator condfmt = new ConditionalFormattingEvaluator(wb,
fe);
>                 System.out.println(">>>>" + condfmt.getConditionalFormattingForCell(cell));
>             } catch(Exception e) {e.printStackTrace();};
>     }
> }
>
>
>


-- 

*Blake Watson*

*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com
www.PennyMacUSA.com <http://www.pennymacusa.com/>

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