help group rows after exporting report to Excel! :(

[serhio]

Hello,

I have the following issue:
After exporting Crystal report file in Excel, I can't group the rows
in the exported file.

I mean, when I open an exported in Excel report, I can press the
"Group" button, but this haven't any result.

I don't know what exactly happens, but if a copy the content in a new
excel file, the ancient "grouped" rows appears (correctly) in group,
like I expected in the exported file.

Somebody has any idea, why this happens or how this can be fixed?


see also
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3202637&SiteID=1

 

[serhio]

An example of such file can be found there:

http://serhio.atspace.com/vasile.xls

 

[serhio]

The problem is that when exporting Crystal parametrize in a certain
manner the file, that is not like a "normal" excel file.

If I copy the content on a new workbook, keeping the original source
formatting, the "real" file contains some "changed" colors.
In the exported from Crystal reports Excel File it's impossible to
group the rows(in reality, the groupment is not reflected to the
user). In its copy - yes.

you can see a image with original report, exported file, and its copy
(here)
- http://picasaweb.google.ru/gserhio/Crystal/photo#5191995425026408306

I am afraid that this is not a excel programming problem...