Hi I have huge set of data to load and format conditionally (400k+ rows and 100+ columns)
I'm using InitRow event and shared Appearance object, as explained here:
But still getting Out of Memery exception (my PS has 16Gb mem + 30 Gb Swap...)
Do you know any solution for that ?
Maybe there is an on option to perform conditional formatting *ONLY* for displayed rows / cells, instread all dataset ?
tested on both v. 18.2 and 19.1V. 19.1 throws Out of Memory error even quicker then 18.2 ...