We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Is there a way to have different print scaling for different sheets in a single workbook?

asked 2020-08-14 06:34:02 +0200

YALOU gravatar image

I often have situations where I want to use different print scaling for some sheets in a workbook than for other sheets in the same workbook. Is there any way to do this in LibreCalc?

For example... In a workbook, I have worksheet A that has rows added as more data becomes available and I want that sheet to always scale to print using the "Fit print range(s) to width/height" with "Width in pages" set to 1 and "Height in pages" unchecked (i.e., unlimited). In the same workbook I also have small worksheet B that tends to change structure occasionally but it's important that it fit on one page when printed so I want it to always scale to print using the Fit print range(s) on number of pages set to 1.

In real world cases I sometimes have many worksheets with many differing print scaling requirements.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-08-14 08:40:58 +0200

Zizi64 gravatar image

You can apply different (custom) Page Styles fot each sheets. And you can use different Scaling Mode and/or different Scaling Factor in the different Page Styles.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-08-14 06:34:02 +0200

Seen: 44 times

Last updated: Aug 14 '20