HOW TO VIEW PUNJABI, HINDI AND OTHER FONTS ON YOUR ANDROID PHONE WITH WPS OFFICE

Here comes another tutorial which will guide you to install various fonts on your android phone so that they can be viewed in word, excel, power point files with the help of WPS Office. After completing this tutorial you can read/edit those documents which comes with fonts which are not otherwise present in your phone and they are not displayed properly.

Things you need:

  1. WPS Office installed on your phone.

  2. Various Punjabi, Hindi and other fonts which you need.

  3. ES File Explorer installed on your phone (Or any other capable file explorer).

Steps:

  1. Install WPS Office from here (Size 21 mb, Latest version is 9.2 at the time of writing of this tutorial).

  2. Install ES File Explorer from here (Size 4.38 mb, Latest version is 4.0.2.3 at the time of writing of this tutorial).

  3. Open WPS Office app once and close it.

  4. Open ES File Explorer on your phone and make hidden files visible. To do this tap on upper left Corner>Settings>Display Settings>Show hidden files. Make sure to ‘tick’ this option. Screenshots are given below for your help.

Screen 1    Screen 2    Screen 3      Screen 4

4. Place your fonts (Punjabi, Hindi, Others) in .fonts folder. For this Open ES Explorer, tap on Internal Memory Drive of your phone (usually denoted by 0) > Android > data > cn.wps.moffice_eng > .cache > KingsoftOffice > .fonts. Paste all your needed fonts in this folder. Check the screenshots for help.

Screen 5      Screen 6      Screen 7      Screen 8      Screen 9      Screen 10

In case if you need some popular punjabi fonts like AmrLipi, Anmollipi, Amritboli, Amrit-Lipi2, AmritLipi, AnmolKalmi, Asees, Joy, GurmukhiLys20 etc i have uploaded these for you. DOWNLOAD PUNJABI FONTS (Size 246kb, rar file, you have to extract these fonts from archive to use them)

5. Open WPS Office.

6. Now you will be able to view and use installed fonts. If not working, close WPS Office and open it again. 

MI POWER BANK REVIEW

Product : Mi Power Bank (10400mAh)

Model : NDY-02-AD     Colour: Silver

Price : Rs. 999 (as per Sept 2014)

BOX CONTENTS

Power Bank, USB Cable (about 16 cms length), User Guide

20140903_165046

SPECS

Charging Time : About 10 hours with 1.0 A charger, About 5.5 hours with 2.0 A charger

Capacity : 10400 mah

Weight : 252 grams (approx)

Ports : One USB port (output), One mini USB port (input), One Power check Button, 4 white LED Indicators

REVIEW

MI Power Bank is a portable charger available exclusively on Flipkart (India). You can charge any device which can be charged by a usb cable. It comes in a small box.

20140903_161919

Flipkart Box

20140903_162228

A small box

Its build quality is good with aluminium coating on top which is water and rust resistant.

20140903_162932

Protective covering on ports

20140903_163519

Peeling off the protective covering

20140906_102307

Power Check Button, LED Lights, Input Port, Output Port

You can check the remaining power by pressing the power button on top. Each led light indicates 25% of the capacity. If on pressing the power button, only led 1 is blinking, it means your power bank is 25% charged. If 2 led lights are blinking then 50%, Similarly 4 flashing leds indicates that your Power Bank is fully charged. In the same way, while charging your Power Bank 4 led lights indicates the level of charge. If led 1 is stable and led 2 is blinking, it means your Power Bank is charged by 25%.

20140903_163029

Information on bottom

PROS

1. Compact for the capacity

2. Good Build Quality

3. Good Performance

4. Good Value for money

CONS

1. Can only charge one phone at a time

2. No charger provided with the product

2. Led lights can’t be put off while charging phone

ASUS ZENFONE 5 REVIEW

I will be comparing most of the aspects with Samsung Galaxy Grand 2 as it is my Primary Phone.

SPECIFICATIONS

Model: Asus Zenfone 5 A501CG 8GB

1.6 ghz dual core intel atom processor with hyper threading

2 GB RAM

PowerVR 544SGXmp2 GPU

Android 4.3 (upgradable to Android 4.4 Kitkat)

5 inch HD IPS (294 ppi) display

8 MP auto focus rear camera with led flash

2 MP front Camera

BOX CONTENTS

