Home Discussions Questions & Answers Auto-Sizing Columns in Excel Output

Auto-Sizing Columns in Excel Output

Avatar photoCustomer June 30, 2021 at 9:23 pm

I need to ensure the column width in the Excel output accommodates the header names but is not overly wide. How can I control how the column width is determined?

Viewing 4 reply threads
  • Author
    Replies
    • Support July 2, 2021 at 10:26 pm  

      You use the profile option ‘Blitz Report XLSX Column Width Mode’. This defines if the column width in Blitz Reports XLSX output files gets aligned to the column headers, the data, or both.

    • Avatar photoCustomer July 4, 2021 at 7:29 pm  

      What is the default mode used for column width calculation?

    • Support July 6, 2021 at 6:38 am  

      The default mode is ‘both’.

    • Avatar photoCustomer July 6, 2021 at 7:22 pm  

      Is there a way to adjust the calculated width globally?

    • Support July 7, 2021 at 5:17 am  

      Yes, you can use the profile option ‘Blitz Report XLSX Column Width Scale Percentage’ to adjust the width scale.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: