Обсуждение: Clipboard update

Here's a small update to the clipboard support. It adds an option to
allow using Tab as the column separator.

Using tab as the separator allows you to paste the results into Excel
and OpenOffice Calc while retaining the columns. I haven't had the
chance to test it, but I think it will also allow you to paste rows
into SQL Server's Enterprise Manager.

We should probably consider making the default copy settings be tab
deliminated with no quoting, as that's how both Excel and the SQL
Server tools put data into the clipboard.

Ed

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

> -----Original Message-----
> From: pgadmin-hackers-owner@postgresql.org
> [mailto:pgadmin-hackers-owner@postgresql.org] On Behalf Of
> edigeronimo@xtracard.com
> Sent: 12 April 2006 04:48
> To: pgadmin-hackers@postgresql.org
> Subject: [pgadmin-hackers] Clipboard update
>
> Here's a small update to the clipboard support. It adds an
> option to allow using Tab as the column separator.
>
> Using tab as the separator allows you to paste the results
> into Excel and OpenOffice Calc while retaining the columns. I
> haven't had the chance to test it, but I think it will also
> allow you to paste rows into SQL Server's Enterprise Manager.

Thanks Ed, patch applied.

> We should probably consider making the default copy settings
> be tab deliminated with no quoting, as that's how both Excel
> and the SQL Server tools put data into the clipboard.

That's fine with me - does anyone object?

Regards, Dave.

Dave Page wrote:
>
>
>
>>-----Original Message-----
>>From: pgadmin-hackers-owner@postgresql.org
>>[mailto:pgadmin-hackers-owner@postgresql.org] On Behalf Of
>>edigeronimo@xtracard.com
>>Sent: 12 April 2006 04:48
>>To: pgadmin-hackers@postgresql.org
>>Subject: [pgadmin-hackers] Clipboard update
>>
>>Here's a small update to the clipboard support. It adds an
>>option to allow using Tab as the column separator.
>>
>>Using tab as the separator allows you to paste the results
>>into Excel and OpenOffice Calc while retaining the columns. I
>>haven't had the chance to test it, but I think it will also
>>allow you to paste rows into SQL Server's Enterprise Manager.
>
>
> Thanks Ed, patch applied.
>
>
>>We should probably consider making the default copy settings
>>be tab deliminated with no quoting, as that's how both Excel
>>and the SQL Server tools put data into the clipboard.
>
>
> That's fine with me - does anyone object?

Only for copy/paste; in files "tab is crap"

Regards,
Andreas

> >>Here's a small update to the clipboard support. It adds an
> option to
> >>allow using Tab as the column separator.
> >>
> >>Using tab as the separator allows you to paste the results
> into Excel
> >>and OpenOffice Calc while retaining the columns. I haven't had the
> >>chance to test it, but I think it will also allow you to paste rows
> >>into SQL Server's Enterprise Manager.
> >
> >
> > Thanks Ed, patch applied.
> >
> >
> >>We should probably consider making the default copy settings be tab
> >>deliminated with no quoting, as that's how both Excel and the SQL
> >>Server tools put data into the clipboard.
> >
> >
> > That's fine with me - does anyone object?
>
> Only for copy/paste; in files "tab is crap"

Agreement from me. Question though: Is the "standard format"
platform-dependent? What would it typically be on macos or linux?
Perhaps it needs a different default?

//Magnus

On 12/4/06 18:22, "Magnus Hagander" <mha@sollentuna.net> wrote:

>>>> Here's a small update to the clipboard support. It adds an
>> option to
>>>> allow using Tab as the column separator.
>>>>
>>>> Using tab as the separator allows you to paste the results
>> into Excel
>>>> and OpenOffice Calc while retaining the columns. I haven't had the
>>>> chance to test it, but I think it will also allow you to paste rows
>>>> into SQL Server's Enterprise Manager.
>>>
>>>
>>> Thanks Ed, patch applied.
>>>
>>>
>>>> We should probably consider making the default copy settings be tab
>>>> deliminated with no quoting, as that's how both Excel and the SQL
>>>> Server tools put data into the clipboard.
>>>
>>>
>>> That's fine with me - does anyone object?
>>
>> Only for copy/paste; in files "tab is crap"
>
> Agreement from me.

Yes - we're just talking about the Result Copy options in frmOptions.

> Question though: Is the "standard format"
> platform-dependent? What would it typically be on macos or linux?
> Perhaps it needs a different default?

Tab delimited works nicely in Excel on OSX. I'll have to try Linux tomorrow.

Regards, Dave.

> -----Original Message-----
> From: pgadmin-hackers-owner@postgresql.org
> [mailto:pgadmin-hackers-owner@postgresql.org] On Behalf Of Dave Page
> Sent: 12 April 2006 20:07
> To: Magnus Hagander; Andreas Pflug
> Cc: edigeronimo@xtracard.com; pgadmin-hackers@postgresql.org
> Subject: Re: [pgadmin-hackers] Clipboard update
>
>
> > Question though: Is the "standard format"
> > platform-dependent? What would it typically be on macos or linux?
> > Perhaps it needs a different default?
>
> Tab delimited works nicely in Excel on OSX. I'll have to try
> Linux tomorrow.

Tried with Kspread, and none of our current delimiters work, so there is
no sensible default there. Anyone have OOo/StarOffice on *nix that they
can try?

Regards, Dave