Cool! Thanks, Greg! On Tue, Jan 23, 2018 at 1:59 PM, Greg Woolsey <[email protected]> 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 <[email protected]> > 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 [email protected] www.PennyMacUSA.com <http://www.pennymacusa.com/>
