Re: [libreoffice-users] Re: very slow loading of a ods file

2016-05-01 Thread John R. Sowden

On 04/30/2016 09:23 AM, Andreas Säger wrote:

Am 30.04.2016 um 00:02 schrieb John R. Sowden:

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.


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.

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


--
To unsubscribe e-mail to: users+unsubscr...@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


[libreoffice-users] Re: very slow loading of a ods file

2016-04-30 Thread Andreas Säger
Am 30.04.2016 um 00:02 schrieb John R. Sowden:
> 
> 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.
> 

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.



-- 
To unsubscribe e-mail to: users+unsubscr...@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