Ask Your Question

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

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

rama 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 close merge delete

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 30 times

Last updated: Aug 27 '16