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: Spreadsheet (show other bugs)
Version: unspecified
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-10-20 07:47 UTC by Larsen
Modified: 2013-05-05 23:57 UTC (History)
0 users

See Also:
i915 platform:
i915 features:


Attachments

Description Larsen 2012-10-20 07:47:27 UTC
Hi,

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.


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.