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+unsubscr...@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
