https://bugs.documentfoundation.org/show_bug.cgi?id=96344

Aron Budea <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Priority|medium                      |low
             Status|UNCONFIRMED                 |NEW
            Version|4.3.3.2 release             |4.3.0.4 release
           Keywords|                            |implementationError
                 CC|                            |[email protected]
     Ever confirmed|0                           |1
            Summary|FILTER - Bad count of items |Count of selected and
                   |in status bar and DCOUNT    |copied items is
                   |counting items in list      |inconsistent if there are
                   |                            |hidden rows/columns
           Severity|normal                      |trivial
                 OS|Linux (All)                 |All

--- Comment #9 from Aron Budea <[email protected]> ---
I also think this is an inconsistency, but not sure how it could be resolved to
always be straightforward.
Normally selecting a range includes all elements in the range (so row 554-604
is indeed 51 rows). And logically they're still selected, even if some of the
rows are hidden (that's why if you select these rows, then right click the
hidden part and click Show Rows, the additional rows will be included in the
selection). Why they aren't copied... probably because of practical reasons.

An alternative way of selection is holding Ctrl and clicking individual fields,
in this case if the selection is not continuous, the text in the status bar
disappears.
Note: if fields around the hidden rows are selected this way, right click +
Show Rows doesn't work anymore, this might be a bug.

Alternative 1:
Text in status bar should reflect the number of currently selected and visible
(eg. copied) rows and columns, and should update if rows/columns are hidden or
shown.

Alternative 2:
Text in status bar should reflect the number of currently selected and visible
(eg. copied) rows and columns, and the selection should not change if
rows/column are hidden or shown.

Alternative 3:
Text in status bar should reflect the number of currently selected rows and
columns, but the hidden rows/columns should be added in parentheses.
For example: "51 rows (31 hidden), 1 columns selected"

There could be further ideas, these are the ones that came to my mind.
Based on the above, setting status to NEW, and since it has minimal effect on
professional work, adjusting importance to low/trivial.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to