Issue 7269 - PageUp-, PageDown keys should work in print preview
Summary: PageUp-, PageDown keys should work in print preview
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.1
Hardware: All All
: P4 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
URL:
Keywords:
: 9049 63914 (view as issue list)
Depends on:
Blocks:
 
Reported: 2002-08-27 07:24 UTC by deller
Modified: 2013-08-07 15:14 UTC (History)
8 users (show)

See Also:
Issue Type: PATCH
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
7269.patch (1.53 KB, text/plain)
2007-07-09 07:55 UTC, tqfa
no flags Details
7269.patch (1.25 KB, text/plain)
2007-07-10 03:07 UTC, tqfa
no flags Details
7269.patch (1.49 KB, text/plain)
2007-07-11 03:14 UTC, tqfa
no flags Details
7269.patch (1.74 KB, text/plain)
2007-07-12 09:42 UTC, tqfa
no flags Details
7269.patch (1.64 KB, text/plain)
2007-07-13 07:50 UTC, tqfa
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description deller 2002-08-27 07:24:03 UTC
During a print preview of a spreadsheet, the PageUp- and PageDown keys  
should jump to the previous or next page. This can currently only be done 
with the mouse. 
Thanks.
Comment 1 peter.junge 2002-11-28 15:18:24 UTC
OOPS,
looks like we really forgot this one.

@Frank: Would be nice for the accessibility project.
Peter
Comment 2 frank.loehmann 2002-11-29 08:14:14 UTC
.
Comment 3 frank.loehmann 2003-02-10 16:14:04 UTC
Shortcut is already present: Ctrl+Page Up/Down
Page up and down are needed for "scrolling" the doc, if the zoom 
level is higher.
Comment 4 peter.junge 2003-02-10 16:25:21 UTC
Hi,

Frank is right. I have to close it as works for me.

best regards, Peter
Comment 5 peter.junge 2003-02-10 16:25:43 UTC
WFM -> Closed
Comment 6 deller 2003-02-10 21:34:05 UTC
Hi,  
  
Great, Thanks !  
It really works as you describe with CNTRL-PageUP/Down !  
  
But nevertheless, I would like to reopen this bug, since I think this is not  
a very intuitive behaviour.  
As a user you expect KSpread to show the next page if you press PageDown.  
If I'm on a high zoom-level and see the first half of a page, everyone normally  
press the PageDown key to see the second half. That works great, but why shouldn't I  
press the PageDown key again to display the upper part of the following page.  
Instead I now have to press Control-PageDown ?!?  Why ? A normal user would  
never think about pressing Control-PageDown.  
  
Just my thoughts....  
  
Regards,  
Helge  
Comment 7 deller 2003-02-10 21:35:20 UTC
Sorry, of course I meant OpenOffice.org Calc, not KSpread. 
Comment 8 peter.junge 2003-02-11 10:40:35 UTC
@Frank: I find Helge's suggestion quite good. The behaviour should
IMHO be:
PgUp/PgDn -> Scroll continiously through the preview
Ctrl + PgUp/PgDn -> Scroll to top of next/previous page
I guess that's also the way nearly anybody else does it. ;-)

I lowered Priority and target a little bit because the function works
in general.

Best regards, Peter
Comment 9 frank.loehmann 2003-02-12 16:03:10 UTC
I suggest that Matthias should take a look a this. 
FL->MMP: Please decide if this sounds reasonable, because if we 
would do this as suggested by Helge, we have to change more than 
this single implementation.
Comment 10 matthias.mueller-prove 2003-02-17 09:05:28 UTC
started
Comment 11 Unknown 2003-04-24 06:13:05 UTC
Yes, Frank, what Helge suggested is not only reasonable, but also
intuitive and expected.

