We are in the process of switching from v8.5 to 9. Our endusers are concerned that v9 does not keep the same formatting in excel as do v8.5 reports.
In version 9, when we export to Excel 2000 97-2000, the text control function of the worksheet Wraps text and Merges cells arbitrarily. When we export the data to Excel 2000 97-2000(data only), the columns stay in place, but we loose many of the headers.
Version 8.5 exports to excel are perfect (columns and hearders align, not extra spaces, etc...) The same report in version 9 adds spaces, wraps text, etc...
any thoughts?
In version 9, when we export to Excel 2000 97-2000, the text control function of the worksheet Wraps text and Merges cells arbitrarily. When we export the data to Excel 2000 97-2000(data only), the columns stay in place, but we loose many of the headers.
Version 8.5 exports to excel are perfect (columns and hearders align, not extra spaces, etc...) The same report in version 9 adds spaces, wraps text, etc...
any thoughts?