[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 Katie Chan changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Assignee|libreoffice-b...@lists.free |k...@ktchan.info |desktop.org | Ever confirmed|1 |0 --- Comment #21 from Katie Chan --- Created attachment 178177 --> https://bugs.documentfoundation.org/attachment.cgi?id=178177&action=edit LibreOffice Calc Sort Behaviour comparison When a subset of cells are sorted by the same criteria, a user should expect to see the same result in the user selected subset of cells compared to the result of having the superset of cells sorted. If the sort range include at least one cell with user entered characters in a column when "Include formats" is selected in the Options, everything in that row are moved by the sort including any formatting such as cell colour in an otherwise empty cell. This was the behaviour in 4.2.8 and earlier. And in fact, this is also the behaviour where the formatting only row is NOT the left-most or right-most column selected. Where the formatting only row is left most or right most, that left-most or right-most column with formatting only is not sorted along with the rest of the selected range. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 Jean-Baptiste Faure changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #20 from Jean-Baptiste Faure --- Well, Calc does not think, it does what the commands chosen by the user are programmed to do. Please, add a screen copy of what you expect when you sort the range A10:D20 of your test file. Status has been set to NEEDINFO, please set it back to UNCONFIRMED once requested information has been provided. Best regards. JBF -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 Buovjaga changed: What|Removed |Added Status|REOPENED|NEW -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 Katie Chan changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|WORKSFORME |--- --- Comment #19 from Katie Chan --- It was still open because the regression in behaviour going from 4.2.8 to 4.3.5 remains. Using the attachment from comment #2, previously if you sort A10 to D20 by "Column B", Calc does not decide to only worry about A10:C20 because it doesn't think there's any content in D10:D20. On the basis of consistency in behaviour, sort should not return differently if you select A1:D20 compared to a the fewer rows but same columns A10:D20. Formatting such as colour is data. The program is optimising where it shouldn't. "Include formats" does not solve this issue. Selected, Sort is moving the formating (such as colour) with the rest of the content of the cell, but that's after it has reduced what it is sorting (and hence moving) from A10:D20 to A10:C20 because it think there's no content including any formatting despite the colour. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 Jean-Baptiste Faure changed: What|Removed |Added Resolution|--- |WORKSFORME Status|NEW |RESOLVED CC||jbfa...@libreoffice.org --- Comment #18 from Jean-Baptiste Faure --- I don't understand why this bug report is still open when it has been indicated (comment #12) that the sort option "Include formats" allows to take into account empty cells with format. So closing as WorksForMe. If you do not agree, please argue why you think the sort option "Include formats" do not allow to make the sorting working as expected. Best regards. JBF -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 --- Comment #17 from Jürgen Kirsten --- Hello everyone, I also noticed this bug and was planning to publish it here. During the search I noticed this case here. When optimising the sorting area, it is not only reduced at the end of the area with empty columns, but also at the beginning. Also, the same behaviour when sorting in columns. Excel and Google Spreadsheets do it "right". Meanwhile, two sort-options have been created: - Include boundary column(s) containing only comments - Include boundary column(s) containing only images You could add another option for the boundary column(s) containing only formatting. You could also combine it with the comments option. So: - Include boundary column(s) containing only comments or formatting This would then also solve the problem of compatibility with previous versions. Have fun programming. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 --- Comment #16 from b. --- there are some 'targets' for calc, performance, usability, 'understandability', 'standard', respect the manual?, and often mentioned compatibility - to ex$el, (compatibility to prior versions is also important, but would block any changes except additions) at least ex$el compatibility is missed with the current behaviour, ex$el 2010 treats empty cells - with formatting! - selected either by selection or by 'all' as part of the range to work on and re-arranges them together with the others, keeping 'row-integrity', 'column integrity' (when sorting left to right), or 'dataset integrity', i had no chance to check if cells without any attributes are reordered, but there is no big difference if they are sorted or not, -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 Robert Lacroix changed: What|Removed |Added CC||pp.l...@tiscali.it --- Comment #15 from Robert Lacroix --- *** Bug 107779 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 --- Comment #14 from Katie Chan --- Yes, the bug/regression is still around. Version: 6.3.0.4 (x64) Build ID: 057fc023c990d676a43019934386b85b21a9ee99 CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win; Locale: en-GB (en_GB); UI-Language: en-US Calc: CL -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 --- Comment #13 from QA Administrators --- Dear Katie Chan, 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 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 --- Comment #12 from Eike Rathke --- If there is no data (only empty cells) in the rightmost column(s) then those columns are entirely omitted from the sort operation (for cases where users select whole rows or other ranges that include more columns than actually filled to prevent unnecessary reordering of only empty cells). Looks like this shrinking can not be done if Sort Option "Include formats" is activated and formatting is present in those otherwise empty ranges. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 andrehe changed: What|Removed |Added CC||ahpub...@gmx.net --- Comment #11 from andrehe --- I suggest that sort has been optimized to not reorder empty cells, and a cell with only formatting is considered to be an empty cell which is the problem. The example shows that formatting is not forgotten during reordering, just that this step is skipped with a cell lacking content. I can reproduce it as explained in comment 2 for the following versions: Version: 6.0.3.2 Build ID: 1:6.0.3-0ubuntu1 CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); Calc: group Version: 6.0.5.2 Build ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16 CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk2; Locale: en-US (en_US.UTF-8); Calc: CL Version: 6.1.0.2 Build ID: b3972dcf1284967612d5ee04fea9d15bcf0cc106 CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk2; Locale: en-US (en_US.UTF-8); Calc: CL Version: 6.2.0.0.alpha0+ Build ID: 5a7d18e432571fb1e9b2cd54d6168353d25c6f19 CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk2; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-07-26_22:07:10 Locale: en-US (en_US.UTF-8); Calc: CL Version: 5.4.7.2 Build ID: c838ef25c16710f8838b1faec480ebba495259d0 CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk2; Locale: en-US (en_US.UTF-8); Calc: CL Version: 5.0.6.3 Build ID: 490fc03b25318460cfc54456516ea2519c11d1aa Locale: en-US (en_US.UTF-8) Version: 5.0.0.5 => main window does not open, cannot test Version: 4.4.7.2 => main window does not open, cannot test -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 --- Comment #10 from Xavier Van Wijmeersch --- I can reproduce it as explained in comment 2 Version: 5.4.3.0.0+ Build ID: 8d6dd32d58494cc21c32bc3c4798fdd4593bde08 CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group and Version: 6.0.0.0.alpha0+ Build ID: 19910c461230f70bb9e98ad44db3525f0d755724 CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 --- Comment #9 from Xisco Faulí --- ** Please read this message in its entirety before responding ** 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 on a currently supported version of LibreOffice (5.4.1 or 5.3.6 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) 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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170929 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 Matthew Francis changed: What|Removed |Added Keywords||bisected CC||er...@redhat.com, ||fdb...@neosheffield.co.uk --- Comment #6 from Matthew Francis --- This seems to have begun at the below commit. Adding Cc: to er...@redhat.com; Could you possibly take a look at this one? Thanks commit 1e4235f8b2dc693b0fb1edade9db25a631bdbf94 Author: Eike Rathke AuthorDate: Fri Dec 5 18:36:03 2014 +0100 Commit: Eike Rathke CommitDate: Fri Dec 5 19:06:29 2014 +0100 actually use identical code for both byRow and byCol, fdo#81501 follow-up Change-Id: I982e03a12dd80be0787f22dce4495065775e7de0 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.documentfoundation.org/show_bug.cgi?id=88002 Michael Weghorn changed: What|Removed |Added CC||m.wegh...@posteo.de Hardware|x86-64 (AMD64) |All Whiteboard|bibisectRequest |bibisected OS|Windows (All) |All --- Comment #5 from Michael Weghorn --- bibisect result: 9926afee22c71ba349b8b643ca984a2635156bc0 is the first bad commit commit 9926afee22c71ba349b8b643ca984a2635156bc0 Author: Miklos Vajna Date: Sat Dec 6 07:51:11 2014 +0100 2014-12-06: source-hash-d0894ff58fbdd823273bc91939801971b7a03182 :100644 100644 b77b245ad79f2a67c5607a7c856e2210fb11dc4d e822b31ac888fe05a1382ab8adfe406b1baab047 Mbuild-info.txt :04 04 d42be0798b2b820135be1bda9fef0b1cb5fe81ca c54d17cfb88aae06452faf8148d02a8f491e39a3 Mopt y$ git bisect log # bad: [ad5ed3c0a2b049c70515c303e8150f5a75dd818f] 2015-02-06: source-hash-004304eb2fd1703d22dec0abf0170bb2ce493d0c # good: [e4b0a61cedc6ac0e65a4a110fd83edd8295f4856] 2014-11-20: source-hash-d273a60bfdbf9bb7623bed38667ec0647753157c git bisect start 'master' 'oldest' # bad: [09b2fa5b1f166e0d6f077325f2ea5fec8c061b47] 2014-12-29: source-hash-4c9cf98819037fdb70cbe68f678f6498d5646736 git bisect bad 09b2fa5b1f166e0d6f077325f2ea5fec8c061b47 # bad: [cc11b8ff286074f3edcc650b231c4ed3edaebc2f] 2014-12-09: source-hash-887cb59ac4bfca94f310baee3e9da58ccf9cb3e3 git bisect bad cc11b8ff286074f3edcc650b231c4ed3edaebc2f # good: [82d2ef2b66746aac43c054f440e7a4b79b4cc215] 2014-11-29: source-hash-03c049a093c9ed0451099325d73429b010e71594 git bisect good 82d2ef2b66746aac43c054f440e7a4b79b4cc215 # good: [1185944aa3de25f09176f2c87e8afdf9266efe24] 2014-12-04: source-hash-183b89db121b8c6e02c14ebf2c2666ee807a9c82 git bisect good 1185944aa3de25f09176f2c87e8afdf9266efe24 # bad: [9926afee22c71ba349b8b643ca984a2635156bc0] 2014-12-06: source-hash-d0894ff58fbdd823273bc91939801971b7a03182 git bisect bad 9926afee22c71ba349b8b643ca984a2635156bc0 # good: [9c5629e92e7fdb9506e193e95f048b2dbd07517c] 2014-12-05: source-hash-6b096f273ac9d7bbe93d2cb083958b3a04866d73 git bisect good 9c5629e92e7fdb9506e193e95f048b2dbd07517c # first bad commit: [9926afee22c71ba349b8b643ca984a2635156bc0] 2014-12-06: source-hash-d0894ff58fbdd823273bc91939801971b7a03182 I also changing "Hardware" to "All"/"All" because it occurs on Debian GNU/Linux as well - and on x86, too. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.freedesktop.org/show_bug.cgi?id=88002 Beluga changed: What|Removed |Added Keywords||regression Whiteboard||bibisectRequest --- Comment #4 from Beluga --- On this it sorts correctly: Ubuntu 14.10 64-bit Version: 4.3.3.2 Build ID: 430m0(Build:2) These exhibit the wrong sorting behavior: Win 7 64-bit 4.3.5.2 and Version: 4.5.0.0.alpha0+ Build ID: 57626f2132f73e4e42b31e364b25c5867336e718 TinderBox: Win-x86@42, Branch:master, Time: 2014-12-26_09:26:33 Ubuntu 14.10 64-bit Version: 4.5.0.0.alpha0+ Build ID: f92183833fa569006602ac7e93c906d2094e0d4d TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2014-12-14_00:21:45 Must be a regression introduced after 4.3.3.2, added whiteboard for bibisect request. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.freedesktop.org/show_bug.cgi?id=88002 Beluga changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||todven...@suomi24.fi Ever confirmed|0 |1 --- Comment #3 from Beluga --- Reproduced per instructions in comment 2. LibO 4.4 RC1 on Win 8.1 32-bit. Windows 8 only? I'll try on Win 7 & Ubuntu later. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.freedesktop.org/show_bug.cgi?id=88002 Katie Chan changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.freedesktop.org/show_bug.cgi?id=88002 --- Comment #2 from Katie Chan --- Created attachment 111726 --> https://bugs.freedesktop.org/attachment.cgi?id=111726&action=edit Sample doc showing bug Attached sample document to reproduce bug. Compare selecting A1 to D20 and sort by "Name" which works as intended, versus selecting A10 to D20 only and sorting by "Column B". The background formatting (i.e. background color) of Column D should sort along with columns A-C but it doesn't in 4.3.5. I have reproduced it in a clean Win8.1 on a VM with only CamStudio and LibreOffice installed. LO 4.2.8 was first installed and tested, and then upgraded to 4.3.5 by installing on top. You can see a 26 seconds video showing the test on 4.3.5 at http://www.ktchan.info/files/libreoffice/bug88002.avi if you wish. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 88002] EDITING: Sorting ignores end column with formatting only
https://bugs.freedesktop.org/show_bug.cgi?id=88002 raal changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||r...@post.cz Ever confirmed|0 |1 --- Comment #1 from raal --- I can not confirm with my file on LO 4.3.5, win7 and linux. Please send us a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document. (Please note that the attachment will be public, remove any sensitive information before attaching it.) How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F Thank you -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
