very slow loading of a ods file

users
#1

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

#2

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.

#3

You seem to have done most of the diagnostic work here. Surely the next step is to create a fresh spreadsheet from scratch with similar data and see if it displays the same problem? If it does, post it somewhere where people can obtain it; they can then test it on different platforms and with different versions and attempt further investigation.

Brian Barker

#4

John R. Sowden wrote:
[...]
> 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.
>

Could you post a copy of that last file with only the date column somewhere so that others can test it?

#5

I've discovered a bit more. First to answer your question, the cells are formatted as date format 02/25 with no year, but if you look at the actual data it shows the year. I created this SS a few years ago, setting up the beginning and end of each month, then I expand each month inside the beginning and end. This is because I have a consolidated page (income statement) that uses the start and end addresses. By expanding inside the month, the inc stat cell addresses adjust automatically. Joe Connor looked a some data I sent him and found some of those 2014 original entries. I even found a 1901 entry, since he put me on that path.

But, it was my opinion that the problem was the date issue inside LO. I was wrong. I created a separate date column and entered all of the dates in text format. I then deleted the previous date column. Very minor change in speed of operation. I just rechecked the load time with the dates in text format. 2 minutes and 8 seconds. That was timed with my Heathkit digital clock that I built in 1972, so it might not be perfect :slight_smile: .

John

#6

Make a backup copy.
Select all (Ctrl+A)
Hit the backspace key and select Objects for deletion.
Hit Ctrl+Shift+Space (menu:Format>Clear Direct Formatting...)
Same with any other sheet.
With the raw data and formulas it should make a huge difference.

#7

well, that worked. I lost my bold titles, my 0,000.00 number format and my grayed out amounts between months.
Did those cause that, or was something else lurking in the background?
obviously, I will add them in each at a time and test each.

John