Features

Enhancements:

• The right click context menu has been enhanced.
• While sharing, the limit on the number of characters in the custom email inivitation is now increased to 1000 characters.
• Performance has been improved while loading spreadsheets and performing certain operations like insert/delete rows and columns. More improvements on the way.
• Issue in published ranges not getting updated when it refers to cells linked with External Data has been fixed.
• Some rare issues while sharing spreadsheets have been fixed.
• Date format related fixes and script timeout related fixes have been done in Macros.

Record and Play Macros:

• Zoho Sheet now supports record and playback of Macros. We launched the VBA Macros functionality in April, and you had to know the basics of VBA to write Macros. But now, you can just record the user actions to generate the Macro code without even needing to learn VBA. This recorded macro can then be run on the spreadsheet.
• We also support relative reference while recording a macro. Using this option, a macro can be recorded once and can be played on any other part of the spreadsheet without worrying about absolute cell locations.
• Here is a list of unsupported actions.

Templates (preview):

• We have added support for templates. You can maintain your own list of templates and can create a new spreadsheet from a template and vice versa.
• You can publish a template to the public template gallery. Users can browse the public template gallery and can copy the templates to their account.
• We will add some standard system templates, enhance our public template gallery and then announce templates functionality in Zoho Sheet.

Other Major Enhancements:

• Polish language:
  Zoho Sheet is now available in Polish language. Thanks to our users who translated Zoho Sheet into Polish. We now support 22 languages and many more are in progress on our translation site where users themselves localize Zoho Sheet.
• New Share UI:
  We have re-designed our "Share" screen to provide better experience while sharing to contacts and groups. You can also search your contacts before sharing it to them. This new Share UI will be used in Writer and Show as well to provide a consistent user experience.
• Firefox 3 performance improvements:
  We have made some changes to improve the performance in Firefox 3. More performance improvements for all browsers are in the works.
• ... and some bug fixes.

Bug Fixes:

• Auto-fill issue in IE has been fixed.
• Edit Chart / Publish Chart / Clone Image broken links have been fixed.
• Firefox 3 issues of not being able to edit by typing immediately after opening.
• Error messages in spreadsheets with external data, when opened for a long time has been fixed.

New Features:

• Sorting Enhancements:
  We have enahanced our Sorting capabilities. Selecting a column and then using the sort buttons on our toolbar will now detect and prompt if the range has to be expanded. The headers will also be auto-detected. We have the advanced sort option on the right click menu for a long time now. Again this will detect the headers in the selected range. You can sort by upto 3 columns in any order. We also added an option to either sort top to bottom or left to right.
• Esperanto Language:
  Zoho Sheet is now available in Esperanto langauge, thanks to our user "cfm" who single-handedly localized the interface. We now support 21 languages and many more are in progress on our translation site where users themselves localize Zoho Sheet.
• Cloning an Image:
  You can now clone an image in a spreadsheet. Just hover your mouse over the image and click on Clone on the top of the image.
• Multiple Column/Row Resize:
  Earlier, it was possible to change the width / height of multiple columns and rows by using the right click options. Now you can resize them by just selecting the columns and then resizing one of them. The other columns will be assigned the same equal width. Same is the case for resizing rows. In an earlier update, we also supported setting optimal width / height needed for the selected columns / rows upon double clicking the column/row separators.
• Scrolling on range selection:
  The grid will now scroll while doing range selections either using the mouse or the keyboard.
• More shortcuts for navigation:
  New shortcuts Ctrl+Up, Ctrl+Down, Ctrl+Left and Ctrl+Right help you to quickly navigate through the data in your spreadsheet. These shortcuts can also be used along with the Shift key to select such cell ranges.
• Bug Fixes and Improvements:
  An issue with respect to showing the weekday in Japanese date formats has been fixed. Performance improvements have been done in bringing up the Share Dialog and also while inserting / deleting columns. More performance improvements on the way.

Public Spreadsheet URLs and Number of Views:

• Short and Readable URLs:
  The URL of public spreadsheets have now been made more readable and much shorter. The URLs will be of the form http://sheet.zoho.com/public/username/documentname. Your existing public URLs and embedded spreadsheets will continue to work on the old URL as well.
• Listing of user's public spreadsheets:
  http://sheet.zoho.com/public/username/ will list the public documents of a particular user and you also have a RSS feed for that. This RSS feed will be useful if someone wants to subscribe to your public spreadsheets. It will also be useful to you if you want to display a list of your recent public spreadsheets as a widget in your blog or website. Please note that public spreadsheets which are set not to show in Zoho public documents will not be shown here.
• Export public spreadsheets via URL:
  You can export a public spreadsheet by appending .filetype at the end of the URL. For example: http://sheet.zoho.com/public/username/documentname.xls will export the spreadsheet to XLS format. Supported extensions include xls, sxc, csv, html and pdf.
• Number of views:
  We also now show the number of times a particular spreadsheet has been viewed. These are not unique visitors but are actually page loads. In the public spreadsheet view, the views are shown beside the filename at the top. Views are being tracked since the last 3 months.

Charting Enhancements:

• Charts with data in another sheet:
  You can now draw charts for data ranges available in a different sheet in the same workbook. For example, you can have a chart in Sheet2 with the data range pointing to Sheet1!A1:E30. These are handled in Import and Export as well.
• Charting on discontiguous data ranges:
  Support for charting on discontiguous data ranges like A1:A10,D1:E10 have been added. Currently you have to manually type in such ranges. They are handled in Import and Export as well.
• Chart Scale:
  The Y-Axis scale of charts will automatically be adjusted depending on the values. Suppose your values are in the range 80-90, the Y axis will start at 80 instead of 0. These will be applied to all charts except Column and Bar charts.
