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
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
please upload test file
Created attachment 108681 [details] document created executing steps in description
weird bug. I can confirm it under Win7x64 using LO 4.3.2.2
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.