On Wed, 28 Oct 2009, Sherlock Ric wrote:
> > From: Sherlock, Ric
> >
> > > From: bill lam
> > >
> > > eg, for cells
> > > -+-+-+
> > > |a|b|e|
> > > | |c| |
> > > | |d| |
> > > +-+-+-+
> > > |a|a|a|
> > > +-+-+-+
> > >
> > > clipboard of csv as reported by wd'clippaste' will be
> > > 97 9 98 10 99 10 100 9 101 10 97 9 97 9 97{a.
> >
> > Interestingly when I create the described spreadsheet structure in
> > Excel 2007, copy it to the clipboard and look at it using wd'clippaste'
> > I get the following:
> >
> > a. i. wd 'clippaste'
> > 97 9 34 98 10 99 10 100 34 9 101 13 10 97 9 97 9 97 13 10
> >
>
> Using OpenOffice 3.0 on Ubuntu I get the same result as Bill. i.e.
> a. i. wd 'clippaste'
> 97 9 98 10 99 10 100 9 101 10 97 9 97 9 97 10
>
> As I said before - I'm not sure you can expect any routine to parse this
> correctly because there is nothing differentiating an embedded-line-break
> from an end-of-record.
>
> Note also that the clipboard is TAB-separated not comma-separated so pure csv
> routines won't work anyway. The tables/dsv addon will work, but only if the
> fields containing embedded line breaks are enclosed with a string delimiter.
I got the result using gnumeric on linux, it even didn't have the
ending LF.
I was interested in reading and setting block of cells in a
spreadsheet via clipboard. I was wondering how the clipboard with
embedded line breaks can be handled. Apparently different spreadsheet
applications use slightly different clipboard formats.
--
regards,
====================================================
GPG key 1024D/4434BAB3 2008-08-24
gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
