I had asked the clipboard format expected by excel some months ago.
Embedded linefeed with a cell is supported. The puzzle was why it worked
in J6, because I can see rows should be delimited by LF instead of CRLF.
IIRC you or someone else had asked why clipwrite did not work in jconsole,
anyway
please make a note, it needs to first run gtkinit_jgtk_'' before calling
any other gtk functions.
Чтв, 05 Май 2011, Devon McCormick писал(а):
> Attempting to see if there is a hack to help Leigh in the short-term, I ran
> this in J7:
>
> clipwrite 'Hello.',(255{a.),'world.'
>
> and got this exception in "jconsole":
>
> Unhandled exception at 0x6c38d64d in jconsole.exe: 0xC0000005: Access
> violation reading location 0x00000000.
>
> I don't think I care that much about the actual error but it would be nice
> if it were caught. Interestingly,
>
> clipwrite a.
>
> doesn't seem to cause a problem though the clipboard does not appear to
> change contents after this.
>
> It also appears that clipboard usage doesn't work when I'm running jconsole
> under emacs as is my wont. In fact, if I load the gtk routines ("load
> 'gtk'") in this mode, my first attempt to use "clipwrite" gives five error
> messages and a subsequent attempt gives two and locks up my J session,
> requiring me to break out and kill it. I guess this is no different from
> lack of "wd" under jconsole in J6 but I had my hopes that it would be.
>
> I've actually been toying with some VBA to move data in and out of Excel by
> using files to avoid use of the clipboard. If I have the patience to do a
> good job with this, I'll make it available. I wonder if VBA could use
> sockets?
>
>
> On Wed, May 4, 2011 at 7:54 PM, chris burke <[email protected]> wrote:
>
> > It is a bug. I believe it may have been in J6, but in any case, the problem
> > is that the J7 definition was copied from J6 without testing this.
> >
> > In the definition, there is a toHOST that converts the LF separator into
> > CRLF. This causes the problem, and should be removed.
> >
> > I have a fix that will be put up this weekend.
> >
> > On Thu, May 5, 2011 at 7:27 AM, Leigh J. Halliwell <[email protected]
> > >wrote:
> >
> > > Dear J Forum:
> > >
> > > When I excute the j701 the sentence " clipwrite 2 6 $ 'Hello,world.' "
> > and
> > > paste it into Excel, it pastes as three vertical cells, as:
> > "Hello,"/{empty
> > > cell}/"world." This never happened in j602. Why am I getting the extra
> > > line feed, and how can I get rid of it? I'm running Excel 2003 on 32-bit
> > > Windows XP. Thank you.
> > >
> > > Sincerely,
> > >
> > > Leigh
> > >
> > > ----------------------------------------------------------------------
> > > For information about J forums see http://www.jsoftware.com/forums.htm
> > >
> > ----------------------------------------------------------------------
> > For information about J forums see http://www.jsoftware.com/forums.htm
> >
>
>
>
> --
> Devon McCormick, CFA
> ^me^ at acm.
> org is my
> preferred e-mail
> ----------------------------------------------------------------------
> For information about J forums see http://www.jsoftware.com/forums.htm
--
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
