Hello,
i have a issue :/ , when i exported to Excel, the resulting file , throws an error format, the columns are formatted as currency, and in the exported file format is generated as a string.
Any ideas?
Regards.
Alfredo Melo. P:
Hi Shyam!
you can Fire the event CellExported, check if the columns is Summary, if its summary, you can set the property CellFormat = "C".
i had that issue :), and this works perfectly.
Hi Peter
Here I am getting an cell formatting issue when Exporting data to excel-
I have an column with formatting Currency and Summary Row Behaviors for that column, when exporting data to excel Sum of that column was not coming, than I add a property DisableCellValueFormatting = "true" in WebExcelExporter, Now Sum of that column is coming but formatting is not coming.
Please suggest how to get grid data as formatting and Summary in Excel export?
Regards
Shyam
Hi Alfredo,
Thank you for your reply.
Glad that you were able to resolve the matter. Please let me know if I can be of further assistance.
Best Regards,
Petar IvanovDeveloper Support EngineerInfragistics, Inc.http://ko.infragistics.com/support
Hi Petar Ivanov,
well, i've already fix the problem :), with an event before export, and its working now.. by the way, my version of advantage is 11.1, .. but now works great :) thanks
Regards!
Alfredo Melo
It has been some time since your post, however in case you still need assistance I would be glad to help.
I have tested your scenario using version 11.2 but am so far unable to replicate the described behavior (i.e the currency formatted column is exported successfully in Excel). In order to research this further I would need to know what version of .NetAdvantage you are using in your implementation.
Please do not hesitate to contact me if you have any questions.