Slow Insert Row

users
#1

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

When I insert a row in small sheet it takes about 7 seconds before the
row is inserted.

This isn't typical for my machine. On another much older machine of
mine the Insert Row process is instant.

I'm running Ubuntu 11.04

Any ideas?

(No, I don't have a huge pile of programs that're open)

#2

Verify the settings in:
Menu/Tools/Options/LibreOffice/Memory.
Miguel Ángel.

#3

Hi :slight_smile:
Could you try temporarily re-naming your user profile?
http://wiki.documentfoundation.org/Documentation/UserProfile

If it doesn't work then just delete the new profile and rename the old one so that you get all your templates, galleries, extensions, settings and everything all back the way it was.
Regards from
Tom :slight_smile:

#4

-----BEGIN PGP SIGNED MESSAGE-----Hash: SHA1On 12/16/2011 05:14 AM, Tom Davies wrote:Hi :)Could you try temporarily re-naming your user profile?http://wiki.documentfoundation.org/Documentation/UserProfileIf it doesn't work then just delete the new profile and
      rename the old one so that you get all your templates, galleries,
      extensions, settings and everything all back the way it was.Regards fromTom :)I deleted the old /user/ folder.LibreOffice created a new one when
    I started up Calc again.There was no change in speed for the
    Insert Row.— On Fri, 16/12/11, MiguelAngelmariosv@miguelangel.mobiwrote:From: MiguelAngelmariosv@miguelangel.mobiSubject: Re: [libreoffice-users] Slow Insert RowTo:users@global.libreoffice.orgDate: Friday, 16 December, 2011, 9:16El 16/12/11 5:48, . escribi:When I insert a row in small sheet it takes about 7 seconds
      before therow is inserted.This isn't typical for my machine. On another much older
      machine ofmine the Insert Row process is instant.I'm running Ubuntu 11.04Any ideas?(No, I don't have a huge pile of programs that're open)Verify the settings in:Menu/Tools/Options/LibreOffice/Memory.Miguelngel.-----BEGIN PGP SIGNATURE-----Version: GnuPG v1.4.11 (GNU/Linux)Comment: Using GnuPG with Mozilla -http://enigmail.mozdev.org/iQEcBAEBAgAGBQJO61CjAAoJEPBpZNn4grcj3ZIIAIUCwR535qAsIuv4uaoEQ/X9tI1YYGtx+hNCCSkJggnXpqx5XPEvra1dj9/xthzL4e+1hWKyqeM4lW0ZxTflBkoYsfWujF2gLAsf3RLWI8UTYnxlapaglEqCAoew4+3d0wjV96cbx0sxSw9qKB5FuSoveVvJa/2IZcc8YOMqqlU3Z9lcL5B9/MjyjTCY53iM7h/PfjsgQ2dmt8Koxud/FpDjaiVRXsqYzAxHUDZrLW96ku0dx9N9EUp55/pYnBv7/7ZGlr6dv/rDhr/8Qr+P0VG7bpFAelwjtV3YiAxOK4GyhWcaoDseNpAxLV3ERddVRjHV0b0xY0AgDBGILmu73S8==vVCF-----END PGP SIGNATURE-----

#5

-----BEGIN PGP SIGNED MESSAGE-----Hash: SHA1On 12/16/2011 04:16 AM, MiguelAngel wrote:El 16/12/11 5:48, . escribi:When I insert a row in small sheet it takes about 7 seconds
      before therow is inserted.This isn't typical for my machine. On another much older
      machine ofmine the Insert Row process is instant.I'm running Ubuntu 11.04Any ideas?(No, I don't have a huge pile of programs that're open)Verify the settings in:Menu/Tools/Options/LibreOffice/Memory.Miguelngel.What should they be set to?-----BEGIN PGP SIGNATURE-----Version: GnuPG v1.4.11 (GNU/Linux)Comment: Using GnuPG with Mozilla -http://enigmail.mozdev.org/iQEcBAEBAgAGBQJO61DWAAoJEPBpZNn4grcjaVcH/2WRJpRkVVzLaVls6UilFAdK3/EJTZiWfZHachJ0RTOMbO6NiR3HaNeXGbJpTODxAzxG+0Is/BpM8Yel0PyfeU+DR8NZT8OQFoI7Fc4vx7dKCV7XWTY6YAi+ktYENS5c4qK5i95Nh0QXp5LbjTny4BgK+udy6luMdSGa5dTFJ0rklfdxwM7hmAaRoW2m5ch7MnTBQrMr/XrYR2AHd5SdzsIh6rJ2CC7CbcpX0nIvlCZN4WNZZ6u1Ako/mNkVrv/9ZbFiwYqG32+hl0iLLhqFDTPg/QBhUo2JolY8mkNkv+GMlEkaghRjyWFLFA3PFp298BbSNLeQV6ayQThjFZcpmkw==zZ5y-----END PGP SIGNATURE-----

