https://bugs.documentfoundation.org/show_bug.cgi?id=142891
--- Comment #9 from [email protected] --- (In reply to Julien Nabet from comment #8) > Could you give a try to 7.2.2 Testing with 7.2.2.2 (msi install upgraded the 7.1). The symptoms change. At first there are still cell recalculation errors after Undo:delete (but different errors). However. . . If the test file is saved once (using 7.2.2.2) then close/restart 7.2.2.2 once, all cell values now work at all steps. I only tested Undo:delete; it's a complex file with a long history. However, it seems this cell Calculation Undo problem (OpenCL on) resolved. Great! (if the User knows to upgrade Calc/open file/save file/restart/open file again). Remaining problem. The red plot chart doesn't follow (but the orange chart does). After Undo:delete, Red shows points including many Y values at -27. The x,y scatter seen is identical to the miscalculation with Calc 7.1. Those "old" wrong values are nowhere on the sheet cells or I can't see them. But they are presented on the chart. Strange; everything's calculated twice? Once for Sheet display and again for Graphics Engine OLE? Testing "Recalculate Hard" causes the red chart to refresh and becomes correct. Diagnosis about why. I tested all available chart options; change scales, colours, fonts, titles, Delete the series, Add the series, plot the series on a secondary Yaxis . . . After Undo:delete, the red chart updates to it's good series only by... Double-click the chart then Right-click the Red plots. Then choose Format Data Series. Then Deselect (uncheck) "Include values from hidden cells" (set to off). Then OK. The red plot jumps to the correct Data Range values. If the file is saved with "Include hidden" on or off the Chart refresh is still incorrect at next Undo:delete. Also, it doesn't matter if the setting is on or off. It needs to be toggled. Toggle off to on or on to off both work. I have no experience about hiding cell values (it were preferable if someone familiar with "hide" could check over this single sheet file). However, the problem is cleared by setting OpenCL off. @Julien Do you prefer a separate new Bug Report? -- You are receiving this mail because: You are the assignee for the bug.
