Hi :) No worries! It's what we are here for! :) The thing in my answer was to try Gnumeric http://projects.gnome.org/gnumeric instead of Calc/Excel for that 1 spreadsheet (or for all of them to make it easier).
Renaming (or deleting) the User Profile seems to fix something like 90% of weird problems that suddenly start but didn't occur before. It's a "magic cure all" worth knowing. I prefer renaming so i can go back (some day (if i ever get around to it)) to get details of why it happened. I keep meaning to back-up my User Profile when i get it just right but keep forgetting. Regards from Tom :) On 18 February 2014 15:56, Tom Cloyd <[email protected]> wrote: > 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 <[email protected]> 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: [email protected] >>> 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 > * << [email protected] >> (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: [email protected] 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
