Gmail addes few more features

Google Opearing System points to few more features that will be a part of Gmail to makes Gmail email user's life a bit more easy. The features are "Delete All Spam Email" & "Delete All' option in Trash Bin. It just saves us so much time when the amount of SPAM these days is just too much to handle 50 at a time. One great tip I got while I was on the site was the feature where one could add unlimited email addresses to a single Gmail account. One can have an email address of gmailaddress+newlabel@gmail.com and then have another address of gmailaddress+label2@gmail.com and they will both end up in gmailaddress@gmail.com inbox or get filtered if filters have been setup for it. So an example of this is if I go on a newsgroup and want to create on the fly email address (still wanting them to come to my Gmail inbox) but still don't want to give out my main address. Now assume that my email address is softwareandtolls@gmail.com then I can create on the fly email address of softwareandtolls+forummail@gmail.com and it will still end up in softwareandtolls.com inbox. Great feature indeed. Have not tried with other email providers yet.

Updates on Google Reader

Finally Google has made few more changes to make Google Reader more usable and user friendly. I have been using Google Reader for quite some time now since I left using Bloglines and Newsgator. Below is a briefing on the new features on Google Reader: - A new settings page: -
Media_httpwwwsoftware_amijp
This is a good single page for administration where we can manage subscriptions, labels (tags), Import/Export subsriptions and an Extra tab. Subscriptions Page
Media_httpwwwsoftware_qnhwq
Subscription page is where one can add subscriptions, delete subsriptions (multiple at time), rename subscriptions and edit labels associated to the subscriptions. On this page one can even filter the subscriptions or labels. Labels
Media_httpwwwsoftware_fpggx
The labels page is where one can manage labels/tags. One can delete labels, Share labels to the public where all the subscriptions under that label/tags would be accessible by people. Import/Export Page
Media_httpwwwsoftware_udnob
On this page on settings menu, one can upload the OPML file or export their subscriptions that they might have on Google Reader. Access your labels and subscriptions from the main page easily One new feature that I would find it very handy is accessing the subscriptions and labels directly from the main page no matter what you are reading at the moment.
Media_httpwwwsoftware_zanas
And not to forget their keyboard shortcut method where you can punch in keyboard shortcuts and get access to subscriptions and labels easily. Overall I am pleased with the new features. I hope it gets better with the performance as time goes by. The official Google Reader blog posts about the new feature here.

Using Gmail account to monitor and handle all your separate email accounts

