https://bugs.freedesktop.org/show_bug.cgi?id=85490
--- Comment #8 from Joey Reid <[email protected]> --- >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 [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
