• Skip to main content
  • Skip to primary sidebar

Ravi Shankar

Tweaking Apps

  • Swift
  • Tech Tips

Prevent users from adding new worksheet in Excel

January 25, 2016 By Ravi Shankar 2 Comments

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 change the permission. You can access Protect Workbook Structure from the Info menu.

image

Click the File menu and then navigate to Info menu and click the drop down arrow under Protect Workbook option. From the list of available option select Protect Workbook Structure. This would display the following Protect Structure and Windows. Mark the check box with label as Structure. If you want to password protect it then enter a password in the Password field. Click Ok button to save and confirm the changes.

image

Filed Under: Excel, Excel 2010, Excel 2013, Excel 2016, MS Office Tagged With: add sheet, Excel 2010, Office 2010, prevent, Protect Workbook Structure, Worksheet

Go To specific page number in Word

January 14, 2016 By Ravi Shankar 5 Comments

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.

Go To option in Word 2013 and Word 2010

Another shortcut for launching Find and Replace is by pressing Ctrl + G.

Find and Replace in Word 2013 and Word 2010

Navigate Go To tab and select Page option for Go to what and specify the page number under the textbox available under Enter page number label.

Also See: Insert and Save watermark in Microsoft Word

Filed Under: MS Office, Word 2010, Word 2013 Tagged With: Go To, Office 2010, Page Number, Tips, Word 2010, Word 2013

Fix for Directory not found for option error in Xcode

January 7, 2016 By Ravi Shankar Leave a Comment

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 removing the entry specified for “Framework Search Paths”

Filed Under: Uncategorized Tagged With: error, Xcode

Autocorrect in Word – Replace text as you type

December 8, 2015 By Ravi Shankar Leave a Comment

Autocorrect in Microsoft Word 2016, Word 2013, 2010 and 2007 has a feature called replace any text as you type. This tutorial provides an example for replacing text with text and image in Word document.

Replace text as you type in Word 2016, Word 2013, Word 2010 and Word 2007

In Word 2013 and Word 2010 you can access Proofing section by clicking File menu –> Options. To access AutoCorrect option in Word 2007 click on the Word Options and navigate to Proofing section.

Proofing section in Word document

And on clicking the AutoCorrect Options the following dialog box would be displayed. Under Replace text as you type, you can add the text which needs to be replaced it is typed in the Word Document.

Replace text as you type in Word

For example if you want dato be replaced with Digital Answers in word document, then add da to the left hand side and Digital Answers to right hand side then click Add button.

Replace text with text using Autcorrect

How to use autocorrect for replacing text with picture

Step 1: Navigate to Insert menu, click Pictures under illustrations section

Insert Pictures in Word 2013

Step 2: Using the Insert Picture dialog, select and add image to the document.

Select Picture Dialog in Word 2013

Step 3: Click File menu, select Options from the menu list.

Word Options in Word 2013

Step 4: In Word Option window, navigate to Proofing section and click AutoCorrect Options.

AutoCorrect Options in Word 2013

Step 5: Now enter the name under Replace text and make sure Formatted Text radio option is selected. (If you have not selected any image then this option will not be displayed)

Replace text as you type in Word 2013

Step 6: Click Add button to add the entry to AutoCorrect list. Then OK button on the AutoCorrect and Word Options to close the windows.

Now whenever you type the replace text, it will be automatically replaced with the image. If you are frequently going to insert company logo or your signature then you try this feature.

Formatted Text in Word 2013

Also See: Find Autocorrect entries file in Word 2010

Filed Under: MS Office, Technical, Word 2007, Word 2010, Word 2013, Word 2016 Tagged With: AutoCorrect, Proofing, Replace text as you type, replace text with image, Word Options

How to include original message in Outlook

December 8, 2015 By Ravi Shankar Leave a Comment

Microsoft Outlook users can include the original message while forwarding or replying to an email. The users can choose any one of the following options for original message

  • Do not include original message
  • Attach original message
  • Include original message text
  • Include and indent original message text
  • Prefix each line of the original message 

Listed below are the steps to access the message handling option in Outlook 2013, Outlook 2010 and Outlook 2007

Include original message in Outlook 2016, Outlook 2013 and Outlook 2010
Click File menu, select Options from the list.

