如何从适合页面宽度的libreoffice计算表生成pdf? [英] How to generate pdf from a libreoffice calc sheet fitting the page width?

问题描述

在Ubuntu 13.10中使用LibreOffice 4.1.2.3，我拼命尝试将工作表(4列)的内容导出为pdf(纵向)，因此所有4列都适合页面. 页面很好地解释了所有设置-但它们没有任何作用！

Using LibreOffice 4.1.2.3 in Ubuntu 13.10 I am desperately trying to export the content of a sheet (4 columns) into a pdf (portrait), so all 4 columns fit on a page. A page nicely explains all the settings - but they do not have any effect!

我选择了要导出为pdf的所有范围(前面提到的4列)，单击文件"->导出为PDF"，无论我做了什么更改(例如缩放到7％)，生成的pdf都包含两个pages:前三列的页面，第四列的页面.

I select all the range I want to export to a pdf (the 4 columns previously mentioned), click File -> Export as PDF, and no matter what I change (e.g. zoom to 7%), the generated pdf contains two pages: One page with the first three columns, and another page with the fourth column.

这非常麻烦和荒谬，不胜感激，可以帮助您解决此问题.

This is quite cumbersome and ridiculous, and any help is appreciated to solve this problem.

推荐答案

LibreOffice帮助在这里可能会引起误解.这些设置(适合宽度等)仅影响显示结果PDF 的方式.如果要缩放输出以使其适合一定数量的页面，则必须修改

Maybe the LibreOffice Help is misleading here. Those settings (Fit width etc) just affect how to display the resulting PDF. If you want to scale the output to make it fit to a certain number of pages, you will have to modify the page styles's properties: Menu Format -> Page... -> Sheet Tab.

在这里，您有三个选择:

Here, you have three options:

• Reduce / enlarge printout :设置固定的缩放比例(例如50 %)；
• Fit print range(s) to width / heigth :设置页面的最大宽度或最大高度，在每种情况下都将按比例缩放；
• Fit print range(s) on number of pages :设置最大页数.

• Reduce / enlarge printout: set a fixed scaling factor (e.g. 50 %);
• Fit print range(s) to width / heigth: set either the maximum width or maximum heigth in pages, scaling will be proportionally in every case;
• Fit print range(s) on number of pages: set the maximum page number.

在您的情况下，只需选择第三个选项并将页码设置为 1 :

In your case, just select the third option and set the page number to 1:

这篇关于如何从适合页面宽度的libreoffice计算表生成pdf?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！