All of my summaries are exported as text determined by the format string. I am losing all the decimal information which needs to be in Excel. Is there any way I can change this behavior?
You could handle the SunnaryCellExported event and write the value of the summary into the cell yourself.
That's what I am doing, but that also requires me to handle all the appearance properties as well. Seems strange that the text and not value is written to the cell...
Yes, you would still have to format the text... but then again, you would have to do that anyway, since you want to export the value and not the text.
I was originally overriding the SummaryCellExporting event, setting the value and canceling the event which is why all of my appearances were not set. I switched to the SummaryCellExported event but I still have to do a few extra things, like format the text, in addition to setting the value.
Why do you have to handle the appearance properties? All you have to do is set the Value on the WorksheetCell. The appearances will already be applied to the cell by the exporter. You don't have to do anything else.