Hi :) I think it might be best to start a new thread with a fresh new email to the Users List
[email protected] (capitals or lower-case makes no difference in email addresses except that CamelCase is easier to read) A new subject-line mentioning "broken links" might attract the attention of the right people. I have no idea about this topic. Regards from Tom :) On 19 February 2014 01:26, Tom Cloyd <[email protected]> wrote: > UPDATE re: the below problem: > > This is very odd. Here's an example of what I'm seeing: I have a hyperlink > from a cell in sheet C to a cell in sheet A. I click/double-click the link. > Nothing happens. I inspect the link, and where the link target URL should be > I see "!!br0ken!!" > > But the tool-tip over the link advises me to try "Ctrl-click...." and that > actually works. > > Is this the default? Could be, for all I know. And why does the link > indicate it's broken, yet it still works? > > I can make NO sense of this, I'll admit. > > t. > > ========= > > > Tom, > > Well, I'm back on ver. 4.2. I have a lot of files in Calc with links - to > various sheets, and to other files. THEY ARE ALL BROKEN NOW. > > This is a disaster, and reverting LO isn't, I think going to fix it. > > Sigh. > > Re: faster load/save of files - xml is a text format, and will necessarily > be slower than a binary equivalent - that's my understanding, anyway. I > noticed quite some time ago, when converting from Excel to Calc that the > save took about 3 times as along. > > t. > > On 02/18/2014 10:12 AM, Tom Davies wrote: >> >> Hi :) >> Thanks! :) >> >> Xml is the way all the office formats are going. It does have 3 main >> advantages afaik; >> 1. When things go wrong it's easier to poke around inside and maybe >> even fix corrupted files >> 2. It's easy to compress further into Zip or other compression formats >> 3. errr, oh i thought it was faster and easier to load/save but i've >> never seen anyone produce stats about it. Now you mention it i've no >> idea whether it feels faster or slower to open files. >> >> As for your User Profile, it might be a really good idea to >> occasionally create a back-up copy in the same way and then keep the >> one with the settings you like best to put on any machine just before >> installing LibreOffice or OpenOffice so that you get all your fav. >> settings but with all the relevant updated bits added by the >> installer. >> >> Regards from >> Tom :) >> >> >> On 18 February 2014 16:41, Tom Cloyd <[email protected]> wrote: >>> >>> Tom, >>> >>> I have to say that nothing makes me smile quite like a quick, detailed >>> response to a problem reported to a user discussion list! >>> >>> For years, the absolute best list in this regard I've experienced has >>> been >>> that for the Lilypond music engraving software, but LO's list is surely a >>> close second. >>> >>> As for gnumeric - that's totally new to me. I like calc, but do NOT like >>> the >>> fact that it save files in xml and thus they are large and slow to save >>> and >>> retrieve. There's just no need for that. Xml should be an option, with >>> binary the default, in my opinion. Will definitely give gnumeric a try. >>> >>> Thanks for the profile-renaming tip. I followed your advice, and thus >>> saved >>> my dictionaries - probably the single most valuable thing in my user >>> profile. >>> >>> Thanks again for all the help! >>> >>> Tom >>> >>> >>> On 02/18/2014 09:32 AM, Tom Davies wrote: >>>> >>>> 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 >>>>> >>>>> >>>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>>>> >>> >>> -- >>> >>> >>> >>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>> 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 >>> >>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>> > > > -- > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > 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