Outlook Options

In the Outlook Options window, click Mail tab then scroll down Replies and and forwards section.

Replies and forwards option in Outlook 2013, Outlook 2010

Use the option “When replying to a message” and “When forward a message” to specify the option for original message.

Include Original Message in Outlook 2013, Outlook 2010

Include original message in Outlook 2007

Tools -> Options -> Email Options -> On replies and forwards section

Email Options in Outlook 2007Attach Original message in Outlook 2007

Using the drop down available under when replying to a message and When forwarding a message, you can choose any of the following values from drop down.

Include Original message text in Outlook

Also See: Close original message on reply or forward in Microsoft Outlook

Filed Under: MS Office, Outlook 2007, Outlook 2010, Outlook 2013, Outlook 2016 Tagged With: Attach Original Message, Email Options, Include Original message, Replies and Forwards

iOS Swift – Firebase Demo

November 26, 2015 By Ravi Shankar 4 Comments

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 for capturing name, date and image. These data are then converted in to required data type for storing purpose.

Installing Firebase in iOS SDK Project

The easiest way to include Firebase SDK to your iOS project is by using Cocoapods and the instruction are clearly given in Firebase documentation section. After installing the Firebase iOS sdk make sure to create a bridge file by adding the following import statement.

[code language=”swift”]#import Firebase/Firebase.h
[/code]

Firebase DataStore

User with Google or GitHub account can directly login to Firebase. The data stored in Firebase in JSON format. Find below a screenshot of the data stored by this demo app.

Profiles is top node and under which each row is stored as key/value pairs with name as the identifier for each row. Firebase provides a path (URL ) for storing the data which ends with firebaseio.com. You should be able find this URL in Firebase main screen.

[code language=”plain”]Example :- _unique_identifier_.firebaseio.com[/code]

Saving data to Firebase

You need to create a reference to Firebase class as shown below

