Slow response time with Calc

users
#1

When using Calc, I like to navigate across the cells using the arrow
keys on the keyboard. I'm finding when I do this on my Linux system, the
longer I'm in the spreadsheet, the slower my navigation becomes. After a
while, there's a large delay when I press one of the arrow keys.
Eventually, the spreadsheet becomes all but unusable. My spreadsheets
are not large; as spreadsheets go, they are quite simple. And, the
behavior doesn't immediately happen. When I first load a spreadsheet
file, the navigation is immediate. It slows down as I use the file, even
if all I'm doing is navigating with arrow keys.

I dual boot Windows 10 and Ubuntu Mate 14.04LTS. On the Windows 10 side
of things, I'm using LO 5.2.x and on the Linux side, I'm using LO 5.1.6.2.

This behavior only happens on the Linux side of things.

Has anyone else experienced anything like this?

Virgil

#2

Perhaps in relation with:
https://bugs.documentfoundation.org/show_bug.cgi?id=71409

Test with Menu/Tools/Options/LibreOffice/Accessibility - Support assistive
.... disable.

Miguel Ángel.

#3

For what it's worth, I just tried a Calc spreadsheet on the following OSs:

Linux Mint 18 Cinnamon running from a live USB session with LO 5.1.2.x

Puppy Linux (Tahr) running from a live USB session with LO 5.1.2.x

Neither exhibited the same slowness issue that I have with running
Ubuntu Mate. I'm beginning to think my problem isn't with LO as much as
it is with Ubuntu Mate.

Virgil

#4

I had not read the previous posts - removed from my email client.

Was the version of LO you were having problems with downloaded from LO's site or from Ubuntu's repository? I currently use version 5.2.3.3.

I never use the repository version or the PPA version. I just download it from LO's site, every so often.

I run Ubuntu Mate 16.04. I stopped using Linux Mint since it was having problems seeing most of my printers attached to my home/office router. I started using Ubuntu in 2009 and have been using it for my default system[s] since then. I try other distros on my secondary systems, though.

#5

Hi. I have a similar issue. I use LibreOffice 5.2.3.3 on Ubuntu xfce 16.04. I run a spreadsheet which downloads some data (ascii numeric) from an internet page and executes some elementary calculations with these data (total .ods is 33,3 kb). pc is i5 with 4 gb ddr4 ram; data are downloaded every 4 minutes. Downloading the data, Calc is completely blocked for about one minute and sometimes I have to force the window to close and restart Calc, which has to recover the file. May be there is an issue with memory or what.

Paolo

#6

I typically get my programs from the Ubuntu repository and add new PPA
repositories for newer programs. I work through Synaptic. In the case of
my Ubuntu Mate 14.04, I added the PPA for LO 5.1.x and updated that way.
For my other experiments with live USBs, I've just used whatever came
with the Linux distro. They have all come with some form of LO 5.1.x.

So, the only odd variable I'm finding is the Ubuntu Mate.

For me at least, LO Calc 5.1.x works fine on my Linux Mint Cinnamon live USB
LO Calc 5.1.x works fine on a live Ubuntu 14.04 (Unity) USB
LO Calc 5.1.x works fine on a live Puppy Linux (Tahr) USB
LO Calc 5.2.3.3 works fine on my Windows 10 partition.

I'm only experiencing the degradation in performance with LO Calc 5.1.x
on my Ubuntu Mate 14.04 partition.

I may blow off the Mate flavor of Ubuntu and install the Unity version.
I haven't been fully satisfied with Mate anyway.

Virgil

#7

So, a funny thing happened on my way to resolve my slow Calc issues. As
I indicated, I wasn't happy with Ubuntu Mate and wanted to try another
solution. I have several different Linux live distros on a USB
flashdrive, but I had never tried a virtual box as was recently
suggested in another thread.

So, I tried it, creating a VB in my Win10 partition and using it for
Ubuntu 14.04 Unity (I had tried 16.04 earlier this year and had many
problems with it, so I decided to stick with what had worked for me
before). I was surprised at how easy it was to set up VB. I accepted all
of its recommended settings and was up and running in minutes. Well
"running" is an exaggeration. Call it "walking." My Ubuntu in VB was
unacceptably slow. Even typing resulted in a noticeable lag between each
letter. When I went back to Windows, it too had slowed down perceptibly.
My computer is a Sony Vaio laptop with quadcore CPU, 4gb of RAM and
300+gb hard drive. I had dedicated 1gb of RAM to Ubuntu as recommended
by VB. I quickly decided that the performance dropoff was not worth any
benefit gained from not dual booting.

I then decided to replace my Ubuntu Mate with Ubuntu 14.04 Unity on my
dual boot system. I had used Unity before, but had problems when I
upgraded to 16.04.

I have installed Ubuntu Linux and other distros dozens of times without
problem, but this time I got careless. The installer found my Mate
installation and asked if I wanted to install beside it or erase and
replace it. I clicked erase and replace. The installation went smoothly
and when it was done, I rebooted.

I was surprised not to see a Grub menu of OS options. I've heard Grub
horror stories, so I thought something was corrupt in my boot options.
Then, it hit me. I checked my file system and there it was... or wasn't.
Not only had the installer erased my Mate partition, but it had erased
my Win10 partition as well. I no longer had Windows on my computer.

Fortunately, I frequently backup my important data, but for the life of
me, I can't find my Windows restoration CDs (the computer is about six
years old, and we have moved twice in the past year.)

So, for now, I am single booting Ubuntu Unity 14.04. Actually, this may
be a blessing in disguise. I have always wanted to abandon Windows
entirely just to see if I could do *everything* in Linux. I've never had
the guts to do it. Now, I have to see if I can live without Redmond.
But, as a remaining crutch, I still have an old XP desktop and my wife's
Vista laptop if needed in a pinch.

But, to the question at hand. The slow response time in Calc that I was
experiencing in Ubuntu Mate is now gone. Of course with such a drastic
solution, I've changed so many variables that I doubt I'll ever know
what the true problem was. Perhaps I just had a corrupt user profile
that needed changed on my Mate system. Had I only tried that, I may have
saved myself the loss of Win10 (not that I ever really liked it anyway).

Oh, well, live and learn. At any rate, it does feel nice to have a
really clean computer with a crisp fast OS and a well-behaving LO.

Cheers, y'all.

Virgil