Issue 123285 - problems with recalc and displaying cells
Summary: problems with recalc and displaying cells
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.0.0
Hardware: Mac Mac OS X 10.6
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2013-09-18 15:52 UTC by AuldSchool
Modified: 2017-05-20 11:55 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

shows ghosted borders & values ind43:d49 and k43:49 should be blank. (547.90 KB, image/tiff)
2013-09-18 15:52 UTC, AuldSchool
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description AuldSchool 2013-09-18 15:52:01 UTC
Created attachment 81568 [details]
shows ghosted borders & values ind43:d49 and k43:49 should be blank.

Not even sure how to describe this, contents of cells seems to be okay, but displaying them is getting real goofy. Now using 4.0.0 but it seems this has always been a problem when I scroll down using (keyboard) arrows and then back up again (i.e having 30 rows displayed 6-37, going down to row 40 clicking above slider to go back up to row 5 and the display may 'ghost' some gridlines or I may now see two of row five.

I usually have some part of the window frozen. That may be a factor.

But now I am not getting recalculations or what really drove me here today I deleted something, it did not recalc. Shows up on screen, I check into the formula bar up top and nothing is there, click back into cell and an adjacent cell goes blank, and another cell shows partial top and bottom borders?!?

I've been a spreadsheet user since VisiCalc. So this is not something beyond my competence, I've been through all the preferences, etc. Have screen shots will add as attatched. All three are of the exact same spreadsheet after moving to various cells.

This recalc problem is really major though. Using an older MacBook, running 10.6.8 and was using OpenOffice for the past year. But since upgrading to 4.0.0 fairly recently I've noticed recalc doesn't always happen. Checked and autorecalc is ON.

Have more screenshots if you want them.
Comment 1 AuldSchool 2013-09-18 16:06:04 UTC
Should have selected critical as this really slows down the work. Been playing around trying to fix this on a simple checkbook sheet before going to the grocery store — for the last two hours.

Have tried using Recalc from the Tools>Cell Contents menu and sometime it recalcs, sometimes it doesn't. On my MacBook I don't normally use Fkeys as the also control volume, mute, screen brightness and I believe F9 is set for Exposé by default although I haven't used that much.

What does 'usually' get recalculations going is clicking in formula bar and without without changing anything, clicking the green arrow. But that didn't work either yesterday some of the time. Faux-Changing the formula (editing a 54 to 54) sometimes works.

Closing everything - I usually have at least three large spreadsheets - all multisheet) going at once - which is a hassle and re-opening OOO.

Wish I could tell you how to duplicate it, and was hoping it was a common bug… 

My instincts is that maybe I don't have enough memory going or its related to WindowFreeze somehow. My sheets are always too large (one of the four open files goes to 67xCF and it has two sheets) for easy scrolling without top & left panes frozen.