Static font color

Discuss the spreadsheet application

Static font color

Postby stevequinney » Sun Dec 02, 2018 5:10 pm

Hi all.
I'm a newby to OpenOffice from Excel.
If I am working on a spreadsheet and want to change the font color of a number of entries in different parts of the spreadsheet, it seems I have to keep going back to the "Font Color" icon for each entry. For example, if the entries are currently black and I want to make them red, is it possible to make the "Font Color" icon stay on red until I need to change it to a different color? It's a pain having to go back to the icon to change the color for each entry.
Thanks for any help you can give me.
OpenOffice 4.1.6 on Windows 10
stevequinney
 
Posts: 4
Joined: Sun Dec 02, 2018 5:01 pm

Re: Static font color

Postby jrkrideau » Sun Dec 02, 2018 7:40 pm

The recommended way in Calc is to use a Style. Styles are easier to use and tend to make for a more stable document.

Ignore the Font Colour Icon. In fact, I would say that you should never use an icon button to format anything in Calc or Writer. All formatting is better done using Styles.


https://wiki.openoffice.org/wiki/Docume ... _Templates.
OpenOffice 4.1.6; Ubuntu 18.04
jrkrideau
Volunteer
 
Posts: 3686
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Static font color

Postby Zizi64 » Sun Dec 02, 2018 8:09 pm

The recommended way in Calc is to use a Style.


+1


The Styles are the most valuable feature of the AOO/LO.
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.4; AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7986
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Static font color

Postby stevequinney » Sun Dec 02, 2018 9:15 pm

Thanks for your replies both of you, but having looked up "STYLE" in the help pages, it does not make any sense to me. It seems to be far more complicated than I need. I simply want to change the color of a number of fields (which will be in different cells each month) spread around the spreadsheet, from (for example) red to black (or any other color I may choose). I do not want to have to assign a complicated formula to each cell with specific colors in the formula. I could of course be completely mis-understanding what the help page is saying! Is OpenOffice capable of doing this?
Thanks again,
Steve
OpenOffice 4.1.6 on Windows 10
stevequinney
 
Posts: 4
Joined: Sun Dec 02, 2018 5:01 pm

Re: Static font color

Postby Zizi64 » Sun Dec 02, 2018 9:32 pm

A cell style is nothing more than adjusted properties related to the cell object, with a specific name.

You can apply a style by a double click on the style name in the style list. A cell style is nothing more than adjusted properties related to the cell object, with a specific name.
The cell styles have a hierarchic property. They can inherit their properties from the parent style, but you can modify the inherited properties of the child style
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.4; AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7986
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Static font color

Postby robleyd » Mon Dec 03, 2018 1:52 am

See the Wiki page on creating styles in Calc
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2763
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Static font color

Postby stevequinney » Mon Dec 03, 2018 11:22 am

Thanks again for all the replies, really appreciated, but it still makes no sense to me.
I'm giving up on Open Office and going to use Libreoffice, which is far simpler and does what I want without the complications of formulas and parent/child situations.
Once again, thanks for your time and effort trying to explain.
Steve.
OpenOffice 4.1.6 on Windows 10
stevequinney
 
Posts: 4
Joined: Sun Dec 02, 2018 5:01 pm

Re: Static font color

Postby RoryOF » Mon Dec 03, 2018 11:32 am

I suspect you will have the same or similar problems in LibreOffice - it and OpenOffice are closely related.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28981
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Static font color

Postby stevequinney » Mon Dec 03, 2018 12:17 pm

Thanks RoryOF for your reply, but I've used Libreoffice and it does exactly what I want and it's so easy.
Steve
OpenOffice 4.1.6 on Windows 10
stevequinney
 
Posts: 4
Joined: Sun Dec 02, 2018 5:01 pm


Return to Calc

Who is online

Users browsing this forum: Zhadnost and 19 guests