Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


Hi,

There's another help-related bug waiting for attention. The request is this:

"@David:
Help for this under "Shortcut Keys for Spreadsheets" is not very precise. For
'Ctrl+Down Arrow' I read: "Moves the cursor to the bottom edge of the current
data range" . What ever "THE" current data range might be. I believe it means
"Moves the cursor to the last row containing data below the current cursor
position or marked cell row"
Additionally all those details I found out nowhere are mentioned , I believe
that should be improved in Help and Manual."

--
David Nelson


---------- Forwarded message ----------
From:  <bugzilla-daemon@freedesktop.org>
Date: Sat, Nov 5, 2011 at 21:07
Subject: [Bug 39212] Loss of OpenOffice default behavior for copying
formulas EDITING
To: commerce@traduction.biz


https://bugs.freedesktop.org/show_bug.cgi?id=39212

Rainer Bielefeld <LibreOffice@bielefeldundbuss.de> changed:

          What    |Removed                     |Added
----------------------------------------------------------------------------
          Severity|major                       |minor
        AssignedTo|libreoffice-bugs@lists.free |kohei.yoshida@gmail.com
                  |desktop.org                 |
                CC|                            |commerce@traduction.biz,
                  |                            |LibreOffice@bielefeldundbus
                  |                            |s.de

--- Comment #6 from Lorieul <gaborytime@gmail.com> 2011-10-21 08:50:35 PDT ---
@Cor Nouws
Does "." in your last comment (2011-10-14 08:40:24 PDT) means the bug was
solved ?
The bug status is still "NEW" isn't it ?
Or does it mean enough information has been collected and no more comment
should be added ?

--- Comment #7 from Rainer Bielefeld <LibreOffice@bielefeldundbuss.de>
2011-11-05 12:07:57 PDT ---
Reported effects are more or less reproducible with "LibreOffice 3.4.4RC2  -
WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:402)]".

We have a changed behavior in 3.4 compared to 3.3 (an OOo), but I doubt that
it's a bug.

I compared behavior of this version, OOo 3.1.1, "LibreOffice Portable 3.3.0  -
WIN7  Home Premium (64bit) German UI [OOO330m19 (Build:6 Tag 3.3.0.4)]", Server
installation of Master "LibO-dev 3.5.0 – WIN7 Home Premium (64bit) English UI
[(Build ID:  d3d1481-3f8994a-2ba0a9f)]" (110909). Master seems to behave as
3.4.

The first test with OOo 3.1.1


a) Tests with OOo, Steps to reproduce:

0. Preparations: Open new spreadsheet, type an "x" to A10, B11, C12, E14, F5,
F6

11. Click A1
12. <Shift+4x-arrowright>
  (A1:A5 highlighted)
13. <Control+arrowdown>
  Cursor jumps to E14, what SEEMS in accordance with Help for that version:
   "...Moves the cursor to the bottom of the current data range". E14 is the
   most bottom cell containing data, empty column D will be ignored, what
   is a good solution, a jump to the bottom of the table is useless

14. Redo from 1, but with selected A1:F1
  Now cursor will move to F5, that's not something with "Data Range", but
  simply the FIRST next cell containing Data below cursor. I would have
  expected cursor jumping to F14 of at least F5

New test with OOo 3.1.1
21. Click A1
22. <Shift+4x-arrowright>
  (A1:A5 highlighted)
23. <Shift+Control+arrowdown>   Instep 3 marked range A1:E14,
  Cursor jumps to E14, A1:E14 selcted / highlighted, Cell Cursor E14
  what SEEMS in accordance with Help for that version:
   "...Moves the cursor to the end of the current data range containig data".
   E14 is the
   most bottom cell containing data, empty column D will be ignored, what
   is a good solution, a jump to the bottom of the table is useless

24. Redo from 21, but with selected F1:A1
   F1:A10 will become marked, I would have expected F1:A14, because Row 14 is
   the last one containing data.

New test with OOo 3.1.1
31. Click E1
32.  <Shift+4x-arrowleft>
  (A5:A1 highlighted)
33. <Control+arrowdown>
   Cursor Jumps to 'A10'. I would have expected A14 (Data Range), but cursor
   simply jumps to the next cell containing data.
34. Redo from 31, but with selected F1:A1
   F1:A10 will become marked, I would have expected F1:A14, because Row 14 is
   the last one containing data. But not unexpeced after 21ff



