Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index

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

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?


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. .
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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.