{"id":2350,"date":"2018-02-09T21:12:15","date_gmt":"2018-02-09T21:12:15","guid":{"rendered":"http:\/\/www.dpscomputing.com\/blog\/?p=2350"},"modified":"2021-03-01T21:50:15","modified_gmt":"2021-03-01T21:50:15","slug":"libre-office-5-calc-paste-column-bug","status":"publish","type":"post","link":"https:\/\/www.dpscomputing.com\/blog\/2018\/02\/09\/libre-office-5-calc-paste-column-bug\/","title":{"rendered":"Libre Office 5 Calc Paste Column Bug"},"content":{"rendered":"

\"\"<\/a>For the as yet uninitiated, Libre Office<\/a> is a freely available alternative to the popular Microsoft Office suite.<\/p>\n

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

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.<\/p>\n

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.\u00a0 Calc has the look and feel of Excel, so just as you would do there, you click the cell letter heading:<\/p>\n

\"\"<\/a><\/p>\n

Once selected, you can then press CTRL + C (or right click, copy) to copy the column.\u00a0 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:<\/p>\n

\"\"<\/a><\/p>\n

Now there are two ways you could approach the next step.\u00a0 First you might select the first cell of the column where you want to move the data to:<\/p>\n

\"\"<\/a><\/p>\n

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:<\/p>\n

\"\"<\/a><\/p>\n

But whatever you do,\u00a0don’t do it!<\/strong><\/em>\u00a0<\/em> 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!\u00a0 Doing so will almost immediately crash Libre Office 5 Calc.\u00a0 If you leave it a little longer, it may well even crash your computer.<\/p>\n

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.<\/p>\n

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!).\u00a0 Hopefully, it’ll be fixed in Libre Office 6 – we’ll let you know when we find out!<\/p>\n","protected":false},"excerpt":{"rendered":"

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.\u00a0 But if you want a...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[55],"tags":[1921,2101,2100,2099,2096,2097,2098,2092,2093,2095,2094,1934],"class_list":["post-2350","post","type-post","status-publish","format-standard","hentry","category-articles","tag-bug","tag-calc-column","tag-calc-copy","tag-calc-copy-bug","tag-column","tag-copy-and-paste","tag-copy-column-bug","tag-libre-office","tag-libre-office-5","tag-libre-office-5-calc","tag-libre-office-calc","tag-office"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p3nsfA-BU","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/posts\/2350","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/comments?post=2350"}],"version-history":[{"count":4,"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/posts\/2350\/revisions"}],"predecessor-version":[{"id":3078,"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/posts\/2350\/revisions\/3078"}],"wp:attachment":[{"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/media?parent=2350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/categories?post=2350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpscomputing.com\/blog\/wp-json\/wp\/v2\/tags?post=2350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}