Steps how to reproduce with server installation of Version: 220.127.116.11.alpha0+
Build ID: 2e3b0c5d42d60d46cd9f8b8eda9424b095c63418; Windows 6.1:
0. Create a minimum Spreadsheet with single column containing values 1, 2, 3
1. ˋClick → Rightclick on row heading for row containing "2" → Hide rowˊ
» row disappears
2. ˋRightclick on Cell containing "1" → Copyˊ
3. Select / Mark Cells containing numbers "1" and "3" using mouse pointer
» Both cells highlighted
4. ˋRightclick Cell containing "3" → Pasteˊ
» Both cells show "1"
5. Select both rows containing "1" by selecting both row headings using mouse
» both rows highlighted
6. ˋRightclick one of the highlighted page headers → showˊ
» hidden row appears
Expected: column shows 1, 2, 1
Actual: column shows 1, 1, 1 😥
Similar problem has been fixed for Bug 35345 - Cells hidden with filters get changed
I can't see any reason why there should be different behavior between rows hidden by filter and rows hidden by 'Hide'
i can confirm this behaviour, but isn't it the same like excel 2016 does?
(In reply to Oliver Brinzing from comment #1)
May be, but I consider that behavior as a bug. It is completely unexpected that hidden cells become modified (sometimes and sometimes not).
This was a request. It's not behavior that should be confirmed, but change. So it was wrongfully confirmed without UXeval.
My opinion is that this should not be accepted. Hidden is not the same as filtered out.
Solution is to have *an option* not to select hidden cells i.e. to select visible cells only but that's bug 36466. I'll mark this one a a duplicate.
There's the extension https://extensions.libreoffice.org/extensions/copy-only-visible-cells but it's logic is also not complete, it copies visible cells but it should instead just select visible cells. Copying to or from can than be done as usual.
*** This bug has been marked as a duplicate of bug 36466 ***
(In reply to Timur from comment #3)
> Solution is to have *an option* not to select hidden cells...
Accepted. Removing UX again since this does not need discussion.
Real Life User Scenario for this decision is missing. I can't imagine any reason why hidden cells (does not matter hidden by what operation should) be modified.
Tired with this.
(In reply to Rainer Bielefeld Retired from comment #5)
> Tired with this.
Don't be. We have both situations the one where users are not aware of hidden cells and overriding or not is awkward and the opposite when they expect a particular behaviour. Isn't the best solution to make them aware of this?