Ask Your Question

Calc, File>Export as PDF

asked 2021-04-05 19:22:00 +0200

TAB gravatar image

updated 2021-04-18 04:19:13 +0200

In Calc, File>Export as PDF>Range: Selection/Selected sheet exports nothing (blank file) without a Selection. Should it not export the current sheet (if that's what ‘Selected sheet’ means)? Version: (x64) / LibreOffice Community Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: en-CA (en_US); UI: en-US Calc: threaded No empty cell was selected. The range is ‘Selected sheet’.The file is .ods.

edit retag flag offensive close merge delete



Which version of the LO are you using?

Zizi64 gravatar imageZizi64 ( 2021-04-05 20:40:04 +0200 )edit

Have you selected an empty cell?

LeroyG gravatar imageLeroyG ( 2021-04-06 13:55:00 +0200 )edit

Check the print range(s).

gabix gravatar imagegabix ( 2021-04-08 08:14:17 +0200 )edit

In LO on Windows 10.0 Build 19042 I get expected behaviour of full range exported.

If I have a single cell selected, whether in the range or not in the range, then Calc exports to pdf the full data range. It seems to work even with non-contiguous ranges.

If I have two or more cells selected then only those selected cells will be exported, so if two blank cells are selected I will get a blank sheet.

Regardless, I would follow the advice of gabix and define the print range anyway.

Could it be something peculiar to a foreign file format? Is it .xls(x) or .ods?

Earnest Al gravatar imageEarnest Al ( 2021-04-11 03:29:29 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2021-04-08 19:53:10 +0200

GrahamLees gravatar image

updated 2021-04-08 20:29:19 +0200


In v7.0.4.2 When selecting to print to PDF you need to select the file type to save to at the bottom right of the the selection dialogue box to PDF from the drop down otherwise it defaults to a different format.

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2021-04-05 19:22:00 +0200

Seen: 75 times

Last updated: Apr 18