Bug 223639

Summary:	Filling cells with Auto-Filter active overwrites hidden rows
Product:	[Applications] calligrasheets	Reporter:	Kde <kde>
Component:	general	Assignee:	Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null>
Status:	CONFIRMED ---
Severity:	normal	CC:	mecirt
Priority:	NOR
Version First Reported In:	unspecified
Target Milestone:	---
Platform:	unspecified
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:

Description Kde 2010-01-21 04:30:56 UTC

Version:           2.1.1 (using 4.3.90 (KDE 4.3.90 (KDE 4.4 RC1)) "release 212", KDE:KDE4:Factory:Desktop / openSUSE_11.1)
Compiler:          gcc
OS:                Linux (x86_64) release 2.6.27.42-0.1-default

To reproduce, create a new spreadsheet, put the following data in the first column:
1
2
1

Turn on Auto-Filter for this column and filter for '1', then overwrite the first row with a new value such as 'x' and use the mouse cursor + drag-down box in the lower right corner to fill up the second visible row with 'x' as well. Now turn off Auto-Filter again and you'll see that all three rows contain an 'x' even though only rows 1 and 3 were modified by the user.

See http://www.youtube.com/watch?v=B7ArppPlckA for the same bug in OpenOffice. So far only Excel does it right.

Comment 1 Kde 2010-01-21 04:33:44 UTC

This was tested in the following version:
Version 2.1.1
Using KDE Development Platform 4.3.90 (KDE 4.3.90 (KDE 4.4 RC1)) "release 212"

Comment 2 Andrew Crouthamel 2018-11-02 23:04:13 UTC

Dear Bug Submitter,

This bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version? I am setting the status to NEEDSINFO pending your response, please change the Status back to REPORTED when you respond.

Thank you for helping us make KDE software even better for everyone!

Comment 3 Andrew Crouthamel 2018-11-16 05:31:12 UTC

Dear Bug Submitter,

This is a reminder that this bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version?

Thank you for helping us make KDE software even better for everyone!

Comment 4 Justin Zobel 2022-12-12 01:55:58 UTC

Thank you for reporting this issue in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the issue with a recent software version?

If you can reproduce the issue, please change the status to "REPORTED" when replying. Thank you!