Submit your Suggestions for Spectrum

Allow exports to .xlsx or .xlsb formats. Current .xls format limits rows to 65,536 rows of data

We have some large jobs that have a lot of job cost history. We frequently like to export data, but have encountered problems with larger jobs that are long in duration as the job cost data is more than 65,536 rows of job cost history. When attempting to export, the only Excel option is the .xls format. This format limits the rows. We'd like an option that allows us to grab all the data and does not limit us. Please provide ability to export to .xlsx or .xlsb formats. 

Currently our workaround is to export in separate chunks by date range, and then combine into one .xlsx report.

  • Tina McElrath
  • Apr 2 2018
  • Already exists
Platform
Company MDU CSG, Inc.
Job Title / Role Training & Service Coordinator
I need it... 6 months
  • Attach files
  • Barbara Powell commented
    June 01, 2018 19:21

    To be clear, we'd like .xlsx for the functionality of it, not for the row size limits.

    Thanks.

    Attachments Open full size
  • Barbara Powell commented
    June 01, 2018 19:20

    Does this feature already exist? I don't see it. I see only .xls as an option.

    Thanks

    xls files in sp...
    Attachments Open full size
  • Admin
    Geoffrey Falk commented
    May 23, 2018 23:06

    This was modified back in 14.21.

    Always nice to clean up resolved items!!

    Geoff

    Attachments Open full size

Related ideas

Dear Viewpoint Suggestion Box contributor;

We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs. Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.

1515 SE Water Avenue, Suite 300, Portland, OR 97214 |  800.333.3197  | Contact Us | Terms of Use | Privacy | Support Policies

© 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.