https://bugs.documentfoundation.org/show_bug.cgi?id=149699
Bug ID: 149699
Summary: XLSX CALC FILTER - copying a selected row actually
copying from a different sheet
Product: LibreOffice
Version: 7.2.1.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have an XLSX file opened. It has about 10 tabs/sheets. Only a few hundred
rows per tab. No macros or anything like that.
When I create an autofilter on one tab, filter one of the columns and select
and copy a row, when I paste it, it pastes a row from a tab that I've never
even been to, viewed or copied.
I've used Libre since it's creation. I've never seen this happen before.
But I've been testing all morning and I can recreate it.
This is a file that is part of an NDA. So I can't attach it. However, I am fine
with scheduling a screen sharing session? Just reach out to me. I'm hear to
help in any way possible.
Thanks!
Steps to Reproduce:
1.Open this simple XLSX file
2.Select the tab,
3.Create auto filter
4.Filter one of the columns so many of the rows are hidden
5.Select cells from a row that is visible in the filter
6.Copy
7.Paste into any other Windows program: Gmail, Notepad, etc.
Actual Results:
It pastes a row from a tab/sheet that you've never even viewed, let alone
copied.
Expected Results:
It should paste the correct data.
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Again, I've been using Libre since it was released.
If this was a wide spread issue, the sky would have been falling long ago.
But I am able to reproduce this.
My actual version is 7.2.12. That wasn't one of the options in the version
option box.
--
You are receiving this mail because:
You are the assignee for the bug.
