GNOME Bugzilla – Bug 130424
Cells aren't redrawn automatically
Last modified: 2004-12-22 21:47:04 UTC
Since version 1.2.2, there appears to be an issue with redrawing cells. I think it applies only to cells with a background. I suspect that the fixing of bug 64297 has something to do with this, though, that's just my guess. I have narrowed down the issue in a sample spreadsheet and will post it as an attachment to this bug. The following steps will show what's going wrong: 1. Display Sheet2. 2. Select the range C4:E4. 3. Autofill the range C4:E6. Range C5:E6 is still empty, which is a bug. 4. Click on cell C4. Range C5:E6 is redrawn. 5. Display Sheet1. 6. Click on cell B2. 7. Type in `0' and press [Enter]. 8. Display Sheet2. Columns D and E doesn't display `zero' values, which is a bug. 9. Press [Ctrl]+[A]. 10. Click on cell C4. Columns D and E are redrawn.
Created attachment 22850 [details] sample spreadsheet
Confirmed 1-4. (Have not tried the rest.)
This is related to the manual recalc. The patch was subtle, and very low level. Thankfully it's simple enough that I'm pretty sure it's correct. A Done for head.pplied to 1.2.x and HEAD. It will be in the 1.2.5 release. The core of the issue was that we depended on a recalc to provide the initial values to display for expressions. However, with manual recalc that was not happening. The proposed fix is to add a new state that recalcs new expressions that need to be displayed. This will force the reval of other cells, which violates manual recalc, but we'll need to make larger changes to handle that case.
Version 1.2.5 still fails on the 2nd issue of the sample spreadsheet. Should this bug be reopened?
2nd issue ? I'm losing track of what is what. Please open a new report with just that. In general please try to limit reports to single problems. It makes things easier to track. We can merge reports with impunity, but splitting them takes more work.