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: ConditionalFormattingEvaluator.getConditionalFormattingForCell: slow?
Date Tue, 23 Jan 2018 23:11:43 GMT
Cool! Thanks, Greg!

On Tue, Jan 23, 2018 at 1:59 PM, Greg Woolsey <greg.woolsey@gmail.com>
wrote:

> Interesting!  I'd love to see that as Java to run some comparisons, but I
> don't have the time right now to investigate.  If you do it, I'd evaluate
> and commit it if appropriate.
>
> On Tue, Jan 23, 2018 at 1:32 PM Blake Watson <blake.watson@pnmac.com>
> wrote:
>
> > OK, FWIW, I did this:
> >
> > 1. I get all the rules on the sheet...
> > 2. ...and map the rules to their formatting...
> > 3. ...then call getMatchingCells for each rule...
> > 4. ...and create a map of cells to formatting...
> > 5. ...then merge the maps for all rules...
> >
> > I ended up with a hash-map of cell=>formatting that is much faster (20x)
> to
> > reference for each cell than calling .getConditionalForCell. (That's for
> > one 800 cell sheet on a smallish spreadsheet of about 70K with three
> simple
> > conditional formatting rules.)
> >
> > If I can Java-ize it, it might be worth putting into a utility unit.
> >
> > ===Blake===
> >
>



-- 

*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