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


Hey, thanks, guys. That's a ton of help. I've a bit more time today, and will pursue the problem.

There's also some great stuff in your email, Tom, for my carefully kept notes on LO, and especially on Calc., which I use a great deal every day. You took real time to give me that much info. I seriously appreciate this effort!

Thank you both for the quick and thoughtful response.

Tom

On 02/18/2014 01:51 AM, Tom Davies wrote:
Hi :)
If something worked and suddenly stopped working as if by magic then
the first thing to try is to rename your User Profile
https://wiki.documentfoundation.org/UserProfile

Renaming is better than deleting because you might have tons of stuff
in your profile (templates, galleries, Extensions, file-backups etc)
that you don't want to lose.  If renaming or deleting the User Profile
DOES work then you might be able to copy chunks of your old one back
and that can be a good way of trouble-shooting down to pin-point the
problem.  If you have deleted the User Profile then that is, of
course, impossible.  If you just renamed the User Profile then you can
leave the trouble-shooting to a day when you do find time (or never
but at least it's possible).  If renaming DOES NOT help then you could
rename the old one back without suffering any losses.

On the other hand it is quite possible that you don't have anything
exciting in your User Profile or that it might be a good time to start
afresh with reconfiguring LO's settings and with installing fresh
Extensions that you need now rather than trying to keep using ancient
ones or ancient versions of ones you don't really use any more.


If the problems happened straight after upgrading to a newer version
then reverting to an older version makes a LOT of sense.  Preferably
an x.x.4 or higher.  It's that 3rd digit that shows greater stability.
  The 4.1.4 should be about as solid as they get but some people are on
4.0.6 to get the extra stability of that although they miss out a lot
on features and compatibility with MS formats.  Although i have some
machines still on 3.5.(something) without really missing anything but
then my needs are modest for those machines.  Anyway, 4.1.4 is a good
release and it's worth carrying on following the 4.1.x branch as it
gets developed further and stability increases further.


However 30+ worksheets in a single file and 1Mb means it's quite a
huge file!  If you can't break it up easily (or even if you can but
don't want to) then it is well worth considering using a specialist
spreadsheeting program instead of Calc/Excel.  Both the later are
designed to integrate well with other modules/programs within an
office suite but means you are carrying extra baggage and your
computer is using resources to make it easy to switch into
Presentations, Drawing programs, and all sorts of stuff that you
probably don't need while using the spreadsheet.  A specialist tool
focussing resources on, and designed purely for handling, spreadsheets
might be better.

Gnumeric uses the same formats as Calc natively and can also handle
the relevant MS formats and is often found to out-perform Excel and
even Calc especially on low spec. machines.
http://projects.gnome.org/gnumeric
>From their News section the quick link to directly download their
latest Windows version is
http://people.gnome.org/~mortenw/gnumeric/gnumeric-1.12.9-20131128.exe
NOTE this directly downloads an Exe file!!!  I NEVER usually give
links like that because you don't know me and have no reason to trust
me so you really should try the first link and have a look around for
yourself before attempting any downloading!  The only reason i give it
this time is because i found it difficult to find on their site so i
just wanted to make it easier for you.

Regards from
Tom :)

On 17 February 2014 23:24, Tim Lloyd <tim.lloyd@gmx.com> wrote:
Tom,

my thoughts FWIW. I would suggest restoring the latest version, deleting
your user profile and trying again. This has been known to work in the past.

What operating system are you using?

is this an old file which has seen a number of different LO versions?

Cheers

On 18/02/14 03:33, Tom Cloyd wrote:
I'm reverting to ver. 4.1.4.2, after spending almost 40 min. this morning
trying to isolate a problem. I could reliable crash the problem by trying to
copy two cells in Calc to another location in the same sheet. I got this
error message:

/vector::_M_range_check

/I'm working and have no time to go beyond posting the problem here.
That's just the reality of my life this Monday morning. I'd attempt a bug
report, but every time I've tried that I've gotten lost in the sheer
strangeness of the process. No time for that either.

I can offer to share the spreadsheet in which the crash occurs, for what
that's worth. It has maybe 30 sheets and is about a meg. in size. I did find
that removing about 15 of the sheets appeared to stop the problem, for
unknown reasons.

t.
//


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



--


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Tom Cloyd, MS MA (LMHC, WA State)
Cedar City / St. George, UT, U.S.A: (435) 272-3332
* << tc@tomcloyd.com >> (email) << TomCloyd.com >> (website)
* Sleight of Mind blog: Sleightmind.com (mental health issues)
* Trauma Psych blog: http://thetraumapsych.wordpress.com
* Trauma! A PTSD blog: http://www.healthyplace.com/blogs/traumaptsdblog/
* Founder: Google+ Trauma and Dissociation Education and Advocacy community
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


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

Context


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.