Slow Loading a calc sheet

users
#1

xubuntu 14.04 lts, LO v5.0.5.2

When I load a calc file it takes a long time. The progress bar at the bottom immediately goes the the middle, then stops. I have timed it at about 40 seconds until the file is opened. This seems to be an issue only with my "checkbook". We are on a non-calendar fiscal year. The scrolling through the sheet slows tremendously at the point when we switch from december to january, about line 250. None of the other sheets in the file are more than 100 lines long. This computer has 4 GB ram. Also I do no 'date math' on the date column, but the date column (1) is formatted to MM/DD.

thoughts?
John

#2

I've had slow-loading sheets, but they were always large with a lot of calculated fields -- my computer also has 4GB RAM, but I don't remember the processor speed (it was 3rd-fastest available when I got the machine, but that's about 5½ years ago now). Do you, perhaps, have a number of non-displaying calculated fields? That's the only thing that comes to mind.

Dave Liesse

#3

No. I can't think of why I would have non-displaying calculated fields, except doe a hidden column, and not on this file.
I think it has something to do with the date column. I just tried a file of the same structure a couple of years old. It loaded much faster (5-10 seconds), paused for a bit with the progress bar in the middle. but nowhere as slow. In the months after December, it even takes a while to move horizontally. I do calcs of 3 balance columns, links to a chart of accounts in a different page of this file, and others. It seems that even though I am not using the date field as a data, it still is causing LO grief. I think I will convert this column to text to see if it makes a difference.

John