Bug 80065 - EDITING: Slow editing of spreadsheet
Summary: EDITING: Slow editing of spreadsheet
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: perf
Depends on:
Blocks: Performance CPU-AT-100%
  Show dependency tree / graph
 
Reported: 2014-06-15 20:35 UTC by Craig
Modified: 2024-04-25 06:39 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

Attachments
Anonymised accounts spreadsheet (252.54 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-11-20 18:54 UTC, Craig 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Craig 2014-06-15 20:35:07 UTC 
PERF

Problem description: Accounts spreadsheet I created several years ago has suddenly become excruciatingly slow when entering data. 

Has 13 worksheets with no more than 1000 rows by 40 cols.

OS: Linux Mint 16 Cinnamon V2.0.14 x64, 
Kernel: 3.11.0-12-generic
Intel Core i7 CPU 930 @2.8GHz x 4
RAM 11.7GB

Steps to reproduce:
1. Enter data into a cell
2. Use arrow keys to move to the next cell

Current behavior: Takes 20 seconds to respond and CPU goes to 100%

Expected behavior: Immediate response and no increase in CPU.

              
Operating System: other
Version: 4.1.3.2 release
Comment 1 m_a_riosv 2014-06-15 20:59:49 UTC 
Hi Craig,

I think this is a duplicate of https://bugs.freedesktop.org/show_bug.cgi?id=71409

With accessibility installed and active in Menu/Tools/Options/LibreOffice/Accessibility - Support assistive ......

Disable the option, you need to restart.
Comment 2 Craig 2014-06-16 08:26:05 UTC 
I don't  have

Menu/Tools/Options/LibreOffice/Accessibility - Support assistive ......

to disable. Just a set of Miscellaneous options and Options for high contrast appearance. Unchecking them all and restarting improved the situation a little, but I get the impression it's more a video display issue.

Sorry, not techy enough to go deeper. Happy to look at logs or try some diagnostics with advice.

Regards,

Craig


On 15/06/14 21:59, bugzilla-daemon@freedesktop.org wrote:
> m.a.riosv <mailto:mariosv@miguelangel.mobi> changed bug 80065 
> <https://bugs.freedesktop.org/show_bug.cgi?id=80065>
> What 	Removed 	Added
> Status 	UNCONFIRMED 	NEEDINFO
> CC 		mariosv@miguelangel.mobi
> Ever confirmed 		1
>
> *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=80065#c1> 
> on bug 80065 <https://bugs.freedesktop.org/show_bug.cgi?id=80065> from 
> m.a.riosv <mailto:mariosv@miguelangel.mobi> *
> Hi Craig,
>
> I think this is a duplicate of
> https://bugs.freedesktop.org/show_bug.cgi?id=71409  <show_bug.cgi?id=71409>
>
> With accessibility installed and active in
> Menu/Tools/Options/LibreOffice/Accessibility - Support assistive ......
>
> Disable the option, you need to restart.
> ------------------------------------------------------------------------
> You are receiving this mail because:
>
>   * You reported the bug.
>
Comment 3 tommy27 2014-06-18 02:07:33 UTC 
hi Craig,
try resetting the user profile ( https://wiki.documentfoundation.org/UserProfile ) and if that is not enough upgrade to LibO 4.2.4.2

moreover attach a test file without sensitive information to help us debugging
Comment 4 raal 2014-09-10 18:20:50 UTC 
See the comment 3, settings as NEEDINFO. Please set as Unconfirmed again after you provide more informations. Thank you.
Comment 5 Craig 2014-11-20 18:54:37 UTC 
Created attachment 109772 [details]
Anonymised accounts spreadsheet

Anonymised spreadsheet to use as a test case for this bug. VERY slow save time (>36s)
Comment 6 tommy27 2014-11-20 21:19:15 UTC 
I confirm very slow saving time in LibO 4.3.3.2 under Win7
Comment 7 QA Administrators 2015-12-20 16:08:21 UTC Comment hidden (obsolete)
Comment 8 Aron Budea 2016-11-27 12:29:30 UTC 
Tested with 5.2.3.3 / Windows 7.
Editing is pretty quick, but saving could be faster.
Comment 9 Telesto 2017-10-08 17:45:52 UTC 
No repro with:
Version: 6.0.0.0.alpha0+
Build ID: c5a93cad149618bbd43632f1660a558c34bdbf7e
CPU threads: 4; OS: Windows 6.3; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2017-10-07_01:04:25
Locale: nl-NL (nl_NL); Calc: CL
Comment 10 Xavier Van Wijmeersch 2017-10-09 07:55:31 UTC 
No repro with

Version: 5.3.1.2
Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2
CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 11 QA Administrators 2018-10-10 03:05:43 UTC Comment hidden (obsolete)
Comment 12 Roman Kuznetsov 2019-02-23 17:10:00 UTC 
don't repro in

Version: 6.3.0.0.alpha0+ (x64)
Build ID: 47c498417248444cab4e8f597ddeec4e0d585a71
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-02-21_08:39:21
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

Status->WFM