LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   libre calc exceeding limit (https://www.linuxquestions.org/questions/linux-newbie-8/libre-calc-exceeding-limit-4175533609/)

vigneswaraprabhu 02-10-2015 09:55 AM

libre calc exceeding limit
 
iam trying to open a 100mb fasta file in libre calc, and it stays like that for several minutes and finally displays that the file exceeded the row limit in excel , is there any way for me to view this file in excel

TB0ne 02-10-2015 10:09 AM

Quote:

Originally Posted by vigneswaraprabhu (Post 5315023)
iam trying to open a 100mb fasta file in libre calc, and it stays like that for several minutes and finally displays that the file exceeded the row limit in excel , is there any way for me to view this file in excel

No idea, why don't you try it??? Excel is a Windows program, and different from Libre Office. Also, a fasta file isn't really formatted for a spreadsheet program. What do you normally open them with?

The error message is pretty clear...there are too many rows. So either split the file up into smaller chunks, or open it with a different program.

rtmistler 02-10-2015 01:12 PM

Quote:

Originally Posted by vigneswaraprabhu (Post 5315023)
iam trying to open a 100mb fasta file in libre calc, and it stays like that for several minutes and finally displays that the file exceeded the row limit in excel , is there any way for me to view this file in excel

Shouldn't you convert it to a CSV format before you try this? After all, it's just going to find the descriptions and the sequences and segregate those by ... line feeds? Have you tried to import it as data and see what it can deal with for delimiters? What's your intent here? If you wish to chart the different sequences, won't you need to break those sequences down per row or column? Right now there's no real way for calc or excel to do that if it is a native fasta format.

Shouldn't there also be an application which generates and deals with these files? Can you use that to export the data differently?

vigneswaraprabhu 02-11-2015 03:50 AM

Quote:

Originally Posted by rtmistler (Post 5315127)
Shouldn't you convert it to a CSV format before you try this? After all, it's just going to find the descriptions and the sequences and segregate those by ... line feeds? Have you tried to import it as data and see what it can deal with for delimiters? What's your intent here? If you wish to chart the different sequences, won't you need to break those sequences down per row or column? Right now there's no real way for calc or excel to do that if it is a native fasta format.

Shouldn't there also be an application which generates and deals with these files? Can you use that to export the data differently?

yes iam trying to convert the fasta contents into a table, and i usually provide appropriate delimiters and it works out for smaller files, but this larger one doesn't open at all.

rtmistler 02-11-2015 08:31 AM

The few suggestions then are to:
  1. Break the file up into several smaller files
  2. Pre-convert it into CSV format prior to attempting to import it to calc
  3. Do both: break it up into smaller files and pre-convert the chunks.
You may have found a limit, be that memory or program capabilities for calc, but I wouldn't know because I don't have that much knowledge of that program's maximum limitations. Pre-converting the file, I'd either write a script or a program to do that.


All times are GMT -5. The time now is 10:35 AM.