Ask Your Question

How can I export a multiselection in calc to PDF? (to include column headings) [closed]

asked 2016-08-27 19:18:59 +0200

rama gravatar image

updated 2020-09-11 08:26:19 +0200

Alex Kemp gravatar image

I have a regular calc sheet where the first row is the headings for the column. How can I export a multiselection to PDF? That is, I want the headings and some rows of the table, but not everything inbetween. See example below where > denotes selection <:

> NAME        VALUE     <
  Lisa        hot dog
> Raggis      ice cream <
edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-11 08:26:48.932698

1 Answer

Sort by » oldest newest most voted

answered 2016-08-27 21:31:21 +0200

mark_t gravatar image

I think the best way would be to use filter to show the data table as you want it in the pdf.

Select the headers of the table, then select Data, Autofilter.

If its difficult to use filters on the existing table content to select the rows required, you could add a helper column to apply the filter. You could then hide this column to avoid export to the pdf.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-08-27 19:18:59 +0200

Seen: 59 times

Last updated: Aug 27 '16