Bug 56217 - Use formatting of referenced cell in target cell
Summary: Use formatting of referenced cell in target cell
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Cell-Reference
  Show dependency treegraph
Reported: 2012-10-20 07:47 UTC by Larsen
Modified: 2024-06-07 09:58 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Larsen 2012-10-20 07:47:27 UTC

I searched for "format reference", but didn´t get a result when constraint to "Chart" component. Google merely showed that some people using Excel are looking for what I want, too.

Assume there are three cells defined (e.g. "open", "discuss", "done") and have a background color assigned.

In the cells in my column "status", I reference one of those cells and get the value of it, but not the formatting. It would be very nice to not only get the value, but also the formatting, so e.g. when I set the background color of "done" to green, all the cells referencing "done" would also become green.
Comment 1 A (Andy) 2013-04-14 12:01:14 UTC
This could be a further reference enhancement feature.  
But with the normal reference you should only get the content but not the formatting.  But one can maybe think about an advanced feature.

In the meantime did you already try the conditional formatting feature?  This could probably also resolve your issue?
Comment 2 Larsen 2013-04-14 20:13:25 UTC
I haven´t tried it, but you´re right that could be a workaround. Though, it would be easier to have this as an advanced feature.
Comment 3 m_a_riosv 2024-06-07 09:58:39 UTC
*** Bug 161453 has been marked as a duplicate of this bug. ***