Bug 108934 - Graphics Performance Inferior to Excel by a factor of at least 10 (when zoomed out)
Summary: Graphics Performance Inferior to Excel by a factor of at least 10 (when zoome...
Status: RESOLVED DUPLICATE of bug 108574
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.4.2 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-07-04 06:04 UTC by Kevin
Modified: 2017-08-07 11:16 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
big file that Excel handles infinitely better than calc in terms of zooming and scrolling (857.42 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-07-04 06:09 UTC, Kevin
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin 2017-07-04 06:04:46 UTC
Description:
Scrolling and zooming are prohibitively slow - to the point of seeming like the app has crashed.

Steps to Reproduce:
1. open the attached document in Excel
2. hold down control and roll the mouse wheel to zoom way out
3. use the vertical scroll bar
4. repeat in Calc

Actual Results:  
Excel zooms in and out effortlessly - Calc freezes for minutes at a time. 

Expected Results:
This is exactly the OPPOSITE of what I would expect from a "non-corporate" application. Calc should be smooth, smart, elegant and graceful; Excel should be the result of decades of badly-managed, profit-driven, middle management-ruined upgrades. IN FACT, the opposite is true.


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36
Comment 1 Kevin 2017-07-04 06:09:33 UTC
Created attachment 134470 [details]
big file that Excel handles infinitely better than calc in terms of zooming and scrolling

And note well that this file (858K) is tiny compared to the massives types of spreadsheet that many users will need to work with. I'm only using Calc to make a decent looking table - only graphics - imagine how horrendous this problem would be with a massive database that incorporates all of the spreadsheet functionality or a list of tens of thousand of entries. Something is grossly inefficient about the way this thing is coded.
Comment 2 Kevin 2017-07-04 06:13:17 UTC
Note that I'm using a powerful, modern i7 Intel processor with 8 gigs of RAM - this would be significantly worse with an older PC, and many of your cost-conscious users have older PCs (to say nothing of schools and public libraries that can't afford to upgrade frequently).
Comment 3 Xavier Van Wijmeersch 2017-07-04 08:03:12 UTC
I can't reproduce zoomed to 400% and scrolling is fast, the only thing i can say is that lower than 100% slows the scrolling

Version: 6.0.0.0.alpha0+
Build ID: cac5c9f6081590b0548d3116bc4cd4a2509ec576
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-07-01_00:55:04
Locale: nl-BE (en_US.UTF-8); Calc: group

os Slackware64 14.2 current
Comment 4 Telesto 2017-07-04 10:06:07 UTC
Probably a dupe: see bug 108574; bug 108388
Comment 5 Xavier Van Wijmeersch 2017-07-05 16:42:49 UTC
did a another test with a older laptop
loading the file takes a while
zooming to 400% and scrolling is normal, but zooming to 50% scrolling is slower than normal

old laptop Dell Latitude D620
Intel(R) Core(TM)2 cpu T5500 @ 1.66Ghz
build year 2006

Version: 5.4.0.1.0+
Build ID: 367de96d58043f3a4e7809fa2d588e263a86af1b
CPU threads: 2; OS: Linux 4.9; UI render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86@71-TDF, Branch:libreoffice-5-4, Time: 2017-07-05_08:14:09
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 5.3.4.2
Build ID: SlackBuild for 5.3.4 by Eric Hameleers
CPU Threads: 2; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 6 Kevin 2017-07-05 21:39:28 UTC
(In reply to Xavier Van Wijmeersch from comment #5)

interesting point - performance is only degraded at when zoomed out, not when zoomed in - while you're zooming, don't forget the appalling bug where non-monospaced fonts don't scale correctly at different zoom level. It's just as important to zoom in and out of a large spreadsheet as it is to zoom in and of google maps. I am truly horrified that you guys keep releasing update after upadate without fixing these utterly humiliating mistakes. Where's the pride? What's the point of this project if you're not going to respect it?
Comment 7 Buovjaga 2017-08-07 11:16:29 UTC
Yep, seems to be the same as Telesto's. I confirmed it is slow with 50% in 5.4 and pretty snappy in 5.0 (Win 10).

*** This bug has been marked as a duplicate of bug 108574 ***