TOPIC: Excel column sizing problem (config file)

Excel column sizing problem (config file) 01 May 2018 18:11 #2661

  • RonMoses
  • RonMoses's Avatar
  • Offline
When I recently upgraded to 1.9, my config file was overwritten. Since then, all Excel exports are exporting with a fixed column width rather than using the column widths from the report. This has resulted in column headings being merged across multiple columns, and a number of alignment issues. What do I need to reset in my config file to fix this?
The administrator has disabled public write access.

Excel column sizing problem (config file) 15 May 2018 15:22 #2678

  • aellis
  • aellis's Avatar
  • Offline
Ron,
Sorry that config file got overwritten on the upgrade - I still have a request from you in my inbox to prevent that from happening from ages ago (not forgotten!). Anyway, can you tell me what options on the 'Export Report' dialog you need to tick to get it to export correctly in the full copy of Crystal? That should help me match those up to options in Formats.xml.
Thanks!
Adam
The administrator has disabled public write access.

Excel column sizing problem (config file) 15 May 2018 15:55 #2679

  • RonMoses
  • RonMoses's Avatar
  • Offline
I'm 99.9% sure it's this...
<ExcelAreaType>255</ExcelAreaType>
That gets set to 0 in the default formats file.
The administrator has disabled public write access.