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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution