[plug] Import more than 256 "cells" of data into a spreadsheet

Gavin Chester gavinchester1 at hotmail.com
Thu Jul 14 11:14:20 WST 2005


On Thu, 2005-07-14 at 10:55 +0800, Senectus . wrote:
> I've just noticed that both Excel and OO Spreadsheet/Calc have a built
> in limit of 256 columns.
> This is proving an issue for me because I need to import a line of
> text from a CSV that is about 366 cells.
> Is there some way to import them as a vertical column instead of a
> horizontal row?
> 
> Thanks 

In ANY editor (not entering into the vim, vi, gedit, notepad war
argument ;-) )  replace every comma with EOL/carriage return to build a
column of values in your original data?  Or, would that end up being
imported into one cell, only?  Should work.  Just a thought :-)

Gavin 




More information about the plug mailing list