It may be related to this issue: https://bugs.freedesktop.org/show_bug.cgi?id=74042 which claims to have been fixed in 4.2.1 but is still present in Version: 4.2.1.1 Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b
Dave -------- Original Message -------- From: Tom Cloyd <[email protected]> To: <[email protected]> Date: Tue, 18 Feb 2014 18:26:02 -0700 > 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
