Ask Your Question
0

Problem with printing selected cells in Calc

asked 2018-09-26 15:57:59 +0100

tim.uk gravatar image

I have a selection of cells in a spreadsheet. The selection is 3 columns wide, and 46 rows deep - it will easily fit on one page of paper. However when I print the selected cells, only the first 17 rows x 3 columns are printed. What am I missing?

edit retag flag offensive close merge delete

4 Answers

Sort by » oldest newest most voted
1

answered 2018-09-28 07:02:34 +0100

Emoh gravatar image

Please check it out again if Print Preview displaying the selected cells correctly; there shouldn't be any problem.

You can try select the desired range and then from Menu -> Format -> Print Range -> Define

print document.

edit flag offensive delete link more

Comments

Print preview does not show all the selected cells either :( It should not be necessary to define a print range. However I have determined that the bug seems to be related to the page breaks - if the selection crosses a page break, only cells up to the page break are printed. I've submitted a bug report with an example.

tim.uk gravatar imagetim.uk ( 2018-09-28 11:01:02 +0100 )edit
0

answered 2020-02-13 11:51:48 +0100

fcosta gravatar image

updated 2020-02-13 12:13:10 +0100

In LO 6.3 (similarly in some previous version) you do it in 2 steps.

First, set the printing range:

  • select the range of cells you want to print
  • in the main menu select: Format > Print Range > Define

Second, set that the print range should be in one (and only one) page:

  • Format > Page > Sheet
  • in the Scale section, in the Scaling mode dropdown, select "Fit print range on number of pages"
  • be sure that the following "Number of pages:" is set to 1

Now print selecting Print Selected Cells in the From which field of the Print dialog. Only one page should print with only the cells you selected (as large as possible to fit the page).

Note: - the preview while printing unfortunately will not display accordingly to your settings, you should disregard it - if what printed appears too big, in the second step select Reduce/enlarge printout and play/try different values of the Scaling factor.

edit flag offensive delete link more
0

answered 2019-04-05 21:44:23 +0100

jelabarre59 gravatar image

It would be handy if "print preview" would allow you to do a preview on just the highlighter/selected cells. Currently you would have to print highlighted cells and print them, hoping they're readable or fit on the page properly. Usually when you're printing a highlighted group it's because you need a "quick and dirty" output, and so you shouldn't have to print and fudge multiple times to get something usable.

edit flag offensive delete link more
0

answered 2019-04-06 00:03:01 +0100

m.a.riosv gravatar image

In the tab [Sheet] of the page style, you can set up on the Scale, a percent, or how the print range should fit in a number of selected pages.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-26 15:57:59 +0100

Seen: 932 times

Last updated: Feb 13