• Chart Colors:
  The default chart colors have been changed. The colors are not customizable yet. We wanted to change the initial default color of red (which is somewhat negative) and we came up with this new color palette.

Blue Theme and Norwegian language:

• Blue Theme:
  We have come up with a light and pleasing blue theme, named Mint Blue. We already have a grey theme in addition to the classic green theme. The default theme is now changed to the new blue theme. You can select the Theme you prefer from the Themes menu at the top.
• Norwegian Language:
  Zoho Sheet is now available in Norwegian language, thanks to our users who translated it on our translation site. With this, Zoho Sheet now supports a total of 20 languages. If you want to see Zoho Sheet in your language, then fill in this form.

Performance Improvements and Fixes:

• We have made some performance improvements and fixes in Formula recalculation. Performance has been improved in Range selections too.
• Hyperlinks in cells will now inherit the font styles of the cell, except for foreground color, which will always be blue.
• Some rare issues while sharing spreadsheets have been fixed.

Enhancements:

• Macros Localization:
  The new Macros feature has now been localized to Japanese and Simplified Chinese.
• Contacts:
  Your contacts (the email addresses to which you had shared spreadsheets) have now been moved over to the common contacts across Zoho Services. Similarly your contacts from Other Zoho applications will now be shown while sharing in Zoho Sheet.
• AutoSum:
  The AutoSum functionality has been enhanced. Previously you had to select a range and then click on the AutoSum button. Now you can just select the target cell and click the AutoSum button (or the shortcut key Alt+=) and it will automatically show the SUM formula for the cells above or towards the left.
• Keyboard shortcuts:
  Couple of shortcut keys have been added. Alt+= is for the AutoSum functionality mentioned above, while Ctrl+Shift+N is to focus the current cell indicator (available towards the left of the formula bar). You can use this current cell indicator field (or Named Box) to go to an already define named range or to define a new named range for the currently selected cell / range.
• Search Shared Spreadsheets:
  Search available on the sidebar used to search only the content of your own spreadsheets. Now it will search inside spreadsheets shared to you too.
• Expand Formula Bar:
  The formula bar can be expanded / collapsed using the expand button at the extreme right of the formula bar. This is quite useful if you are typing in a long text or formula. The shortcut key for the same is Ctrl+Shift+U.
• Bug Fixes:
  We have fixed certain issues related to Undo of borders and the STOCK() function.

VBA Macros:

• We have now added support for VBA Macros in Zoho Sheet. You can write VBA code to automate or do a variety of tasks on your Zoho spreadsheets. Use the Macro menu on the toolbar.
• Importing Microsoft Excel spreadsheets with Macros will automatically import your macros too. Exporting from Zoho Sheet currently doesn't support Macros.
• We have created a separate wiki site for people to share and exchange Macro code snippets. This site can be accessed from http://vbmacros.wiki.zoho.com.
• Record and Play Macros will be supported in a future update.

Pivot Tables:

• We now support Pivot Tables to help you analyze your data and create Reports. Use the Pivot menu in the toolbar.
• Pivot Charts are also supported in addition to Zoho Sheet charts.
• You can either import a CSV file as tabular data and create reports (or) select a range in your existing Zoho spreadsheet and create reports.
• Publishing of Reports, Print Reports, Import / Export of spreadsheets with Pivots are some of the things that will follow in a future update

Other New Features:

These features were supported in the last 5 months and we have been regularly updating the site.

• Share Spreadsheets to Groups:
  Sharing to a group of users has now become easy. You can create groups in Zoho and share your spreadsheets to groups. Groups are common across Zoho services like Writer, Sheet, Business, etc.
• Support for Named Ranges:
  Names can now be assigned to a cell or a cell range. These names can then be used in formulas / macros to refer to a range of cells. To define a name, select the cell range and then use the "Name this Cell" menu item in the More Actions menu or in the right click context menu.
• Multiline Support:
  Multiline support inside a cell has been added. You can use Ctrl+Enter or Alt+Enter to insert a line break inside a cell.
• New Publish Options:
  New publish options have been added to control use of your public spreadsheets in Zoho. You can now restrict users from exporting your public spreadsheet. You can also hide formulas used in your public spreadsheet from your users. This is useful if you want to prevent users from viewing the formulas you have used.
• Support for large spreadsheets:
  You can now load upto 100,000 rows of data when imported as CSV files. You would need to select the Tabular Data option while importing. We will also make our application scalable for other data formats too.
• Auto-Filter:
  We support auto-filters when imported as CSV files. Again you would need to select the Tabular Data option while importing. Filters for normal spreadsheets will be supported later.
• Freeze Panes (partial):
  While importing CSV files containing structured data, if you choose the Tabular Data option, the top row will be freezed and you can apply freeze columns on any of the columns. However we haven't supported freeze panes in our normal sheets. This will follow in a future update.
• TSV File Support:
  Import and export of .tsv files (tab separate values) is now possible.
• New languages:
  Support for 3 more languages - Czech, Bulgarian and Traditional chinese - have been added. These have been translated by our community of users at translate.sheet.zoho.com. We now support 19 languages.
• Chinese Yuan Currency:
  Support for Chinese Yuan currency has been added.
• Set as Text:
  Use the Set as Text icon in the toolbar to set the cell format as text. This icon is available in the drop down next to the comma icon in the toolbar. If you want to enter data like 00002345235 without trimming those leading zeros or enter 4/4 without needing to automatically convert it into date, then you can set these cells as text or you can prefix the cell value by a single quote (') and it will be marked as text.
• Performance Improvement:
  Some performance improvements have been done in loading sheets and range selections. More improvements on the way.
• More Keyboard Shortcuts:
  Many shortcuts have been added. Refer Keyboard Shortcuts which is available under the Product Links at the top.
• Optimal Width and Height:
  You can double click on the column and row separators to set the optimal width and height.
• Cell selection in Formulas:
  We now support selecting cell regions using keyboard while typing in formulas.

Batch Operations and Sidebar Enhancements:

• Batch export:
  You can now export multiple spreadsheeets in your account as a zip file of xls / pdf / ods / sxc file formats. Currently you can export only till 10 spreadsheets at a time. Just select the spreadsheets and use the Actions menu at the bottom.
• Batch sharing:
  Similarly, you can select multiple spreadsheets and share them with others.
• Batch delete:
  Multiple spreadsheets can be deleted too in the same manner. Similar in the "Shared with me" section of the sidebar, you can select multiple spreadsheets and remove sharing to you if you do not need it.
• Sorting spreadsheets list:
  You can now sort your spreadsheets by created time, modified time and file name - both ascending and descending. The default sort behaviour is now changed such that your recently modified spreadsheets are shown at the top. Use ths "Sort by" menu available at the top of the "My Sheets" section.
• Filters:
  We have added few filtered views - "Shared by me", "My Public Documents", "Last Created (10)", and "Last Modified (10)". Look for the View menu in the sidebar.
• File Info and Actions:
  Along side each file in the sidebar, you will find an icon hovering over which will display the file info such as last modified time, users shared to, etc. You also have an action icon to Delete, Duplicate or Export the specific file.

More Features:

• Autofill:
  While typing the first few characters in a cell, Zoho Sheet will automatically try to fill in the remaining characters based on the cell content that have already been filled in that particular column. This is quite handy when you need to type the same set of values in a column. This also reduces human error during data entry. You can also use the "Pick from list" option in the right click menu to pick from the list of strings in that column.
• Themes:
  We now have a grey theme in addition to the default green. You can set them using the Themes link at the top.
• Duplicate sheet in a workbook:
  You can now copy / move a sheet inside a workbook. To use it right click on the sheet tab at the bottom and use the respective options.
• Enhanced Color Picker:
  We have enhanced the color pickers for the cell foreground and background. Clicking on the icon directly will apply the last applied color. You can choose a different color using the dropdown near the icon.
• Goto:
  You can now go to a particular cell using the Ctrl+G shortcut. Just enter the cell reference in the text box. For example type A60 to go to the cell A60.
• 2 More Shortcuts:
  Couple of shortcuts - Shift+Enter to go to the previous cell in the same column and Ctrl+K to insert a hyperlink have been added.
• New Date Format:
  A new date format "D MMM YYYY" has been added based on requests from the Genealogy community.

Enhancements and Fixes:

• Images in spreadsheets are also versioned along with the spreadsheet.
• When you save a shared spreadsheet to your account, images and charts weren't copied. This has been fixed now.
• Issue with respect to opening the active sheet in a workbook while loading has been fixed.
• Now you can share your spreadsheet to only 20 users at a time. To share with more people, you need to repeat the steps.
• Automatic row height changes in IE when formatting the cells has been fixed. Certain row header alignment issues in IE have also been fixed.
• When you scroll through a large data set and try to draw a chart for it, the generated chart was not being shown in the visible area. This has now been fixed.
• Some performance improvements have been done including speeding up formatting of a cell range.

Search across spreadsheets:

• We now support File content search. You can search for content across your spreadsheets. Use the search box on the sidebar. Earlier we supported only tag search.
• Currently this doesn't search inside spreadsheets shared to you or the old revisions / versions of your spreadsheet.
• You can search for spreadsheets matching specified tags (as supported earlier) by prefixing "tags:" to your search query.
• The search in start.zoho.com will search across all your documents, spreadsheets and presentations in Zoho.

Fixes:

• Zoho Wiki page editing issue when a Zoho Sheet is embedded in the page is fixed.
• Bug in Remote API save when the filename has special characters like "/" has been fixed.

Changes:

• 2 new languages, Catalan and Turkish, have been added, thanks to our users Joaquim Virgili and Alpay, who translated them to Catalan and Turkish respectively. Other languages are also updated with the latest messages in http://translate.sheet.zoho.com
• Insert Images now accepts an image available in a public URL too.
• Issues in our Remote API editor on Internet Explorer have been fixed.

Community driven localization:

• We launched a site last week for community driven translation of the Zoho Sheet interface. You can read more about it on our blog. If you wish to translate the Zoho Sheet interface to your language, then you can do it at translate.sheet.zoho.com.
• We launched it on 13th of this month and within couple of days, one more new language, Romanian, has been translated by our users and we have now added it to our main site. Now you can select Romanian from the Language settings.
• Many other new languages are being translated by our users at translate.sheet.zoho.com.

Changes:

• Zoho Sheet's Remote API now supports uploading workbooks in the CSV format too.
• Issue with respect to Real time collaboration in Safari has been fixed.
• Undo / Redo using the shortcuts Ctrl+Z and Ctrl+Y is now fixed in Safari.

Insert Images:

• You can now insert images into your spreadsheets. Click on the Insert icon in the toolbar (the icon with the + symbol in it) and select Insert Image.
• You can also insert already uploaded images, just click on Insert Image, drag the image and drop it onto your spreadsheet.
• In the next update, you will also be able to insert an image available in a public URL.

Safari support:

• We have fixed some of the pressing issues in Zoho Sheet on the Safari browser. Now you will be able to view and edit spreadsheets on the latest version of the Safari browser (Safari 3 and above).
• Few more issues in Safari will be fixed.

Other New Features:

• More Currencies:
  We now support few more currencies - Euro, British Pound, Japanese Yen and Indian Rupee in addition to the US Dollar.
• Chinese Language Support:
  We have added support for Simplified Chinese language. You can select it from the Language link at the top.
• ... and some bug fixes and performance improvements.

Stock Quotes Function:

• You can now fetch stock quotes into your cells by using the STOCK function.
• This function is available under the Stock category and Financial category in the functions dialog.
• Note: Stock details are provided from free stock sources available in the Web. The data may be delayed up to 30 minutes. Also the data provided is solely for informational purposes.
• Limitations: This cannot be currently used in nested functions, nor can it refer other cells.

Other New Features:

• Multi-lingual support - 7 new languages:
  Support for more languages have been added - Portuguese (Brazilian and European), Danish, Italian, Russian, Swedish, and Dutch. This is in addition to the existing languages of English, French, German, Japanese and Spanish. This comes up to a total of 12 languages.
• HTML view of public spreadsheets:
  You can now find plain non-interactive HTML views of public spreadsheets for fast loading and for printing.
• More Shortcuts:
  Shortcuts - Ctrl+Home and Ctrl+End - have been added to go to the first cell and the last cell of the spreadsheet respectively. In addition Ctrl+Arrows help you to navigate the whole set of rows and columns.

Fixes and Enhancements:

• Charts export has been enhanced. The new chart types are also now supported while exporting the spreadsheets back.
• Charts are now supported in our Remote API Editor too.
• You can now add Tags to documents shared to you too. Searching on the search box in the sidebar now shows results from your shared documents too.
• ... and some bug fixes.

Fixes and Enhancements:

• 4 Japanese fonts have been added for cell formatting.
• Notify shared users will now send individual email messages to the shared users. It also adds a contextual line at the end referring to the document name and the URL.
• Multilingual support has also been added to our Remote API Editor. Now you have to pass an additional parameter like lang=fr to our remote editor for multilingual support.
• Issues in chart not getting drawn for some data ranges in our Remote API Editor has been fixed.
• Some more minor fixes and enhancements.

Enhancements:

• New button on public sheets to allow embedding in websites and blogs.
• Email notification on shared sheet updates can now be turned on/off in the Edit shared details screen.

Fixes:

• Issue in loading shared sheets on a screen with resolution 1024x768 or less has been fixed.
• Issue in sheet loading with long merged cells with borders has been fixed.

Zoho Sheet in 5 languages:

• Zoho Sheet is now available in 5 different languages - English, French, German, Japanese and Spanish.
• Login and select your language from the link at the top.
• In the next couple of updates, we will allow users to contribute translating Zoho Sheet in their native language.

Enhanced Collaboration:

• You can now customize the email message being sent out while sharing spreadsheets.
• You can choose to be automatically notified via email, when a shared user makes changes to the spreadsheet.
• There is a 'Notify Shared Users' option under the Share menu which can be used to manually send an email to the shared users.

More Enhancements:

• Recalculate:
  You can now recalculate the formulas in your spreadsheet. Just hit the F9 key.
• Formula Editing:
  You can now use your mouse to select cell ranges while typing formulas.
• Data label options in Charts:
  The data label option in charts allows you to display the labels / values / percentage on the data points.
• OpenDocument support in APIs:
  Our API now supports the OpenDocument spreadsheet (ods) format too. We already support it via our user interface.

Bug Fixes:

• Issue with non-english characters in sheet names has been fixed.
• Issue with multiple published ranges of one or more linked external data in a single sheet has been fixed.

Link External Data from RSS/Atom Feeds:

• You can now periodically fetch data into your spreadsheet cells from RSS/Atom feeds in addition to CSV files and HTML pages.
• Extended custom tags in RSS/Atom feeds, such as the GData API for Google Base, are also supported.
• Currently only the recent entries in the feed are populated. The older entries are not retained. We will be changing this behaviour in the future.
• Column selection as in linking HTML pages is also something we will be supporting in the future.

More Chart Types:

• New chart types - Stacked percentage charts (Column and Bar, 2D and 3D), Line Marker and Scatter Line Marker charts.
• This adds up to a total of 27 chart types.

Fixes:

• Fixed online status issues in certain scenarios, in Real time collaboration.
• Shared sheet loading performance has been improved since last update.

Changes:

• XHTML Export - You can now export your spreadsheets in XHTML format too.
• Bug in Copy pasting ranges while collaborating in real time has been fixed.
• Copy paste issue in Mac Firefox has been fixed. You can now use the apple key too.

Real-time collaboration and chatting:

• We now support real-time collaboration on spreadsheets. This allows users to share and work on the same spreadsheet simultaneously. Changes by the user are reflected in real time.
• You can group chat with your collaborators who are online and discuss on the spreadsheet.
• You can also chat individually with each collaborator.
• Chat transcripts are not stored currently. You can use the Comments tab beside the chat to store permanent comments.

More APIs:

• APIs for reading more granular data like a cell or cell range has been added.
• APIs are now available in 3 formats - XML, CSV and JSON (also JSONP)
• We have now supported REST APIs for the existing ones too in addition to the new APIs.
• API documentation available here.

OpenDocument support and more Import / Export types:

• We now support importing and exporting of OpenDocument spreadsheets (.ods). To learn more about this format, click here.
• New Import types: OpenDocument Spreadsheet (.ods)
• New Export types: OpenDocument Spreadsheet (.ods), Microsoft Excel 2003 XML (.xml), and Gnumeric (.gnumeric)

Enhancements in Charts:

• Importing of spreadsheets now also supports the new charts that we have recently added.
• Date type values are now properly displayed in charts.
• Fix in charting of a data range where the 1st column / row contains one or more blank cells.

More Charts:

• We have now added support for more chart types. We currently support a total of 21 chart types.
• You can now draw a chart even for multiple cell ranges. For eg) A1:A8;C1:E8
• Some performance improvements in page loading and few fixes.

