XLSX Export is More Limited than the Capabilities of the File Format

The XLSX export document writer is miscoded. It limits this file type to an artificially low number of rows capable of export. I can export all the data I need in CSV (something I have to use CHR because even CSV is artificially limited) then open in excel and save as XLSX and i have no problems. I know the file format is capable of holding a lot more data than RE thinks it can. The XLSX format is far more useful and retains far more information (i.e. doesn't truncate leading zeros) than any of the other formats and just causes more work for the end user.

Thank you.

  • Guest
  • Nov 15 2012
  • Attach files
  • Guest commented
    March 17, 2016 23:23

    I noticed the same issue. Also, when I tried to run the Honor/Memorial acknowledgment letter process, and tried to save to an Excel 2007 file, I got an error message about not being able to support so many columns (don't remember the exact wording). Saving the data file to CSV worked just fine.

    Attachments Open full size
  • Guest commented
    March 17, 2016 23:23

    Here I thought I was going mad, glad to see I'm not the only who has ran into that quirk of Raiser's Edge. Excel 2007 (XLSX) Exports will bomb out on supporting columns, yet a CSV Export will run fine.

    Attachments Open full size

Related ideas