RE: Pasting from Excel 2.9 - kray

2008-04-02 Thread Bryan McCormick
Ken, That is very odd that you got 2.8.1 to work with Excel 2002. Mind you I am on 2.8.1 with Excel 2003. The same issue presents with OpenOffice though regardless of Rev version. I guess I never had the combo of 2002/2.8.1 since I had upgraded to 2003 before I had 2.8.1. Multi-version combo

Re: 2.9 - Pasting from Excel

2008-03-31 Thread Ken Ray
On Mon, 31 Mar 2008 13:56:12 -0400, Bill Marriott wrote: > I'm pleased to report this issue has been fixed for Revolution 2.9! > > http://quality.runrev.com/qacenter/show_bug.cgi?id=6269 Whoops! I just logged another bug in a similar vein; I'll verify it against the next RC to make sure it's fi

Re: 2.9 - Pasting from Excel

2008-03-31 Thread Ken Ray
On Sun, 30 Mar 2008 12:30:11 -0700, Richard Gaskin wrote: > Bill Marriott wrote: >> Appears to be a problem on Windows only. > > Has it been determined yet whether the delimiters are absent, or just > another character other than tab such as NULL? Good question - I tested this on XP SP2 running

Re: 2.9 - Pasting from Excel

2008-03-31 Thread Bill Marriott
I'm pleased to report this issue has been fixed for Revolution 2.9! http://quality.runrev.com/qacenter/show_bug.cgi?id=6269 "Bill Marriott" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Appears to be a problem on Windows only. > >> AND it works for me as well in Leopard .2 and

Re: Pasting from Excel

2008-03-31 Thread Robert Sneidar
example, what you end up with in pasting from Excel to Rev is no separation character of any kind, so you simply get a run of text concatenated together. - Example For example a spreadsheet with the following (tabs to show columns) Hot BlueRed Almond ...results in this

Re: Pasting from Excel

2008-03-30 Thread Jim Lambert
I, too, have had problems copying from Excel and pasting into Rev fields on Windows only. However if I put clipboarddata["TEXT"] into fld somefield all usually works. Jim Lambert ___ use-revolution mailing list use-revolution@lists.runrev.com Please

Re: 2.9 - Pasting from Excel

2008-03-30 Thread Roger . E . Eller
Does this work using Open Office in Linux? I would try it but I don't have the link to download RC4. > Appears to be a problem on Windows only. > >> AND it works for me as well in Leopard .2 and 2.9.0 rc 4 and Excel X for >> mac service release 1 (2001) Roger Eller <[EMAIL PROTECTED]> ___

Re: 2.9 - Pasting from Excel

2008-03-30 Thread Richard Gaskin
Bill Marriott wrote: Appears to be a problem on Windows only. Has it been determined yet whether the delimiters are absent, or just another character other than tab such as NULL? -- Richard Gaskin Managing Editor, revJournal ___ Rev tip

Re: 2.9 - Pasting from Excel

2008-03-30 Thread Bill Marriott
Appears to be a problem on Windows only. > AND it works for me as well in Leopard .2 and 2.9.0 rc 4 and Excel X for > mac service release 1 (2001) > >>Here if I copy (or cut) from an Excel file (multiple rows and columns) >>and then I paste in a Rev field (with tab stops being defined) I got

Re: 2.9 - Pasting from Excel

2008-03-30 Thread Stephen Barncard
AND it works for me as well in Leopard .2 and 2.9.0 rc 4 and Excel X for mac service release 1 (2001) Hi, Here if I copy (or cut) from an Excel file (multiple rows and columns) and then I paste in a Rev field (with tab stops being defined) I got the texts of the cells separared by tabs (an

Re: 2.9 - Pasting from Excel

2008-03-30 Thread Andre.Bisseret
Hi, Here if I copy (or cut) from an Excel file (multiple rows and columns) and then I paste in a Rev field (with tab stops being defined) I got the texts of the cells separared by tabs (and the rows by cr) I am working on Mac OSX 10.5.2. Microsoft Excel 2008 for Mac Rev 2.9.0 rc 3. For

Re: Pasting from Excel

2008-03-29 Thread Jim Ault
rom Rev to Excel. This is on Windows. I was keeping my fingers > crossed this would be rectified in 2.9. > > To clarify by example, what you end up with in pasting from Excel to Rev > is no separation character of any kind, so you simply get a run of text > concatenated together

Re: Re: 2.9 - Pasting from Excel

2008-03-29 Thread Bryan McCormick
technically I don't think it is a bug as much as an unexpected feature failure? - Returns indicate rows: 10 20 30 Pasted into Rev yields 102030 - I did notice one major problem was fixed in 2.9: In pre 2.9 when pasting from Excel with a number formatted with

Re: Pasting from Excel

2008-03-29 Thread Richard Gaskin
Bryan McCormick wrote: Checking the clipboard to do something simple like replace tab with (pick a delimiter) does not work. I thought of that as well Jim, but no go, the tabs just do not appear to be there. Looks like you solved the mystery: Excel's clip format is different from its tabbed e

Re: 2.9 - Pasting from Excel

2008-03-29 Thread Bill Marriott
Jim, > Excel has an internal clipboard, and the answer may be to copy, paste > values > into a blank/new worksheet, then copy that result so that the clipboard > format is as consistent with text only as possible (no formulas, > conditional > formatting, etc) and then see if tabs are removed. I

RE: Pasting from Excel

2008-03-29 Thread Bryan McCormick
this would be rectified in 2.9. To clarify by example, what you end up with in pasting from Excel to Rev is no separation character of any kind, so you simply get a run of text concatenated together. - Example For example a spreadsheet with the following (tabs to show columns) Hot

Re: 2.9 - Pasting from Excel

2008-03-29 Thread Jim Ault
I am a little confused about the original poster's situation. On 3/29/08 11:23 AM, "Bill Marriott" <[EMAIL PROTECTED]> wrote: > Bryan, > > Please file this as a report in RQCC. Clipboard processing was redone for > 2.9, and this would have been an ideal time to address this. Unfortunately, > I h

Re: 2.9 - Pasting from Excel

2008-03-29 Thread Bill Marriott
Bryan, Please file this as a report in RQCC. Clipboard processing was redone for 2.9, and this would have been an ideal time to address this. Unfortunately, I highly doubt there will be time to do anything about it before release, but you never know. > This is likely to seem ridiculously simpl

2.9 - Pasting from Excel

2008-03-28 Thread Bryan McCormick
Hi Folks, This is likely to seem ridiculously simple. I use Excel a lot during the course of the day. Sometimes I need to cut and paste data from multiple rows and columns on an ad hoc basis and take it into Rev. In prior versions of Rev the result was text not separated by tabs as you would