b) LibO 3.3.3
b1) Tests 11ff
b1a)  In step 13 jumps to A14: SEEMS Correct "End of range", but why column A?
b1b   In step 14 jumps to A5, means target column = where range started in
     step 11
     target Row = the one of cell cursor position

b2) Tests 21ff
b2a) In step 23 marked range A1:E14, expected after b1, Cell cursor A1
b2b) Step 24 marked A1F5, expected after b1, b2a

b3) Tests 31ff
b3a) In step 33 marked range A1:E14, expected after b1, Cell cursor A1
b3b) Step 34 marked A1F10, expected after tests b

c) LibO 3.4.4
c1) Tests 11ff
c1a)  In step 13 jumps to A10: Here Target row is defined in start range
     column, not in end range column, behavior different to OOo, LibO333
c1b   In step 14 jumps to A10,  Here Target row is defined in start range
     column, not in end range column, behavior different to OOo, LibO333
     target Row = the one of cell cursor position

c2) Tests 21ff
c2a) In step 23 marked range A1:E10, expected after c1, Cell cursor A1
c2b) Step 24 marked A1F10, expected after c1,
    behavior different to OOo, LibO333

c3) Tests 31ff
c3a) In step 33 marked range A1:E14, expected after b1, Cell cursor A1
    behavior different to OOo, LibO333
c3b) Step 34 marked A1:F5, expected after tests c
    behavior different to OOo, LibO333


My conclusions
--------------

OOo3.1.1
<Control+arrow> always reaches the next cell with contents in arrow direction
from the current Cell Cursor. Useful in many cases, but IMHO not really
consequent.

LibO 3.3.3
<Control+arrow> always reaches the next cell with contents in arrow direction
from the current Cell Cursor (as OOo).
For Down-Example reached Column differs from OOo, not below cell cursor, but
below begin of marked start range.
Useful in many cases, but IMHO not really consequent.

LibO 3.3.4
<Control+arrow> always reaches the next cell with contents in arrow direction
from the START OF MARKED CELL RANGE. Differs from OOo and LibO333
For Down-Example reached Column differs from OOo, not below cell cursor, but
below begin of marked start range.

IMHO hehavior is not consistent in all cases

I would prefer
a solution that for our <Control+Arrowdown> Example, the most bottom line with
contents will be reached


@Lorieul
In OOo Bugzilla it was not possible only to add oneself to CC, it was necessary
to write a comment. Most of us have been used to comment a simple dot if
nothing was to say.

@Rmax
Instead of mournful "EXCEL slavery" comments you should write down exact
descriptions of your observation. "No longer works" is not a good description.
Knowing all that behavior it's easy to find workarounds for your needs, for
example
40. goto B2, <control+c>
41. <Control+Arrowdown> from A1 to A100
42. <arrowright> reaches B1000
43. <shift+control+arrowup> marks B1000:B1
44. <control+click> unselects B1 (not necessary)
45. <control+v> will paste formulas to B2:B1000.
   A little more work than with LibO333, but not terrible

50. or simpliy use the scroll slider? Mark and fill down?Faster and more secure
than all other soulutions.

60. or if you do not want to use the mouse:
61.  goto B2, <control+c>
62. <Control+Arrowdown> from A1 to A1000
63. <arrowright> reaches B1000
64. <shift+control+arrowup> marks B1000:B1
64. <shift+arrowdown>  unselects B1 (not necessary)
65. <control+v> wil paste formulas to B2:B1000.

Comparing number of all key press key release actions between LibO 3.3.3 and
LibO 3.4.4 for your example (ontil past completed with<cnotrl+v> :
333: 14
344: 16
That seems not completely inacceptable


@David:
Help for this under "Shortcut Keys for Spreadsheets" is not very precise. For
'Ctrl+Down Arrow' I read: "Moves the cursor to the bottom edge of the current
data range" . What ever "THE" current data range might be. I believe it means
"Moves the cursor to the last row containing data below the current cursor
position or marked cell row"
Additionally all those details I found out nowhere are mentioned , I believe
that should be improved in Help and Manual.

@Kohei:
I can't see any reason for urgent action, but currently I believe consistence
is not optimum. But of course, there might be lots of cases for other use I did
not examine until now?!

--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

-- 
Unsubscribe instructions: E-mail to documentation+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.