https://bugs.freedesktop.org/show_bug.cgi?id=45146
--- Comment #27 from [email protected] --- I've created an easily duplicated spreadsheet that illustrates what I think may be a problem. I'm not sure if it matches the bug described in this (45156) or if it represents a different bug. If it needs to be a separate bug, then I can create a new one. Note that LO Calc may not be technically doing anything wrong, but it does not match user expectations, which is critical. Create this simple spreadsheet, starting at cell A1: 2014-04-01 SubAssembly1 =B$2+B$3 2014-02-01 Nuts 10 2014-03-01 Bolts 5 2014-04-01 SubAssembly2 =B2+B3 2014-01-01 Grease 50 2014-05-01 Assembly1 =B4+B5 2014-05-01 Assembly2 =B$1+B$5 Now sort rows, using Column A as the key. Notice the Error 522's. Now undo, and sort rows using Column B as the key. Notice the new Error 522's. Now undo, and sort rows using Column C as the key. Notice the new Error 522's. In all these cases, the user had an expectation to be able to sort by any column without the data changing (with only the order of the rows changing). This way, the spreadsheet can be sorted by date, part name, or cost. When I add a fourth column that includes cells that add and subtract specific values from the third column, the problem gets even more pronounced. Note that I intentionally used both absolute and relative references to cover both cases. I had hoped at least one type of reference would work. Obviously, only one type of reference would be used (this is just a demonstration). Is this simple spreadsheet in error, or does it reflect a problem with the output of LO Calc not matching that of user expectations? -- 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
