Monday, May 2, 2016

Excel : Complex formatting that is applied to the selected chart may take a while to display

Excel_complex_graph_chart_formatting


Excel Waring / Error: 

Complex formatting that is applied to the selected chart may take a while to display.

Description:

In MS Excel, while changing the color, line width, line format (dashed,round,dash dot etc) , a warning will be showed as follows.
"Complex formatting that is applied to the selected chart may take a while to display"

If you continue to change the format, ignoring the warning, then the graphs will load very slowly each and every time you update a change in the graph. Overall speed performace of the excel file will be reduced.

Sometimes, if you change a color of the line or increase the text inside the graph, then it will not get referenced immediately. You need to click somewhere else on the sheet or some other graph to see the update you have done recently.


Solution:

So, the best practice is to leave the graphs with the default formatting. Make the changes in line formatting of the graphs only if it is necessary.

You can revert the changes made in the graph by applying another chart style by double clicking the chart and selecting a chart style in Design → Char Tools

Thursday, April 28, 2016

UTS : Renew Season ticket , New season ticket in utsonmobile app


Queue train ticket chennai

UTS Android , iPhone app :

UTS is a smartphone app developed to book suburban tickets, take season tickets and renew season tickets through mobile app.UTS mobile app can be downloaded from official Google play store, Apple itunes

To get a new season ticket in UTS app :

  1. Login to UTS mobile app using your mobile number and password
  2. Select Book ticket → Season ticket → Ticket issue
  3. Now enter the details Source station, Destination, Class, Name, Age, Gender, ID card number, address
  4. Now proceed with payment option
  5. The total fare of the season ticket will be displayed
  6. Choose confirm to complete the season ticket booking. Balance will be deducted from R-wallet
  7. You will get an sms confirmation with ticket information
  8. The passenger can use Show ticket option to display the ticket to TTR
  9. Season ticket cannot be canceled.


To renew a season ticket in UTS app :

  1. Login to UTS mobile app using your mobile number and password
  2. Select Book ticket → Season ticket → Renewal
  3. Now, the details of old season ticket will be displayed
  4. Change the details if you want and proceed with pay
  5. The total fare will be displayed
  6. Choose confirm to finish renewal of season ticket
  7. Now , the balance will be reduced from your R-wallet and you will receive an confirmation message after renewal of season ticket

Aircel : Call waiting Activation | Aircel call waiting service


Aircel Call waiting :

  • Call waiting is a free service provided by Aircel to all its postpaid and prepaid customers. 
  • If the Aircel user enabled call waiting service, then he will be able to receive another call even if he is currently speaking a call.
  • The caller at other end will hear that the Aircel customer is speaking with some other person and request him to wait.


To Activate Call waiting in Aircel:

  1. Go to System settings → Call
  2. In additional settings  enable call waiting (During a call, notify me of incoming calls)
In Aircel, call waiting service is free of cost.