Description: On filtered list an autofill upwards erases data in target-fields. Downwards is OK. If the neighbourcells upside without filter are equal, the fillfunktion is ok. This Bug exists on Libre for Windows and Linux. Tested altough on Vers.5.1.6.2 ..5.4.3.2 Steps to Reproduce: 1.switch on autofilter 2.take the autofiller and pull it upwards 3. Actual Results: the upwards cells are erased instaed of decrease value Expected Results: libre works normal Reproducible: Always User Profile Reset: Yes Additional Info: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:56.0) Gecko/20100101 Firefox/56.0
(In reply to August Koch from comment #0) What do you mean by "autofilter" here? Do you mean auto-fill? Could you please provide a screenshot to show the bug? If you mean autofill, I do not reproduce under Fedora 26 x64.
(In reply to Kevin Suo from comment #1) > (In reply to August Koch from comment #0) > What do you mean by "autofilter" here? Do you mean auto-fill? Could you > please provide a screenshot to show the bug? > > If you mean autofill, I do not reproduce under Fedora 26 x64. Then August needs to attach an example file. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
Created attachment 137778 [details] Example file For some reason the reporter emailed me personally with this file and information. 1- filter the "Data-2" to "test1" 2- Put with mousepointer for Example "C5" on the lower right edge and pull it down to "C11" - The Result is OK - in Cell "C8" and "C11" is now the Value "d". 3- Put with mousepointer on "C11" on the lower right edge and pull it up to "C5" - the Result are BLANK Cells in "C8" and "C5"
I reproduce with the steps. Not happening in 3.6.7 Arch Linux 64-bit Version: 6.0.0.0.alpha1+ Build ID: 17cfe6e25d479428de308c22fcd218dcf8827840 CPU threads: 8; OS: Linux 4.13; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on November 15th 2017 Arch Linux 64-bit Version 3.6.7.2 (Build ID: e183d5b)
This seems to have begun at the below commit. Adding Cc: to Kohei Yoshida ; Could you possibly take a look at this one? Thanks 21e84025ea8a7c6a95fd2616711226def03cbd07 is the first bad commit commit 21e84025ea8a7c6a95fd2616711226def03cbd07 Author: Matthew Francis <mjay.francis@gmail.com> Date: Thu May 28 18:47:06 2015 +0800 source-hash-a995462e6855061816c6529c366f20ace2b45868 commit a995462e6855061816c6529c366f20ace2b45868 Author: Kohei Yoshida <kohei.yoshida@collabora.com> AuthorDate: Fri Jan 31 18:05:05 2014 -0500 Commit: Kohei Yoshida <kohei.yoshida@collabora.com> CommitDate: Fri Jan 31 18:06:07 2014 -0500 Take advantage of segment-based hidden flag storage. To avoid querying this states for every single column and row.
*** Bug 119957 has been marked as a duplicate of this bug. ***
Dear August Koch, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
the bug is still present Verze: 6.4.0.0.alpha0+ (x64) ID sestavení: 758516295e5f69393bd78bb4af6e7214d48ece0b Vlákna CPU: 4; OS: Windows 6.3 Build 9600; Vykreslování UI: výchozí; VCL: win; Národní prostředí: cs-CZ (cs_CZ); Jazyk UI: cs-CZ Calc: CL
I can still reproduce with: Version: 7.2.0.0.alpha1+ / LibreOffice Community Build ID: 774be6d793203183fe1856ffb8b720f00b48c2bb CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-06-03_19:22:06 Calc: threaded
Removing bug 119957 from duplicates because LO always (since at least 3.5) erased the contents of the hidden cells during the upward autofill. This bug is particularly about NOT filling the visible cells, so we'll leave the other bug to cover the hidden cell aspect.
Justin Luth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/618084819babc839510860b74b36631749093c4c tdf#113785 sc FillAutoSimple: also optimize in negative direction It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Justin Luth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/bda200a5e9c4592bd61b7924fa171ec3265bfd24 tdf#113785 sc: IsDataFiltered must be normalized It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 1c0aa970650ffc7c749e0b5ea655ebb2d137c8ae CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: es-ES (es_ES.UTF-8); UI: en-US Calc: threaded @Justin, thanks for fixing this issue!!
Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-7-3": https://git.libreoffice.org/core/commit/f3035cdb6a8d3ef56180640ef9d04031012250b9 tdf#113785 sc FillAutoSimple: also optimize in negative direction It will be available in 7.3.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-7-3": https://git.libreoffice.org/core/commit/35302c773ab352f2a9681839c6c11c67d765fbe8 tdf#113785 sc: IsDataFiltered must be normalized It will be available in 7.3.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/99191703b528d8d7b0b9c5d84d76a6fdebbf5191 tdf#113785 sc FillAutoSimple: also optimize in negative direction It will be available in 7.2.6. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/0b59601e415d186565278289e4d3613f727ef75c tdf#113785 sc: IsDataFiltered must be normalized It will be available in 7.2.6. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.