Exporting Grid Stylesheet,Borders And Currency format to Excel

Hello,

1.I have a grid with columns having 'currency style' applied as follows:

gridRelationDescriptor.ChildTableDescriptor.Appearance.AnyRecordFieldCell.BaseStyle = "CurrencyStyle"

What changes are required in the code so as to take 'Rs.' as the curency format in 'anyrecordfieldcell' as well as 'summarycell'.

2.The current currency format along with the styleheet and borders do not get exported to
excel.

I went through the online documentation for this problem.
I found the following lines of code:

Dim converter As GroupingGridExcelConverterControl = New GroupingGridExcelConverterControl()
converter.ExportBorders = True

converter.ExportGroupPlusMinus = True

converter.ExportPreviewRows = True

converter.ExportRecordPlusMinus = True

converter.ExportStyle = True

converter.HeaderBackColor = Color.Orange

converter.CaptionBackColor = Color.Lavender

But i dont get these options for an GroupingGridExcelConverterControl object.


Thankyou,
Vaishali





1 Reply

YG Yavanaarasi G Syncfusion Team May 5, 2008 01:53 PM UTC

Hi Vaishali,

Thank you for your interest in Syncfusion products.

currency format do not get exported to excel:

I am able to see the issue that you have mentioned. We have forwarded the issue to our development team for more analysis. We will update you on this issue within two business days.

Please let me know if you have any other concrens.

Regards,
G.Yavana




Loader.
Up arrow icon