Bug 143532 - Dragging date with Ctrl and filter bottom-up overwrites invisible values
Summary: Dragging date with Ctrl and filter bottom-up overwrites invisible values
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.4.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Styles
  Show dependency treegraph
 
Reported: 2021-07-25 07:17 UTC by liboffbugz
Modified: 2023-07-28 04:34 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
A sample file where this behavior occurs (9.54 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-07-25 07:21 UTC, liboffbugz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description liboffbugz 2021-07-25 07:17:36 UTC
Description:
Dragging date with Ctrl and filter bottom-up overwrites invisible values.
Dragging date with Ctrl and filter top-down keeps invisible values.

Steps to Reproduce:
1. Start a new Calc-workbook
2. Fill with this content: A1="filter", A2="a", A3="b", A4="a", A5="b", A6="a", B1="date", B2=01.01.2021, B3=02.01.2021, B4=03.01.2021, B5=04.01.2021, B6=05.01.2021
3. Add autofilter at A1/B1
4. Set filter at A1 to "a"
5. Focus B6
6. Drag B6 up to B2
7. Press Ctrl
8. Drop

Actual Results:
In one case the cells B2 to B5 are empty (even the invisible).
In another case (with a more complex workbook) all invisible cells were overwritten with the value from B6.

Expected Results:
Only the visible cells (B2, B4 and B6) contain the dragged value (05.01.2021).


Reproducible: Always


User Profile Reset: No



Additional Info:
The same scenario with dragging A2 down to A6 works as expected.
Comment 1 liboffbugz 2021-07-25 07:21:05 UTC
Created attachment 173827 [details]
A sample file where this behavior occurs
Comment 2 Eleonora Govallo 2021-07-27 21:22:46 UTC
Repro in Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: c5ca46e75e28ba4245d8544ca53c71fea87d1bbd
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: ru-RU (ru_RU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-07-20_00:22:42
Calc: threaded
Comment 3 QA Administrators 2023-07-28 03:16:56 UTC Comment hidden (obsolete)
Comment 4 ady 2023-07-28 03:49:39 UTC
FWIW, this is no repro on Windows, at least since LO 7.2.7.2; in older versions I see there are some problems similar to what is described in comment 0.
Comment 5 liboffbugz 2023-07-28 04:34:45 UTC
In this version, I can't reproduce anymore:

Version: 7.5.4.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 2; OS: Linux 6.2; UI render: default; VCL: x11
Locale: de-DE (en_US.UTF-8); UI: en-US
Ubuntu package version: 4:7.5.4-0ubuntu0.23.04.1
Calc: threaded

Thanks for those who fixed it.