@adrian Thanks. Makes sense.
So I have been using the simple grid and my own drop-down combobox. The workbook variant is visually much nicer.
The underlying issue I was wondering was whether they handled memory differently when actually displaying the full cell properties
I am trying to use the grid to preview some BIG files where the color (background and font) is actually the important bit. The file I am looking at right now (Excel 97-2003 format) is nearly 30MB, approximately 25 sheets and upwards of 250 columns in some. In Excel the memory usage with the file loaded goes to about 200-230MB, but not too bad.
I can load it in the AdvStringGrid with cell properties option turned off. Memory usage goes up to about 160MB during loading and then drops back when the sheet is displayed.
When I turn on the cell properties option (as I need), loading the file and preparing for display takes a quite a long time, and you can watch memory usage climb and climb till it hits about 1.7GB, and the program reports out of memory..
From your description it sound like I am not going to solve main main issue simply using the built in functionality. I may have to see about whether I can use the virtual methods and all of the cell rendering myself. But I don't have time for that right now. I also think it is probably a question for one of the other sections in the TMS forum