We made an update just now in Zoho Sheet with support for the following:
– Publish sheet to enable embedding of spreadsheets in webpages
– Specific sheet sharing enables you to share individual sheets to a set of users
– Horizontal merging of cells
– Vertical alignment of cells
and some enhancements.
This enables you to embed your interactive spreadsheets to your blog or a website page or a Zoho Writer document or a Zoho Show slide. These are up-to-date spreadsheets. Any changes in the original spreadsheet in Zoho are reflected in the published spreadsheets. Right now, the spreadsheet has to be made public to avail this feature and the public sheet will also be listed in zohosheet.com. This is subject to change on a later update.
Here is a spreadsheet embedded in a Zoho Writer document.
More on embedding your spreadsheet into Zoho Writer and Zoho Show on a later post.
Share Specific Sheets:
You can now share specific sheets to specific users with specific access too. So now you can have everything related in one workbook / document and share it with your users giving appropriate permissions. You can even hide sheets you do not want to share. The default is however sharing the whole document. We have also added auto completion of email address. If you are trying to share a document to an email address to which you have already shared, it will prompt the email address as you begin to type the first few letters.
Merge cells and Vertical alignment:
We have now supported horizontal merging of cells. You can span your cell content across multiple cells horizontally. Vertical merging of cells will follow in the coming updates. And no more overlapping of cell content.
Vertical alignment is another thing that we have added in this update. Use the icons in the extended toolbar for this.
We have also made some enhancements like copying cell(s) to a bigger target range will paste the content in the whole range. Very useful if you need to copy a formula to multiple cells, in the absence of fill series. Have a look at our What’s New page for more information.
As usual, keep sending us your valuable feedback and suggestions.
P.S: This wordpress installation removes the iframes and hence I am currently unable to post the spreadsheet directly in our blog. I think we need to customize it.