LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 02-10-2015, 10:55 AM   #1
vigneswaraprabhu
LQ Newbie
 
Registered: Feb 2015
Posts: 3

Rep: Reputation: Disabled
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
 
Old 02-10-2015, 11:09 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,919

Rep: Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689
Quote:
Originally Posted by vigneswaraprabhu View Post
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.
 
Old 02-10-2015, 02:12 PM   #3
rtmistler
Moderator
 
Registered: Mar 2011
Location: Sutton, MA. USA
Distribution: MINT Debian, Angstrom, SUSE, Ubuntu
Posts: 4,087
Blog Entries: 10

Rep: Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521
Quote:
Originally Posted by vigneswaraprabhu View Post
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?
 
Old 02-11-2015, 04:50 AM   #4
vigneswaraprabhu
LQ Newbie
 
Registered: Feb 2015
Posts: 3

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by rtmistler View Post
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.
 
Old 02-11-2015, 09:31 AM   #5
rtmistler
Moderator
 
Registered: Mar 2011
Location: Sutton, MA. USA
Distribution: MINT Debian, Angstrom, SUSE, Ubuntu
Posts: 4,087
Blog Entries: 10

Rep: Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521Reputation: 1521
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Libre Office calc does not update sharky Linux - Software 8 05-24-2013 03:05 PM
[SOLVED] where are macros stored in libre office calc 3.6.2+ knobby67 Linux - Software 3 04-26-2013 12:28 AM
Libre Office Calc, copy formular from one sheet to another knobby67 Linux - Software 1 11-14-2012 10:30 AM
[SOLVED] Libre Office Calc: I want to prevent changes to all but a few cells. damgar Linux - Software 2 07-09-2012 11:27 AM


All times are GMT -5. The time now is 02:12 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration