I have a RadGrid I'm exporting to excel but for cells with zeros it's not formating cell for Decimal with two places. I'm using the below to set the cell text and it works fine for Cell values other than Zero.
cell.Text = decValue.ToString("n2")
1 Answer, 1 is accepted
0
Hi Chuck,
The way cell formatting should be applied depends on the Excel export format used. Therefore you can check out the following resources respectively tho the different Excel export formats provided by the RadGrid:
- XLSX and Biff format - How to set Excel export cell format
- Excel HTML based format - Number formats / Formulas
- ExcelML format - StyleElement object and Number formats
I hope this will help!
Regards,
Doncho
Progress Telerik
Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
Our thoughts here at Progress are with those affected by the outbreak.