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

I've discovered a bit more.  First to answer your question, the cells 
are formatted as date format 02/25 with no year, but if you look at the 
actual data it shows the year.  I created this SS a few years ago, 
setting up the beginning and end of each month, then I expand each month 
inside the beginning and end.  This is because I have a consolidated 
page (income statement) that uses the start and end addresses.  By 
expanding inside the month, the inc stat cell addresses adjust 
automatically.  Joe Connor looked a some data I sent him and found some 
of those 2014 original entries.  I even found a 1901 entry, since he put 
me on that path.

But, it was my opinion that the problem was the date issue inside LO.  I 
was wrong.  I created a separate date column and entered all of the 
dates in text format.  I then deleted the previous date column.  Very 
minor change in speed of operation.   I just rechecked the load time 
with the dates in text format.  2 minutes and 8 seconds.  That was timed 
with my Heathkit digital clock that I built in 1972, so it might not be 
perfect  :) .

John

On 04/29/2016 04:31 PM, Tim---Kracked_P_P---webmaster wrote:
> 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