[Libreoffice-bugs] [Bug 45296] New: TABLE: TABLE: Deleted status ignored while showing changes.

[bugzilla-daemon at freedesktop.org]

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

             Bug #: 45296
           Summary: TABLE: TABLE: Deleted status ignored while showing
                    changes.
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.4.4 release
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Writer
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: joseph.theriault at seed-forensics.de


Problem description: 
When the option "show changes" is actived, deleted values are interpreted in
calculations.

Steps to reproduce:
1. Create a table with one row and three columns.
2. Enter "1" in the first column and "2" in the second.
3. In the third column, enter the function "sum<A1:A2>" (the sum of the first
two cells).
4. Turn on "record changes" and "show changes" via Edit->Changes.
5. Select the value "1" in the first column and change it to "2".

Current behavior:
The deleted value, "1", is marked as deleted and the new value, "2" is written
beside it (as expected). However, the calculated sum in the third column is
reported as 14, having interpreted the value of the cell as "12" rather than
"2".

Expected behavior:
The deleted value, "1", should be ignored in the calculation. The sum of the
two cells should be "4" after changing the value of the first cell from "1" to
"2".

Platform (if different from the browser): 

Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:9.0.1) Gecko/20100101
Firefox/9.0.1

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.