https://bugs.freedesktop.org/show_bug.cgi?id=81633

          Priority: medium
            Bug ID: 81633
          Assignee: [email protected]
           Summary: Sorting shouldn't always automatically adjust
                    references.
          Severity: major
    Classification: Unclassified
                OS: Linux (All)
          Reporter: [email protected]
          Hardware: x86-64 (AMD64)
            Status: UNCONFIRMED
           Version: 4.4.0.0.alpha0+ Master
         Component: Spreadsheet
           Product: LibreOffice

The fix for bug 81309 seems to generate a regression in the behavior of some
spreadsheet when sorting. Steps to reproduce:

1/ open attached file to bug 81617:
https://bugs.freedesktop.org/attachment.cgi?id=103205
it is a simplified extract of bank account. Column D gives the balance between
incomes (column C) and spendings (column B). Each formula in column D refers to
the value in the previous row in the same column.
2/ select rows 8 to 14
3/ click on the button "Sort ascending" on the dates (column A)
The formulas in D8 and D14 are false. It worked in all previous versions of
LibreOffice and OO.

Remarks:
a/ I discovered this regression on 4.3.1.0.0+ Build ID:
f6445efb0e5c3de099f0425825fe1e6e8271dfb9 build at home (complete clean build)
on Ubuntu 14.04 x86-64
2/ This bug does not affect 4.2.7.0.0+ updated and build one day ago
3/ this bug affects 4.2.7.0.0+ after backport of bug 81309 fix (Build ID:
f5949d09321e3ac62538df0e70e58284bd1cab32)

Best regards. JBF

-- 
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

Reply via email to