I am trying to control the format that excel chooses for my cells when I do an ExportToExcel() of my grid.
I have a column that holds percentage values. In the column declaration, I have the following:
But although both format strings are the same, in the excel sheet that is generated, the data rows are formatted with the "Number" category, and so they have values like "0.36", while the footer is formatted with the "Percentage" category and has values like "36.4%" (which is what I want).
I have tried at least a dozen things and I can't get the data rows to display in a percentage format. Is there any way to control the format of data rows when you use ExportToExcel?
I have a column that holds percentage values. In the column declaration, I have the following:
DataFormatString
="{0:N1}%" FooterAggregateFormatString="{0:N1}%"
But although both format strings are the same, in the excel sheet that is generated, the data rows are formatted with the "Number" category, and so they have values like "0.36", while the footer is formatted with the "Percentage" category and has values like "36.4%" (which is what I want).
I have tried at least a dozen things and I can't get the data rows to display in a percentage format. Is there any way to control the format of data rows when you use ExportToExcel?