Link External Data from web pages:

• You can now sync up with external data available as HTML tables in public web pages. This is in addition to public CSV files which we already support.
• Use the More Actions > Link External Data menu for this.
• Note: when you specify the polling period, you need to comply with the source website's terms and conditions.

Performance Improvements and Fixes:

• We have substantially improved the page loading speed while you log in. We will be improving this further.
• Issues in new sheet addition and sheet switching while viewing an old version has been fixed.
• Couple of issues in Link External Data has been fixed.

Link External Data:

• You can now link dynamic CSV files available in a public URL to a cell range in your Zoho Sheet. Your Zoho Sheet will update itself automatically from the public CSV file.
• You can then perform analysis or draw charts and publish charts or cell ranges which will also be up-to-date.
• Use the 'Link External Data' option in the 'More Actions' menu and provide the public URL of the CSV data and specify the start cell from where you need to include the CSV data. It will automatically parse the CSV data and insert data into corresponding cells.
• Warning: If there are more than couple of hundered of rows in the CSV data, then it might take some time to show up for the first time. We will be improving the performance in the future.

Commenting on a spreadsheet document:

• You can now write comments on the spreadsheet as a whole. This is very useful when you are collaborating with other users and need to convey your thoughts and opinions related to the spreadsheet.
• This is accessible via an icon on the bottom right of the spreadsheet.
• We will bring in notifications and moderation in future releases.
• And you would have observed that we already support inserting comments / notes on cells, which is accessible via the right click context menu.

