VIEW ANY FONT IN WORD, EXCEL FILES ON YOUR PHONE

Sometime you open a Word, Excel, PowerPoint file on your smartphone and the text is not readable or doesn’t make any sense. The problem is due to lack of particular font in which the document is originally written. With this tutorial you can now use any font on your phone with the help of Kingsoft Office. I have taken example of installing Punjabi Fonts, but you can install any other font as you wish.

This tutorial will guide you to view Punjabi fonts in Word, Excel, PowerPoint, Notepad  files on your android smartphone. Not only you can view Punjabi font but you can also edit it. This will resolve such problems when you are unable to read your document because of a particular font not present in your smartphone.

Things you need

  1. ‘Kingsoft Office’ app for your phone. Size 15.5mb (Download link here)

  2. ‘Kingsoft Office XPlats’ for windows. Size 4.07mb (Download link here )

  3. Various Punjabi fonts installed on a windows based PC

  4. A Facebook, Twitter or Google (gmail) account

Summary of Steps to view any font on your phone

  1. Install Kingsoft Office in your phone and Kingsoft Office XPlats in your PC

  2. Use XPlats on your PC to upload the required fonts from your PC to Cloud

  3. Use Kingsoft Office app on your phone to download the fonts from Cloud to your phone

  4. Now you are able to view documents saved in the fonts you just downloaded.

Detail of Steps to view Punjabi (or any other) Font on your Smartphone

     1. Install Kingsoft Office in your phone.

     2. Install required Punjabi fonts (like Asees, AnmolLipi etc) in your PC.

     3. Install Kingsoft Office XPlats v1.4  in your PC.

   4. Run XPlats on your PC. You will be presented with the following screen

start screen xplats

     5. Click on Sign in. There are three options to sign in as visible in the next screenshot.

sign in screen xplats

You can use your existing Google (gmail) account, Facebook account or Twitter account to sign in. Somehow the first two didn’t work for me. Though it may work for you. So I am going with the twitter option.

     6. Click on Twitter. Enter your twitter username and password. After successful login the next screen appears

(Note: If some certificate warning appears, click on ‘Yes’ to proceed)

authorise twitter on xplats

7. Click on Authorize app. On Next Screen, Click on Cloud Fonts and then System Option as shown in the red circles.

system fonts

Here all the fonts installed on your PC will be shown.

     8. Click on the required fonts and choose to upload. The selected fonts will be uploaded to the cloud, which we will be downloading in our smartphone later. I have selected and uploaded fonts like ‘AmritLipi’, ‘AnmolLipi’, ‘Asees’, ‘Joy’ etc which are the most popular Punjabi fonts.

     9. Click on the ‘Cloud’ option. You can see the fonts which you have successfully uploaded to the cloud.

cloud fonts option xplats

Major task is done here. Just a few steps on your phone remains

   10. Run Kingsoft Office app on your phone. Create a New Document and tap Blank Word. Tap on  Font Option. Again tap on Font. A drop down menu appears. There are two options here All and Cloud. Click on Cloud and then Try now.

Screenshot_2013-12-29-14-07-36    Screenshot_2013-12-29-14-08-05     Screenshot_2013-12-29-15-27-28

     11. Sign in with your twitter account. (or the account you used to Login in step 5). After successful login, the fonts you uploaded earlier from your PC will be shown here under the cloud tab. Download them all. This is all you need to do. Now open any Word, Excel, PowerPoint File on your phone (using kingsoft Office app). You will be able to view and edit the file with proper font.

Screenshot_2013-12-29-15-35-59     Screenshot_2013-12-29-15-34-49    Screenshot_2013-12-29-15-37-57

Please leave your comments below if you have any problem at any step. You can also follow me on twitter

RESTRICT ANDROID APPS USING INTERNET IN BACKGROUND

(note this tutorial is explained with android 4.2.2 settings running on a samsung galaxy grand smartphone)

1. Keep Background Data Restricted for certain apps

Most of the apps connect to internet by themselves even if they are not running in foreground, they eat your phone’s data as well as the battery life. By following this method you can not only save your internet data, also the battery life of your phone considerably. For this we have to restrict applications to use Background Data, so that they cannot connect to internet in background.
For certain apps which you don’t need to be running in background and consume data you can follow these steps to restrict them

Go to Settings-> Connections-> Data Usage

Screenshot_2013-11-19-10-44-36

You can see your total data usage for a certain period (set by the user) here. Scroll down to see data usage by all apps and activites

Screenshot_2013-11-19-10-45-19

Tap on any app to see the detail of data used. You can see the foreground and background data used by the app.

Screenshot_2013-11-19-10-46-02

Scroll down. Select ‘Restrict background data’ option. A tick mark will be placed in the check box. You are done now.  Similarly do for other apps.

There are two benefits here, firstly your internet data is saved and you have more control over your data usage. Secondly it saves your phone’s battery as the apps are unable to connect to internet in background.

(Note: Do this trick for only those apps which you don’t want to be using internet in background. If you restrict apps like whatsapp, facebook etc., you will no longer be getting notifications of these apps. Some apps which can be restricted are Google Play Store, Google Services, Google Search, Software Update, Youtube etc. You can manually check updates for these apps after few days)