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
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
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
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.
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.
Unfortunately, you currently won't be able to do this, as we don't expose a mechanism publicly for evaluating CF rules for a particular cell.
I think we can expose it though, so i'll write up a bug, so in a future SR it will be possible. Note: that you'll still have to do the work of reading through the returned style and converting the properties that you want to modify into Excel "styles".
-SteveZ