Roman
Comment 12 oc 2003-08-08 14:04:17 UTC
*** Issue 9049 has been marked as a duplicate of this issue. ***
Comment 13 matthias.mueller-prove 2003-09-19 13:50:35 UTC
MMP>FL: Hi Frank,
from my point of view it is recommended to have the same set of
shortcuts in all print previews (Writer, Calc, etc.). Page up/down
should flip the pages, instead of just paning to the top and bottom of
a page in zoom mode -- as in Calc 1.1.  
Comment 14 frank.loehmann 2004-04-07 19:23:02 UTC
FL->NN: Writer already switches pages (page sets) if the bottom of the current
page was already reached. Please change this for Calc in the same way. Page
Up/Down move the current visible document preview and if the page border is
reached/is already visible the page preview will be switched to the beginning of
the next page. (Please keep current Ctrl+Page Up/Down in addition)
Comment 15 Martin Hollmichel 2004-05-28 15:01:05 UTC
according to the announcement on releases
(http://www.openoffice.org/servlets/ReadMsg?list=releases&msgNo=7503) this issue
will be re-targeted to OOo Later.
Comment 16 graysonking 2006-02-11 20:47:49 UTC
even better if arrow keys work as well as pageup/pagedown.  i.e. arrowleft or
arrowup or pageup skips to previous page, and arrowright or arrowdown or
pagedown skips to next page.  also, home and end keys should skip to first and
last page respectively.
Comment 17 drensink 2006-04-03 01:57:53 UTC
*** Issue 63914 has been marked as a duplicate of this issue. ***
Comment 18 kpalagin 2006-08-16 11:55:57 UTC
2.0 is released. Would it be possible to retarget the issue for earlier 
than "OOo later" and make Calc's scrolling behavior in Preview consistent with 
that of Writer (where PageUp/PageDn and mouse wheel scrolling work)?
Otherwise it is confusing to the user.
Thanks a lot.
WBR,
K. Palagin.
Comment 19 tqfa 2007-07-09 07:55:51 UTC
Created attachment 46628 [details]
7269.patch
Comment 20 tqfa 2007-07-10 03:07:27 UTC
Created attachment 46665 [details]
7269.patch
Comment 21 ooo 2007-07-10 11:16:30 UTC
Ah, already wondered about the other modifications around the changed lines..
Yes, that approach seems to be viable. Did you verify in your build that it
works as intended?

Btw, some words on style:

In naming conventions, for pointers we use the prefix 'p', so instead of
SfxViewFrame* aSfxViewFrame
it should read
SfxViewFrame* pSfxViewFrame
The 'a' prefix is used for instances of objects.

For new code please use spaces (indenting to 4) instead of tabs. The old
aCurPos.Y() -= nVPage;
respectively
aCurPos.Y() += nVPage;
statements should be indented accordingly to properly align with the new if/else
code for readability.
For correct indenting please ensure that your editor displays tabs with an
indenting equivalent to 4 spaces for legacy code.

Thanks
  Eike
Comment 22 tqfa 2007-07-11 02:55:05 UTC
hi er!

  Yes,OK,I am sorry!

Because I am used to use "a" instead of the anything.
I will give up this bad habit.
Thanks for your suggestion.
I builded it in my work.and I will commit a new patch to OOo.

I hope you give me some suggestion.

Best wishes for you!

Tangquanfa
Comment 23 tqfa 2007-07-11 03:14:58 UTC
Created attachment 46684 [details]
7269.patch
Comment 24 ooo 2007-07-11 21:56:29 UTC
Hi Tang,

The patch goes into the right direction and works for slightly zoomed-in
pages, but there are some issues with it:

1. If the page displayed fits into the preview area and no scrolling is
   possible, the PgUp/PgDn keys have no effect. In this case the
   previous/next page should be displayed.

2. If the page is zoomed-in, pressing PgUp at the top of the first page
   jumps to the bottom of that page. Similar, pressing PgDn at the
   bottom of the last page jumps to the top of that page. Instead, no
   action should be performed in both cases.

3. In a large zoom where the page is wider than the preview area, moving
   up with PgUp jumps to the bottom/right corner of the previous page
   when the page boundary is crossed. Similar, when the page is scrolled
   to the right, moving down with PgDn jumps to the top/left corner of
   the next page when the page boundary is crossed. In both cases the
   relative X offset should be kept, similar to how it is done if the
   Previous Page / Next Page buttons are clicked respectively
   Ctrl+PgUp/PgDn are pressed.

Thanks
  Eike
Comment 25 tqfa 2007-07-12 09:42:55 UTC
Created attachment 46714 [details]
7269.patch
Comment 26 tqfa 2007-07-12 09:43:33 UTC
hi er!

  Thank you very much for your advice!
  But I don't agree with the third case. Because when the user press down 
PgDn , the top/left 

corner content on the next page should be in sight of the user.So,when the user 
press down 

PgUp , the bottom/right  corner content on the previous page should be in sight 
of the user.I 

think.

I have been improved my code about the other case.

Please focus my latest patch.

I hope you give me some suggestion.

Best wishes for you!

Tangquanfa
Comment 27 ooo 2007-07-12 13:05:20 UTC
@fl: Frank, could you please add your valuable 2 cents from the User
Experience's point of view what the user might expect when crossing the page
boundary in a zoomed-in view:

Should the horizontal position of the page been kept, thus paging vertically
through the document? Or should the view jump to the bottom-right respectively
top-left, depending on the direction the user is scrolling?

See point 3 of my comment #desc25 above.

Thanks
  Eike
Comment 28 frank.loehmann 2007-07-12 15:00:54 UTC
FL->ER: I have discussed this with NN, TBE and FST today. We came to the
conclusion that the horizontal position must not be changed.
Comment 29 tqfa 2007-07-13 07:50:10 UTC
Created attachment 46740 [details]
7269.patch
Comment 30 stx123 2007-07-13 08:54:51 UTC
It seems we should reconsider the target...
Comment 31 ooo 2007-07-16 14:42:47 UTC
Great, this looks good and behaves correct.

Will have to find out whether this could still make it into OOo2.3 after feature
freeze. It's not a real feature, but a small enhancement and would require a
changes announcement anyway and as such usually counts for feature freeze.
Cc'ing 'mh' for this.

@Martin: any opinion? Do we want to pick this up for OOo2.3?

Thanks
  Eike
Comment 32 kpalagin 2007-07-24 11:58:39 UTC
So what is the decision?
Comment 33 Martin Hollmichel 2007-07-24 12:49:05 UTC
set target to next feature release 2.4.
Comment 34 niklas.nebel 2007-08-31 17:43:07 UTC
I added one small change to make sure the pages of all sheets are counted, and
committed the patch on CWS "calc44" (for OOo 2.4).
Changed: prevwsh.cxx 1.37.62.1
Comment 35 kpalagin 2007-08-31 20:59:43 UTC
tqfa, nn,
thank you very much!
Comment 36 niklas.nebel 2007-09-18 13:54:11 UTC
Reassigning to QA for verification.
Comment 37 frank 2007-09-26 12:15:00 UTC
found fixed on cws calc44 using Solaris, Linux and Windows build
Comment 38 frank 2007-12-14 10:52:12 UTC
found integrated on master m239 using Linux, Solaris and Windows build
Comment 39 frank 2007-12-14 10:57:41 UTC
closed