We're currently migrating from Ask to Discourse, read the details here

Ask Your Question

Libreoffice Calc Print Range [closed]

asked 2012-03-11 19:05:08 +0200

anonymous user


updated 2017-06-25 21:35:02 +0200

Hi all. I have a two questions: 1) How can I change the colors for the selected cells? 2) How can I define the print area/range on selected cells on Calc?

Sorry for my BAD English!

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 2015-10-19 13:41:51.233817

5 Answers

Sort by » oldest newest most voted

answered 2012-03-11 19:36:38 +0200

jofilho gravatar image


Select the cells and use the menu...

1) Format | Cells (select the tab background and choose a color)

2) Format | Print Ranges | Define

edit flag offensive delete link more

answered 2012-03-28 15:12:48 +0200

lo-l gravatar image

2) Format | Print Ranges | Define

does not work! page preview does not take care of any defined print range... it drives me crazy!!!!!

edit flag offensive delete link more

answered 2012-04-15 07:52:15 +0200

I have that problem too. Mine said one page in the preview the proceeded to print 133.

edit flag offensive delete link more

answered 2012-03-11 22:44:49 +0200

__crazy gravatar image

updated 2012-03-12 09:11:35 +0200

Question three: When I open a .xls file from web it's opening in Read Only mode. Can I disable this?

Thanks for help but I just printed a file from Calc and it sent 33 pages to my printer. Does anyone have this problem?

edit flag offensive delete link more


Look this link, please: http://ask.libreoffice.org/question/578/cant-edit-my-word-doc-why I suggest you divide your questions on several questions. This practice can help keep the site more organized. Thks.

jofilho gravatar imagejofilho ( 2012-03-12 01:15:32 +0200 )edit

answered 2012-12-14 00:29:10 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

The initial question in this thread:

1) How can I change the colors for the selected cells?

could also be interpreted to mean:

When selecting a cell range, the color of this range changes temporarily to denote the selection. Where are these colors defined?

Mine is a pale grey that is hard to see, and I would like to change it.

I have changed various colors under 'Tools > LibreOffice > Appearance' without much success. I found a posting elsewhere that showed that the transparency of this color could be affected by going to:

Tools > LibreOffice > View

and clicking/changing the 'Selection/Transparency' setting.

Deselecting the 'transparency' checkbox altogether made the color of the selected cells turn to black, and re-selecting transparency and setting it to a lower value made the selection darker, which is progress. Yet, I would like to change it to pale yellow, rather than dark grey.

edit flag offensive delete link more

Question Tools



Asked: 2012-03-11 19:05:08 +0200

Seen: 14,706 times

Last updated: Dec 14 '12