Bug 39274 - Add ability to set highlight color for text (Calc)
Summary: Add ability to set highlight color for text (Calc)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.1 release
Hardware: All All
: low enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Enhancements Calc-Cells Highlight-Color-Button
  Show dependency treegraph
 
Reported: 2011-07-15 19:58 UTC by Steven W
Modified: 2023-11-05 17:32 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Steven W 2011-07-15 19:58:10 UTC
Would like to have the highlight feature available in Calc.  I think the summary says it all, but just in case, here's a description of what I mean:

Double click a cell and type a five word sentence.  Say you want to "highlight" three words.  As of now you can change the background color (of the whole cell), text color, but you can't simply highlight certain words like you can in Writer.  

Not sure if the ODF spec supports this or not.

Thanks.
Comment 1 Steven W 2011-07-15 19:58:43 UTC
Just correcting title.
Comment 2 Rainer Bielefeld Retired 2011-07-16 00:10:15 UTC
Yes, I also sometimes missed it, and if it's possible to have a character colot, it should not be too difficult to get a background, too, if it's part of ODF definition.

EXCEL 2010 (Starter) I can't find such a feature.

@Christoph:
Have there been any considerations?
Comment 3 Christoph 2011-07-16 05:52:39 UTC
@Rainer: No, I'm not aware that there are considerations for that. Most of "Calc" is based on the assumption that the "artifact" are the cells. So, the quick background formatting is tied to the cells instead of characters. I don't know whether ODF supports that. The most simple implementation would be to add the "Background" tab to "Format - Characters ...".

@Steven: Do you refer to highlighting of words to make them stand out visually, or does highlighting refer to adding notes / comments to those cells? What is your use case? How much content is in the cells, so that this highlighting is required?
Comment 4 Steven W 2011-07-16 10:54:39 UTC
@Steven: Do you refer to highlighting of words to make them stand out visually,
or does highlighting refer to adding notes / comments to those cells? What is
your use case? How much content is in the cells, so that this highlighting is
required?


Yeah, the idea is to make those words stand out visually.  The amount of content can vary from a few words to a couple of paragraphs.  I'm creating a spreadsheet to help a friend keep track of medical issues/medications used, plasma levels, etc.
Comment 5 Steven W 2011-07-16 10:58:05 UTC
I was using different color text and underlining, but he said he'd prefer highlighting, I was a bit dismayed that you couldn't do that.  I also note the hyperlink tab is missing in the charter formatting dialog, I think that could come in handy for someone too.
Comment 6 Steven W 2011-07-16 11:00:06 UTC
Sorry for multiple replies here.  As of now, I'm drawing rectangles over the text and using transparency to simulate the effect.
Comment 7 Björn Michaelsen 2011-12-23 12:27:45 UTC Comment hidden (obsolete, spam)
Comment 8 sasha.libreoffice 2012-01-27 10:45:30 UTC
in LibO 3.6.0 master background of character not present
Comment 9 Norbert X 2014-10-04 19:34:54 UTC
I can confirm this bug on LibO 4.3.2.2.
Comment 10 Norbert X 2015-08-05 16:19:40 UTC
Bug exists in LibreOffice 5.0 (Ubuntu 12.04.5 with PPA, 1:5.0.0~rc5-0ubuntu1~precise1).
Comment 11 Norbert X 2017-09-01 17:05:57 UTC
Bug exists in 

Version: 5.4.1.2
Build ID: 1:5.4.1~rc2-0ubuntu0.16.04.1~lo0
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk2; 
Locale: en-US (en_US.UTF-8); Calc: group

Ubuntu 16.04 LTS with PPA.