[Libreoffice-bugs] [Bug 72487] EDITING: sorting columns
https://bugs.freedesktop.org/show_bug.cgi?id=72487 --- Comment #15 from Luke lukebe...@hotmail.com --- Created attachment 108562 -- https://bugs.freedesktop.org/attachment.cgi?id=108562action=edit testsort1.ods Sorted in Google Sheets and Excel testsort1.ods and testsort2 do not follow long established spreadsheet conventions. Giving a #REF error is not a bug as you can see by my attachment. To get the desired behavior, spreadsheets should have been created with absolute references. This report should have been marked invalid a long time ago. -- 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 72487] EDITING: sorting columns
https://bugs.freedesktop.org/show_bug.cgi?id=72487 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added CC||jbfa...@libreoffice.org Resolution|NOTABUG |DUPLICATE --- Comment #14 from Jean-Baptiste Faure jbfa...@libreoffice.org --- Your test file attachment 90525 works as expected with version 4.3.4.0.0+ and the master (if you choose the right configuration option). It should work with version 4.3.2 too. Indeed it falls in the category solved by the fix for bug 81309. I did not consider the test file testsort2.ods because the formula in the column A is broken, it is erroneously initialized by the value in A1 which is not a date. Best regards. JBF *** This bug has been marked as a duplicate of bug 81309 *** -- 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 72487] EDITING: sorting columns
https://bugs.freedesktop.org/show_bug.cgi?id=72487 GerardF gerard.farg...@orange.fr changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||gerard.farg...@orange.fr Ever confirmed|0 |1 --- Comment #3 from GerardF gerard.farg...@orange.fr --- (In reply to comment #2) How can you cancel a bug report so fast? You didn't ask for another file. The problem occurs on the file called Water Diary which I didn't send you. It is 1600 rows long. If you tried that fucking file you would see my point, you dummy. We cannot try with a non-existing file... Provide a file with the bug and/or give more information about this file and the way you sort. -- 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 72487] EDITING: sorting columns
https://bugs.freedesktop.org/show_bug.cgi?id=72487 --- Comment #4 from mariosv mari...@miguelangel.mobi --- Hi Joe, I don't remember have cancelled the bug, why do you think so?, you can see the history modifications on the link top left. comment#1, your sample file works fine for me. Have you tried resetting user profile, as suggested? -- 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 72487] EDITING: sorting columns
https://bugs.freedesktop.org/show_bug.cgi?id=72487 --- Comment #5 from Joe Huard joe.hu...@primus.ca --- Okay, I re-read your first reply, and I made a mistake thinking it was Removed, because I saw the word Removed in the top line. So, I apologize for my behavior, I'm the dummy. Joe On 09/12/2013 4:17 AM, bugzilla-dae...@freedesktop.org wrote: *Comment # 4 https://bugs.freedesktop.org/show_bug.cgi?id=72487#c4 on bug 72487 https://bugs.freedesktop.org/show_bug.cgi?id=72487 from mariosv mailto:mari...@miguelangel.mobi * Hi Joe, I don't remember have cancelled the bug, why do you think so?, you can see the history modifications on the link top left. comment#1 show_bug.cgi?id=72487#c1, your sample file works fine for me. Have you tried resetting user profile, as suggested? You are receiving this mail because: * You reported the bug. -- 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 72487] EDITING: sorting columns
https://bugs.freedesktop.org/show_bug.cgi?id=72487 --- Comment #7 from Joe Huard joe.hu...@primus.ca --- Created attachment 90524 -- https://bugs.freedesktop.org/attachment.cgi?id=90524action=edit attachment-31361-1.dat --- Comment #8 from Joe Huard joe.hu...@primus.ca --- Created attachment 90525 -- https://bugs.freedesktop.org/attachment.cgi?id=90525action=edit testsort1.ods --- Comment #9 from Joe Huard joe.hu...@primus.ca --- Created attachment 90526 -- https://bugs.freedesktop.org/attachment.cgi?id=90526action=edit testsort2.ods -- 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 72487] EDITING: sorting columns
https://bugs.freedesktop.org/show_bug.cgi?id=72487 --- Comment #6 from Joe Huard joe.hu...@primus.ca --- I renamed the User folder to User-old. After restarting Libre Office Calc, the same problem exists. I am attaching 2 files; testsort1 and testsort2. Testsort1 shows 2 columns 1600 rows with dates and numbers. I sorted that in descending mode using the Wt. column, and the resulting mess is viewable in testsort2. The dates don't match the weights, and some more recent dates are missing and replaced by ###VALUE. IE, the dates should NOT be all in order from past to more recent. They should be all mixed up. :-( Joe On 09/12/2013 3:16 AM, bugzilla-dae...@freedesktop.org wrote: GerardF mailto:gerard.farg...@orange.fr changed bug 72487 https://bugs.freedesktop.org/show_bug.cgi?id=72487 What Removed Added StatusUNCONFIRMED NEEDINFO CCgerard.farg...@orange.fr Ever confirmed1 *Comment # 3 https://bugs.freedesktop.org/show_bug.cgi?id=72487#c3 on bug 72487 https://bugs.freedesktop.org/show_bug.cgi?id=72487 from GerardF mailto:gerard.farg...@orange.fr * (In reply tocomment #2 show_bug.cgi?id=72487#c2) How can you cancel a bug report so fast? You didn't ask for another file. The problem occurs on the file called Water Diary which I didn't send you. It is 1600 rows long. If you tried that fucking file you would see my point, you dummy. We cannot try with a non-existing file... Provide a file with the bug and/or give more information about this file and the way you sort. You are receiving this mail because: * You reported the bug. -- 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 72487] EDITING: sorting columns
https://bugs.freedesktop.org/show_bug.cgi?id=72487 mariosv mari...@miguelangel.mobi changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |NOTABUG --- Comment #10 from mariosv mari...@miguelangel.mobi --- You are using a formula for dates, when sorting all dates are properly sorted, but they have relative formula so they always refer to the previous cell plus 1, the same after sort. And how the fixed date in A2 also change with the sort, in A2 you have a formula summing one to A1 what is a text, so can't be summed. You can copy dates and with paste special paste their values without the formula, so you can sort without problem. For me it is not a bug. Please if you are not agree reopen it. -- 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 72487] EDITING: sorting columns
https://bugs.freedesktop.org/show_bug.cgi?id=72487 --- Comment #11 from Joe Huard joe.hu...@primus.ca --- For me, I still think it is a bug. What you provided is a workaround. Thanks though; I can work with that. Joe On 09/12/2013 5:21 PM, bugzilla-dae...@freedesktop.org wrote: mariosv mailto:mari...@miguelangel.mobi changed bug 72487 https://bugs.freedesktop.org/show_bug.cgi?id=72487 What Removed Added StatusNEEDINFORESOLVED Resolution--- NOTABUG *Comment # 10 https://bugs.freedesktop.org/show_bug.cgi?id=72487#c10 on bug 72487 https://bugs.freedesktop.org/show_bug.cgi?id=72487 from mariosv mailto:mari...@miguelangel.mobi * You are using a formula for dates, when sorting all dates are properly sorted, but they have relative formula so they always refer to the previous cell plus 1, the same after sort. And how the fixed date in A2 also change with the sort, in A2 you have a formula summing one to A1 what is a text, so can't be summed. You can copy dates and with paste special paste their values without the formula, so you can sort without problem. For me it is not a bug. Please if you are not agree reopen it. You are receiving this mail because: * You reported the bug. -- 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 72487] EDITING: sorting columns
https://bugs.freedesktop.org/show_bug.cgi?id=72487 --- Comment #12 from mariosv mari...@miguelangel.mobi --- Hi Joe not a work around, when you sort relative cells formulas, the cell formula is adapted to the new position. If: B14: =A14*2 and after a sort B14 is moved to B3 then: B3: =A3*2 what is fine, because this retain the formula between cells in the row if you don't want this change you need to have an absolute row reference. B14: =A$14*2 and after a sort B14 is moved to B3 then: B3: =A$14*2 I think maybe is easy, not use formulas, but fill down as you need dragging the date with the mouse. -- 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 72487] EDITING: sorting columns
https://bugs.freedesktop.org/show_bug.cgi?id=72487 --- Comment #13 from Joe Huard joe.hu...@primus.ca --- I do drag the date down with the mouse. That is how I did it from the beginning. Joe On 09/12/2013 6:09 PM, bugzilla-dae...@freedesktop.org wrote: *Comment # 12 https://bugs.freedesktop.org/show_bug.cgi?id=72487#c12 on bug 72487 https://bugs.freedesktop.org/show_bug.cgi?id=72487 from mariosv mailto:mari...@miguelangel.mobi * Hi Joe not a work around, when you sort relative cells formulas, the cell formula is adapted to the new position. If: B14: =A14*2 and after a sort B14 is moved to B3 then: B3: =A3*2 what is fine, because this retain the formula between cells in the row if you don't want this change you need to have an absolute row reference. B14: =A$14*2 and after a sort B14 is moved to B3 then: B3: =A$14*2 I think maybe is easy, not use formulas, but fill down as you need dragging the date with the mouse. You are receiving this mail because: * You reported the bug. -- 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 72487] EDITING: sorting columns
https://bugs.freedesktop.org/show_bug.cgi?id=72487 mariosv mari...@miguelangel.mobi changed: What|Removed |Added CC||mari...@miguelangel.mobi --- Comment #1 from mariosv mari...@miguelangel.mobi --- Hi Joe, thanks for reporting. I can't reproduce you issue with your file, sort fine for me. Win7x64 Version 4.0.6.2 (Build ID: 2e2573268451a50806fcd60ae2d9fe01dd0ce24) If you are sure both columns are selected, please try resetting the user profile, sometimes solves strange issues: https://wiki.documentfoundation.org/UserProfile -- 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 72487] EDITING: sorting columns
https://bugs.freedesktop.org/show_bug.cgi?id=72487 --- Comment #2 from Joe Huard joe.hu...@primus.ca --- How can you cancel a bug report so fast? You didn't ask for another file. The problem occurs on the file called Water Diary which I didn't send you. It is 1600 rows long. If you tried that fucking file you would see my point, you dummy. On 08/12/2013 6:17 PM, bugzilla-dae...@freedesktop.org wrote: mariosv mailto:mari...@miguelangel.mobi changed bug 72487 https://bugs.freedesktop.org/show_bug.cgi?id=72487 What Removed Added CCmari...@miguelangel.mobi *Comment # 1 https://bugs.freedesktop.org/show_bug.cgi?id=72487#c1 on bug 72487 https://bugs.freedesktop.org/show_bug.cgi?id=72487 from mariosv mailto:mari...@miguelangel.mobi * Hi Joe, thanks for reporting. I can't reproduce you issue with your file, sort fine for me. Win7x64 Version 4.0.6.2 (Build ID: 2e2573268451a50806fcd60ae2d9fe01dd0ce24) If you are sure both columns are selected, please try resetting the user profile, sometimes solves strange issues: https://wiki.documentfoundation.org/UserProfile You are receiving this mail because: * You reported the bug. -- 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