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