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

Reply via email to