Selecting entire rows and columns in Excel via keyboard shortcuts

Selecting entire rows and columns in Excel via keyboard shortcuts

One Minute Office Magic

I was unaware of these two keyboard shortcuts that make selecting entire rows and columns in Excel a piece of cake.

Here I have a basic table in my spreadsheet:


I clicked into cell A3 and pressed SHIFT + SPACE. Row 3 was highlighted to the end of the table row:


I again clicked into cell A3 and pressed CTRL + SPACE (^ + SPACE on a Mac). Column A was highlighted to the end of the table column:


This certainly beats my former technique of dragging the cursor around.

Ver la entrada original

State of the JavaScript Development World

State of the JavaScript Development World


JavaScript has become not just an essential Web programming language but vital in general IT development. The rise of JavaScript as the dominant Web Language was cemented recently by Matt Mullenweg. Matt is the CEO of Automattic, the owners of and leader of WordPress development strategy. In November of 2015 Matt introduced Calypso an entirely JavaScript-based front-end for WordPress. See our briefing on whats in Calypso here. Subsequently Matt said:

Learn JavaScript deeply.

Now given that WordPress is used on 26% of the world’s top 10 million websites:
this announcement carries some hefty usage weight. But JavaScript has been gaining presence in a number of major software providers like Facebook and Instagram where React.js is one of the key scripting components for Facebook, Instagram and now As well whole development ecosystems have arisen around delivering mobile apps either use Hybrid JavaScript frameworks like Ionic and OnsenUI [advanatge performance speed and maximum…

Ver la entrada original 2.812 palabras más

10 differences between an intranet and digital workplace homepage

Inside out

As intranet managers, from time-to-time we all do it, despite bearing the scars from the last time. We decide to re-launch our intranet homepage. A triumph of optimism over experience. We know we’ll get hate mail from users the day it launches no matter how good it actually is … but we just can’t help ourselves. And so it is now in BT. We’re full speed ahead on developing a new intranet homepage site which will be launched before Christmas.

I won’t bore you with all the gruesome detail, but when the idea was first conceived, it made me think about what needs to be different this time around from what we’ve previously offered up to BT employees. How does the homepage need to be different to support the BT Digital Workplace rather than the BT Intranet?

Knowing that no one reads blog posts anymore unless they are lists of…

Ver la entrada original 264 palabras más

Disable Sharepoint item events firing during item update

Complement the bellow post with a comment on it from user “Adam Carr”. As reference it claims:

“base.DisableEventFiring() & base.EnableEventFiring() have both been made obsolete in SharePoint 2010. Use the boolean property base.EventFiringEnabled instead.”

Adrian Henke's Blog

In Sharepoint, the attached item events are fired whenever you perform an item.Update()
Ryan posted a solution to this issue, using a custom event handler that disables the events upon request.

What I dislike about the solution, is the risk of leaving the events disabled. Assume an exception occurs, the code will never reach the line where the event firing is enabled (restored) again.

I suggest a using-pattern, much like the TransactionScope class used for db transactions in the entity framework.

Now we can use this class together with the using syntax to create a scope within all item event firing is disabled.

This way, the event firing is enabled again as soon as the code leaves the defined scope, be it through normal operation or by exceptions.

Update 1

For SharePoint 2010, use this snippet instead:

Ver la entrada original

Cohesion and coupling: good measures of quality

Cohesion and coupling: good measures of quality

Really the two must important? I think so, the comments are a short but useful debate.

Musing Mortoray

What is good code? Even if I say nobody cares about your code the quality nonetheless does influence a project. Functional correctness reigns supreme, but if we put that aside what should we look at next? Cohesion and coupling are the two most significant aspects of code impacting software quality.


Cohesion is how well the bits of a module fit together. A set of functions, an interface, is considered cohesive when each function is closely related to another. For example, log_error and log_warning are closely related and belong nicely together in a single log module. As functions diverge in their behaviour a module becomes less cohesive. For example, log_error and parse_json don’t seem to be related at all.

We can roughly measure cohesion by how succinctly the module can be described. Short and precise sentences are preferred to longer, verbose, and generic ones. Contrast “The log module records diagnostic…

Ver la entrada original 787 palabras más

Customize SharePoint Search Results Paging…!!!

Kamil's Blog

Recently I had a requirement to customize the OOB SharePoint search results paging control (SearchPagingWebPart). So below is the problem definition and the solutions I came across. (the link to the downloadable source code for the solution is attached at the end of the post)

OOB paging control gives you several options to specify and define the paging behavior.


Most important properties for me are the first two ones.

1) Maximum page links before current
2) Maximum page links after current

So with the above configuration paging will look like this:


Its fare enough so the current page is 1 and there are no pages to be displayed as previous links. so it will display only 3 after links.

When you navigate to a page in the middle it will look like this:


So its now displaying 4 before links with page numbers and 3 after links.

Ver la entrada original 596 palabras más