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 :) .
On 04/29/2016 04:31 PM, Tim---Kracked_P_P---webmaster wrote:
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 184.108.40.206.
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
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
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
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 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: firstname.lastname@example.org
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
Impressum (Legal Info)
: 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