Bug 56217

Summary:	Use formatting of referenced cell in target cell
Product:	LibreOffice	Reporter:	Larsen <larsen007>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	enhancement
Priority:	medium
Version:	unspecified
Hardware:	Other
OS:	All
Whiteboard:
i915 platform:		i915 features:

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.