Issue 125730 - Enhancement to "copy to" feature of filter(s) to copy VALUE not formula
Summary: Enhancement to "copy to" feature of filter(s) to copy VALUE not formula
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.1.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-10-09 08:01 UTC by Alan Greer
Modified: 2014-10-27 12:36 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Alan Greer 2014-10-09 08:01:39 UTC 
This issue is briefly discussed in the following thread:

https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=72770

Adding an option to the "copy to" feature of a data filter (like that in Paste Special) would greatly enhance the power of the filters. I appreciate that this is a quasi database function but then again so is the whole concept of filters anyway.

I am guessing that the infrastructure already exists - it is just a question of how to incorporate the additional options in the filter dialogs.

A little example follows:

a	b	c	d
			
		1	10
		2	20
		3	30
Total	Smith	6	60
			
		4	40
		5	50
		6	60
Total	Jones	15	150
			
Result I get:			
a	b	c	d
Total	Smith	0	0
Total	Jones	0	0
			
Results I would hope for:			
a	b	c	d
Total	Smith	6	60
Total	Jones	15	150

Regards, Alan
Comment 1 oooforum (fr) 2014-10-10 14:00:58 UTC 
See this: https://issues.apache.org/ooo/show_bug.cgi?id=124520
Comment 2 Alan Greer 2014-10-27 12:36:29 UTC 
(In reply to oooforum from comment #1)
> See this: https://issues.apache.org/ooo/show_bug.cgi?id=124520

OK, but I do not see this is exactly relevant to my request for an enhancement.

I specifically want the cell computed _values_ copied and not the cell formulae so what you see in the destination (wherever that is, same sheet or otherwise) is what you "see" in the original cells that you want to replicate. Call it "copy by value" not "copy by reference" which is sort of what the current implementation does.