Libre Office 5 Calc Paste Column Bug

For the as yet uninitiated, Libre Office is a freely available alternative to the popular Microsoft Office suite.

Now if you’re looking for Sharepoint, you’re in the wrong place.  But if you want a good word processor or spreadsheet application at a infinitely cheaper price (i.e. free!) then look no further.

However, we have come across a teensy weensy bug that’s a little bit frustrating – so we’re giving you the heads up now so you can avoid it.

When using Calc, Libre Office’s answer to Excel, you’ll probably find now and then that you want to copy a whole column and paste it over on another column.  Calc has the look and feel of Excel, so just as you would do there, you click the cell letter heading:

Once selected, you can then press CTRL + C (or right click, copy) to copy the column.  After you’ve done this, you’ll notice the familiar dancing dashed line around the area (in this case the column) that you’ve copied:

Now there are two ways you could approach the next step.  First you might select the first cell of the column where you want to move the data to:

But another way that will be familiar to many spreadsheet users is selecting the column itself – just as we did before we copied the last column, by clicking on the column header letter and selecting the whole target column:

But whatever you do, don’t do it!  Well the select part is OK, but if you’ve selected the whole of the target column as in the image above, do not, under any circumstances press CTRL – V (or paste) now!  Doing so will almost immediately crash Libre Office 5 Calc.  If you leave it a little longer, it may well even crash your computer.

So just to be safe, when copying one column to the other, make sure you use the first cell selection method and not the column selection method.

It’s a little bug and it’s a bit annoying if you do it accidentally (which hopefully after this heads up you won’t do now!).  Hopefully, it’ll be fixed in Libre Office 6 – we’ll let you know when we find out!

 

Sorry – We’re Back With You Now!

Hi everyone,

Just a quick message to apologise to those of you that have been visiting posts and experiencing a 500 Internal Server Error and seeing blank pages – not good at all.

Good news is, we’ve found the problem and fixed it.

If you do have any more issues, please do contact us and let us know and we’ll get to fixing it straight away!

Thanks,

DPS David.

Twitter ‘Embed Tweet’ Preview Bug

Twitter logo

I know what you’re thinking – ‘Shut the door, Twitter has a bug’.

Well yes it does, and we’ve found it – but thankfully it’s not too much of a biggie.

Those who have embedded a tweet, for example, on a website or blog will be familiar with the following screen:

All is fine here.

If you’ve ever embedded a reply to a tweet you’ll see a similar screen, but with extra options regarding the parent tweet:

Still, nothing out of place here.

But if you uncheck the ‘Include parent Tweet’ checkbox you may notice your browser window getting longer and longer, with the scrollbar getting smaller and smaller.  So what’s behind the page growth?:

Taking a look at the preview section below, you’ll notice that the preview isn’t clearing the previous preview and regenerating it but is instead just tacking it onto the end of the last preview.  Hit the checkbox a few more times and you’ll get a few more.

If you’re really bored and are looking for something to do – and in the spirit of full disclosure, yes I did, for a minute or so – you can keep clicking the ‘Include parent Tweet’ checkbox and see how large you can make your browser window without crashing your browser or computer.

It’s not often we see bugs fly through onto a live site by a company as big as this, but it’s not impossible.  It always goes to show that it doesn’t matter who you are, you need to QA your code before it goes live to the world!

Matt Hancock MP Launches App To Bemusement Of General Public

Matt Hancock – some people know him, some people don’t – he’s the current Digital, Culture, Media & Sport secretary of the United Kingdom and forms part of Her Majesty’s Government.

His department is the former Culture, Media & Sport department and in an effort to show that he considers ‘Digital’ an important part of his role, he’s embraced the world of digital and employed a development agency to make an app.  A phone app.  An app you can use on your tablets.  An app all about…

Matt Hancock

Introducing the new ‘Matt Hancock’ app!  To quote an early adopter, Robert Hutton, “it’s like having an actual Matt Hancock in the palm of your hand!”.

