Re: [libreoffice-users] very slow loading of a ods file

On 04/29/2016 06:02 PM, John R. Sowden wrote:
> I wrote about this a few weeks ago, but got no response.  Now I have 
> done some testing and my results might cause someone to notice what 
> the issue is.  I am running Ubuntu 14.04 and LO Version 5.0.5.2.
>
> I have a spreadsheet of about 200k.  it is about 6 pages and there are 
> some links between a few pages. Page 2 is a ledger with dates in the 
> first column.  My dates start in the summer and end in the summer, not 
> on a calendar basis.  When I am scrolling or entering data after 
> December, the sheet slows to a point that a page down takes about 
> 10-15 seconds.  After copying to a test file, I deleted the pages 
> other than page 2 (with the dates), one page at a time, saving the 
> file each time.  I then try to more the cursor after December.  No 
> change for each page deleted.  On page 2 I started deleting columns, 
> doing the same test (save/test).  No change all the way to the date 
> column alone-no change.
>
> It also takes about a minute to load the sheet.  The progress bar 
> jumps to the middle of the screan, then crawls slowly to the end.
>
> I then copied another test sheet and deleted all entries below 
> December, calcs and cursor moves worked fine.
>
> Therefore I concluded that the problem is with the dates after 
> December.  I am doing no date math.  This seems like a LO internal 
> (Java?) problem.
>
> Thoughts?   Work Arrounds?
>
> John

let clarify it. . .

First, are the dates listed with or without the year - September 4th or 
September 4th 2015?

You had dates listed
June date
July dates
August. .
September
October
November
December dates
January dates
February date
and so on. . .

You are having slow down issues accessing the January dates and beyond?

I deal with making a list of monthly deposits with a graphic to the 
right of the deposit amounts.  I do not use any year info except in a 
"text" cell.

column 1        column 2                    graphic sideways bar graph 
based on the date and amounts

Dec. 24             $256.04
Jan. 25 2016     $356.35
Feb. 25             $389.45
March 23
  [March amount had not been added yet]

I do not use a date formatted cell for the dates in the first column.  I 
do not need it to be formatted.

Are you using a date formatted cell/column?  If so, then try the option 
to make the cell for the date from a date formatted cell to a text 
cell.  If that fixes the issues you are having, then there is some 
issues with the date formatting of that cell/column.

I do not know what the internal bug/issue could be, but if my idea of 
using text cells instead of date formated cell, then it may narrow down 
where the bug/issue.







--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted