ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: MEngelbyPQ on August 03, 2019, 02:39:28 am

Title: PSA: Grid Title over 30 chars causes Excel export to fail
Post by: MEngelbyPQ on August 03, 2019, 02:39:28 am

Well, not exactly fail.  It causes Excel to complain about something (it won't say) and by pressing ok on the dialog warning, the worksheet will load.  But for unknowing users, this is very concerning.  When the grid title is too long, and exportData is invoked, the warning that shows up is:
"We found a problem with some content in '{workbook name}.xlsx'. Do you want us to try to recover as much as we can? if you trust the source of the workbook, click Yes."

The PSA is: keep your Grid Titles less than 31 characters or specify the 'sheetName' option in the exportData method.

Ps.  It took me an embarrassingly long amount of time to figure this out.

Title: Re: PSA: Grid Title over 30 chars causes Excel export to fail
Post by: paramvir on August 07, 2019, 10:58:00 am

Thanks for your valuable information / feedback.

Currently it can be overcome by limiting the title before call to exportData method.

Code: [Select]

  this.option('title', this.option('title').substr(0,31) );