Hi,
Is it possible to implement Custom rule for Conditional Formatting feature in xamGrid?
If Yes,Can you please provide us with an example?
Thanks
Yes it is possible.
Check out these forum posts that have examples of some custom rules:
http://community.infragistics.com/forums/p/53040/275161.aspx#275161
http://community.infragistics.com/forums/p/52867/274473.aspx#274473
Hope this helps,
-SteveZ
How do we pass on the conditional formatting in grid to Excel(while exporting from Grid to excel)?
To add to what Steve has mentioned, he has created a development issue with an ID of 74649. I have created a private case for you that you can use to track this issue and be notified when the fix is available in a release.
You'll be able to access this case from the My Support Activity page:
<https://ko.infragistics.com/Membership/MySupport.aspx>
Please let me know if I can be of any further assistance.
This issue is now resolved in the latest service release. This service release is available under your account at the Infragistics Website. To download the service release, log in to ‘My IG’ and select ‘Keys & Downloads’. Select the NetAdvantage tab and then click on the product name. The available service releases should now be listed on the page underneath the tab control.
Please let me know if you have any further questions or concerns about this matter.
Hi
I want to change the color of the cell in the "Excel sheet" based on some condition. Please guide me how can i achieve this. Can we do this by using conditional formatting?If yes, please tell how we can do this
Thanks,
Prasoon
Hi Prasoon,
Currently the Infragistics Excel framework does not support the conditional formatting. This feature has already been added to our product idea system though, so I recommend that you head over and vote for it. http://ideas.infragistics.com/forums/192359-windows-forms/suggestions/6396988-conditional-formating-for-documents-excel
Currently, you'll only be able to apply cell colors conditionally when you are programmatically creating the worksheet. This would mainly consist of you setting the WorksheetCell value and then depending on what value you set inside it, you would get the WorksheetCell.CellFormat and set the cell properties to change the way the cell looked. The CellFormat contains many properties you can use to adjust how the cell looks. http://help.infragistics.com/doc/Silverlight/2014.2/CLR4.0/?page=InfragisticsSL5.Documents.Excel.v14.2~Infragistics.Documents.Excel.IWorksheetCellFormat_members.html