[Solved] Unable to view all of large Excel file

Discuss the spreadsheet application

[Solved] Unable to view all of large Excel file

Postby miggs42 » Sat Jul 14, 2018 4:26 am

When I download a very large excel spreadsheet, I can't see the whole list. It is only showing 2730 lines and there should be around 5000. Does anyone know how to fix this?
Last edited by miggs42 on Sun Jul 15, 2018 5:14 pm, edited 2 times in total.
open office 4.1.5 on Mac 10.13.6
miggs42
 
Posts: 3
Joined: Sat Jul 14, 2018 4:21 am

Re: Unable to view all of large Excel file

Postby Zizi64 » Sat Jul 14, 2018 6:21 am

I can not help for you - without seeing the Excel file...

Can you upload it (max. 128 KiB), or share it (on a free file sharing service) ?
Last edited by Zizi64 on Sat Jul 14, 2018 8:21 am, edited 1 time in total.
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.1 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.2 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7462
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Unable to view all of large Excel file

Postby miggs42 » Sat Jul 14, 2018 7:18 am

Sorry, I can't post it. I am trying to download my companies portfolio to an excel file from the sales rep portal. When I view it on the website, I can see everything. As soon as I "download to excel file" it cuts it off. I wish I could show you what I was talking about, but I can't. It's not a public website.
open office 4.1.5 on Mac 10.13.6
miggs42
 
Posts: 3
Joined: Sat Jul 14, 2018 4:21 am

Re: Unable to view all of large Excel file

Postby Zizi64 » Sat Jul 14, 2018 8:29 am

Is it an .xls or is it an .xlsx file?

You can check the content of an OOXML based (.xlsx type) spreadsheet file without Excel and without AOO Calc application:
Rename ia copy of your file to .zip extension. Then you will able unzip it, and you will able to open the files (located inside the archive) with a text editor or with an xml editor.
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.1 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.2 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7462
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Unable to view all of large Excel file

Postby jrkrideau » Sat Jul 14, 2018 11:45 am

miggs42 wrote:As soon as I "download to excel file" it cuts it off.

Is there an option to download as a .csv or text file? If so you might be able to do that and import into Calc, or at least open the file to confirm that the download is actually giving you the ~5000 rows of data. At the moment we don't know if it is a download issue or a Calc import problem.

Another approach might be to install Gnumeric spreadsheet and see if it will give you the ~5000 rows.

I have noticed that occasionally it seems to deal with Excel file a bit better than Calc does. You then can save in ODF format and presumably work with the data in Calc
AOO 4.1.5; Ubuntu 18.04
jrkrideau
Volunteer
 
Posts: 3582
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Unable to view all of large Excel file

Postby Villeroy » Sat Jul 14, 2018 10:05 pm

LibreOffice handles Excel files, particularly xlsx, way better than OpenOffice.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 25963
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Unable to view all of large Excel file

Postby MrProgrammer » Sun Jul 15, 2018 5:06 am

miggs42 wrote:When I view it on the website, I can see everything. As soon as I "download to excel file" it cuts it off.
• Your theory: The download contains all 5000 lines however, Calc does not display them all.
• Alternate theory: The website download is incomplete and contains only 2730 lines. Calc is displaying all of them.
Mr. Programmer
AOO 4.1.5 Build 9789 on Mac OS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 3524
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Unable to view all of large Excel file

Postby miggs42 » Sun Jul 15, 2018 5:13 pm

The LibreOffice route worked perfectly! Thanks!
open office 4.1.5 on Mac 10.13.6
miggs42
 
Posts: 3
Joined: Sat Jul 14, 2018 4:21 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 25 guests