[Bug 123285] New: problems with recalc and displaying cells

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=123285

            Bug ID: 123285
        Issue Type: DEFECT
           Summary: problems with recalc and displaying cells
           Product: Calc
           Version: 4.0.0
          Hardware: Mac
                OS: Mac OSX, 10.6
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: formatting
          Assignee: issues@openoffice.apache.org
          Reporter: jpmartin@iserv.net
                CC: issues@openoffice.apache.org

Created attachment 81568
  --> https://issues.apache.org/ooo/attachment.cgi?id=81568&action=edit
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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 123285] problems with recalc and displaying cells

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=123285

AuldSchool <jp...@iserv.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|normal                      |critical

--- Comment #1 from AuldSchool <jp...@iserv.net> ---
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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.