Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index

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.


On 03/15/2016 11:55 AM, Dave Liesse wrote:
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

On 3/15/2016 10:14, John R. Sowden wrote:
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.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.