It seems that I have too many test versions installed to accurately recognise which one I am looking at.
Correction: The issue _HAS_ been fixed in 4.2.1.1 RC1 Sorry for the noise. Dave -------- Original Message -------- From: Dave Barton <d...@tasit.net> To: LibreOffice User's Help Forum <users@global.libreoffice.org Date: Wed, 19 Feb 2014 11:31:43 +0100 > 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 <tomcloydm...@gmail.com> > To: <users@global.libreoffice.org> > 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 <tomcloydm...@gmail.com> 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 <tomcloydm...@gmail.com> 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 <tim.ll...@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+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