Listed below are the various keyboard shortcuts in Xcode 7. Symbols corresponding to Mac keyboard used are command (⌘), shift (⇧), control (⌃), option/alt (⌥) Build, Run, Test Build ⌘ + BClean ⌘ + ⇧ + KRun Tests ⌘ + URun ⌘ + R Debug Step Over F6Step Into F7Step Out F8Toggle BreakPoint ⌘ + […]
How to programmatically add AutoLayout constraints?
AutoLayout solves the mystery when designing app for more than one screen size and for both Portrait and Landscape orientation. This is done by adding constraints to the views using various Auto Layout options available as part of Interface Builder. As an iOS developer, you can also add these constraints programmatically using NSLayoutConstraints or Visual […]
A trick to flip a column upside down in Excel
Excel users can sort a column using the Sort feature available as part of Sort & Filter menu. But what if you want to flip a column upside down. Let us see this with an example column having some text values as shown below. We will not be able to apply sort feature directly on […]
Prevent users from adding new worksheet in Excel
Excel 2016, 2013 and 2010 provides an option to prevent users from adding new worksheet to existing Workbook structure. So if you are the owner of Excel file and you do not want to allow other users to add any new worksheet, rename or move worksheet then you can use Protect Workbook Structure option to […]
Go To specific page number in Word
In Word 2013 and Word 2010 you can go to specific page in the Word document using the Find and Replace dialog. To display the Find and Replace dialog, Navigate to Home menu and click on the drop down arrow under Find menu. Another shortcut for launching Find and Replace is by pressing Ctrl + […]
Fix for Directory not found for option error in Xcode
You might see Directotry not found for option error when opening an iOS 8 existing project in Xcode 7. This error because of the invalid path sepcifed from the Framework Path for the test target, (null): Directory not found for option ‘-F/Applications/Xcode.app/Contents/Developer/Platforms/iPhoneSimulator.platform/Developer/SDKs/iPhoneSimulator9.2.sdk/Developer/Library/Frameworks’ This can be fixed by selected the test target, navigating Search Paths and […]
iOS Swift – Firebase Demo
Firebase is a platform that allows web and mobile application to store data in cloud. In this article, we will see an example app written in Swift that uses Firebase for storing and retrieving data in real time. The source code for this demo is available under GitHub. This demo app consists of three fields […]
How to import text file in Excel
This tutorial is provided step by step instruction to import a text file in to Worksheet in Excel 2016 and 2013. For this demo, let us take the following sample data with the columns separated from tabs and spaces. Step 1: Launch Excel Workbook and click the Data menu. Then navigate to Get External Data […]