• Skip to main content
  • Skip to primary sidebar

Ravi Shankar

Tweaking Apps

  • Swift
  • Tech Tips

How to change starting page number in Excel 2010

July 19, 2012 By Ravi Shankar Leave a Comment

This post is in reply to the query posted by a reader that

My footer is starting with zero. Why?
I want it to start with one.

Excel 2010 footer page number by default starts with number 1and you can change the starting page number using the Page Setup option.

Step 1: Click the File menu and navigate to Print option.

image

Step 2: In the Print screen, click the Page Setup link available at the bottom.

Step 3: This would display the following Page Setup window.

image

Enter the starting page number for you footer in the First page number field. If you want to have the default behavior then keep the value as auto.

Step 4: Click OK button to confirm and save the changes.

By this way you can customize the starting page number in Excel 2010.

del.icio.us Tags: Excel 2010,starting,page number,first page number,change

Filed Under: Excel, Excel 2010, Office 2010 Tagged With: Change, Excel 2010, first page number, Page Number, starting

How to launch Word 2013 with blank document

July 18, 2012 By Ravi Shankar Leave a Comment

Word 2013 by default displays the start screen during the launch. But if you find this feature not useful and want to always open blank document when launching the application then you can use the settings available part Word 2013 options.

Word 2013 template

Step 1: Launch Word 2013 and click the File menu.

Step 2: From the left hand sidebar, select Options from the list.

Word 2013 options

Step 3: In the Word Options window, navigate to Startup Options under the General tab.

Word 2013 startup options

Step 4: Unmark the check box with label as Show the Start screen when this application starts. Then click OK button to confirm and save the changes.

Now when ever you launch Word 2013 it will open a blank document.

Filed Under: MS Office, Office 2013, Word 2013 Tagged With: Application, Blank Document, Startups, Word 2013

How to only enable portrait orientation for iPhone App

June 14, 2012 By Ravi Shankar 2 Comments

When developing an iPhone app in Xcode, if you have any requirement that only portrait orientation allowed then you can do the following.

Step 1: Open the implementation file for editing.

Step 2. Navigate to shouldAutorotateToInterfaceOrientation method. This methods is auto generated by Xcode while creating the project.

Step 3: replace the return statement with return (interfaceOrientation == UIInterfaceOrientationPortrait);. The update method should be displayed as shown below.

– (BOOL)shouldAutorotateToInterfaceOrientation:(UIInterfaceOrientation)interfaceOrientation

{

    return (interfaceOrientation == UIInterfaceOrientationPortrait);

}

This method will return true only when the orientation in Portrait mode.

Step 4: Now navigate to Project Folder on the navigattion bar. In the summary tab under Supported Device Orientations, make sure to un mark the other orientation except portrait.

Portrait Device Orientation

 

Filed Under: Apple, Develop, iPhone Tagged With: device orientation, dsiable, iPhone app, portrait, Xcode

How to rename default view controllers in XCode

June 11, 2012 By Ravi Shankar Leave a Comment

Xcode by default provides default name for the view controllers depending upon on the selected projects templates. For example, while creating Tabbed Application, you will find FirstViewController and SecondViewController as the name for default view controllers.

NewImage

Now if you want to provide a proper name to the FirstViewControllers and SecondViewControllers you can use the Rename option available under the Edit menu.

To rename FirstViewController,  

Step 1: Navigate to FirstViewController.h and select the name after interface keyword.

NewImage 

Step 2: Click the Edit menu then Refactor and select Rename from the list of available option.

NewImage

Step 3: Enter the name then select Rename related files and click the Preview button. This would display the list of files and location where the rename would affect.

Step 4: If you are happy with Preview then save the changes.

NewImage

By this way you can rename the default view controller and their related files (.h, .m and XIB) in Xcode.

Filed Under: Xcode Tagged With: rename, view controllers, Xcode

XCode – Open file in same window on double click

June 2, 2012 By Ravi Shankar Leave a Comment

Xcode by default displays project file in a seperate window when the user double clicks on the file. And if you want to change this behavior and to open the file in the same window as that of single click then you can use the options provided as part of Xcode Preferences.

Step 1: Launch the XCode Preferences, XCode menu -> Preferences or ? + ,

Step 2: In the General tab, navigate to Double Click Navigation option.

XCode double click

Step 3: Select Same as Click value from the drop down list.

Now when a user double clicks on a file, XCode will display the file in the same window.

Filed Under: Xcode

How to archive multiple email messages on iPhone or iPad

May 29, 2012 By Ravi Shankar Leave a Comment

This tutorial provides the steps required for archiving multiple email messages on iPhone or iPad. You can use the same procedures for deleting or moving more than one messages.

Step 1: Tap the Mail app on iPhone or iPad.

201205290908.jpg

