[Solved] Matching a cell color in Calc

Discuss the spreadsheet application

[Solved] Matching a cell color in Calc

Postby patrickeo » Sat May 09, 2020 7:27 pm

OK, have tried everything I can think of but found no solution. I am trying to figure out the color of a cell so I can add it to my palette. Please help me. It cannot be this difficult. I am using a spreadsheet with validity drop down selections. I cannot just use the brush because the validity disappears. I need to add it to my color palette. How do I identify either the color name (if there is one) or the RGB code or any code really. I am positive someone else has encountered this issue as well.
Last edited by Hagar Delest on Sun May 10, 2020 4:48 pm, edited 1 time in total.
Reason: tagged solved
OpenOffice 3.3.0 on Windows 7, Home Premium, 64 bit.
patrickeo
 
Posts: 7
Joined: Tue Feb 28, 2012 2:27 pm

Re: matching a cell color in Calc

Postby FJCC » Sat May 09, 2020 7:50 pm

Does this work? Select the cell and then go to the menu Format -> Cells. On the Background tab the name of the color should be displayed under to color palette and the corresponding color tile should have a (faint) dotted border.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7872
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: matching a cell color in Calc

Postby Zizi64 » Sat May 09, 2020 9:16 pm

How do I identify either the color name (if there is one) or the RGB code or any code really.


There is an extension named RGB. Try it.

https://extensions.openoffice.org/en/project/rgb
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
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: 9702
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: matching a cell color in Calc

Postby patrickeo » Sat May 09, 2020 9:42 pm

FJCC wrote:Does this work? Select the cell and then go to the menu Format -> Cells. On the Background tab the name of the color should be displayed under to color palette and the corresponding color tile should have a (faint) dotted border.


Actually tried that for the same reason you mentioned.....but the window pops up and I do see the color of the cell but nothing is highlighted and no name is listed, instead, it says "No Fill".
OpenOffice 3.3.0 on Windows 7, Home Premium, 64 bit.
patrickeo
 
Posts: 7
Joined: Tue Feb 28, 2012 2:27 pm

Re: matching a cell color in Calc

Postby MrProgrammer » Sat May 09, 2020 11:20 pm

patrickeo wrote: I am trying to figure out the color of a cell so I can add it to my palette.
If the color was applied using a style, look in the style's Organizer dialog to see the RGB colors. If the color was applied using direct formatting, create a style, say Foo, from the selection first, then look at Foo's Organizer dialog. The RGB extension may have useful features, but I don't need it to determine a cell's color.

patrickeo wrote:I do see the color of the cell but nothing is highlighted and no name is listed, instead, it says "No Fill".
Yes, for the Background dialog to show you a color, the color must match one in the palette. Once you know the RGB values you can create a matching palette color in the OpenOffice → Colors option. Options are set with OpenOffice → Preferences on a Mac, Tools → Options on other platforms. But if all you want to do is set another cell to the same color as the one you chose, select the other cell and apply the Foo style. This sets the color, whether it is in the palette or not.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3858
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: matching a cell color in Calc

Postby patrickeo » Sun May 10, 2020 2:51 am

Nothing is working so far.....going to keep trying...has to be a way.
OpenOffice 3.3.0 on Windows 7, Home Premium, 64 bit.
patrickeo
 
Posts: 7
Joined: Tue Feb 28, 2012 2:27 pm

Re: matching a cell color in Calc

Postby FJCC » Sun May 10, 2020 3:25 am

Have you tried the extension mentioned by Zizi64?
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7872
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: matching a cell color in Calc

Postby Zizi64 » Sun May 10, 2020 6:26 am

The extension RGB can determine and show the RGB value of the background color of the selected cell.

RGB.png
Last edited by Zizi64 on Sun May 10, 2020 11:34 am, edited 1 time in total.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
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: 9702
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Matching a cell color in Calc

Postby Villeroy » Sun May 10, 2020 11:21 am

Installing https://libreoffice.org/ solves this and a whole lot more problems.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 29107
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Matching a cell color in Calc

Postby patrickeo » Sun May 10, 2020 3:03 pm

This issue has been Solved! Used the RGB extension and it worked like a charm! Thank all of you people for your input!
OpenOffice 3.3.0 on Windows 7, Home Premium, 64 bit.
patrickeo
 
Posts: 7
Joined: Tue Feb 28, 2012 2:27 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests