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


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

Context


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.