Other New Features:

• Semi-public spreadsheets:
  You can now specify not to list your spreadsheet under public sheets on our website when you publish them as public. This is useful when you don't want people other than those whom you share the link with to view your spreadsheet. Since this is not listed on our site, search engines cannot crawl and index the spreadsheet unless you post the link / embed the sheet on some public website.
• Hyperlinks in spreadsheet:
  Hyperlinks are now supported in Zoho Sheet. It will automatically recogonize URLs and link them up automatically. You can also type a text in a cell and add an hyperlink to the whole text in the cell using the right click context menu. Hyperlink function is not yet supported.
• Auto-versioning:
  Your spreadsheets will now be versioned automatically. The last 25 auto-versioned ones will be maintained in addition to the manually marked versions. Even if you forget to manually mark your version, it will be auto-versioned when a shared user, or the original user opens it again, makes changes and saves it.

Fixes:

• The issue of borders not being drawn in IE has been fixed.
• In the last update, RAND, RANDBETWEEN and TODAY functions were not being updated when reopened. This has been fixed now.
• Issue in sheet name containing accented characters has been fixed.
• Issue in auto insertion of rows during copy paste has been fixed.
• Having & in formulas caused some issues while editing the cell again. This has been fixed now.
• Cut pasting a formula cell did not remove the formula in the source cell. This has been fixed.

Microsoft Office Plugin, APIs and Desktopize:

• You can now work with your Zoho Sheet (and Zoho Writer) documents in Microsoft Office itself. Download the plugin now!
• We have opened up our APIs for you to create nice interesting and useful mashups. For details on Zoho API, see the Zoho API developer guide. More granular APIs coming up soon.
• Desktopize, our partner customized their offering for Zoho making our applications behave more like a desktop application. If you like desktop shortcuts, quick tray access, Drag-n-drop documents into Zoho apps, try out this application.

Enhancements:

• We now allow you to remove documents from your shared list if you are no longer interested in it.
• Some issues in charts while exporting and importing spreadsheets have been fixed. There are still some small issues which we will be fixing up.

New Features and Enhancements:

• Undo / Redo has been supported upto 10 levels. Use the standard shortcuts Ctrl+Z and Ctrl+Y.
• Performance improvements have been made. Now your sheets should load faster.
• Print Preview now includes charts too. Changes have been done such that it will show only the current sheet.
• You can now import a file to your account from a public URL too.

Fixes:

• Fixed showing empty file list under My Sheets when any of the files contain special characters like a double quote in its name.
• Fixed link to the spreadsheet in RSS feeds of public spreadsheets.
• Some minor bug fixes.

Changes:

• UTF-8 characters are now supported in spreadsheets and file names. So now spreadsheets in other languages like Japanese, Chinese, etc are supported.
• We have moved Zoho Sheet to the Grid for better scalability and availability.
• Scrolling of sheets in a workbook has been support.
• Selecting a range of numbers will display the Sum value in our status bar at the bottom near the sheet tabs.

Cell Borders:

• Support for cell borders has been added. You can now format your spreadsheets the way you want.
• Advanced options like border colors and border thickness will be supported in the future. However importing a spreadsheet with colored / thick borders will be shown as it is.

Publish Cell Ranges:

• You can now publish specific cell ranges too. Just select the range, right click and select Publish this Range. You can also use the Publish menu for this purpose.
• You will get an HTML code which you can paste it in any web page / blog / Zoho Writer document / Zoho Show slide.
• This is a non-interactive read-only view of the range which will look like a normal HTML table fitting in well with the overall web page contents.
• Everytime the published page is opened, you get the actual live data from Zoho Sheet.

Version your spreadsheets:

• We added the much needed ability to version your spreadsheets so that your old revisions are safe with you.
• You need to specifically mark your versions. You can do it before sharing or before doing a major change. The shared user can also mark his version (if he has write access) after his changes.
• The Mark as new version is accessible under the More Actions menu in the toolbar and under the Save drop down. Version History is available under More Actions.
• You can view old versions, revert to an old version or delete an old version.

Fill series:

