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=108491&action=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