Bug 115622 - NAVIGATION: Calc fails to page-down accurately, neglects to display certain rows
Summary: NAVIGATION: Calc fails to page-down accurately, neglects to display certain rows
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2018-02-11 00:07 UTC by tagishsimon
Modified: 2018-02-13 15:46 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Simple file exhibiting the pagedown problem (13.69 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-02-11 00:08 UTC, tagishsimon

Note You need to log in before you can comment on or make changes to this bug.
Description tagishsimon 2018-02-11 00:07:07 UTC
I want to page-down through my speadsheet & visually inspect *all* rows. Depending on which row has cursor focus, LibreOffice either does what you'd expect (shows all rows, as a sequence of pages) or does not do what you'd expect (omits to show certain rows).

Referring to the attached file, in full-screen mode on a macbook pro...

if the cursor focus is on row 1 and I page down, I see the following rows as I page down:
169-225 ... i.e. all good - I get to see all rows.

If the cursor focus is on row 20 and I page down, I see rows:
122-168 ... so rows 72-75, and rows 120 & 121 were not displayed. 

That's a *huge* problem for my use case, and evidence that LO cannot do something fairly basic: show spreadsheet contents in full as a series of pages as I page down.

Steps to Reproduce:
1. Open file 'pagedown_problem.ods'
2. Place cursor focus on row 20
3. Page down & observe the row range being displayed for each page
4. (optionally: weep)

Actual Results:  
Several rows are not displayed to the user

Expected Results:
all rows should be displayed to the user

Reproducible: Always

User Profile Reset: No

Additional Info:

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:58.0) Gecko/20100101 Firefox/58.0
Comment 1 tagishsimon 2018-02-11 00:08:00 UTC
Created attachment 139766 [details]
Simple file exhibiting the pagedown problem
Comment 2 Alex Thurgood 2018-02-12 11:43:36 UTC
@taglshslmon : which full screen mode are we talking about here ?
Comment 3 Alex Thurgood 2018-02-12 11:51:04 UTC
OK, I can confirm this in normal windowed mode, i.e. without full screen activation and 

Build ID: 64a0f66915f38c6217de274f0aa8e15618924765
Threads CPU : 4; OS : Mac OS X 10.13.3; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group
Comment 4 tagishsimon 2018-02-12 13:16:52 UTC
Yes, apologies; I thought I'd posted a response but ... 

... by fullscreen I meant 'having hit the green fullscreen button'; the issue is not dependent on that. Having a normal window open arbitrarily sized to display ~33 rows, and with cursor focus on row 20, I page down and see rows:

80-109 <- so here we missed rows 78 & 79.

The key appears to be that the cursor focus is about half-way down a page when the page-downs are done.
Comment 5 Telesto 2018-02-12 19:20:42 UTC Comment hidden (obsolete)
Comment 6 tagishsimon 2018-02-13 14:55:23 UTC Comment hidden (obsolete)
Comment 7 Telesto 2018-02-13 15:35:17 UTC
(In reply to tagishsimon from comment #6)
Sorry, my bad. Anyway, not Mac specific.

Repro with:
Build ID: 8a0b61172a14b8b766a2e85f27762db3558d3af7
CPU threads: 4; OS: Windows 6.3; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-02-06_03:28:54
Locale: nl-NL (nl_NL); Calc: CL
Comment 8 Telesto 2018-02-13 15:46:39 UTC
Repro with
Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Locale: nl_NL

Similar behavior with
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-