• Fill series has been supported. You can either fill down or fill to the right.
• To enter a vertical series of 1, 2, 3, etc you can just type 1 and then drag the small box at the bottom right of the selected cell while holding the Ctrl key. Without the Ctrl key it will paste the same value in all the dragged cells.
• Similarly you can fill months like Jan, Feb, etc. and dates like Sep-27-2006, Sep-28-2006, etc.
• The most important use is when you have a formula and you want to fill down similar formula for a range of cells.

Fixes and Enhancements:

• Another important area we have worked upon is speeding up the loading time. This will be more visible when you import new files.
• You can now export your sheets via just an URL. Just add "&export=xls" at the end of the permalink of your sheets - either private, public or files viewed through the quick read plugin. Supported export types include xls, sxc, csv, html and pdf.
• New rows and columns will be added when you are on the last row / column and hit the enter / down / right keys
• You can now Save to your account the sheets that you view from our excel viewer / quick read plugins / throwaway sheets. Use the Save to my account button.
• We use the Yellow fade technique to highlight changes in dependent cells when a cell value changes. This caused an issue of background color of the dependent cells changing to white. We have fixed it now.
• Some minor issues in sheet level sharing have been fixed.

Publish and Embed your spreadsheets:

• You can now embed your spreadsheets into your website pages or blogs or even a Zoho Writer document or a Zoho Show slide. These are live spreadsheets, so changing the data in Zoho Sheet will automatically be reflected in the published pages.
• Use the Publish button to make the spreadsheet public and embed it to any webpage. Please note this will make the document public and will also list it in www.zohosheet.com. However this is subject to change in the coming updates.
• Copy the HTML snippet shown and paste it in your desired place.
• We also have publishing cell ranges alone, coming up.

Share specific sheets:

• You now have the option of sharing specific sheets in a workbook with other users.
• You can even specify some sheets as read-only and some sheets as read-write for the users. You can also hide certain sheets.
• This is in addition to sharing the whole document / workbook as such, which is the default.

Merge cells and Vertical alignment:

• We now support horizontal cell merge. You can merge 2 or more cells horizontally by using the merge icon in the toolbar. You can also split merged cells by using the split icon in the extended toolbar.
• Vertical alignment has been supported now. They are available in the extended toolbar.

Fixes and Enhancements:

• Added Clear Formatting in right click menu which will clear the styles as well as the formatting like number, date, currencies, etc.
• You can now copy cells and paste it on to a bigger target range. This will paste the cell content in each of the cells in the target range. This is very useful when you want to apply the same formula to a big range.
• The Reply-To header of the email being sent out while sharing documents will now be set to the email address of the document owner. So the shared user can now directly reply to the auto-generated email.
• Fixed issue in deleting large number of rows and columns.
• Overlapping of text has been fixed in imported sheets when the content overflows to the next cell. To view the full content, you now need to resize / set the column width or merge with the next cell on the right if it is empty.

Changes:

• Speeded up loading times while opening and switching between sheets. The first time there may not be any different, but subsequent load times should be faster. We will be improving the performance even more in the coming updates.
• Previously the separator for arguments / parameters to a function was semi-colon. Now comma is also supported as the argument separator similar to MS Excel.
• Previously you had to refer to cells in other sheets using the dot operator, for example: =Sheet1.C3. Now the ! operator is also supported as in MS Excel. So =Sheet1!C3 will also work.
• Demo login will now show only recent 10 files. It will also open a Welcome sheet by default when you login. Use demo login only for testing or trial purposes.

Number and Date Formatting:

• With number formatting, you can format your numbers and dates the way you want.
• It will also automatically recogonize dates and numbers you type.
• We will be adding more formats, especially currencies in the coming updates.

Sorting:

• You can now select a range, right click and sort the data in the range.
• Sorting can be done on any column and if there are any duplicate entries in that column, you can sort the values further by specifying 2 other columns in the range.
• There is also an option to specify if the range contains an header so that it can be ignored.
• Quick Sort buttons, A-Z and Z-A, are available on the toolbar, which will sort by the first column, either ascending or descending. Quick Sort is case insensitive. Headers should not be selected in the range for quick sort.
• We know that Undo is missing and might be required immediately after a sort. We will support it in the coming update.

Insert Comments / Notes on cells:

• You can now add comments to cells by right clicking on the cell and selecting the Insert Comment menu.
• A comment is a piece of text which you can attach to a cell. Upon hovering the mouse over the cell, the comment gets displayed. Very useful to refer back later or to guide your users.
• To edit or remove the comment, you can again use the right click menu.

Right click context menu:

• We have added a Right click context menu to easily access the various operations.
• Operations like Cut, Copy, Paste, Clear contents, Wrap, Insert and Delete Rows, Columns, Insert Comments, Sort, Column Width, Row Height, etc are available by right clicking on the cells or row and column headers.
• The Cut, Copy and Paste available in the right click menu is only for copying and pasting within Zoho Sheet, either in the same document or across documents. To be able to copy to external applications like Notepad / Excel, use the Copy to Clipboard menu. However, the shortcut Ctrl+C can be used for both copying within Zoho Sheet as well as copying to external applications.

Column Width and Row Height:

• You can now set the column width and row height using the right click option and specifying the value.
• Width or Height for multiple columns or rows can also be set by selecting the required columns / rows and specifying the value as above.

Fixes and Enhancements:

