https://bugs.freedesktop.org/show_bug.cgi?id=61534
Priority: high
Bug ID: 61534
CC: jmadero....@gmail.com
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Calc: Select to block margin is severely broken
Severity: critical
Classification: Unclassified
OS: All
Reporter: crx...@hotmail.com
Hardware: All
Status: UNCONFIRMED
Version: 3.5.7.2 release
Component: Spreadsheet
Product: LibreOffice
"Select to block margin" is a function that is, by default, mapped to
<Control><Shift><ARROW>. It is used frequently in Calc to select large areas
of data for copy/paste. LibreOffice has somehow severely damaged the "Select
to block margin" function in Calc in two ways...
The first problem is extremely easy to see:
* Create a new spreadsheet.
* Place cursor in A1
* Press <Control><Shift><Down>.
The correct behavior would be that the cells from A1 through A1048576 would be
selected and the display would show your cursor on A1048576. Instead, it
selects all those cells but leaves you sitting in cell A1 and without changing
your view at all.
The second problem is much, much worse, and also harder to illustrate:
* Create a new spreadsheet.
* Type a list of labels in the first column for several rows (A1:A4 or so).
For the test, you just need a few, but imagine it could be many thousands.
* Now place your cursor on B1.
* Put a formula in B1 that is =LEN(A1)
* Now use <Control><c> to copy that formula and then move your cursor to B2.
* Now we want to paste it down through the end of the data that exists in
column A. So press and hold <Control><Shift>. While not letting go of
<control><shift>, press <down> then <left> then <up>. Then let go of <Control>
but continue holding <shift> and press <right>, then <enter>.
The above method is a very common way to select areas for copying. But it is
broken the moment the user presses <up> in the last line of the example above.
Imagine if column A had 20,000 rows/cells of data. Without this functionality
working, how would one copy a formula down the correct number of rows in column
B to match the number of rows in column A? With this broken behavior, it could
take hundreds of presses of the <page down> key while holding down <shift>
trying to do what would otherwise take a few keystrokes.
If these two problems are not clear from my description (the second one is hard
to describe) I will try to come up with a sequence of annotated screenshots or
something.
I have tested that this is NOT broken in OpenOffice 3.2.1, nor in 3.4!! But it
is broken in LibreOffice 3.5.7 and 4.0. This is a *HUGE* problem for my users.
Big enough that I think we can't migrate from OpenOffice to LibreOffice and I
just had to halt our rollout. Any serious spreadsheet user needs the ability
to properly/quickly "select blocks to margins" of data.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