Phone with Battery, Asus Earphones with ear plugs, Asus Charger, Asus Data Cable, User Manual, Warranty Card.

20140821_160228

20140821_160320

DESIGN/LOOKS

Zenfone 5 looks trendy and slim. Its built quality is very good. The back is made of plastic which is very soft to hands. Weight of the phone is 140 grams, feels much lighter then Grand 2 which weighs 163 grams. The phone is pretty slim, maximum width is 8.8 mm in center, from sides it is much more slimmer.

There is Notification LED which glows red when battery is low, Orange while the battery is charging, Green when the battery is fully charged, and Green if there is any notification. But the notification led is a tiny one, and is not visible from far away, only visible properly when you are looking from above the phone.

 

20140821_215809_LLS

20140821_215919_LLS

20140821_155255

DISPLAY

5 inch HD screen is a good one. Just slight color difference when tilted, otherwise good viewing angles. Colors are slightly dull in compare to Grand 2, say by 10%. Pixels are not visible as it packs a good pixel density of 294ppi. The display is quite reflective and you have to maximise the brightness in sunlight to view it properly. Also the display attracts finger prints easily. But the touch is very smooth and easy to operate. Corning Gorilla Glass 3 protects the screen from minor scratches, so you don’t need a screen guard for this one. Overall the display quality is a very good one.

STORAGE

Out of 8 gb internal memory, 4.8 gb is available to install apps. Out of the 2 gb ram, about 1.4 gb ram is available on first boot. Once installed most apps can be moved to external card (along with data)

Screenshot_2013-11-09-11-00-34    Screenshot_2013-11-09-10-58-13

PERFORMANCE

The phone runs completely lag free. The dual core processor actually work as a quad core one as it supports hyper threading. Installing apps takes half of the time when compared to Grand 2. The phone heats up a bit while gaming or other cpu intensive tasks and specially if the screen brightness is set to high, but its not a major concern.

Screenshot_2014-08-21-22-09-52

AUDIO QUALITY

Volume of speaker is not very loud. But its still good. Ringtone is loud, vibration is strong enough. During calls the audio reception is not of a great quality (only at highest audio level), but again its good enough. Microphone is good, there is no problem hearing your voice at the other end. Asus headphones are good ones.

CAMERA

Camera captures pretty good photos. By default it captures photos in 6MP (wide) format. But you can change it to 8MP (4:3) in settings. Photos captured in daylight are pretty good. In low light photos are bit grainy. Led flash is good for near objects. Led flash is weaker by 10-15% compared to Grand 2. Still the photos are good as you can see in samples. Full HD video recording is also of good quality. Front camera is also good.

Jpeg

(In Sunlight)

Jpeg

(Without Sunlight during day)

Jpeg

(In Sunlight)

Jpeg

(In complete dark with flash)

Jpeg

(Low light with flash)

BENCHMARKS

Running Antutu Benchmark gives a score of 19608 which is a very good score. Antutu benchmark suggests graphics quality to be excellent, fluently supports large mobile games.

Screenshot_2014-08-21-22-14-53             Screenshot_2014-08-21-22-15-39

GAMING

Most of the games i tried run lag free even on high settings. These include Asphalt 8, Rayman Fiesta Run, Temple Run OZ etc

BATTERY

2110 mah battery takes about 3 hours to fully charge from 0 to 100% (with single sim and data off). The battery life turned out to be average specially if you are using dual sim. But i found the battery life good enough when using single sim with power saving mode set to optimized mode. Battery falls by 1-2% overnight (with single sim and data off). With less usage, battery can easily last for more then 2 days as is evident from the screenshot below. (2 days 22 hours on battery includes phone calls of nearly 1 hour, 2 hours of internet over wifi, power saving mode on all the time, data off all time)

Screenshot_2014-08-27-19-05-14

Other Features :

USB On The Go (OTG) support.

Accelerometer, proximity, light and magnetic sensors

Dual Sim (dual standby). Both sims are Micro Sims and both supports 3G. But 3G can be used only on 1 sim at a given time. Both sims supports WCDMA and GSM

MicroSd slot for support of memory cards upto 64 gb. It supports MicroSD and MicroSDHC cards.

Dual Microphones, one at the top and one at the bottom

Notification Led is present

Glove mode to use the touch screen with gloves

Phone supports Hindi font by default, and hindi language is visible in Whatsapp and other apps. Punjabi font is not supported

Wifi Direct, Wifi Hotspot, Tethering through USB, via Bluetooth is present. Wifi works fine.

 

Conclusion :

Asus Zenfone 5 is one of the best phone in the budget of Rs 10000 as of now. Asus also provides timely OTA updates to the phone, as you can see in the screenshot.

Screenshot_2014-08-21-10-17-39

 

Any queries are welcome in comments below.

LAVA IRIS 406Q REVIEW

Quick Specs : 1.2 ghz quad core qualcomm processor, 1 gb ram, Adreno 305 gpu, Android 4.3, 4 inch tft display, Dual Sim (dual standby), 5 mp fixed focus rear camera.

Box Contents : Phone, Battery, Flip Cover, Earphones, Charger, Data Cable, Screen Guard, Warranty Card.

Design and Looks : Looks are not that great, as the phone is bulky (10.6 mm at width). Weight is 135 grams approx. But it is good for a budget phone. Build quality is average. A minor fall in my case, left 1/3rd of display ‘black’ on 2nd day of usage. Got it replaced for Rs 1800

Display : Tft Display has average viewing angles, brightness and color production. The display is of 480 x 800 resolution (233 ppi). Pixels are visible if you look close.

Storage : Out of 4 gb internal memory, 2.5 gb is available to the user. (1 gb of which is allocated to install apps). Out of the 1 gb ram only 924 mb ram is available. Free Ram on first boot is about 400 mb. Apps cannot be moved to external storage.

Performance : The interface of the phone is smooth. Navigating through menus is lag free. There is minor stutter sometimes while opening gallery etc. but its not a deal breaker. Lava has promised kitkat update for this one (mentioned on the box) which will make the phone a bit more fast.

Sound : The audio quality is good and loud.

Benchmarks : Running Antutu Benchmark gives a score of 16596 which is good score considering the budget.

Screenshot_2014-05-16-19-22-00

Camera : Camera Quality is good for a budget phone. The shots in daylight are good. But indoors the shots turns out to be grainy (as with most phones). The led flash isn’t that great when taking night shots. Phone supports HDR, Panorama, Continuous Shot etc.  Video recording is in 720p resolution and is of ok quality. Front camera is bad.

IMG_020170_053113

 

IMG_160514_192433-1

 

 

 

 

IMG_020170_053054

(Indoor in lights)

Gaming : The phone is good at gaming. I played Temple Run Oz on high settings, the gameplay was smooth and lag free. The box mentions the gpu as ‘Adreno 302’, but actually it is ‘Adreno 305’

Screenshot_2014-05-16-19-22-54

Battery : Battery life of the phone is average (1700 mah). Specially if the screen brightness is set anywhere from mid level to high, the battery drains quite fast. You can expect 8-10 hours on medium usage. 

Other Features : USB On The Go is not supported. There are accelerometer, proximity and light sensors. It supports 2 normal sims. There is a microsd slot as well.

Screenshot_2014-05-16-19-22-47

Conclusion : Lava Iris 406q is a good phone performance wise. But i am not impressed with its looks and build quality. Phone with similar or better features are now available in this budget. Like Xolo Q600s, Moto E and Micromax Unite 2. Micromax Unite 2 definitely looks better bet then this.

 Any queries are welcome in comments below.

SONY T2 ULTRA DUAL HANDS ON

2014-03-31 13.05.03

Quick Specs : 1.4 ghz quad core qualcomm processor, 1 gb ram, Adreno 305 gpu, Android 4.3, 6 inch IPS tft display, Dual Sim (dual standby), 13 mp rear camera.

Box Contents :

Design and Looks : The phone is huge with 6 inch screen and will not fit in your jeans pocket easily. Only buy this if it is ok with you to handle such size. Phone looks slim. There is a notification led in front.

Display : IPS tft Display has good viewing angles, brightness and color production. Its definitely better then closest rival Grand 2. Its very hard to spot the pixels (245 ppi). Overall the display looks nice. Display as well as the back of the phone is a finger print magnet, back is glossy. Touch is smooth.

Storage : Out of 8 gb internal memory, 4.8 gb is available to the user to install apps. Out of the 1 gb ram only 865 mb ram is available. After installing some basic apps like MX Player, Whatsapp etc free ram available is nearly 300 mb, which looks less if you are in to heavy multitasking.

Performance : The interface of the phone is lag free. There is no lag anywhere in the phone. It is smooth and fast. This applies to navigating through apps and checking photos in gallery. Everything is instant and lag free.

Sound : The audio quality is good. But it is not loud. Overall its speaker is of average loudness.

Benchmarks : Running Antutu Benchmark gives a score of 19392

Camera :

Gaming :

Battery :

Other Features : USB On The Go is supported. It is not a dual active phone. You can only forward a call from one sim to other sim which may incur you charges. (just like samsung phones)

Conclusion :

 Any queries are welcome in comments below.

XOLO Q700S REVIEW

xolo-q-700-s

Quick Specs : 1.3 ghz quad core mediatek mt6582 CPU, Mali 400 mp GPU, 1 gb ram, 4 gb internal memory, 4.5 inch ips display with 480 x 854 pixels (217 ppi), 8.3 mega pixel camera, Android 4.2.2, 1800 mah battery

Box Contents : Phone, Charger, Data Cable, Screen Guard, Headphones, Warranty Card, Quick Start Guide.

Design and Looks : Xolo Q700s is stylish and slim (8.9mm). The back of the phone looks metallic (actually plastic) and gives a premium look to the phone. Phone is available in two colours, silver and golden. Front colour is black in both. The phone is easy to carry and easy to operate with one hand. Sensors include Accelerometer, Proximity and ambient light.

Display : Display has good viewing angles, brightness and color production. Still experts can spot the pixels (217 ppi). Overall the display looks nice. Front side of the phone is a finger print magnet. Touch screen is easy to operate. Still the touch is not as good as Samsung phones. It is good in itself though.

Storage : Out of 4 gb internal memory, 1.73 gb is available to the user to install apps. Free ram on first boot is nearly 800 mb (out of 973 mb). Apps can be moved to SD Card. (note that not all apps are movable to sd card)

Performance : The interface of the phone is lag free. There is no lag anywhere in the phone. It is smooth and fast. This applies to navigating through apps and checking photos in gallery. Everything is instant and lag free.

Sound : The voice quality during calls is good and clearly audible. It has a good microphone too. But when you listen to music, the speaker is not that loud. Its average, but still the clarity of sound is good.

Benchmarks : Running Antutu Benchmark gives a score of 17166 on day 1. 17467  on 2nd run after few days.

Camera : The camera captures good photos in daylight. But in low light conditions the photos are average. If we compare photo quality with galaxy s duos 2, then S duos 2 photos appears much better. It captures photos in 3840 x 2160 resolution (wide) by default. (You can change this setting from ‘Camera Settings>Preview Size>Standard 4:3’ to capture photos in 3264×2448 resolution). Camera supports HDR mode, Panorama and Continuous shot upto 99 photos. Video is captured in 1088p @ 30 fps (you have to select ‘fine’ quality to record in Full HD). Videos are of average quality too. The camera keeps on adjusting brightness during capture and final output doesn’t look very smooth. Hope a firmware update will arrive to fix this. Another disappointment is that the videos are captured in 3gpp format. I have found no setting to change the format.

IMG_20140213_115641

(In Sunlight)

IMG_20130101_000501

(Indoor during daytime)

IMG_20140204_181508

(Outdoor in evening low light condition)

Gaming : Just tried ‘Temple Run OZ’ on high settings. Played it for 15 mins. There is no lag and gameplay is totally smooth. Seems like the phone can run most of the games easily.

Battery : The battery took nearly 3 hours to fully charge. (from 0 to 100 %). The phone gives a decent amount of battery standby (600 hrs as stated by xolo). During first night i kept the phone with internet off, for like 8 hours (with both sims on) and the battery was not dropped even by a single percent (72% at night and same in the morning). Second day the battery dropped just 1% overnight. Even if you are using the phone regularly the battery can easily last for more then 12 hours. And with lesser usage you can expect it to last for 2-3 days easily. It also gives 23 hours of talktime which is great.

Other Features : The phone supports usb mass storage. USB OTG is however not supported. There is wi fi direct to share files. The phone supports two regular sims. It also has memory card support. There are apps like Xolo Secure which keeps your device safe from theft and data loss. Another app which comes pre installed is Xolo Power which helps in saving the battery in different ways.

Conclusion : Xolo Q700s is good looking, lag free and have decent battery. Still camera quality and touch is bit inferior to Samsung phones. Overall its a good buy for less then 10k rupees.

 Any queries are welcome in comments below. You can also follow me on twitter

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)