Problem when exporting to excel spreadsheet
Posted on 2003-03-28
We're publishing Crystal Reports 8.0 via a .Net frontend (not CR.NET). The reports are developed in CR 8.5. When a report is exported to Excel via the website, it seems that all the cells are merged into one. You can still edit each individual cell as if they were separate but if you try and sort them it throws the following message:
"Microsoft Excel found data next to your selection. Since you have not selected this data, it will not be sorted. What do you want to do?
[radio button] Expand Selection
[radio button] Continue with current selection
Sort [button] Cancel [button]"
Then regardless of which option is chosen, an excel notice pops up:
"The operation requires the merged cells to be identically sized."
Even if I change the format to number (it is set as General)and try and sort, i get the notice without the prior option.
Is it something within the Crystal Report that needs to be change?
thanks for the help.