AdvStringGrid GetCellColor in preview and print

van_Megen_J · April 3, 2021, 6:35pm

Hi,
I have a stringgrid with data and selected cells collered with onGetCellColor.
The color appears in the stringgrid, but when I make a preview no colors are visible.
Is this a setting?

brunofierens · April 5, 2021, 7:48am

"Preview"?
Do you mean print preview here?
If so, assign your OnGetCellColor event also to OnGetCellPrintColor

van_Megen_J · April 6, 2021, 7:37am

Yes, this works, thank you.
What I noticed is that suppressed cols are in the preview and print visible.The same is for SavetoXLS.
Further, I merged some cells and when I export to Excel (SavetoXLS) these cells are no merge anymore and the value is put in every cell I merged. So if I merge row 0 and coll 0 to10 the value in my grid or preview is put in every 10 cells in row 0.

van_Megen_J · April 6, 2021, 7:38am

Also the programmaticly changed col sizes are ignored

brunofierens · April 6, 2021, 1:37pm

It does not take suppressed columns in account for preview or print. Use column hiding if this is needed or set grid.PrintSettings.NoAutoSize = true
To export to XLS with cell merging & colors, use TAdvGridExcelIO https://www.tmssoftware.com/site/asg56.asp or the TMS VCL Excel Bridge https://www.tmssoftware.com/site/vclgridexcelbridge.asp

van_Megen_J · April 6, 2021, 4:59pm

Do I need an update?

brunofierens · April 6, 2021, 6:40pm

What exactly did you install?