Row Height/Column Width Exceeding the Page Size

If you set a cell to auto-adjust the row height, the cell will adjust its row height based on the text length, with the column width remaining unchanged.

Once the text is too long and the row height exceeds the page height, an error will occur: ''Error code: 11300002. The row height and column width exceed the page size.'', as shown in the following figure.

In addition to the row height exceeding the page height described above, the following scenarios can also trigger this error.

A certain cell is set to auto-adjust its row height and has a too-long text inside.

A certain cell is set to auto-adjust its column width and has a too-long text inside.

There are issues with the setting of duplicate header rows and columns.

Cell Merging

If the error is caused by setting the row height auto-adjusting, you can perform the cell merging vertically but not horizontally.

After you merge cells, the original cell is spanned across multiple rows. In this case, cells with heights exceeding the page height are broken down into multiple rows for calculation and displayed on multiple pages, ensuring no error occurs during a preview.

Note:

Similarly, the width of a cell cannot be greater than that of a page. Otherwise, an error will occur. In this case, you can merge cells horizontally.

Page Setting Adjusting

If the error is caused by setting the row height auto-adjusting, you can increase the page height. If the error is caused by setting the column width auto-adjusting, you can increase the page width. /