https://bugs.documentfoundation.org/show_bug.cgi?id=167807
Bug ID: 167807
Summary: Proposal: Different semantics for autofill & paste for
Grouping (F12) vs Hiding (context menu)
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
This proposal is an alternative solution for allowing autofill to work with
hidden rows/columns, in context of the renewed recent discussion in:
https://bugs.documentfoundation.org/show_bug.cgi?id=56799,
https://bugs.documentfoundation.org/show_bug.cgi?id=85170,
https://bugs.documentfoundation.org/show_bug.cgi?id=137774
In particular, in bug 85170, the proposal is for adding a warning when autofill
overwrites content in hidden rows/cols,
but here I'd like to suggest an alternative, to see what people think:
* Grouping (F12) - for hide out of view only; but any copy paste over, and any
autofill operations with/over those hidden rows/cols to be allowed.
* Hiding (from context menu) - for hiding the hidden rows/cols not only from
view, but also from any autofill actions; also, by extension, from pasting over
them.
Potential Advantages:
- different people will use one vs the other for different needs
- if the are other actions, besides autofill, that need "hidden" rows/ cols to
not be touched, then it can use Hide ; maybe "filtered" rows/cols?
(I'm not sure, I don't use it much)
- Hiding for excepting from autofill agrees with the name "Hide" suggesting a
real hiding (from computations) , not just grouping
- Given that Hidden (via Hide) rows/cols are more prone to be forgotten about
than Grouping, it fits that they will never be (accidentally?) overwritten by
autofill ( or paste)
- no need for extra warning at working with "hidden" cells, given that people
will learn about this distinction and come to expect that autofill touches
Grouped cells
Potential Disadvantages:
- some people may have already the expectation that Grouped rows/cols are not
supposed to be touched by autofill actions either.
But: Excel, G.Sheets allow autofill actions over/involving hidden/grouped
rows/cols, thus the set of people being too surprised should not be relatively
big.
Steps to Reproduce:
NA
Actual Results:
NA
Expected Results:
NA
Reproducible: Always
User Profile Reset: No
Additional Info:
NA
--
You are receiving this mail because:
You are the assignee for the bug.