#6

Hi :slight_smile:
Hmm, ok rename your old profile back to replace the new one to at least get your other settings back the way they were before.

Sorry i couldn't help there!
Apols and regards from
Tom :slight_smile:

#7

It seems the problem is related to Ubuntu 11.04 only. LO opens
perfectly quick. But, the Insert Row operation is too slow for
practical use.

My other machine is Ubuntu 10.04 running Lo 3.3.??? and works very
well. 11.04 with Lo doesn't.

#8

Hi :slight_smile:
Just out of curiosity can you check which version of java is being used?

Tools - Options - Java

It shouldn't make a difference imo and you should even be able to turn off java without it affecting the "insert row" function
Regards from
Tom :slight_smile:

#9

Hi :slight_smile:
Just out of curiosity can you check which version of java is being used?

Tools - Options - Java

It shouldn't make a difference imo and you should even be able to turn off java without it affecting the "insert row" function
Regards from
Tom :slight_smile:

Can't say for sure...I'm at the other computer right now. But, if I
remember correctly it was 1.6.0.22. I unchecked the "....Java runtime
environment" per instructions found at another website.

#10

It seems the problem is related to Ubuntu 11.04 only. LO opens
perfectly quick. But, the Insert Row operation is too slow for
practical use.

My other machine is Ubuntu 10.04 running Lo 3.3.??? and works very
well. 11.04 with Lo doesn't.

I did not notice any slowness when inserting rows in Ubuntu 11.04 or 11.10 with small spreadsheets. I am using default settings from the repository.

#11

