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...