Ask Your Question
3

Libreoffice Calc Print Range [closed]

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

anonymous user

Anonymous

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

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
4

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

jofilho gravatar image

Hi,

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
0

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

__crazy gravatar image

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

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

Comments

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 +0100 )edit
0

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

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
0

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

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
0

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

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

edit flag offensive delete link more

Question Tools

2 followers

Stats

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

Seen: 14,255 times

Last updated: Dec 14 '12