(Lispix text data for export
to Excel is ASCII, tab delimited.)
To select a
collumn or row and transpose to a row or collumn:
1) Select all of the
data table in the Lispix window
3) Switch to Excel*
4) Paste to a scratch
area of the worksheet.
5) Select the data
6) Click on the upper
cell of where you want the data to go.
7) Paste special,
values, no operation, TRANSPOSE (click the transpose box).
* This presumably should work
with other spreadsheets and plotting programs, but
I have not tested it.
Excel does not like double
float format: 1234.5d2
All floats are converted to
single float format: 1.23456e+12, or 1234.56.
Excel sometimes does not
like 'nil' or ' ', which it treats as strings:
A scatterplot goofs
up if some cells have these values.
(Nil values sort to
Lispix exports nil values
for plots as "" (between the tabs which separate columns).
For spreadsheets, nil values
are 'nil'. 3/13/2003
to work ok on nil values in spreadsheets exported from Lispix. I
don't know why this difference.