Zoho Sheet underwent an update last week with some cool functionality. Here are the new features in this update:

1. Insert Button:
   
   Buttons which trigger VBA macros can now be inserted into your spreadsheets in Zoho. This opens up a lot of possibilities to create spreadsheet based applications. We would love to see what kind of spreadsheets you create using this. Here is a simple BMI (Body Mass Index) calculator with buttons embedded below. Just fill in your details and hit the calculate button.
   
   
   
   To insert a button, look for "Insert Button" under the Insert icon (plus icon) on the toolbar. You can then assign an existing macro to it or assign a new one by writing a VBA macro or by just recording a macro.
   
   
   
   
2. Full XLSX Support:
   
   Earlier we supported import of xlsx files (Microsoft Excel's file format since 2007). Now we support export to xlsx as well. Our APIs too support this new format.
   
   
3. Time Zone Preference:
   
   We now respect your time zone preference and display the date and time accordingly. TODAY() and NOW() functions will give out the date/time based on your time zone setting. You can set your timezone preference by clicking on "Account Settings > My Account" link available on the top bar. You can also visit http://accounts.zoho.com and set your preferences which will be used across the various Zoho services.
   

Apart from the above, there are some enhancements and bug fixes as well. Refer our What's New page for more information.

PS: Zoho Sheet is now on Twitter. Follow us @zohosheet.

Zoho Sheet underwent few updates in the last couple of months after our Freeze panes update. Here are the highlights:

XLSX File Format Support

We recently added support for Excel 2007 file format (.xlsx). You can now import your xlsx spreadsheets to Zoho Sheet and edit them or publish them online. However, exporting to xlsx format is not yet supported. It will come in a future update, after which xlsx files will be supported via our Remote API too.

Collaboration Enhancements

When multiple people are collaborating on a spreadsheet at the same time, we now display who is working on which cell. Each collaborator is given a color code, and we highlight the cell which the user is working on using that color. When you hover the mouse over that cell, it displays the name of the collaborator. We have also fixed certain issues in real time collaboration. 

Cell Comment Enhancements

The cell comments user interface has been enhanced. Some pressing issues in cell comments have been fixed as well.

Apart from the above changes, we have done some performance improvements and bug fixes as well. Refer our What's New page for more information.