About Excel visual grid performance...I have tried many data table libraries over the years in various languages. Almost all have performance issues when reaching 100-1000+ row range (even with virtualization and other tricks enabled). I would like to know how the Excel team made their grids so fast. Scrolling is so smooth.
MS Office was updated to use GPU accelerated rendering and I guess this has something to do with it. I don't know how this works (which API, which portions of the software, which algorithms) as details on that seem to be pretty sparse.
Same here. From around Excel 2007 - 2013... activating the GPU acceleration option slowed Excel way down. I remember turning off the setting many times during those years to get better performance.
Fast forward to 2016-today...Microsoft fixed the GPU acceleration bugs.
I recently opened a 9000 row sheet in LibreOffice Calc on an x220 and had no performance degradation at all. In fact I was impressed at how responsive the application felt compared to Excel. Might be interesting to try bigger and bigger files until it looks like it's slowing down.
