Get every cells in a GridView

[minh]

Hi Telerik team

I would like to go through every cell in a RadGridView to get the value, foreground and background of each cell.

Do you have any solution for that?

For your information, I tried  gridView.ItemContainerGenerator.ContainerFromItem() but it work only for the current view port but I need all pages.

 

Many thanks for your support,

 

[Stenly]

Hi Minh,

Could you please specify why do you need the Background and Foreground properties of each cell? So we can try to provide a solution for your issue.

[minh]

Hi Stanley,

Thank for your prompt reply.

In fact, I have a financial grid where some cells have specific foreground and background colors. I need develop a print preview of the grid and keep all the current grid view properties such as colors of cells, width of cells, alternative row colors, number format in cell etc…

I tried use the default print preview of telerik but the result is very far from what we expected, because the grid is quite complex with alot of business rules to be considered. I finaly chose export to excel way where I can freely custom the preview as I want based on the current view of grid. That’s why I need to know the colors of every cell in the current grid.

Many thanks,

Minh

 

[Stenly]

Hi Minh,

WPF uses UI virtualization which renders rows that are only visible on the window. This prevents you from reading all of the rows in the grid. Please refer to the following documentation regarding the UI virtualization:

WPF DataGrid | UI Virtualization | Telerik UI for WPF

The UI virtualization could be disabled, then all the visual elements will be loaded once RadGridView is visualized and its items are populated.

Please note, however, that this can lead to huge performance issues and additional loading time, and thus - disabling the virtualization when dealing with large amounts of data is highly not recommended.

What I can suggest is to instead work with the underlying data items and style the exported Excel document as explained in this article. Please let me know if you would find this applicable.

Regards,
Stenly
Progress Telerik

[minh]

Hi Stanley,

Many thanks for your reply. Yes, you're completely right on UI virtualization. I had tried to disable Virtualization and my grid is extremely slow on loading :-(.

Regarding to your suggestion, it's still missing background color of cell and also the look is quite far of our expectation. However, we found an alternative way to preview and I'm going to close this post.

 

Many thanks for your supports.