Like most of us I have multiple email addresses that I use for different purpose. I use separate email accounts for newsgroups, for opening up accounts, for personal use, for work and for leaving comments on other blogs. Now to monitor them all on a regular basis constantly in today's busy life becomes rather messy and time consuming. I use Gmail account as one of my main accounts to handle most of my important and personal email (link to that email address can be found on my "about Tejas Patel" section at the bottom of right hand sidebar). I use multiple Gmail accounts as well apart from using domain based accounts. So I use Gmail's feature of handling multiple accounts for "Send As" feature and mail forwarding feature. So what do we need as solution? A single mail account where all the mail from multiple email accounts are forwarded, in which mail messages can be filtered in separate labels and mail messages can be replied from the email address it was sent to Solution:- 1. 1 Gmail account 2. Multiple Gmail or hosted domain accounts which can be forwarded to your mail Gmail account 3. Mail forwarding and "Accounts" feature within Gmail 4. Creating labels in Gmail based on "Email Account" that the message comes from Bingo, using three simple steps you can manage all from email accounts from a single account and use the base account as a email backup account for the respective email addresses. The exact steps are detailed on Google Tutor Post. I have to tell that this has been functioning very well for me for quite some time now. I only wish that I can easily forward my Hotmail email messages to Gmail ( Hotmail email messages cannot be forwarded to other mail account). I am sure similar results can be achieved using other solutions, but this works satisfactorily for me so far. What methods do you use to aggregate your mail accounts?
One of my colleagues day before yesterday sent me a message saying try typing “Bush hid the facts” in notepad, save it, close it and reopen it. I tried the same and initially I was surprised to know that it was displaying only few boxes!! Step 1: Start >> Run >> notepad Step 2: Just type the text in quotes alone – “Bush hid the facts” Step 3: Save the file [I saved it as a.txt] and close it Step 4: Open that saved file. I didn’t think this to be a Easter egg as I was sure that Microsoft wouldn’t unnecessarily take on US government like this. So I thought of testing it out. As a first attempt I replaced all characters within that file with “a”. That is, my file would read “aaaa aaa aaa aaaaa” now saved it as “b.txt”, closed it and reopened it. As I have expected it showed up only boxes. So I immediately concluded that notepad isn’t good at opening files which has only a single sentence of 4 words with its size as 4-3-3-5. I responded back to my friend with my findings!! But I need to admit that this isn’t consistent at all. In some cases it works, for some words/characters it doesn’t work. The thing which confused me more was I was able to open the saved notepad file (with the above mentioned characters of 4-3-3-5 spacing) without any hassle from command prompt. Step 1: Start >> Run >> cmd Step 2: edit a.txt Only then I was thinking in the lines of “May be this could be something to do with text encoding”. So I started to look out for the answer with the help of my friend Google. Though there were many sites which talks about it, to my knowledge the most appropriate ones are these two links. http://weblogs.asp.net/cumpsd/archive/2004/02/27/ 81098.aspx http://blogs.msdn.com/oldnewthing/archive/2004/03/24/ 95235.aspx --- Majorly I didn’t understand much from this post as it was above my head. But one point which I understood is, its the problem with IsTextUnicode() function which Notepad uses to find out whether the text is a Unicode or not. If you go through those two links you would understand that people have discussed about this issue in the year 2004 itself :( [This has been cross-posted @ http://vadivel.blogspot.com as well] Technorati tags: , ,
One of my colleagues day before yesterday sent me a message saying try typing “Bush hid the facts” in notepad, save it, close it and reopen it. I tried the same and initially I was surprised to know that it was displaying only few boxes!! Step 1: Start >> Run >> notepad Step 2: Just type the text in quotes alone – “Bush hid the facts” Step 3: Save the file [I saved it as a.txt] and close it Step 4: Open that saved file. I didn’t think this to be a Easter egg as I was sure that Microsoft wouldn’t unnecessarily take on US government like this. So I thought of testing it out. As a first attempt I replaced all characters within that file with “a”. That is, my file would read “aaaa aaa aaa aaaaa” now saved it as “b.txt”, closed it and reopened it. As I have expected it showed up only boxes. So I immediately concluded that notepad isn’t good at opening files which has only a single sentence of 4 words with its size as 4-3-3-5. I responded back to my friend with my findings!! But I need to admit that this isn’t consistent at all. In some cases it works, for some words/characters it doesn’t work. The thing which confused me more was I was able to open the saved notepad file (with the above mentioned characters of 4-3-3-5 spacing) without any hassle from command prompt. Step 1: Start >> Run >> cmd Step 2: edit a.txt Only then I was thinking in the lines of “May be this could be something to do with text encoding”. So I started to look out for the answer with the help of my friend Google. Though there were many sites which talks about it, to my knowledge the most appropriate ones are these two links. http://weblogs.asp.net/cumpsd/archive/2004/02/27/ 81098.aspx http://blogs.msdn.com/oldnewthing/archive/2004/03/24/ 95235.aspx --- Majorly I didn’t understand much from this post as it was above my head. But one point which I understood is, its the problem with IsTextUnicode() function which Notepad uses to find out whether the text is a Unicode or not. If you go through those two links you would understand that people have discussed about this issue in the year 2004 itself :( [This has been cross-posted @ http://vadivel.blogspot.com as well] Technorati tags: , ,

[Product Review] SwisSQL SQLOne Console 3.0

