[Libreoffice-bugs] [Bug 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Eike Rathke er...@redhat.com changed: What|Removed |Added See Also|https://bugs.freedesktop.or | |g/show_bug.cgi?id=85215,| |https://bugs.freedesktop.or | |g/show_bug.cgi?id=81309,| |https://bugs.freedesktop.or | |g/show_bug.cgi?id=81633,| |https://bugs.freedesktop.or | |g/show_bug.cgi?id=79441,| |https://bugs.freedesktop.or | |g/show_bug.cgi?id=45146,| |https://bugs.freedesktop.or | |g/show_bug.cgi?id=85584,| |https://bugs.freedesktop.or | |g/show_bug.cgi?id=85614,| |https://bugs.freedesktop.or | |g/show_bug.cgi?id=86304 | Depends on||85215, 81309, 81633, 79441, ||45146, 85584, 85614, 86304 --- Comment #18 from Eike Rathke er...@redhat.com --- Moved the see also list to Depends on to be able to see the dependency tree view. -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 --- Comment #19 from Eike Rathke er...@redhat.com --- (In reply to tommy27 from comment #17) I really think that a 4.2.8 release would be a bless. We'll do a 4.2.8 release, currently in progress. -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Eike Rathke er...@redhat.com changed: What|Removed |Added Depends on||86762 -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Eike Rathke er...@redhat.com changed: What|Removed |Added Depends on||81796, 70815, 85405 -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Eike Rathke er...@redhat.com changed: What|Removed |Added Depends on||61344, 77018 -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Eike Rathke er...@redhat.com changed: What|Removed |Added Depends on||84055 -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Bug 85490 depends on bug 81796, which changed state. Bug 81796 Summary: Formula result not displayed after cells deletion sorting https://bugs.freedesktop.org/show_bug.cgi?id=81796 What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Eike Rathke er...@redhat.com changed: What|Removed |Added Depends on||68566 -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Eike Rathke er...@redhat.com changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 --- Comment #16 from Luke lukebe...@hotmail.com --- I've spend the past couple of days using 4.2.8 as my primary office suite and also tested all of the bugs in the meta spreadsheet along with most duplicates of Bug 81633 . I'm pleased to report that all of the spreadsheets in attachment 110103 that were broken in 4.2.7 are fixed in 4.2.8. Great work team! Version: 4.2.8.0.0+ Build ID: 383535196f9924202fc997c388e34a7865a2250e -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 --- Comment #17 from tommy27 ba...@quipo.it --- thanks for feedback Luke. I really think that a 4.2.8 release would be a bless. the 4.2.x branch has been declared End of Life after 4.2.7 but this looks to me a valid reason to resuscitate 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Luke lukebe...@hotmail.com changed: What|Removed |Added Attachment #109652|0 |1 is obsolete|| --- Comment #15 from Luke lukebe...@hotmail.com --- Created attachment 110103 -- https://bugs.freedesktop.org/attachment.cgi?id=110103action=edit Updated use-cases summary with Calc 4.5 results @Eike Rathke With the recent patches you and Kohei have made to the UpdateReferenceOnSort=FALSE code path, the sorting behavior has nearly returned 100% to the legacy/Excel behavior. I went through every duplicate of Bug 81633 on Calc 4.5. They are all sorting correctly now! The only minor issue I encountered is that some spreadsheets (like indicator) now require a Ctrl+Shift+F9 after a sort. This is fabulous. You are a thick skinned saint to bear with all the irate users. The community owes you and everyone else who donated their time to resolve this issue, some hugs and a big thanks. -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Luke lukebe...@hotmail.com changed: What|Removed |Added Attachment #109016|0 |1 is obsolete|| -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 --- Comment #14 from Eike Rathke er...@redhat.com --- Status update and explanations for attachment 109652 metabug_fdo85490_v6.ods per sheet: * Ranking_Columns: fixed with bug 83765 * Bug43004: fixed with bug 83765, was erroneously indicated to be some case of bug 43004 but is not. * Bank_Account: there's nothing wrong with it, with UpdateReferenceOnSort=TRUE the references are adjusted to point to the same data they did before, which for the classic column shifts references around within the same column, and of course in the new column the OFFSET() function still calculates the offsets as it is told so it differs from the classic column. * Indicator_2: range references usually can't be adjusted if they are of the same direction as the reordering and within data, imagine the content of A1:A3 was not {1,2,3} but {4,2,6} instead, where should it point to after reordering? Doing it here in this case would be a special special case. * abs / absData: the observed behavior is exactly the difference of UpdateReferenceOnSort=TRUE, references that point into the reordered range are updated to keep a reference to the same data. If that is not wanted then UpdateReferenceOnSort=FALSE must be used. So it is not correct to say that the behavior would be wrong in the TRUE case. This is why the option was implemented. * Average: updating in the case of UpdateReferenceOnSort=FALSE is a bug, references within the reordered range that are pointing to ranges within the reordered range of the same reordering direction must be kept relative to the reordered data. This is fixed in master, 4.3.4, 4-3 (to-be 4.3.5) and does not yet occur in 4.2.7, but did occur in 4-2 (to-be 4.2.8 if released at all). Cherry-picking another commit from bug 85215 resolved that. * RefInside: same reason as on the Average sheet, fixed with the commits for bug 85215. * Indicator: I didn't wrap my head around that one yet.. but it appears to me that the expectations are wrong. * Stock_Management: a case of why UpdateReferenceOnSort=TRUE was invented. It is misleading to title the other cases as wrong. If a reference updated is wanted for UpdateReferenceOnSort=FALSE then absolute references must be used, i.e. =C$3+C$4, this is the same in all major spreadsheet implementations. * Bug62490: same as Stock_Management, use absolute references, as a workaround if already relateive references are used then use UpdateReferenceOnSort=TRUE. * Ubuntu: apparently Ubuntu for 4.2.7 applied a patch of 4-2 that needs two other patches to follow-up, namely the ones already mentioned above for bug 85215 that also went into 4-2 * Users: so we're fine here? GREAT! -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Luke lukebe...@hotmail.com changed: What|Removed |Added Attachment #108546|0 |1 is obsolete|| --- Comment #13 from Luke lukebe...@hotmail.com --- Created attachment 109652 -- https://bugs.freedesktop.org/attachment.cgi?id=109652action=edit Updated use-cases summary I updated the summary with 3 more problematic use cases. If we could fix the first 3, so that they sorted correctly with UpdateReferenceOnSort=TRUE, the sorting behavior would closely match the industry standard/previous behavior. -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=86304 -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 --- Comment #11 from Luke lukebe...@hotmail.com --- Created attachment 109016 -- https://bugs.freedesktop.org/attachment.cgi?id=109016action=edit summary of Calc behaviors when sorting range of cells with references Updated Summary to include results of Excel and OpenOffice. In every case: Excel = OpenOffice Calc 4.2 = LO Calc 4.2.6 -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Luke lukebe...@hotmail.com changed: What|Removed |Added Attachment #108990|0 |1 is obsolete|| -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Luke lukebe...@hotmail.com changed: What|Removed |Added Attachment #108491|0 |1 is obsolete|| -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Luke lukebe...@hotmail.com changed: What|Removed |Added Attachment #108469|0 |1 is obsolete|| -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 m.a.riosv mari...@miguelangel.mobi changed: What|Removed |Added CC||i...@michalsima.net --- Comment #12 from m.a.riosv mari...@miguelangel.mobi --- *** Bug 85968 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 http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 --- Comment #10 from Jean-Baptiste Faure jbfa...@libreoffice.org --- Created attachment 108990 -- https://bugs.freedesktop.org/attachment.cgi?id=108990action=edit summary of Calc behaviors when sorting range of cells with references In this spreadsheet I tried to summarize the use-cases I have found. Please, test yourself. Best regards. JBF -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Luke lukebe...@hotmail.com changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=85614 -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 --- Comment #6 from Jean-Baptiste Faure jbfa...@libreoffice.org --- (In reply to Joey Reid from comment #3) Created attachment 108491 [details] Use-Case 2 save as XLS to show it should always be moved on sort It should be noted in your presentation that Use-Case: Sorting students by their scores uses absolute references. I do not see any absolute reference in attachment 100144 from bug 79441. By including this use case that is bugged in 4.2+, you are confusing the issue. This issue is a metabug intended to summarize all use-cases for sorting with references and to show what does work and what does not. Why excluding a particular use-case ? Best regards. JBF -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 --- Comment #7 from Jean-Baptiste Faure jbfa...@libreoffice.org --- Bug 85215 : last commits for this bug restored the legacy behavior (when UpdateReferenceOnsort = false). See https://bugs.freedesktop.org/show_bug.cgi?id=85215#c14 Best regards. JBF -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 --- Comment #8 from Joey Reid joeyisdama...@gmail.com --- This issue is a metabug intended to summarize all use-cases for sorting with references and to show what does work and what does not. Jean-Baptiste Faure, There is no valid use case for this adjusting relative references in a sort. That’s what absolute references are for. The whole issue arose from a spreadsheet neophytes who do not understand the fundamentals spreadsheet design. In Bug 45146 a developer, Eike, said, “A relative in-sheet reference is supposed to point to a cell relative to the formula cell containing the reference and hence changes the value if the formula cell is moved during sort. If the reference shall stick to the same cell then an absolute reference must be used. This behavior is identical to how Excel treats it.” Instead of listening to his wisdom and telling the users to fix their broken spreadsheets with absolute references, we bowed to their ridiculous demands, creating this nightmare situation where Calc is incompatible with all other spreadsheet. We should treat this as a learning opportunity and revert changes to prevent any more casualties of this poorly thought out feature. This is a serious issue. Look at all the dupes of Bug 81633 to get an idea of the damage this is doing to Calc's reputation as being a professional quality product. -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=85584 -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 --- Comment #9 from Jean-Baptiste Faure jbfa...@libreoffice.org --- Filled bug 85584 to propose that option UpdateReferencesOnSort be set to false by default. Best regards. JBF -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 --- Comment #4 from Joey Reid joeyisdama...@gmail.com --- Sorry if I was not clear. By the definition of absolute reference and by every spreadsheet's implementation, formulas with absolute references should always be adjusted when sorting. The fact that it's not sorting correctly with newer versions of Calc is unrelated to the issue of how the sorting of formulas with relative references should be handled. In the case of relative references, they should not be adjusted with the sort. The only time I have ever seen a spreadsheet with the option to adjust formulas, is with Gnumeric. And in that case, it is a sort option (not a system setting) and it is disabled by default. -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Luke lukebe...@hotmail.com changed: What|Removed |Added Attachment #108474|0 |1 is obsolete|| --- Comment #5 from Luke lukebe...@hotmail.com --- Created attachment 108546 -- https://bugs.freedesktop.org/attachment.cgi?id=108546action=edit Updated use-cases summary with Excel results I updated the presentation to include the results of how Excel sorts these use cases. Case 1 bank: Good Case 2 students: Good Case 3 synthetic: FAIL Case 4 hardware: Good To resolve this issue, Cases 1, 2 and 4 should all sort properly with the default Calc settings. -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 --- Comment #2 from Jean-Baptiste Faure jbfa...@libreoffice.org --- Created attachment 108474 -- https://bugs.freedesktop.org/attachment.cgi?id=108474action=edit new version of use-cases summary with numbers of main bug reports -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 tommy27 ba...@quipo.it changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||ba...@quipo.it Ever confirmed|0 |1 -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 --- Comment #3 from Joey Reid joeyisdama...@gmail.com --- Created attachment 108491 -- https://bugs.freedesktop.org/attachment.cgi?id=108491action=edit Use-Case 2 save as XLS to show it should always be moved on sort It should be noted in your presentation that Use-Case: Sorting students by their scores uses absolute references. Therefore, its references should ALWAYS be moved on a sort, irrespective of any settings. Steps to Verify: 1. Open testRefInterne.xls in MS Excel and Sort by Average 2. Open testRefInterne.xls in Lo 4.1 or earlier and Sort by Average 3. Open testRefInterne.xls in Apache OpenOffice and Sort by Average 4. Open testRefInterne.xls in Gnumeric and Sort by Average 5. Open testRefInterne.xls in KSpread and Sort by Average 6. Open testRefInterne.xls in WPS Office and Sort by Average 7. Open testRefInterne.xls in IBM Lotus Symphony and Sort by Average 8. Compare sorted tables Results: All spreadsheets adjust the references. Note this is the only case where references should be automatically adjusted. When you perform the same steps with the other use cases that contain relative references, they are not and adjusted automatically by other spreadsheets. By including this use case that is bugged in 4.2+, you are confusing the issue. -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 --- Comment #1 from Jean-Baptiste Faure jbfa...@libreoffice.org --- Created attachment 108469 -- https://bugs.freedesktop.org/attachment.cgi?id=108469action=edit use-case for sorting issues First draft for use-cases. Best regards. JBF -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added Attachment #108468|text/plain |application/vnd.oasis.opend mime type||ocument.spreadsheet -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=85215, ||https://bugs.freedesktop.or ||g/show_bug.cgi?id=81309, ||https://bugs.freedesktop.or ||g/show_bug.cgi?id=81633 -- 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 85490] [METABUG] Use-Cases for sorting with references
https://bugs.freedesktop.org/show_bug.cgi?id=85490 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added See Also||https://bugs.freedesktop.or ||g/show_bug.cgi?id=79441, ||https://bugs.freedesktop.or ||g/show_bug.cgi?id=45146 -- 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