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