spoffice office export Error generating data file on server

Description of Issue

spoffice_officeExport: Error generating data file on server when attempting to send report results to Excel

Context
  • Munis Report Exports
  • Excel
  • Export
  • spoffice
  • spoffice_officeExport
Cause

Common special characters can cause this type of error include the following: @ $ % & and + this can be broadened to also include hidden characters as well

Page break copy and pasted into comment field will cause this error

Resolution

Do not use special characters in Journal comments, Reference fields, or Descriptions

Additional Information

Work around to use display option and pdf option work without error