Last month Srikanth from SwisSQL got in touch with me and introduced me to their new product called "SwisSQL - SQLOne Console 3.0". I initially thought I would fiddle with it sometime in the weekend. But one of the meeting which was about to happen yesterday evening got cancelled and so I came early to home than usual. I just utilized that time to review this product. About the product: 1) SQLOne Console is an automated SQL Migration tool offering SQL Conversion, Execution and Comparison across multiple databases. 2) SQLOne Console migrates SQLs, either available as stand alone scripts or as embedded SQL statements within Application code like VB, PB, VC++, Java etc.,. 3) It supports Migration across Oracle, SQL Server, DB2, MySQL, Sybase, PostgreSQL, Informix and ANSI-SQL database SQL dialects. 4) This software also has features to test the converted SQLs in target databases. It would be a very handy product to have in database migration projects as well DBAs working in multi-database environment. Here we go .... I downloaded and installed the 30-day trial pack of that product from here. The trial pack was not restricted in anyway as far as the functionalities are concerned. But the only hitch is we can run / test only 50 queries by using it. When I clicked on the SwisSQL shortcut, which got created, on my desktop it first opened the command prompt. After couple of seconds it opened the GUI application. Once I clicked on "OK" button the application got loaded without any hassles. The screen was divided horizontally into three parts as shown in the below screenshot.
Media_httpwwwsoftware_uihec
This app consists of 3 frames and they are, 1) The first part of the screen is where you could type your code snippet that needs to be converted into other database dialect. Once you type a query and click on "Convert" from the toolbar (you could also press F5 key to run the queries) the converted query would be displayed in the middle frame. 2) The center frame in the above screenshot is where the converted code snippet would be displayed. Various DB, which is supported by this product, is displayed in a tabbed fashion in this frame. Interestingly one F5 is enough for the product to convert the query into all the 8 DB dialect at one short. 3) The bottom frame is where the executed result would be displayed. Obviously we need to set the connection strings (which could be easily done using settings menu >> Database Connection settings). Few of the code snippets which I have tried myself are: Sample 1 :: First I tested with NewID() function of SQL Server. SQL Server -- Select newId() Oracle - SELECT SYS_GUID() FROM SYS.DUAL DB2 - SELECT GENERATE_UNIQUE() FROM SYSIBM.SYSDUMMY1 FETCH FIRST 1 ROW ONLY Informix - SELECT FIRST 1 SYS_GUID() FROM SYSTABLES PostgreSQL - SELECT SYS_GUID() MySQL - SELECT SYS_GUID() ANSI SQL - SELECT SYS_GUID() Sybase - SELECT NEWID() Sample 2: Then I checked out how Identity() and Primary Key constraint performs in all the DBs. SQL Server - CREATE TABLE tblTest ( Field1 int Identity NOT NULL , Field2 varchar (30) , Field3 int CONSTRAINT pk_parent PRIMARY KEY nonclustered (Field1) ) Oracle - CREATE SEQUENCE tblTest_Field1_SEQ START WITH 1 INCREMENT BY 1 / /* AdventNet SwisSQL Message : Query split into multiple Queries. */ CREATE TABLE tblTest ( Field1 int NOT NULL , Field2 VARCHAR2 (30) , Field3 int null , CONSTRAINT pk_parent PRIMARY KEY (Field1) ) DB2 - CREATE TABLE tblTest ( Field1 int GENERATED BY DEFAULT AS IDENTITY(START WITH 1 INCREMENT BY 1) NOT NULL , Field2 varchar (30) , Field3 int CONSTRAINT pk_parent PRIMARY KEY NOT NULL ) Informix - CREATE TABLE tblTest ( Field1 int NOT NULL , Field2 varchar (30) , Field3 int PRIMARY KEY ) PostgreSQL - CREATE TABLE tblTest ( Field1 INT8 NOT NULL , Field2 varchar (30) , Field3 INT8 CONSTRAINT pk_parent PRIMARY KEY null ) MySQL - CREATE TABLE `tblTest` ( `Field1` int NOT NULL , `Field2` varchar (30) , `Field3` int CONSTRAINT `pk_parent` PRIMARY KEY null ) ANSI SQL - CREATE TABLE tblTest ( Field1 int NOT NULL , Field2 varchar (30) , Field3 int CONSTRAINT pk_parent PRIMARY KEY null ) Sybase :: CREATE TABLE tblTest ( Field1 NUMERIC Identity NOT NULL , Field2 varchar (30) , Field3 int , CONSTRAINT pk_parent PRIMARY KEY nonclustered (Field1) ) Sample 3 : I tried to convert this SQL Server query Execute sp_MSForeachTable @command1 = "sp_help '?'" It didn't work out. When I discussed regarding this with Srikanth I came to know that SwisSQL SQLOne Console converts SQLs only and does not handle T-SQL blocks. To migrate Procedure syntaxes like T-SQL, PL/SQL etc they offer solution based on the source and destination database combination. For those who are interested in that check the below URLs: http://www.swissql.com/products/sqlserver-to-oracle/sql-server-to-oracle.html http://www.swissql.com/products/sqlserver-to-db2/sql-server-to-db2.html As of now, I found that the tool doesn't convert Temporary tables and queries like Identity(int, 1, 1). I actually tried Select Identity(int, 1,1) RowNum, au_id, au_lname, au_fname, phone into #tmpTable from authors and it failed to convert. That said, these aren't supported in the current version of the product. Hope their development team is working on it. The site claims that they support SQL Server 2005 but I haven't tested it out. Would do it sometime later and update this post. I feel this to be an useful tool for the DBAs / senior developers in particular who handle multiple databases parallely. They only know the pain of doing database migrations :) I am sure this tool will be handy and it would really help them do migrate most of the queries with ease. Important URLs for your reference: 1. Download SwisSQL - SQLOne Console 3.0 2. Various Products of SwisSQL 2. Product Support As of now the support given by the team is really great. I was able to get response to my queries within a hour of so. I am impressed. [This has been cross-posted @ http://vadivel.blogspot.com as well] Technorati tags: ,

