At 15:52 07/02/2022 +0000, John Silver wrote:
Is there anyway to determine which color of text is used in a cell in a spreadsheet?
There is no answer to this, as various parts of the text within a spreadsheet cell may have different font colours. Cells have a font colour property, but parts of text within cells can be separately coloured, and this overrides the general cell text colour property.
When going to select the color it wasn't usually marked.
If you select a cell, its font colour (but not its name) shows as a bar under the Font Colour button in the Formatting toolbar. More usefully, the font colour and its name show at Format | Cells... | Font Effects | Font Colour (or right-click | Format Cells... etc.)
Something you may want to consider is some sort of eyedropper tool like they have in graphic programs.
I don't need to consider this as what you probably seek already exists, in the form of the Format Paintbrush in the Standard toolbar. You can easily use this to copy cell formatting (including font colour) from one cell to others. Any unwanted format properties carried over could then be reset, of course.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
