[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.documentfoundation.org/show_bug.cgi?id=81633 Cor Nouws changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Ленар changed: What|Removed |Added i915 platform||ALL -- You

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.documentfoundation.org/show_bug.cgi?id=81633 --- Comment #79 from Luke --- 7qia0tp02, A closed bug is not the proper place to discuss UI. If you want to help out the UX team, you can discuss this issue on IRC or the UX mailing list.

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.documentfoundation.org/show_bug.cgi?id=81633 --- Comment #78 from 7qia0t...@sneakemail.com --- Why in the world do I have to go to Tools -> Options -> Calc -> General and click a checkbox to make this work correctly? This should be a checkbox in the Options tab of the Sort dialog,

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.documentfoundation.org/show_bug.cgi?id=81633 Luke lukebe...@hotmail.com changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.documentfoundation.org/show_bug.cgi?id=81633 m.a.riosv mari...@miguelangel.mobi changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 raal r...@post.cz changed: What|Removed |Added CC||agros...@gmail.com --- Comment #74

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 m.a.riosv mari...@miguelangel.mobi changed: What|Removed |Added CC||bob.g...@gmail.com

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Eike Rathke er...@redhat.com changed: What|Removed |Added Blocks||85490 See

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Eike Rathke er...@redhat.com changed: What|Removed |Added Blocks||85614 See

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Eike Rathke er...@redhat.com changed: What|Removed |Added See Also|https://bugs.freedesktop.or |

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Eike Rathke er...@redhat.com changed: What|Removed |Added See Also|https://bugs.freedesktop.or |

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Eike Rathke er...@redhat.com changed: What|Removed |Added Blocks||85584 See

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Eike Rathke er...@redhat.com changed: What|Removed |Added See Also|https://bugs.freedesktop.or |

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Eike Rathke er...@redhat.com changed: What|Removed |Added See Also|https://bugs.freedesktop.or |

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #71 from m_j_mal...@hotmail.com --- Making this change to LibreOffice 4.2.7.2 has broken many very old spreadsheets and caused them to be mangled in sorting. There is no way to resolve this post with this one:

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Luke lukebe...@hotmail.com changed: What|Removed |Added Attachment #107667|1 |0 is obsolete|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Luke lukebe...@hotmail.com changed: What|Removed |Added Attachment #107667|0 |1 is obsolete|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #67 from Jean-Baptiste Faure jbfa...@libreoffice.org --- *** Bug 85571 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Luke lukebe...@hotmail.com changed: What|Removed |Added CC||i...@michalsima.net ---

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Luke lukebe...@hotmail.com changed: What|Removed |Added See Also||https://launchpad.net/bugs/

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Luke lukebe...@hotmail.com changed: What|Removed |Added See Also||https://bugs.freedesktop.or

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #62 from dmdcare...@care2.com --- (In reply to Luke from comment #61) Thank you very much for following up with this report and with the ESC, but I do not think we can consider this issue resolved until the old functionality is

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #63 from Nigel R Murray nigelrmur...@gmail.com --- Gentlemen, As an outsider who has only begun reading about this issue (since the change in workflow affected me) I would like to add my perspective. I think it is essential that

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 GerardF gerard.farg...@orange.fr changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 stephanie park stephaniepar1...@gmail.com changed: What|Removed |Added Status|RESOLVED|REOPENED

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added Status|REOPENED|RESOLVED

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #58 from dmdcare...@care2.com --- Clearly the bug is still far from resolved and For me it is usable but it is a big change in the workflow which I was used to is unacceptable to me and, possibly, other users. The sorting should work

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #59 from Luke lukebe...@hotmail.com --- Jean-Baptiste, Why have you closed this bug report? This serious issue has still not been resolved. Sorting now requires users to know workarounds and change settings that don't always work.

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #60 from Jean-Baptiste Faure jbfa...@libreoffice.org --- (In reply to Luke from comment #59) Jean-Baptiste, Why have you closed this bug report? I explained in comment #53 why I closed this bug report. This serious issue has

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #61 from Luke lukebe...@hotmail.com --- Jean-Baptiste Faure, Could you please give an example of a VALID spreadsheet that did not work for years too? The one synthetic example in your Meta is completely broken in Excel,Google Sheets,

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #57 from Jean-Baptiste Faure jbfa...@libreoffice.org --- From comment #8 in bug 85215 : It works without error if, instead of selecting only the cell A1 and going to menu Data Sort, I select the range A1:C14 (that is only the data)

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added Attachment #104016|0 |1

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added Status|REOPENED|RESOLVED

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #50 from Michael Meeks michael.me...@collabora.com --- Wow; this bug is unreadably long awful and seems to be collecting different problems. Anyhow - Eike just merged the back-port of the option, defaulting to what should be the old

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #51 from Jean-Baptiste Faure jbfa...@libreoffice.org --- Hi Michael, Thank you very much for that. I saw the commit and I am currently trying to test my build. I do not understand how to check if the option is available in my

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #52 from Jean-Baptiste Faure jbfa...@libreoffice.org --- Ok, I found the option in the Expert Configuration window. Now, version 4.3 works the same way as 4.4 does. But in the case of the first attachment to this bug report

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #45 from Norbert Scheibner s...@gmx.net --- I don't know the effort it takes to implement such a minimal QA. But if it is not in reach, just don't add new enhancements in between minor version updates and definitely not between 4.2.6

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #46 from Fred Olness oln...@smu.edu --- A COMPACT EXAMPLE OF THE BUG: === Here is a compact example of the bug. This is now fixed in the 4.3.4.0.0 2014-10-09 development version. (Thank you) Note, this is clearly a

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #47 from Fred Olness oln...@smu.edu --- Created attachment 107658 -- https://bugs.freedesktop.org/attachment.cgi?id=107658action=edit Short example of the bug This is a short (3 line) example of the bug. -- You are receiving this

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #48 from erik...@gmail.com --- (In reply to Kohei Yoshida from comment #7) Our best option would be to make it configurable. Any attempt to automatically figure out when to and not to adjust would only make the situation worse,

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #49 from Norbert Scheibner s...@gmx.net --- Created attachment 107667 -- https://bugs.freedesktop.org/attachment.cgi?id=107667action=edit Test Case for cross sheet sort. As I started to implement the workaround. I saw another

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Kohei Yoshida libreoff...@kohei.us changed: What|Removed |Added Assignee|libreoff...@kohei.us

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbfa...@libreoffice.org changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #44 from m.a.riosv mari...@miguelangel.mobi --- If someone is interested in a workaround, see my answer in: http://ask.libreoffice.org/en/question/40686/calc-sort-messing-up-formulas/?answer=40912#post-id-40912 IMMHO, while we

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #14 from dmdcare...@care2.com --- (In reply to comment #13) A9: =IF(C9C8;RANK(C9;$C$2:$C$16;0);IF(C9C8;Re-sort;IF(AND(C9=C8;B9B8);Re- sort;))) changing C9 value to 500, after Menu/Data/Sort - Column C descending / Options -

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Commit Notification libreoffice-comm...@lists.freedesktop.org changed: What|Removed |Added Whiteboard|bibisected

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #16 from Commit Notification libreoffice-comm...@lists.freedesktop.org --- Kohei Yoshida committed a patch related to this issue. It has been pushed to master:

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Kohei Yoshida libreoff...@kohei.us changed: What|Removed |Added Status|NEW |RESOLVED

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jacques Guilleron guillero...@aol.com changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Laurent BP jumbo4...@yahoo.fr changed: What|Removed |Added CC||dmdcare...@care2.com ---

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #12 from ign_christian ign_christ...@yahoo.com --- *** Bug 83276 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 m.a.riosv mari...@miguelangel.mobi changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #9 from Jean-Baptiste Faure jbf.fa...@sud-ouest.org --- Created attachment 104016 -- https://bugs.freedesktop.org/attachment.cgi?id=104016action=edit another example of inconsistency in sorting This attachment is the same as the

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #5 from Kohei Yoshida libreoff...@kohei.us --- You guys need to talk to those users who think sorting should adjust references. -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #6 from Kohei Yoshida libreoff...@kohei.us --- Calling this a regression is a testament to the meme that one man's feature is another man's bug. We all lose. -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #7 from Kohei Yoshida libreoff...@kohei.us --- Our best option would be to make it configurable. Any attempt to automatically figure out when to and not to adjust would only make the situation worse, because unless we add a

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Joel Madero jmadero@gmail.com changed: What|Removed |Added Whiteboard|bibisectRequest |bibisected ---

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Joel Madero jmadero@gmail.com changed: What|Removed |Added Hardware|x86-64 (AMD64) |All

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 --- Comment #3 from Jean-Baptiste Faure jbf.fa...@sud-ouest.org --- Tested to be sure: reverting fdo#81309: Adjust references during sort.

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbf.fa...@sud-ouest.org changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbf.fa...@sud-ouest.org changed: What|Removed |Added Version|4.4.0.0.alpha0+ Master |unspecified

[Libreoffice-bugs] [Bug 81633] Sorting shouldn't always automatically adjust references.

https://bugs.freedesktop.org/show_bug.cgi?id=81633 Jean-Baptiste Faure jbf.fa...@sud-ouest.org changed: What|Removed |Added Version|unspecified