[Product Review] SwisSQL SQLOne Console 3.0

Last month Srikanth from SwisSQL got in touch with me and introduced me to their new product called "SwisSQL - SQLOne Console 3.0". I initially thought I would fiddle with it sometime in the weekend. But one of the meeting which was about to happen yesterday evening got cancelled and so I came early to home than usual. I just utilized that time to review this product. About the product: 1) SQLOne Console is an automated SQL Migration tool offering SQL Conversion, Execution and Comparison across multiple databases. 2) SQLOne Console migrates SQLs, either available as stand alone scripts or as embedded SQL statements within Application code like VB, PB, VC++, Java etc.,. 3) It supports Migration across Oracle, SQL Server, DB2, MySQL, Sybase, PostgreSQL, Informix and ANSI-SQL database SQL dialects. 4) This software also has features to test the converted SQLs in target databases. It would be a very handy product to have in database migration projects as well DBAs working in multi-database environment. Here we go .... I downloaded and installed the 30-day trial pack of that product from here. The trial pack was not restricted in anyway as far as the functionalities are concerned. But the only hitch is we can run / test only 50 queries by using it. When I clicked on the SwisSQL shortcut, which got created, on my desktop it first opened the command prompt. After couple of seconds it opened the GUI application. Once I clicked on "OK" button the application got loaded without any hassles. The screen was divided horizontally into three parts as shown in the below screenshot.
Media_httpwwwsoftware_gfwtb
This app consists of 3 frames and they are, 1) The first part of the screen is where you could type your code snippet that needs to be converted into other database dialect. Once you type a query and click on "Convert" from the toolbar (you could also press F5 key to run the queries) the converted query would be displayed in the middle frame. 2) The center frame in the above screenshot is where the converted code snippet would be displayed. Various DB, which is supported by this product, is displayed in a tabbed fashion in this frame. Interestingly one F5 is enough for the product to convert the query into all the 8 DB dialect at one short. 3) The bottom frame is where the executed result would be displayed. Obviously we need to set the connection strings (which could be easily done using settings menu >> Database Connection settings). Few of the code snippets which I have tried myself are: Sample 1 :: First I tested with NewID() function of SQL Server. SQL Server -- Select newId() Oracle - SELECT SYS_GUID() FROM SYS.DUAL DB2 - SELECT GENERATE_UNIQUE() FROM SYSIBM.SYSDUMMY1 FETCH FIRST 1 ROW ONLY Informix - SELECT FIRST 1 SYS_GUID() FROM SYSTABLES PostgreSQL - SELECT SYS_GUID() MySQL - SELECT SYS_GUID() ANSI SQL - SELECT SYS_GUID() Sybase - SELECT NEWID() Sample 2: Then I checked out how Identity() and Primary Key constraint performs in all the DBs. SQL Server - CREATE TABLE tblTest ( Field1 int Identity NOT NULL , Field2 varchar (30) , Field3 int CONSTRAINT pk_parent PRIMARY KEY nonclustered (Field1) ) Oracle - CREATE SEQUENCE tblTest_Field1_SEQ START WITH 1 INCREMENT BY 1 / /* AdventNet SwisSQL Message : Query split into multiple Queries. */ CREATE TABLE tblTest ( Field1 int NOT NULL , Field2 VARCHAR2 (30) , Field3 int null , CONSTRAINT pk_parent PRIMARY KEY (Field1) ) DB2 - CREATE TABLE tblTest ( Field1 int GENERATED BY DEFAULT AS IDENTITY(START WITH 1 INCREMENT BY 1) NOT NULL , Field2 varchar (30) , Field3 int CONSTRAINT pk_parent PRIMARY KEY NOT NULL ) Informix - CREATE TABLE tblTest ( Field1 int NOT NULL , Field2 varchar (30) , Field3 int PRIMARY KEY ) PostgreSQL - CREATE TABLE tblTest ( Field1 INT8 NOT NULL , Field2 varchar (30) , Field3 INT8 CONSTRAINT pk_parent PRIMARY KEY null ) MySQL - CREATE TABLE `tblTest` ( `Field1` int NOT NULL , `Field2` varchar (30) , `Field3` int CONSTRAINT `pk_parent` PRIMARY KEY null ) ANSI SQL - CREATE TABLE tblTest ( Field1 int NOT NULL , Field2 varchar (30) , Field3 int CONSTRAINT pk_parent PRIMARY KEY null ) Sybase :: CREATE TABLE tblTest ( Field1 NUMERIC Identity NOT NULL , Field2 varchar (30) , Field3 int , CONSTRAINT pk_parent PRIMARY KEY nonclustered (Field1) ) Sample 3 : I tried to convert this SQL Server query Execute sp_MSForeachTable @command1 = "sp_help '?'" It didn't work out. When I discussed regarding this with Srikanth I came to know that SwisSQL SQLOne Console converts SQLs only and does not handle T-SQL blocks. To migrate Procedure syntaxes like T-SQL, PL/SQL etc they offer solution based on the source and destination database combination. For those who are interested in that check the below URLs: http://www.swissql.com/products/sqlserver-to-oracle/sql-server-to-oracle.html http://www.swissql.com/products/sqlserver-to-db2/sql-server-to-db2.html As of now, I found that the tool doesn't convert Temporary tables and queries like Identity(int, 1, 1). I actually tried Select Identity(int, 1,1) RowNum, au_id, au_lname, au_fname, phone into #tmpTable from authors and it failed to convert. That said, these aren't supported in the current version of the product. Hope their development team is working on it. The site claims that they support SQL Server 2005 but I haven't tested it out. Would do it sometime later and update this post. I feel this to be an useful tool for the DBAs / senior developers in particular who handle multiple databases parallely. They only know the pain of doing database migrations :) I am sure this tool will be handy and it would really help them do migrate most of the queries with ease. Important URLs for your reference: 1. Download SwisSQL - SQLOne Console 3.0 2. Various Products of SwisSQL 2. Product Support As of now the support given by the team is really great. I was able to get response to my queries within a hour of so. I am impressed. [This has been cross-posted @ http://vadivel.blogspot.com as well] Technorati tags: ,

