Bug 45296 - TABLE: Deleted status ignored while showing changes
Summary: TABLE: Deleted status ignored while showing changes
Status: RESOLVED DUPLICATE of bug 39828
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected)
3.3.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2012-01-27 00:29 UTC by joseph.theriault
Modified: 2018-09-07 15:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

document created executing steps in description (10.68 KB, application/vnd.oasis.opendocument.text)
2014-10-30 09:25 UTC, sasha.libreoffice

Note You need to log in before you can comment on or make changes to this bug.
Description joseph.theriault 2012-01-27 00:29:24 UTC
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
Comment 1 sasha.libreoffice 2012-05-11 03:42:41 UTC
Thanks for bugreport
reproduced in 3.3.4 and 3.5.3 on Fedora 64 bit

Changing version to 3.3.4 as most early reproducible
Comment 2 tommy27 2014-10-30 03:34:20 UTC
please upload test file
Comment 3 sasha.libreoffice 2014-10-30 09:25:32 UTC
Created attachment 108681 [details]
document created executing steps in description
Comment 4 tommy27 2014-10-30 12:17:05 UTC
weird bug. I can confirm it under Win7x64 using LO
Comment 5 QA Administrators 2015-12-20 16:16:17 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2017-01-03 19:49:25 UTC Comment hidden (obsolete)
Comment 7 Timur 2018-09-07 15:27:23 UTC

*** This bug has been marked as a duplicate of bug 39828 ***