Ask Your Question
0

How to color cells efficiently? [closed]

asked 2014-11-19 18:10:43 +0200

Alias duel zone gravatar image

updated 2015-08-29 20:33:21 +0200

Alex Kemp gravatar image

I'm working with:

LibreOffice     4.2.3.3
MacOS X         10.8.5

I have to manage a few tables so as to fill their cells to express a level (temperature for example). Here is an example of the background-color scheme I would like to achieve: LibreOffice table with colors

The function to implement is:

if (cell-content == 1) then color-background = green
if (cell-content == 2) then color-background = yellow
[...]

I already have a pretty good idea of a bad method:

  1. select cell
  2. select menu > Table > Table Properties...
  3. select Background, choose Background color, click OK
  4. goto 1 until deadline

What are the efficient ways to achieve this color filling efficiently and so as to be able to change the overall color scheme?

Is there a right method with "conditional paragraph styles" (p. 216 of Writer Guide 4.0)?

Is there a right method with "formulas" ( p. 282 of Writer Guide 4.0)?

Is it possible to get a function like a "cell-style" so as to apply it manually to a given set of cells?

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 2016-03-06 13:01:10.805961

2 Answers

Sort by » oldest newest most voted
0

answered 2014-11-19 18:45:38 +0200

Lupp gravatar image

updated 2014-11-19 19:43:26 +0200

I don't think there is or will be such a feature in Writer. Insert a Calc OLE object better.

(Editing with regard to the comments)

The formulas are there, but all the formatting styles are lost. ...

Working with formulae in a Writer table is complicated, time-consuming, and error-prone as I would judge. Getting rid of it might pay for a few complications on the other hand.

I am a bit curios now and would like to see a realistic example of your style-of-using-styles.

edit flag offensive delete link more

Comments

I thought to this way. But this will lead me to another problem of the same size: "how will I set the paragraph formatting efficiently of many cells" ? I would like to manage within a technical document tables with text correctly formatted and cells correctly formatted. These tables contains about half an hundred cells.

Alias duel zone gravatar imageAlias duel zone ( 2014-11-19 18:51:12 +0200 )edit

To make a try, I just copied one of my table in writer and pasted it within calc. The formulas are there, but all the formatting styles are lost.

Alias duel zone gravatar imageAlias duel zone ( 2014-11-19 19:00:28 +0200 )edit

For only few different Values try:
→edit→find&replace→search for 1 →→findall and choose the Backcolor you want

repeat previous with the other numbers.

karolus gravatar imagekarolus ( 2014-11-19 19:16:05 +0200 )edit
0

answered 2014-11-19 18:26:26 +0200

karolus gravatar image

updated 2014-11-19 18:30:46 +0200

Hallo

Select the Range in Question and goto →Format→Conditional Formatting →Colorbar

Edit forget this answer I realized too late that you're refers to writer-tables

edit flag offensive delete link more

Comments

Under the Format menu I haven't any Conditional Formatting entry. I don't get it even when I select a cell of my table. Is this a dynamical menu I could get only under certain conditions?

Alias duel zone gravatar imageAlias duel zone ( 2014-11-19 18:36:21 +0200 )edit

You are welcome to laugh: I did the same sort of error. I searched on Google: "LibraOffice Applying Conditional Formatting" and read many pages scratching my head. "Where are all these fantastic functions? Is my version that old? Are my eyes that tired?"

Alias duel zone gravatar imageAlias duel zone ( 2014-11-19 18:41:26 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-11-19 18:10:43 +0200

Seen: 2,702 times

Last updated: Nov 19 '14