Welcome!
Important information
-- Information on torrent hosting changes
-- Information on MX15/16 GPG Keys
-- Spectre and Meltdown vulnerabilities

News
-- Introducing our new Website
-- MX Linux on social media: here

Current releases
-- MX-18.1 Point Release release info here
-- Migration Information to MX-18 here
-- antiX-17.4 release info here

New users
-- Please read this first, and don't forget to add system and hardware information to posts!
-- Here are the Forum Rules

Calc, Gnumeric and big spreadsheets

This forum is intended for the discussion around the use of MEPIS in an office setting as distinct from home or indivicual usage. Examples include mail merge, database construction, hardware sharing, advertising, etc..
User avatar
Jerry3904
Forum Veteran
Forum Veteran
Posts: 24089
Joined: Wed Jul 19, 2006 6:13 am

Calc, Gnumeric and big spreadsheets

#1

Post by Jerry3904 » Thu Sep 29, 2016 2:11 pm

I am working with a spreadsheet ATM that has about 6,000 rows (records) and 60 columns (fields) in xlsx format. A big spreadsheet, but not outrageous. Calc (5.1.5.2) is simply unable to handle it: 10 seconds to load, equal amount just to move one page down, total hang up when I use Ctrl-End. Increasing the memory for object to 20 MB did not help.

Installed Gnumeric 1.12.18, and absolutely no problem at first (see below). Loads and saves quickly, moves around with almost no lag. I have read before that Gnumeric is more accurate, but did not realize what a huge performance difference there was. Glad I don't have to switch to my W 8.1 box for this work...
Production: 4.15.0-1-amd64, MX-17.1, AMD FX-4130 Quad-Core, GeForce GT 630/PCIe/SSE2, 8 GB, SSD 120 GB, Data 1TB
Testing: AAO 722: 4.15.0-1-386. MX-17.1, AMD C-60 APU, 4 GB
Personal: XPS 13, 4.18.0-19.3-liquorix, 4 GB

User avatar
Jerry3904
Forum Veteran
Forum Veteran
Posts: 24089
Joined: Wed Jul 19, 2006 6:13 am

Re: Gnumeric over Calc for big spreadsheets

#2

Post by Jerry3904 » Thu Sep 29, 2016 4:43 pm

<A bit later>

Nope, Gnumeric fails too. Had to move over to my very nice Dell XPS laptop, where Excel still rocks.
Production: 4.15.0-1-amd64, MX-17.1, AMD FX-4130 Quad-Core, GeForce GT 630/PCIe/SSE2, 8 GB, SSD 120 GB, Data 1TB
Testing: AAO 722: 4.15.0-1-386. MX-17.1, AMD C-60 APU, 4 GB
Personal: XPS 13, 4.18.0-19.3-liquorix, 4 GB

User avatar
anticapitalista
Forum Veteran
Forum Veteran
Posts: 6095
Joined: Sat Jul 15, 2006 10:40 am

Re: Gnumeric over Calc for big spreadsheets

#3

Post by anticapitalista » Thu Sep 29, 2016 4:47 pm

Be interesting to see if default jessie calc works better.
anticapitalista
Reg. linux user #395339.

Philosophers have interpreted the world in many ways; the point is to change it.

antiX-17 "Heather Heyer" - lean and mean.
https://antixlinux.com

User avatar
Gordon Cooper
Forum Guide
Forum Guide
Posts: 2295
Joined: Mon Nov 21, 2011 5:50 pm

Re: Gnumeric over Calc for big spreadsheets

#4

Post by Gordon Cooper » Thu Sep 29, 2016 7:04 pm

Gnumeric 1.12.18 is a couple of years old, they were up to 1,12,31 or 32 last month. Developers promote the ability to work with big spreadsheets, where was the failure ?
Primary: Dell9010, MX-18, Win7, 120 SSD, WD 232GIB HD, 4GB RAM
Backup :Homebrew64 bit Intel duo core 2 GB RAM, 120 GB Kingston SSD, Seagate1TB.
MX-17.1 64bit. Also MX17, Kubuntu14.04 & Puppy 6.3.

User avatar
Jerry3904
Forum Veteran
Forum Veteran
Posts: 24089
Joined: Wed Jul 19, 2006 6:13 am

Re: Gnumeric over Calc for big spreadsheets

#5

Post by Jerry3904 » Thu Sep 29, 2016 7:40 pm

