Add helper to auto scale sheet on page by single, columns and rows options

[moisespsena]

Description

I have used excelize to generate data sheets for print. In many cases, when have many columns, the MS Excel or WPS SpreadSheets or LibreOffice Calc, add automatic page breaks on columns. This is a bad option for my sheets!

I see what those sheet editors have a page setup for auto scaling with three options for solve these problems: 1) Fit sheet on one page, 2) Fit all columns on one page and 3) Fit all rows on one page. See bellow image:

I notice what this options is a helper to set other sheet options:

1. Fit sheet on one page: must set SheetPropsOptions.FitToPage = true
2. Fit all columns on one page: set SheetPropsOptions.FitToPage = true and PageLayoutOptions.FitToHeight = 0
3. Fit all rows on one page: set SheetPropsOptions.FitToPage = true and PageLayoutOptions.FitToWidth = 0

I searched excelize api and 5th edition of the ECMA-376 Standard for Office Open XML to set those options on my sheet but i found nothing. For solve this problem, i have created sheets with those options and see the xl/worksheets/sheet1.xml file to check the XML attibutes set.

Additional context

No response

Validations

• Check that there isn't already an issue that requests the same feature to avoid creating a duplicate.

[xuri]

Thanks for your issue. I've left some comments in PR #2109. These three scaling options can be found in the Excel's print settings drop-down menus:

I will update documentation for this.