Ask Your Question
2

Libreoffice Calc Print Range

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

anonymous user

Anonymous

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!

delete close flag offensive retag edit

5 Answers

Sort by » oldest newest most voted
2

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

jofilho gravatar image jofilho flag of Brazil
503 2 10

Hi,

Select the cells and use the menu...

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

2) Format | Print Ranges | Define

link delete flag offensive edit
0

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

this post is marked as community wiki

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

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

Philippe Paravicini gravatar image Philippe Paravicini
1

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.

link delete flag offensive edit
0

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

lo-l gravatar image lo-l
1

2) Format | Print Ranges | Define

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

link delete flag offensive edit
0

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

__crazy gravatar image __crazy
3 1 1 5

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?

link delete flag offensive edit

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 ( 2012-03-12 01:15:32 +0200 )edit
0

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

cribbagepogo gravatar image cribbagepogo
1

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

link delete flag offensive edit

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow
2 followers

subscribe to rss feed

Stats

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

Seen: 2,586 times

Last updated: Dec 14 '12