|105099||Sep 7,2012 10:13 AM||Sep 10,2012 02:31 AM||ASP.NET Web Forms (Classic)||2|
We have a legacy pivot table report that requires all cells to be formatted as text. I'm trying to make sense of the following documentation but having trouble -
Basically, the manual steps in Excel would be
Thanks for your assistance.
Thank you for using the Syncfusion Products.
To apply the desired
numberformat to all cells then, we need to mention the range. Please refer to
the below code snippet which illustrates this. Also we have attached sample for
you reference. Could you please try this and let us know if this helps you.
Case 1. //If we use the below code, blank cells has no effect.
Case 2. //Setting Number Format as Text.
//WE need to mention the specified Range.
sheet.Range["A1:XF1000"].NumberFormat = "@";
Please find the sample for "formatting cells" from
the below link and let us know if this helps you.
Sample link: Sample
Please let us know if you need any clarification.
Thanks and Regards,
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.