• Issue in typing on the formula bar and selecting another cell (without hitting enter / tab keys) not saving the value has been fixed.
• Charts can now handle negative currencies too.
• In 2D charts, the x-axis and y-axis title used to be misaligned. It has been fixed now.
• Fixed email validation to allow signing up with .info mail aliases too.
• In functions dialog, even after clicking on a function, the syntax will be shown for reference. There is also a description link beneath the syntax which explains more on the function.
• Setting fonts and font sizes was very slow. We have improved the speed now.
• Insert / Delete rows and columns are available in right click menu now. So the toolbar has been modified such that these actions are grouped and available under the plus and cross icons on the extreme right of the toolbar.
• Session Timeout is set as 1 hour. So after 1 hour of inactivity, Zoho Sheet will automatically log you out. It won't affect you, if you keep editing or browsing Zoho Sheet with gaps of not more than 1 hour.

Insert Function:

• We have added a Functions screen, which will list all the supported functions. We support more than 300 functions currently.
• Use the Insert Function button fx on the toolbar to bring up the Functions screen.
• You can insert functions by directly clicking on the function names. Hovering the mouse over the function will display the syntax at the bottom.
• Nested functions can easily be created by placing the cursor at the desired position and using the Insert Function button.
• When functions are entered in the formula field at the top, hit enter / tab key to save the value in the cell. We have an issue of the cell not saving when another cell is selected without hitting enter / tab key. We hope to fix it in the coming update.

Fixes and Enhancements:

• Fixed issues in cell wrap
• Fixed some issues related to insert rows at the end

Home page changes:

• We have redesigned the home page to accomodate more useful content.
• We have added some sample sheets and highlighted the new features.
• We have also added an Online Excel Viewer and have linked to it from the home page.

Integration with Webtops - Pageflakes and Google:

• Added a module for Pageflakes. Go to http://pageflakes.com/, click on Add Feed, Enter Feed and give the URL: http://zohosheet.com/pageflakes.html
• Zoho Sheet module for Google personalized home page is available now. Add our Zoho Sheet module by following the links in Google personalized home page: Add content > Add by URL (near the Search button) and then giving the URL - http://zohosheet.com/google.xml

Enhancements:

• Copy Paste across sheets is supported now. It also maintains all the formula relatively while pasting. Use shortcuts Ctrl+C and Ctrl+V for Copy and Paste.
• Copy Paste will now insert rows / columns as necessary at the end.
• The published URL of the chart will now be shown in the public sheet too, to allow other users to embed the chart elsewhere.

Publish Charts:

• You can now publish charts and embed them on your webpage / blog / your Zoho Writer documents with just a single line of HTML code.
• The published charts will always show the latest data. If you update the data in excel, the published chart will automatically change.
• You can publish charts present in both private and public sheets. Only the owner of the document will have permission to publish the chart.
• This option is available on the chart's title bar when you hover your mouse over the chart.

Fixes and Enhancements:

• Insert or delete rows and columns will now update the dependent formulas automatically
• Issue in cell wrapping a range fixed
• Some more minor issues have been fixed

Insert Rows and Columns:

• We have now added the most requested feature of inserting or deleting rows and columns. You can find icons for these actions on the toolbar.
• While inserting rows in between, dependent formulas will be altered accordingly.
• While deleting rows in between, dependent formulas are not altered currently. We will be fixing it soon.
• You can now select continous columns or rows by dragging with the mouse or using the Shift key along with left mouse clicks.

Multiple Sheets Reordering:

• The sheets in your document can now be rearranged by dragging the tabs around.

Import CSV and Save As:

• CSV files can now be imported into Zoho Sheet in addition to MS Excel and OpenOffice Calc files.
• We have now added a Save As option to save a copy of your spreadsheet and work on the copy.

Permanent URLs and Bookmarking:

• Now each document has a permanent URL. You can open your Zoho Sheet documents into different browser tabs / windows by right clicking on the file name and selecting "Open in New Window" menu.
• Yes, you can simultaneously edit any number of spreadsheet documents opening them in different browser tabs or windows.
• You can also bookmark the individual files by right clicking on the file and selecting the "Bookmark this Link" / "Add to Favorites" menu.

Fonts:

• You can now specify different fonts for your cells.
• Font sizes can also be set.

Fixes and Enhancements:

• Issues in editing cell content on the formula bar have been fixed.
• Documents disappearing from the sidebar due to special characters in the file names has been fixed.
• The content of the email message for shared documents has been enhanced.
• Occassional Sign-up errors fixed.

Multiple Sheets:

• We now support multiple sheets in the same document / workbook. You can insert as many charts as you wish.
• You can even refer to values in other sheets and create formulas that depends on cells in other sheets in the document. For example to refer to cell A2 in Sheet1, you need to refer it as $Sheet1.$A2
• Your already imported sheets will now show all the sheets, except for the graphs for which you need to reimport again.
• Right now there are some limitations like you cannot draw a chart in 1 sheet referring to data on another sheet. We hope to support it soon.

Streamlined Interface:

• We have AJAX-ified the whole interface so that the sheet loading is smoother and faster.
• Improved toolbar layout for better organization.

Import and Export Excel with Charts:

• Import Excel will also import the graphs now.
• Export Excel will also export the graphs now to formats such as MS Excel, OpenOffice Calc and Adobe PDF.
• Note: Export in public sheets / throwaway sheets doesn't export the graphs yet.

Fullscreen Extension for Firefox:

• New Firefox extension to automatically go into Fullscreen mode whenever you visit zohosheet.com.
• This will allow you to avail maximum screen space for your spreadsheet.
• After logging in, use the "Fullscreen Hint" link at the top to install the extension.
• Alternatively, without installing the extension, you can use the F11 hot-key of the browser to go to Fullscreen mode each time you visit Zoho Sheet.

Fixes and Enhancements:

• Issue in not auto-saving when we keep on editing without a 1 min gap fixed.
• Some issues in spreadsheet like tab key not navigating properly inside the sheet, cell range selection not confined to the sheet, etc fixed.