[code language=”swift”]let firebase = Firebase(url:”https://_unique_identifer.firebaseio.com/profiles”)[/code]

replace _unique_identifier with the identifier provided for your Firebase account.

The following piece of code is used for saving the information to Firebase.

[code language=”swift”]@IBAction func save(sender: AnyObject) {

let name = nameTextField.text
var data: NSData = NSData()

if let image = photoImageView.image {
data = UIImageJPEGRepresentation(image,0.1)!
}

let base64String = data.base64EncodedStringWithOptions(NSDataBase64EncodingOptions.Encoding64CharacterLineLength)

let user: NSDictionary = [“name”:name!,”dob”:dateOfBirthTimeInterval, “photoBase64”:base64String]

//add firebase child node
let profile = firebase.ref.childByAppendingPath(name!)

// Write data to Firebase
profile.setValue(user)
}
[/code]

The above code does the following

  1. Converts image to to JPEG also compresses the size as we will be storing the image as base64EncodedString. 
  2. Creates a dictionary with name, image (String data) and date (as timeinterval).
  3. This dictionary is then added to the FIrebase Datastore by appending the name as the identifier for each row.
  4. And to save the data to Firebase, you need to call profile.setValue by passing the dictionary object.

Retrieving data from Firebase

Here again you need to create a reference to Firebase class by passing the required path as shown below

[code language=”plain”]let firebase = Firebase(url:”https://_unique_identifer.firebaseio.com/profiles”[/code]

In the following price of code, firebase.observerEventType is used for retrieving the data from Firebase account. The data gets refreshed in real time when ever any updates happen in the data store. This is really cool!!!

[code language=”swift”]func loadDataFromFirebase() {

UIApplication.sharedApplication().networkActivityIndicatorVisible = true

firebase.observeEventType(.Value, withBlock: { snapshot in
var tempItems = [NSDictionary]()

for item in snapshot.children {
let child = item as! FDataSnapshot
let dict = child.value as! NSDictionary
tempItems.append(dict)
}

self.items = tempItems
self.tableView.reloadData()
UIApplication.sharedApplication().networkActivityIndicatorVisible = false
})
}[/code]

snapshot referes to the collection of records store under a path. You can iterate through the collection to reteive each data item.

Delete a row from Firebase

[code language=”swift”]override func tableView(tableView: UITableView, commitEditingStyle editingStyle: UITableViewCellEditingStyle, forRowAtIndexPath indexPath: NSIndexPath) {
if editingStyle == .Delete {

let dict = items[indexPath.row]
let name = dict[“name”] as! String

// delete data from firebase

let profile = firebase.ref.childByAppendingPath(name)
profile.removeValue()
}
}
[/code]

 

Removing a row from Firebase can be done by calling removeValue method on the Firebase object reference as shown in the above code snippet.

In this tutorial, we have seen only the code related with Firebase. You can download the full source from here

Filed Under: ios, Swift Tagged With: Cloud, Firebase

Disable permanently delete items warning message in Outlook

November 22, 2015 By Ravi Shankar Leave a Comment

Outlook displays a warning message when deleting outlook emails. It displays a dialog box with message “Are you sure that you want permanently delete the selected items” as shown below

Are you sure that you want to permanently delee the selected items in Outlook

This is very useful warning option for the users before deleting the mail items permanently. But If you do not want to see the permanently deleted warning message then turn off or disable this warning message.

Disable warning message in Outlook 2016, Outlook 2013 and Outlook 2010

Click on the File menu –> Options and navigate to Advanced tab.

Prompt for confirmation before permanently deleting items in Outlook 2013 and Outlook 2010

Scroll down to Other section and clear the checkbox with label as Prompt for confirmation before permanently deleting items. Click OK to save the changes.

 

Turn off permanently delete warning message in Outlook 2007

This warning message can be disabled in Outlook 2007 by using Tools –> Options.

Go to Tools –> Options and select Other tab.

Outlook 2007 Advanced Optons

Click on the Advanced Options button. The following Advanced Options window would be displayed.

Outlook 2007 Warn before permanenly deleting items

Uncheck the “Warn before permanently deleting items” to disable the warning message.

Also See: How to turn off send without attachments warning message in Outlook

Filed Under: MS Office, Outlook 2007, Outlook 2010, Outlook 2013, Outlook 2016 Tagged With: delete mail items, Deleted Items, Disable, Outlook, Turn Off, Warning Message

Turn off display search as you type in Microsoft Outlook

November 22, 2015 By Ravi Shankar Leave a Comment

Microsoft Outlook provides option to display search results as we type the text in search box. This is a useful feature but if you think the real-time search result is a distraction then you can disable “display search as you type” feature using Search options. Listed below are steps to turn off this feature in Outlook 2016, Outlook 2013, Outlook 2010 and Outlook 2007

display search as you type in Outlook 2013

Outlook 2016, Outlook 2013 and Outlook 2010

Click File menu, select Options from the list.

Options in Outlook 2013

In the Options window, click Search Options and navigate to Results section.

Search options in Outlook 2013

Un mark the check box with caption as “When possible, display results as the query is typed”

turn off display results as the query is typed in Outlook 2013

Outlook 2007

display search results as you type in Outlook 2007

 

And to disable this feature, click on the drop down arrow available in the search box. This would display the following menus

Search Options in Outlook 2007

 

Navigate to Search Options and click it open the Search Option dialog box.

display search results as I type

 

The search section has an option for enabling or disabling the display search results as I type. By un ticking the checkbox this feature can be disabled.

Also See: 15 tips to use Google search effectively

Filed Under: MS Office, Outlook 2007, Outlook 2010, Outlook 2013, Outlook 2016 Tagged With: disable search, Microsoft Outlook, search as you type, Turn off search

  1. Pages:
  2. «
  3. 1
  4. 2
  5. 3
  6. 4
  7. 5
  8. 6
  9. 7
  10. 8
  11. 9
  12. 10
  13. ...
  14. 44
  15. »
« Previous Page
Next Page »

Primary Sidebar

TwitterLinkedin

Recent Posts

  • How to set preferred Wifi network on Mac
  • Attribute Unavailable: Estimated section warning before iOS 11.0
  • How to recover Firefox password from Time Machine backup
  • Show hidden files and folders on Mac
  • How to request a refund for apps in App Store

Pages

  • About
  • Privacy Policy
  • Terms and Conditions

Copyright 2022 © rshankar.com

Terms and Conditions - Privacy Policy