I'm creating an excel spreadsheet using Infragistics 10.3. One of the requirement is to display and event (some text) in a cell with the cell backcolor set to green. If the event is cancel the client still wants it to be displayed except with a single diagonal black stripe through the cell. This is easy to do in excel by using the diagonal border however through the
Worksheet.Rows(i).Cells(j).CellFormat
class there is no diagonal border property available. I've tried using the FillPatternStyle but cannot get the desired effect. How would I go about getting a single black diagonal line through a cell?
Hello,
I am just checking about the progress of this issue. Let me know If you need any further assistance on this issue?
Thank you for using Infragistics Components.
Hi. Thanks for the support. I still need to download 11.1 to test it out.
That is the RTM version of 11.2, which was released before the diagonal borders were implemented. You must upgrade to the latest SR of 11.2 to use the diagonal borders.
Hi. I'm now using Infragistics3.Documents.Excel.v11.2 version 11.2.20112.1010 and am still unable to find or use this functionality. Can you please provide an example for me.
Thanks
Andrew
Hello,
This issue was already fixed in the latest internal build and I believe that this will be included in the very next public service release.
If you have any deadlines and this is too urgent for you, please feel free to let us know.
Please let me know if you have any further questions.
I've downloaded and installed 2011.1 and the service release. The version of the Infragistics2.Documents.Excel that is being used is 11.1.20111.2042
I'm still not able to find any functionality to create diagonal borders in cells. Looking in the Worksheet.Rows(i).Cells(j).CellFormat class all I can find support for are the Top, Bottom, Left and Right borders. Please could you provide me with a sample showing me how to use the diagonal cell borders.
On the following link you could find information for the upcoming releases.
http://ko.infragistics.com/support/service-releases.aspx#ServiceReleases