[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