Regarding 1. It seems that the collapsing of "01.01.2013" has no effect to the export. All cells "under" this element have been exported.
In export functionality we are currently not taking into account expand/collapse behavior. This is by design - in your exports we will export everything no matter if it is collapsed or not.
Regarding 2. the format of the deepest date cells is wrong for me. I know, there is a SetFormat Method for the CellSelection class, but i don't want to set the format for every cell. Is it possible to localize the export data?
This behavior is most probably because of the difference in the culture you are using in your custom group and the Excel's culture which is always the CurrentCulture. The only way is to set the format with CellSelection.SetFormat().
Regarding 3. Row 4 in the export: Why is "Jan 2013" removed with "1.1.2013 0:00"?
This is because as excel, in our spreadsheet we can parse the String Jan 2013 to date, which is automatically done. To modify this behavior we should use the CellSelection.SetFormat() method to set the correct format for these groups. In the attached project you can find an example of how to achieve this, assuming that "Jan 2013" represents the .ToString() of a custom group made by you. ( Search in MainWindow.xaml.cs : "Apply custom format only when the value's name is your custom group" )
Regarding 4. something goes completely wrong on Row 6 and 32 in the export screenshot.
This is most probably because the combination of your current culture and the format "01.01.2013" which in this culture is parsed as double. Is "01.01.2013" also the string representation of another custom group you created? If so you can try and use the same procedure ( using the CellSelection.SetFormat() ) as described above.
Could you try attached project and inform us if you still have any problems or concerns. I'm looking forward to hearing from you.
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WPF.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>