Stills are from the intro video that you are greeted with after first launching the Matt Hancock app.  The purported aim of the app is to engage with his local constituents in West Suffolk but, needless to say, in a matter of days, Matt Hancock has gone global.  OK, global *may* be a slight exaggeration but he’s certainly gone national.  Absolutely further than West Suffolk.

Although no, I’ve not personally joined the Matt Hancock revolution yet.

What’s It All About?

Well, leaving connecting with constituents to one side, it’s social media, kind of Facebook-esque (old world, not current!) and people can be social with each other.

But… rather than having Mark Zuckerberg to idolise like a god you have Matt Hancock.  Matt Hancock has put himself all over the app.  You can check in on what Matt Hancock is currently doing.  Look at what he’s having for tea.  Have a look at the latest selfie he’s taken.

But, it’s not a vanity project… honest!

Who Are The People Using It?

Good question – at the moment, journalists have jumped all over.  Also, Matt Hancock seems to have a lot of ‘fans’ that have also joined up.  Also, following his new found fame with the launch of the eponymous app, a whole cross section of society appear to have signed up.  International take up appears low at this time, but it’s early days.

Whilst users of the worlds biggest social networking site Facebook are sometimes unofficially known as ‘Facebookers’ or ‘Zuckers’, following on in a similar fashion, users of Matt Hancock are affectionately (yet unofficially, as far as we know) known as ‘Mancocks’ or just ‘cocks’ for short (hence the 17+ app rating).

What’s Not To Like?

Well, not much I guess.

The department of Digital, Culture, Media and Sport, which oversees the Information Commissioners Office, stresses the importance of app developers following it’s official guidance for privacy in mobile apps.

Seems developers Disciple Media may not have got the memo though.

Given the recent debacle surrounding allegedly “handsy” MP’s, Matt Hancock sure wants to get his hands on your data:

But, at least he asks.

Will Matt Hancock overtake Facebook?  Only time can tell.

For now, we’ll leave you with Matt Hancock singing ‘Don’t Stop Me Now’ in the style of Queen – enjoy!

Too Many Authentication Failures – Filezilla

TFileZilla logorust me, we’ve all been there.

And yes, it is immensely frustrating.

Picture the scene – you’ve been good and decided to use key based SSH for securely transferring files between your servers and local machines.  You’ve disabled password access to shore up security even more.  You’re used to using passwords – but keyfiles are no biggie.

Until…

“Too many authentication failures”

Panic can certainly start to set in, particularly as Filezilla continues to try and connect when it’s clearly not going to work no matter how many times it tries!  You’re asking yourself why oh why it would attempt such a futile task.  But really, the only question you want answering is why its not working properly.

And usually, the solution is fairly simple.

Keys saved in Pageant

Pageant, or the PuTTy authentication agent, is a handy key repository used by not only the PuTTy SSH/Bash client but also other third party software – including Filezilla.

You load up your first key, go to Filezilla and all is OK.  For Now.  Maybe.

But you add a few more keys and bang, the sh*t has hit the fan.

What’s Up?

Or more like, what’s down?  And the answer to that question will be access to your server from your IP as you do your best imitation of a brute force attack.  Don’t panic though, there’s a fairly reasonable way around it.

Yes Pageant plays nicely with a few keys.  But Filezilla will try each one in order and any reasonably configured server will only allow a few attempts before it decides you are trying to brute force your way.

Fortunately, the answer is fairly simple…

Unfortunately, it means not using Pageant for Filezilla.

Filezilla Key Configuration

Although when you used Pageant and only had a couple of keys you didn’t have to do this and life seemed so much easier, for server / website admins with more than a few sites to manage, it’s more heartache than it’s worth.

You’ve probably got a site configured currently that looks a bit like this:

Head over to the Logon Type dropdown and you’ll notice a Keyfile option – give that a press:

Your password input box will disappear to be replaced by a key file input box:

Go ahead, click on ‘Browse…’ and select your key file.  Job done.

Next time you try to connect to your server, it’ll only try the appropriate key file preventing any pesky brute force look-a-like ‘attacks’ as you try to login.  Enter your key password and boom, you’re in!