Frank Cox wrote: > On Thu, 19 Jul 2007 07:19:45 -0400 > Jean-David Beyer <[EMAIL PROTECTED]> wrote: > >> I receive some >> tables (in .tsv format) that go from A to HR, and calc cuts them off way >> before that.
I goofed, they actually go to KC. > > Are you sure you're not just running out of ram or something, instead of > running out of columns? I am pretty sure. I had no trouble loading it into Applix spreadsheets. I have 8 GBytes RAM on this machine, and any process can get up to almost 4 GBytes of it. VIRT RES SHR %MEM COMMAND 271m 97m 51m 1.2 /usr/lib/openoffice.org2.0/program/scalc.bin -calc So the amount of virtual memory required right now is a little over 1/4 Gigabyte. 1.2% of the memory available. > Running the cursor across a blank OpenOffice Calc spreadsheet runs out at IV, > which is quite a ways past HR, and you say that you don't even get that far. I observe the same thing you do. I get up to IV, but everything after that is lost (silently). > > You might want to look at Gnumeric and see if it will get you where you're > going. Gnumeric will not go past some limit either. I forget what it is, and do not even have a version that runs on my distro: RHEL5. > >> 2a.) As a practical matter, I think a table with that many columns is >> ridiculous. In fact, all I do is delete a large number of columns (at which >> point it goes from A to AM that calc accepts with no problem) and then use >> hand-made programs to enter the result in normalized form into a dbms. So I >> could write a custom program to strip out the columns manually. > > I think your best solution would be to write a small script that would chop > out > what you don't need before you load it into any spreadsheet. Loading, > decoding and displaying all of that data just so you can highlight it and > delete it wastes a lot of computer-time and your time. A script could > probably > run in a second or two and give you exactly what you want without all of the > manual fiddling around. > I think you are right. If it were just something to change in a .conf file, I think I would just put up with it. But I should write a suitable script or C++ program and just go do it. It will not actually be simple, since there are 4 or 5 different formats to deal with, but the old ones are pretty much done, and the new ones are all the same for now. Actually, I forgot that I then sort it and delete a lot of rows (easy: they are all together after the sort). But if I strip out the dead columns in a special programs, openoffice calc will easily handle what is left. -- .~. Jean-David Beyer Registered Linux User 85642. /V\ PGP-Key: 9A2FC99A Registered Machine 241939. /( )\ Shrewsbury, New Jersey http://counter.li.org ^^-^^ 16:35:01 up 10 days, 22:52, 2 users, load average: 4.29, 4.24, 4.20 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]