Interview with Product Manager of Zoho Sheet

As you all aware, Google has released the beta version of “Google Spreadsheet” few days back. Only then through Rajendran [My ex-CTO and a good friend of mine] I came to know about Zoho Sheet. As I have said before, to know that a Chennai based company has developed something AHEAD of GOOGLE is not a small achievement. First of all, I really love the concept of sharing the spreadsheet with others. This might help people use this as a collaborative tool! But there are lots of doubts coming up in my mind when I think about "Spreadsheet over the web". So thought I would get it clarified from the people who have conceptualized, designed and developed it. Here is the interview with Hyther Nizam who is the Director of Product management for Zoho Services at AdventNet, and Product Manager of Zoho Sheet and Zoho Creator. Let’s get started … [Vadivel]: To start with, can you explain what the need of Zoho Sheet is? It would be great if you could give me few real-time examples on where could we use this? [Hyther]: Excel is one of my favorite software which is perfectly designed for its intended purpose and users. But it’s not friendly now for internet population who want to consume lot of data from internet into their spreadsheets. Sharing is pain. Not collaboration friendly. You cannot share it online with your friends, colleagues and clients. You might be sending it now as back and forth email attachments which has its own version problems. Not to say on the ridiculous pricing of M$ office package. Zoho Sheet is an affordable online alternative to such traditional spreadsheets riding on the advantage of web. Zoho Sheet can be used by individuals for tracking personal data or enterprises maintaining their business data. [Vadivel]: I know Zoho is now in its beta. When do you think the final product be made public? Is there any specific time frame you have in mind? [Hyther]: Currently we are busy working on the features to make Zoho Sheet usable for serious users. We would remove the beta tag once we feel we are ready for enterprise users, probably by next 3 months or so. [Vadivel]: I didn't find any help file for this product. Am I missing something? (Is there a help file for this product?) [Hyther]: Currently we are busy churning out code to bring out features quickly. That doesn't mean help file is not important, we would add it for public release [Vadivel]: Let’s assume that I save my business content using Zoho sheet, where would my content get stored? In database or flat file? [Hyther]: Both. We have designed the system for best performance. We leverage file system where we need fast I/O and database for maintaining relational constraints. [Vadivel]: Is the content encrypted? [Hyther]: As of now, no. This is one of the important features which we will add before we get out of beta. However, currently, we have secured file system for user’s data with support for disaster recovery. [Vadivel]: Bottom-line is, how safe would my content be? For ex: Once Zoho sheet becomes live and if some serious business user makes use of this. Can the system admin of Zoho be in a position to view their content? [Hyther]: User data would be encrypted and stored based on the user's credentials, making it absolutely impossible even for Zoho administrator to view the content. [Vadivel]: If at all I could ask, what technology have you used to develop this Zoho sheet? [Hyther]: Java, AJAX [Vadivel]: Is there any specific reason for choosing this technology? [Hyther]: AJAX brings cooler user experience on the web, they call it web 2.0. Java enables fast development with lot of libraries around it [Vadivel]: I know AdventNet is a product based company. That said, from zoho.com I understand that you give away "Zoho Writer", "Zoho Planner" and "Zoho Chat" all for free!! In that line, can people expect Zoho Sheet also be given free of cost? If yes, what is the business model of AdventNet? [Hyther]: Even after beta, Zoho Sheet would remain to have free edition for personal users. We feel we could make money from enterprises with disruptive pricing making Zoho compelling for enterprises, and of course, with cool web services which can solve real problems. [Vadivel]: When you thought about Zoho Sheet, where you guys aware that Google Spreadsheet is going to be released sometime soon? [Hyther]: We expected it. Everyone knows Google is taking on M$ and would come up with online office package. With writely acquisition for word processing, natural next step would be spreadsheets. [Vadivel]: Do you think Google spreadsheet would be a threat to you? If not, in what way you think zoho sheet is a unique product by itself. [Hyther]: Google is not threat to us. In one of my blog post, I have explained our stand with respect to Google spreadsheets. We would focus more on enterprise market and small groups of business users. This is going to be a marathon and we are well prepared for it. [Vadivel]: Where do you think Zoho Sheet or for that matter Zoho go from here in next 5 years from now? [Hyther]: Five years is too long time in this web 2.0 world. Our end-of-this-year goal is to bring out compelling online office suite - Zoho Writer (online word processor), Zoho Sheet (online spreadsheets), Zoho Virtual Office (web-based collaboration groupware) , Zoho Show (online presentation creator and remote sharing, coming soon!) [Vadivel]: Why do you think people would make their sheet public? I couldn't think of a single reason for people making their content public! [Hyther]: Yes, they would not share personal or business spreadsheets to public. But they could create common spreadsheets like FIFA World Cup, Tax Calculator, etc and contribute to public. (Social spreadsheets). [Vadivel]: As I said before, I know Zoho Sheet is still in its beta stage. That said, I played with it for 30 mins yesterday and found few bugs. They are: i) Wrap Text: In a cell which has the default cell width, I typed "alpha beta gamma". Then I clicked on Wrap Text with a hope that it would wrap this sentence to the size of the cell. But to my surprise the row was hidden. Am I missing something? I am not too sure whether this is the way it was designed to work? To me this is a bug as the button reads "Wrap Text" and not "Hide text". [Hyther]: I tried out; it works on latest versions of Mozilla, Firefox. However seems to be an issue in IE. We will fix it. ii) Font Color: I selected the cell where I have entered a formula. FYI, the actual formula which I tried is =(2*2)/4. The formula was correctly calculated and the result was displayed without any issues. Then i clicked on Font Color (A) from the tool bar and choosed Blue color. Though the color of the cell changed to blue now it started displaying the formula as it is with blue color. But the expected result is "the cell should have the result of the forumla in blue color" When I tried the same thing after sometime it worked properly. Though the error isn't reproducable I am sure there is an issue with this :) So its better the dev team start looking into this also. [Hyther]: Your observation is right, currently it behaves this way. Seems to be minor issue, we will correct it. iii) Preview: When i clicked on preview button, its throwing the following error. Error occured Unable to Export the Document [Hyther]: Preview is nothing but html export, that’s why the message says unable to export. I agree this is not an intuitive message. We need to look at that particular sheet and check why it was unable to export. Probably a bug. [Vadivel]: How does it feel to get bug reports like this from end-user? :) [Hyther]: We knew how painful it is for the end users. We are striving hard to fix such obvious issues. Now you know the reason for beta tag :-) [Vadivel]: Thanks a lot Hyther for taking pain in answering my questions and clearing some basic doubts on Zoho sheet. Hope the readers would have also enjoy reading this! [This is the cross posted @ http://vadivel.blogspot.com as well] Technorati tags: ,