2.9 - Pasting from Excel

Andre.Bisseret Andre.Bisseret at inria.fr
Sun Mar 30 14:34:02 EDT 2008


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 a new stack I am developing, I am saving the Excel file in .txt  
(tab separator)
tab, carriage return as well are preserved.

I just tried with Excel file in .xls and I got the same expected result.

Actually, in my stack, I am using something like :
    open file suchFileName FOR read -- an excel file saved in .txt
      read from file suchFileName at 1 until EOF
    put it into fld "thisField"
    close file suchFileName

This works well;  tabs and crs are there

Best regards from Grenoble
André

Le 29 mars 08 à 03:18, Bryan McCormick a écrit :
> 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 expect and as you get if you paste into Notepad for  
> example.
>
> In fact for years that has been my workaround. Copy from Excel,  
> paste into Notepad, then paste into Rev.
>
> I had thought 2.9 might preserve the tabs but it does not. Am I  
> missing something or is this the standard (and expected, and thus  
> S.O.L) behavior?
>
> Is there anything anyone can think of that could make this otherwise  
> simple task, well, simple?
>
> Thanks.
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>





More information about the use-livecode mailing list