https://bugs.freedesktop.org/show_bug.cgi?id=45146
--- Comment #31 from [email protected] --- Thanks for your apology Joel. Accepted. And I apologize if I came across as too harsh. This is a tricky bug and how to report it is tricky as well because the "correct" behavior here may be counter to the absolute logical behavior. In other words, we must somehow allow the user to perform needed tasks. How I discovered this bug (and apparently other people found it before myself) is that I created a spreadsheet with the intent of sorting it by different columns. When I would re-sort it, the values would change. Sometimes complicated spreadsheets contain errors, so I created a simple spreadsheet to demonstrate the problem. >From what I can tell, it is a very serious problem. But I'm also very open to the possibility (and actually hoping) that I'm just not understanding how something works. Being able to sort is important, and not having the values change during that sort is a basic requirement. The ramifications is that my client has seen values change during the sort and wants to move the entire enterprise off of LibreOffice because she now considers it unreliable. I am a huge proponent of LibreOffice and the sole reason why my clients use it. As much as I love LibreOffice, I'm having a tough battle trying to convince them to stick with LibreOffice when it does not generate the results it seems like it should. Two quick asides: please always try to remember that end users don't know names of the developers. Also, I agree that this bug should be "Unconfirmed" until more comments are made. Eike came to the conclusion that absolute references would solve the problem. I was hoping he was correct, as that would be great. But my example seems to show that absolute references don't solve it. Unless the example is wrong. The bottom line is that we need a way to sort while maintaining data and formula integrity. At the least, this will be a documentation issue so users will know how to do it. At the most, this will be a fairly important bug that will need a fix. Anything that compromises the user's data is important. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
