copy paste problem

#1

I'm viewing data in a table , can I copy it like Excel or Access ?
I would like to select multiple rows.

Can this be done?

PS. I do not wan't to add check boxes for picking and filtering the rows
,but only the shift & ctrl keys

thanks

#2

CTRL-SHFT-C (Windows) or CMD-SHFT-C (Mac). This will copy all rows in
the current found set.

Savvas wrote:

Quote:

I'm viewing data in a table , can I copy it like Excel or Access ?
I would like to select multiple rows.

Can this be done?

PS. I do not wan't to add check boxes for picking and filtering the rows
,but only the shift & ctrl keys

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

#3

This is what Help says you can do regarding multiple records:

Copy all records in the found set to the Clipboard (but not data from tab panels that are not in front)

With no fields selected, press Shift (Windows) or Option (Mac OS) while choosing Edit menu > Copy.

You can't just select rows as you describe. You would have to perform a find or omit records as necessary to arrive at the desired found set.

One issue I note on the Mac is that it "copies" (creates a text description) of images in the record as well.

Matt

On 12/28/2006 10:38:12 "Savvas" <savvas (AT) logotipo (DOT) gr> wrote:

Can this be done?

Quote:

PS. I do not wan't to add check boxes for picking and filtering the rows
,but only the shift & ctrl keys

thanks

#4

Clarification:

The images mentioned are in fact field contents (calculated flags and indicators derived from global fields). Thus, that there is something copied is to be expected.

What's not expected is the actual value. The name given for a png value is not what I have set as a field name, nor is it the name of the image as I inserted it into the file.

Where I have a calculated image field named DotFlag, I am given a value in the copied data such as "actions-agt_internet.png."

Does anybody have any insight into this?

Matt

On 12/28/2006 10:52:29 Matt Wills <Im (AT) witz (DOT) end> wrote:

Quote:

This is what Help says you can do regarding multiple records:

Copy all records in the found set to the Clipboard (but not data from tab
panels that are not in front)

With no fields selected, press Shift (Windows) or Option (Mac OS) while
choosing Edit menu > Copy.

You can't just select rows as you describe. You would have to perform a
find or omit records as necessary to arrive at the desired found set.

One issue I note on the Mac is that it "copies" (creates a text
description) of images in the record as well.

Matt

On 12/28/2006 10:38:12 "Savvas" <savvas (AT) logotipo (DOT) gr> wrote:

Can this be done?

PS. I do not wan't to add check boxes for picking and filtering the rows
,but only the shift & ctrl keys

thanks

#5

FileMaker copies only text with this feature. Any container fields on
the layout will copy as though they were GetAsText() calcs. That is, if
the container contents was imported/inserted from a file, then it will
show the original file name; if it was pasted into the container, then
the result will be a question mark.

I don't know the true reason behind this limitation -- and I'm not
disagreeing that the copying of the actual graphics would be valuable --
but what would you expect to happen, for example, if you had a 100-page
Word or PDF document inserted into the container field? Should it copy
and paste the entire document? Or what if it only copied images; should
it copy the images at the size as formatted on the FMP layout, or at its
original (default) size, or ...?

Matt Wills wrote:

Quote:

The images mentioned are in fact field contents (calculated flags and indicators derived from global fields). Thus, that there is something copied is to be expected.

What's not expected is the actual value. The name given for a png value is not what I have set as a field name, nor is it the name of the image as I inserted it into the file.

Where I have a calculated image field named DotFlag, I am given a value in the copied data such as "actions-agt_internet.png."

Does anybody have any insight into this?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

#6

I'm not complaining that it didn't copy the actual graphic. In fact, I would expect that such a copy feature would copy the text representation of the image (being the expression in the calc).

What I'm wondering is why the text so copied bears no resemblance to the field name present on the layout, nor to the field from which it is calculated, nor to any of the global container fields which are eventually the result of the calculation, nor to any of several images inserted to populate those global fields.

Case in point:

I have two calculated container fields. One is a background color, the other is a colored dot. In both of these, a case statement determines the color of the image displayed.

When I Option-Command-C, the entire found set is copied (all fields on the layout). Pasting this into a text document, I see the various text and number values I would expect to see. I also see several occurrences of "actions-agt_internet.png".

That term/value/whatever is not to be found anyhere in the FM file, nor anywhere on my computer, for that matter.

Tus, my question is, what is it?

Matt

On 12/28/2006 11:41:02 Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> wrote:

Quote:

FileMaker copies only text with this feature. Any container fields on the
layout will copy as though they were GetAsText() calcs. That is, if the
container contents was imported/inserted from a file, then it will show
the original file name; if it was pasted into the container, then the
result will be a question mark.

I don't know the true reason behind this limitation -- and I'm not
disagreeing that the copying of the actual graphics would be valuable --
but what would you expect to happen, for example, if you had a 100-page
Word or PDF document inserted into the container field? Should it copy
and paste the entire document? Or what if it only copied images; should
it copy the images at the size as formatted on the FMP layout, or at its
original (default) size, or ...?

Matt Wills wrote:

The images mentioned are in fact field contents (calculated flags and
indicators derived from global fields). Thus, that there is something
copied is to be expected.

What's not expected is the actual value. The name given for a png value
is not what I have set as a field name, nor is it the name of the image
as I inserted it into the file.