Step 2: Select the mailbox for archiving email messages then tap the Edit button.

201205290909.jpg

Step 3: You can use the check box for selecting the email messages.

201205290911.jpg

201205290911.jpg

Step 4: Then tap the button available at the bottom of the screen to archive the message.

Step 5: You can also move the selected messages to a different fodder using the Move button or Flag the messages using the Mark option.

201205290915.jpg

Screenshot of delete option available for mail account configured on iPad

201205290916.jpg

Filed Under: Apple, iPad Tagged With: Apple, archived, iphone, Messages, multiple

How to retrieve the archived messages in iPad or iPhone

May 28, 2012 By Ravi Shankar Leave a Comment

This answers the query posted by a reader regarding “How to retrieve the archive messages in iPad “. The below mentioned steps can be used for seeing the archived messages of GMail account on iPad as well as iPhone.

Step 1: Tap the mail icon on iPad or iPhone.

201205282221.jpg

Step 2: In the Mail App, navigate to Accounts section and tap your Gmail account.

201205282223.jpg

Step 3: The GMail account Mailbox will display a folder named All Mail.

201205282224.jpg

The All Mail folder would contain all the archived message of GMail account on your iPad on iPhone.

Read: How to block contact in IOS 7 for iPhone

Filed Under: iPad Tagged With: archived, iphone, Messages, Retrieve

Provisioning iPhone 4S for deploying and testing Apps

March 31, 2012 By Ravi Shankar 1 Comment

Listed below are detail steps for provisioning iPhone 4S for deploying and testing Apps. The steps have been broadly classified in to the following topics.

  • Requesting Development Certificate
  • Submit Certificate in iOS Provisioning Portal
  • Installing Certificate
  • Registering Device to Provisioning Portal

Requesting Development Certificate

Requesting development certificate requires you to generate a Certificate Signing Request (CSR). The CSR can be generated using the KeyChain app available as part of the Mac OS. You can quickly launch keychain using spotlight search. Apart from generating the CSR, the Keychain app also generates the public and private key.

201203311214.jpg

Select Keychain Access preferences from the menu list and navigate to Certificates tab.

201203311227.jpg

Turn off the Online Certificate Status Protocol (OCSP).

201203311229.jpg

Now to request Certificate, click the Keychain Access menu, select Request a certificate from a Certificate Authority under the Certificate Assistant.

201203311244.jpg

In the Certificate Assistant window, enter your email address, name and mark the radio option with caption as Saved to disk also the check box with label as Let me specify key pair information.

201203311250.jpg

Save the generated certificate to your desktop.

201203311318.jpg

Then for the Key Pair information, select Key Size as 2048 bits and Algorithm as RSA.

201203311319.jpg

On clicking the continue button will display the following confirmation message.

201203311439.jpg

The login section under Keychain Access would display the generated Public key and Private key.

201203311440.jpg

Submitting Request in Provisioning Portal

Login to the members account with your Apple user id and password. Click the iOS Provisioning Portal link available under Developer Program Resources section.

201203311444.jpg

In the Provisioning Portal, navigate to Certificates section and click the Request Certificate button under Development.

201203311443.jpg

This would display a screen with option to submit the CSR.

201203311446.jpg

Choose the required CSR and click the Submit button. After submitting the status would initially be displayed as Pending issuance and later a download link would appear.

201203311447.jpg

201203311448.jpg

Now install the WWDR certificate and iOS developer Certificate on your Mac system

201203311449.jpg

201203311450.jpg

You can verify the installation of certificates by navigating to My Certificates in Keychain Access App.

201203311451.jpg

Registering Device to Provisioning Portal

You can use Xcode for registering the Device ID and this process also create the App ID. Launch Xcode, click the Window menu option and select Organizer from the menu list.

201203311454.jpg

This would display the list of available Devices that have been connected to the Mac system,

201203311455.jpg

When the device is connected, a green status light will be displayed. Now select iPhone 4S and click the Use for Development button. If your Device and Mac system are out of sync with the iOS SDK then you will get the message to keep both of them in sync.

201203311501.jpg

Once the device and Mac system are in sync, you can add the device to Provisioning Portal by right clicking on the device and selecting Add Device to Provisioning Portal.

201203311503.jpg

Xcode will request permission for accessing your Keychain, click Always Allow button and sign-in with your Apple Developer Account credentials. Also allow code sign to sign using your key in keychain.

201203311506.jpg

Now you can test your app on iPhone 4S by selecting the device from Active Scheme list.

201203311508.jpg

Filed Under: Develop, ios Tagged With: Apple, Blogging, deploying, iphone, Provisioning

  1. Pages:
  2. «
  3. 1
  4. ...
  5. 33
  6. 34
  7. 35
  8. 36
  9. 37
  10. 38
  11. 39
  12. ...
  13. 44
  14. »
« 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