-----BEGIN PGP SIGNED MESSAGE-----Hash: SHA1The problem of slow Row Insert has been solved.I'm running Ubuntu 11.04 and the above mentioned problem seems
    typical to 11.04I deleted 3.4.3 which had been installed via Synaptic and the PPA
    stuff that had to be added.Also deleted was the ./LibreOffice
    folder and an old ./OpenOffice folder that contained who-knows-what
    but I read somewhere to delete it…so…I did.Then, I installed the following version;LibreOffice 3.3.4OOO330m19 (Build:401)tag libreoffice-3.3.4.1This version was found at-http://www.libreoffice.org/download/The file was- LibO_3.3.4_Linux_x86_install-deb_en-US.tar.gzhttp://download.documentfoundation.org/libreoffice/stable/3.3.4/deb/x86/LibO_3.3.4_Linux_x86_install-deb_en-US.tar.gz146 MBOnce the file is downloaded and extracted you MUST read the README
    file found in the main folder.It describes how to install
    LibreOffice.If I can do it…so can you.It's very easy and
    doesn't require all of that esoteric ./configure, make, make install
    stuff that works for me about 1% of the time.On 12/16/2011 12:48 PM, Jay Lozier wrote:On 12/16/2011 11:32 AM, .
      wrote:It seems the problem is related to Ubuntu 11.04 only. LO
      opensperfectly quick. But, the Insert Row operation is too
      slow forpractical use.My other machine is Ubuntu 10.04 running Lo 3.3.??? and
      works verywell. 11.04 with Lo doesn't.I did not notice any slowness when inserting rows in Ubuntu
      11.04 or 11.10 with small spreadsheets. I am using default
      settings from the repository.On 12/16/2011 11:09 AM, Tom Davies wrote:Hi :)Hmm, ok rename your old profile back to replace the
      new one to at least get your other settings back the way they were
      before.Sorry i couldn't help there!Apols and regards fromTom :)— On Fri, 16/12/11,
      .peace@AleksandrSolzhenitsyn.netwrote:From: .peace@AleksandrSolzhenitsyn.netSubject: Re: [libreoffice-users] Slow Insert RowTo:users@global.libreoffice.orgDate: Friday, 16 December, 2011, 14:07-----BEGIN PGP SIGNED MESSAGE-----Hash: SHA1On
      12/16/2011 05:14 AM, Tom Davies wrote:Hi :)Could you try
      temporarily re-naming your user
      profile?http://wiki.documentfoundation.org/Documentation/UserProfileIfit doesn't work then just delete the new profile andrename the old one so that you get all your
      templates, galleries,extensions, settings and everything all back the way
      it was.Regards fromTom :)I deleted the old /user/
      folder.LibreOffice created a new one whenI started up Calc again.There was no change in speed
      for theInsert Row.— On Fri, 16/12/11,MiguelAngelmariosv@miguelangel.mobiwrote:From:MiguelAngelmariosv@miguelangel.mobiSubject:Re:
      [libreoffice-users] Slow InsertRowTo:users@global.libreoffice.orgDate:Friday, 16 December, 2011,
      9:16El 16/12/11 5:48, . escribi:When I insert a row in small sheet
      it takes about 7 secondsbefore therow is inserted.This isn't typical for my
      machine. On another much oldermachine ofmine the Insert Row process is instant.I'm
      running Ubuntu 11.04Any ideas?(No, I don't have a huge pile of
      programs that're open)Verify the settings
      in:Menu/Tools/Options/LibreOffice/Memory.Miguelngel.-----BEGIN PGP
      SIGNATURE-----Version: GnuPG v1.4.11 (GNU/Linux)Comment: Using
      GnuPG with Mozilla
      -http://enigmail.mozdev.org/iQEcBAEBAgAGBQJO61CjAAoJEPBpZNn4grcj3ZIIAIUCwR535qAsIuv4uaoEQ/X9tI1YYGtx+hNCCSkJggnXpqx5XPEvra1dj9/xthzL4e+1hWKyqeM4lW0ZxTflBkoYsfWujF2gLAsf3RLWI8UTYnxlapaglEqCAoew4+3d0wjV96cbx0sxSw9qKB5FuSoveVvJa/2IZcc8YOMqqlU3Z9lcL5B9/MjyjTCY53iM7h/PfjsgQ2dmt8Koxud/FpDjaiVRXsqYzAxHUDZrLW96ku0dx9N9EUp55/pYnBv7/7ZGlr6dv/rDhr/8Qr+P0VG7bpFAelwjtV3YiAxOK4GyhWcaoDseNpAxLV3ERddVRjHV0b0xY0AgDBGILmu73S8==vVCF-----END
      PGP SIGNATURE----------BEGIN PGP SIGNATURE-----Version: GnuPG v1.4.11 (GNU/Linux)Comment: Using GnuPG with Mozilla -http://enigmail.mozdev.org/iQEcBAEBAgAGBQJO65DqAAoJEPBpZNn4grcjBHEH/RuCYCQ82RFVZT4jPuRa4zb+mu0KlYdWRtDSXl0v04KUgSJgsc8c3yum34bAXXWGcapNyRTa0zQVVYN9Nu2QR2cUbqGltqz6v7rIUcGp7jHpCPvRpi0fIi4QxVbF+MNoemReKC2WvCRL535dSsop0ObLoQhKYzhPMxrvdX8hkaXoWQV/KDhMLbtGc5NVulCfm3USkfz+lfKqCDdSra5KfaG5pCcRWvZ+JraIK6Drhq6PNSfEzhga7e6Sq8YKFHu1y/mjP+FKAnDeSMVRWAt/7kxrAeSftlYx161W59Xm6scNtEeexDCivdln3F5Kb65Ts+YNqnvTxq09KuKneEW2Rk4==8E6o-----END PGP SIGNATURE-----

#12

Hi :slight_smile:
Glad to hear you fixed it :)  Congrats!  The 3.3.x is the main one i still use on Gnu&Linux machines but i have been happy with 3.4.x on Windows too and they seem to work well together.  I still haven't dared try the 3.5.x branch and probably wont for quite a long time unless i magically find a lot of free time which seems unlikely.

Regards from
Tom :slight_smile:

#13

...snipped
Can you reformat your post so that folks can understand your msg? Thanks.

#14

It seems that my posts are being sent with a messed up appearance.

Do the posts I've sent about the subject above appear messed up and hard
to read?

#15

Sorry about the mess up folks- it wasn't on my side of things.

Here's my post.....

The problem of slow Row Insert has been solved.

I'm running Ubuntu 11.04 and the above mentioned problem seems typical
to 11.04

I deleted 3.4.3 which had been installed via Synaptic and the PPA stuff
that had to be added. Also deleted was the ./LibreOffice folder and an
old ./OpenOffice folder that contained who-knows-what but I read
somewhere to delete it...so...I did.

Then, I installed the following version;

LibreOffice 3.3.4
OOO330m19 (Build:401)
tag libreoffice-3.3.4.1

This version was found at- http://www.libreoffice.org/download/
The file was- LibO_3.3.4_Linux_x86_install-deb_en-US.tar.gz
<http://download.documentfoundation.org/libreoffice/stable/3.3.4/deb/x86/LibO_3.3.4_Linux_x86_install-deb_en-US.tar.gz>
146 MB

Once the file is downloaded and extracted you MUST read the README file
found in the main folder. It describes how to install LibreOffice. If
I can do it....so can you. It's very easy and doesn't require all of
that esoteric ./configure, make, make install stuff that works for me
about 1% of the time.

#16

Hi :slight_smile:
Nicely done! you seem to have sorted out your formatting too. One way
around would be to post using Nabble. However whatever you did to fix it
works well.
Congrats and regards from
Tom :slight_smile: