From: Veli-Pekka Nousiainen on 7 Nov 2006 10:17 parisse(a)domain.invalid wrote: > sethians wrote: >> when i saw in the spreadsheet that have the columns AA, AB, AC, >> AD.... I was happy!!! >> but is the same limitation of the XCELL only 26 columns :( >> >> My spreadsheet's have more than 30 columns >> >> Sethians -l- >> http://www.hpcivil.org >> > > I didn't care to include code for more than 26 columns > since EVALuating a large spreadsheet is too slow. > Rows are not limited. and one can do TRN then use the spread sheet "sideways" and finally TRN the result BUT then you are limited to 26 rows....
From: parisse on 7 Nov 2006 11:13 > and one can do TRN > then use the spread sheet "sideways" > and finally TRN the result > BUT > then you are limited to 26 rows.... > > That will not work, since TRN will not translate cell references.
From: Veli-Pekka Nousiainen on 9 Nov 2006 05:38
parisse(a)domain.invalid wrote: >> and one can do TRN >> then use the spread sheet "sideways" >> and finally TRN the result >> BUT >> then you are limited to 26 rows.... >> >> > > That will not work, since TRN will not translate cell references. (/)&)(/&#)% - how silly of me... Then there is one more command to add TRANS |