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: [email protected]
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
