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.wat...@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=== >