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
--
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