Where I have a calculated image field named DotFlag, I am given a value
in the copied data such as "actions-agt_internet.png."

Does anybody have any insight into this?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Howard Schlossberg FM
Professional Solutions, Inc. Los Angeles

#7

Tis the name of the original file that was imported into the container
to which the calc field is pointing.

Matt Wills wrote:

Quote:

I'm not complaining that it didn't copy the actual graphic. In fact, I would expect that such a copy feature would copy the text representation of the image (being the expression in the calc).

What I'm wondering is why the text so copied bears no resemblance to the field name present on the layout, nor to the field from which it is calculated, nor to any of the global container fields which are eventually the result of the calculation, nor to any of several images inserted to populate those global fields.

Case in point:

I have two calculated container fields. One is a background color, the other is a colored dot. In both of these, a case statement determines the color of the image displayed.

When I Option-Command-C, the entire found set is copied (all fields on the layout). Pasting this into a text document, I see the various text and number values I would expect to see. I also see several occurrences of "actions-agt_internet.png".

That term/value/whatever is not to be found anyhere in the FM file, nor anywhere on my computer, for that matter.

Tus, my question is, what is it?

Matt

On 12/28/2006 11:41:02 Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> wrote:

FileMaker copies only text with this feature. Any container fields on the
layout will copy as though they were GetAsText() calcs. That is, if the
container contents was imported/inserted from a file, then it will show
the original file name; if it was pasted into the container, then the
result will be a question mark.

I don't know the true reason behind this limitation -- and I'm not
disagreeing that the copying of the actual graphics would be valuable --
but what would you expect to happen, for example, if you had a 100-page
Word or PDF document inserted into the container field? Should it copy
and paste the entire document? Or what if it only copied images; should
it copy the images at the size as formatted on the FMP layout, or at its
original (default) size, or ...?

Matt Wills wrote:

The images mentioned are in fact field contents (calculated flags and
indicators derived from global fields). Thus, that there is something
copied is to be expected.

What's not expected is the actual value. The name given for a png value
is not what I have set as a field name, nor is it the name of the image
as I inserted it into the file.

Where I have a calculated image field named DotFlag, I am given a value
in the copied data such as "actions-agt_internet.png."

Does anybody have any insight into this?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Howard Schlossberg FM
Professional Solutions, Inc. Los Angeles

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

#8

I still have all of the original files, and there's no "actions-agt_internet.png."

Matt

On 12/28/2006 18:50:17 Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> wrote:

Quote:

Tis the name of the original file that was imported into the container to
which the calc field is pointing.

Matt Wills wrote:

I'm not complaining that it didn't copy the actual graphic. In fact, I
would expect that such a copy feature would copy the text representation
of the image (being the expression in the calc).

What I'm wondering is why the text so copied bears no resemblance to the
field name present on the layout, nor to the field from which it is
calculated, nor to any of the global container fields which are
eventually the result of the calculation, nor to any of several images
inserted to populate those global fields.

Case in point:

I have two calculated container fields. One is a background color, the
other is a colored dot. In both of these, a case statement determines
the color of the image displayed.

When I Option-Command-C, the entire found set is copied (all fields on
the layout). Pasting this into a text document, I see the various text
and number values I would expect to see. I also see several occurrences
of "actions-agt_internet.png".

That term/value/whatever is not to be found anyhere in the FM file, nor
anywhere on my computer, for that matter.

Tus, my question is, what is it?

Matt

On 12/28/2006 11:41:02 Howard Schlossberg
howard (AT) antispahm (DOT) fmprosolutions.com> wrote:

FileMaker copies only text with this feature. Any container fields on
the layout will copy as though they were GetAsText() calcs. That is, if
the container contents was imported/inserted from a file, then it will
show the original file name; if it was pasted into the container, then
the result will be a question mark.

I don't know the true reason behind this limitation -- and I'm not
disagreeing that the copying of the actual graphics would be valuable --
but what would you expect to happen, for example, if you had a 100-page
Word or PDF document inserted into the container field? Should it copy
and paste the entire document? Or what if it only copied images; should
it copy the images at the size as formatted on the FMP layout, or at its
original (default) size, or ...?

Matt Wills wrote:

The images mentioned are in fact field contents (calculated flags and
indicators derived from global fields). Thus, that there is something
copied is to be expected.

What's not expected is the actual value. The name given for a png
value is not what I have set as a field name, nor is it the name of the
image as I inserted it into the file.

Where I have a calculated image field named DotFlag, I am given a value
in the copied data such as "actions-agt_internet.png."

Does anybody have any insight into this?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Howard Schlossberg FM
Professional Solutions, Inc. Los Angeles

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

copy paste problem

comp.databases.filemaker comp.databases.filemaker

copy paste problem - 12-28-2006 , 09:38 AM

Re: copy paste problem - 12-28-2006 , 09:45 AM

Re: copy paste problem - 12-28-2006 , 09:52 AM

Re: copy paste problem - 12-28-2006 , 10:08 AM

Re: copy paste problem - 12-28-2006 , 10:41 AM

Re: copy paste problem - 12-28-2006 , 04:22 PM

Re: copy paste problem - 12-28-2006 , 05:50 PM

Re: copy paste problem - 12-29-2006 , 03:44 AM