You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/10/09 10:01:39 UTC
[Issue 125730] New: Enhancement to "copy to" feature of filter(s) to
copy VALUE not formula
https://issues.apache.org/ooo/show_bug.cgi?id=125730
Issue ID: 125730
Issue Type: DEFECT
Summary: Enhancement to "copy to" feature of filter(s) to copy
VALUE not formula
Product: Calc
Version: 4.1.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: editing
Assignee: issues@openoffice.apache.org
Reporter: asg@solace.demon.co.uk
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
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125730] Enhancement to "copy to" feature of filter(s) to copy
VALUE not formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125730
oooforum <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |oooforum@free.fr
--- Comment #1 from oooforum <oo...@free.fr> ---
See this: https://issues.apache.org/ooo/show_bug.cgi?id=124520
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125730] Enhancement to "copy to" feature of filter(s) to copy
VALUE not formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125730
Alan Greer <as...@solace.demon.co.uk> changed:
What |Removed |Added
----------------------------------------------------------------------------
Issue Type|DEFECT |ENHANCEMENT
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125730] Enhancement to "copy to" feature of filter(s) to copy
VALUE not formula
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125730
--- Comment #2 from Alan Greer <as...@solace.demon.co.uk> ---
(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.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.