Throwaway Spreadsheet:

• You can now quickly create a throwaway spreadsheet without even signing in and export it back to excel and save it on your hard drive.

Export to PDF, SXC and CSV:

• Export your spreadsheets to PDF, SXC (OpenOffice) and CSV formats in addition to XLS and HTML already present.

... and some minor changes

Graphs / Charts:

• You can now quickly draw graphs / charts to analyze your data in your Zoho Sheets. Column, Bar, Pie and Line graphs are supported. Just select the data range and hit the graph icon. No complex questions asked to configure graphs.

New Toolbar functions - Cell Wrap and Print Preview:

• Cell Wrap:
  Apply cell wrap to the cells to fit the content inside the cell. No more overlapping of text.
• Print Preview:
  You can now print your spreadsheets by clicking on the Print Preview icon in the toolbar, which will open the print preview in a new window. You have then use the Print button in your browser's toolbar / menu to print the spreadsheet.
• New Icons:
  The toolbar buttons for Create, Import, Save and Export have been changed to nice icons to accommodate other functions on the toolbar.

URL APIs to view excel files online:

• You can now view through your browser, any excel file / openoffice calc files residing on your servers via Zoho Sheet. No need to have MS Excel installed on your machines to just view an excel. Use the following REST APIs:
  
  For viewing a remote spreadsheet, use the following URL API:
  http://zohosheet.com/view.do?url=http://thelinktoyourspreadsheet.xls
  
  For saving a remote spreadsheet to your zoho sheet account, use the following URL API:
  http://zohosheet.com/import.do?url=http://thelinktoyourspreadsheet.xls
  
  Replace the http://thelinktoyourspreadsheet.xls with the URL of your spreadsheet.

Auto Save:

• Your spreadsheets are now automatically saved every 1 minute. You will also notice that the Save icon will be disabled when the sheet is saved. It will come back to life as soon as you edit any cell indicating that the sheet has to be saved.

Empty Trash:

• You can now empty all files in your Trash by clicking on the Trash view and then clicking on the "Empty" link. It will prompt for a confirmation.

Currency:

• Now you can set dollar currency and percentage formats to your cells.
• You can even type in $100 and it will automatically recogonize it as a dollar currency format.

Clone Public Sheets:

• You can clone public sheets into your account. Useful if you like a public sheet and want to modify on it and have it in your account.

RSS Feeds:

• You can subscribe to RSS feeds of public sheets or sheets with a particular tag.
• We support RSS 2.0

Confirm Save:

• Now we will prompt you to save the sheet, if you navigate away from the sheet without saving it.

Create and Manage Spreadsheets Online:

• You can Create, Store, Access and Manage your Spreadsheets Online.
• You can use the demo login to create your temporary sheets. All sheets created in the demo account are public by default. They might be deleted after a few days. You can signup for free to have your own personal workspace.

Import:

• Stop worrying about re-doing all your existing valuable spreadsheets. We have an import functionality just for you.
• Import your Excel as well as your OpenOffice spreadsheets.

Export:

• Data is always yours! Yes, you can export your zoho sheets to Excel / HTML formats.

Formulas:

• Comprehensive support for almost all excel forumulas like math, trignometric, date & time, statistical, logical, etc.
• Note that all formula's start with an '=' sign.
• For AutoSum, you can just select the range and hit the Sum (sigma) button to calculate the sum of the selected cells.

Formatting:

• Text: Bold, Italics, Underline
• Colors: Cell Text color, Cell Background color
• Alignment: Right, Center, Left Justification.

Spreadsheet editor:

• Multi Cell(Range) Selection:
  You can select multiple cells/Range using mouse drag or keyboard arrow keys along with the Shift key.
  You can multiselect cells and apply formatting / colors / delete data in cells.
• Resize:
  Columns and Rows can be resized to format your data better.
• ShortCuts:
  Save your time by using the following standard keyboard shortcuts.
  Save - Ctrl+S
  Copy - Ctrl+C
  Cut - Ctrl+X
  Paste - Ctrl+V
  Bold - Ctrl+B
  Italics - Ctrl+I
  Underline - Ctrl+U

Cut/Copy/Paste:

• From External Sources:
  Copy from external sources such as your Excel or a HTML table in a webpage and paste(Ctrl+V) it in your zoho sheet by selecting a start cell.
• Within Zoho Sheet:
  Select a range/cell in the currently opened zoho sheet and Copy/Cut-Paste it on to a different cell
  Formulas automatically changes relatively while copying. Very useful when you want to apply similar formula for multiple cells.
• From Zoho Sheet:
  Yes, data is always yours! Select a range/cell and you can copy(Ctrl+C) your valuable data from zoho sheet and paste(Ctrl+V) it on your external source.

Tagging and Search:

• You can attach tags (keywords) to each document for organizing your spreadsheets better. Tagging makes life easier while searching for your valuable sheets. You can add tags one at a time, or several at a time by separating them with spaces.
• Popular Tags are available as a Tag Cloud for your personal sheets as well as public documents. For simplicity, as a rule, the tags in the tag cloud are arranged alphabetically while size of the text represents its popularity.
• Search is just a click away. Type the word you want to search for and it lists you the documents tagged with the specified search query.
• File names are automatically added as tags when you save them.

Sharing and Collaboration:

• Share your spreadsheets with your friends and also control the access levels to them.
• Document will be locked for editing when multiple people try to edit at the same time.
• Spreadsheet document can be published as a public doc for the whole world to see. Each has its own URL through which it can be accessed.
• Search and explore public documents by tags and copy them to your account if you like them.

Lots more to come. If you would like to see any specific feature in zoho sheet, kindly drop us a mail at support@zohosheet.com.