English
Ask Your Question
1

Can't change font color on autoformatted spreadsheet

asked 2013-02-08 21:35:44 +0100

Edward gravatar image

updated 2013-10-10 23:14:52 +0100

manj_k gravatar image

I have a Calc sheet (app 30 rows, 70 columns, all formatted as text) containing ID#s. I enter new data in red, and use a custom autoformat to display alternating rows with a shaded background. I used to maintain this listing in Writer, but Calc makes it so much easier to add rows and columns, sort, and to print on X# of sheets.

I can't change the font color globally back to black (by selecting all the cells using my mouse or Edit/SelectAll and changing the font color); I'm still left with some cells showing red text. I can make my changes by selecting and then clearing direct formatting, but then I need to re-apply the the autoformat settings. Is there an easier way? Is there a way to search and replace FontColors, as there is in Writer?

edit retag flag offensive close merge delete

Comments

@jorendc -- another one for you :-)

qubit ( 2013-03-10 04:11:32 +0100 )edit

@Edward: Custom autoformat = conditional formatting? In that case you can go to Format > Conditional formatting > Manage... or Conditions. If I understand it wrong, please feel free to attach the document so we can have a look. <br> Thanks in advance<br>Joren

jorendc ( 2013-03-14 13:03:35 +0100 )edit

1 answer

Sort by » oldest newest most voted
0

answered 2013-11-12 15:50:48 +0100

updated 2013-11-12 15:52:10 +0100

I don't know if this will accomplish what you wish, but scroll down to my answer on this link:

http://ask.libreoffice.org/en/question/9205/is-there-a-way-to-add-background-color-to-alternate-rows-of-a-tablespreadsheet/#25119

I do not know specifically how you "auto formatted" your rows, but this is my technique. This, of course contains info on how to change the background, but your named style could also have font info.

Best Regards,

Jim Smith

edit flag offensive delete link more
Login/Signup to Answer

Stats

Asked: 2013-02-08 21:35:44 +0100

Seen: 712 times

Last updated: Nov 12 '13