1) Working with the document in xlsx format, it kept getting increasing slow and finally just hung.
2) When I used a filter to see only a portion of the records, copying/pasting the result failed b/c both Gnu and LO Calc do not copy the filtered results but the same number of rows in the unfiltered document--took me a couple of hours to figure that out.

On 1), I do notice (a bit late) that *.xlsx is not listed as supported on the Debian page:

https://packages.debian.org/sid/gnumeric

Thanks for the info about the more recent versions; the most recent one is in Stretch so I will make a package request.
Production: 4.15.0-1-amd64, MX-17.1, AMD FX-4130 Quad-Core, GeForce GT 630/PCIe/SSE2, 8 GB, SSD 120 GB, Data 1TB
Testing: AAO 722: 4.15.0-1-386. MX-17.1, AMD C-60 APU, 4 GB
Personal: XPS 13, 4.18.0-19.3-liquorix, 4 GB

User avatar
Gordon Cooper
Forum Guide
Forum Guide
Posts: 2295
Joined: Mon Nov 21, 2011 5:50 pm

Re: Gnumeric over Calc for big spreadsheets

#6

Post by Gordon Cooper » Thu Sep 29, 2016 11:56 pm

Was the original spreadsheet written in an Excel version dated pre 2007? if so, there may be macros that cannot be handled by xlsx readers? Should not be any problems with size, saw a reference to more than 16,000 columns being possible.
Primary: Dell9010, MX-18, Win7, 120 SSD, WD 232GIB HD, 4GB RAM
Backup :Homebrew64 bit Intel duo core 2 GB RAM, 120 GB Kingston SSD, Seagate1TB.
MX-17.1 64bit. Also MX17, Kubuntu14.04 & Puppy 6.3.

User avatar
Jerry3904
Forum Veteran
Forum Veteran
Posts: 24089
Joined: Wed Jul 19, 2006 6:13 am

Re: Gnumeric over Calc for big spreadsheets

#7

Post by Jerry3904 » Fri Sep 30, 2016 3:54 am

Nope
Production: 4.15.0-1-amd64, MX-17.1, AMD FX-4130 Quad-Core, GeForce GT 630/PCIe/SSE2, 8 GB, SSD 120 GB, Data 1TB
Testing: AAO 722: 4.15.0-1-386. MX-17.1, AMD C-60 APU, 4 GB
Personal: XPS 13, 4.18.0-19.3-liquorix, 4 GB

User avatar
Jerry3904
Forum Veteran
Forum Veteran
Posts: 24089
Joined: Wed Jul 19, 2006 6:13 am

Re: Calc, Gnumeric and big spreadsheets

#8

Post by Jerry3904 » Sat Oct 01, 2016 9:34 am

Just to finish this up: Stevo backported gnumeric 1.12.32 and it has no problem whatsoever with the big *,xlsx file.
Production: 4.15.0-1-amd64, MX-17.1, AMD FX-4130 Quad-Core, GeForce GT 630/PCIe/SSE2, 8 GB, SSD 120 GB, Data 1TB
Testing: AAO 722: 4.15.0-1-386. MX-17.1, AMD C-60 APU, 4 GB
Personal: XPS 13, 4.18.0-19.3-liquorix, 4 GB

User avatar
Jerry3904
Forum Veteran
Forum Veteran
Posts: 24089
Joined: Wed Jul 19, 2006 6:13 am

Re: Calc, Gnumeric and big spreadsheets

#9

Post by Jerry3904 » Mon Oct 03, 2016 5:16 pm

Finishing this up even further: I just installed LO 5.2.2.2 from the website, and it seems to have no trouble now with *.xlsx files. Which is great!
Production: 4.15.0-1-amd64, MX-17.1, AMD FX-4130 Quad-Core, GeForce GT 630/PCIe/SSE2, 8 GB, SSD 120 GB, Data 1TB
Testing: AAO 722: 4.15.0-1-386. MX-17.1, AMD C-60 APU, 4 GB
Personal: XPS 13, 4.18.0-19.3-liquorix, 4 GB

User avatar
Stevo
Forum Veteran
Forum Veteran
Posts: 18399
Joined: Fri Dec 15, 2006 8:07 pm

Re: Calc, Gnumeric and big spreadsheets

#10

Post by Stevo » Mon Oct 03, 2016 5:51 pm

Did you get a chance to give the new Gnumeric a workout? Do you think it's ready to go to main, along with its newer libgoffice-0.10 and libgsf1-dev?

Post Reply

Return to “Office”