The 'Text to Columns' functionality (available under the Data tab) lets you to split data in cells to different columns based on a delimiter you specify. This is quite useful when you want to split data in 1 column to multiple columns. For example, splitting a column contain Full Name to two columns containing First Name and Last Name. In this case, the delimiter would be given as a space.
This dialog will also be shown automatically when you paste data from an external application, provided it spans multiple rows and appears to be delimited by a character other than the tab character. This option is very useful when you paste a bunch of data (comma-separated data for example) from an external application.
You can also set the format of each of the columns detected. If you have a date column, you could also set the date format (DMY/MDY), which is quite important specifically when you are pasting from an external application. You could also set the locale of the data being pasted, as there could be differences in the way thousand separators, decimal places are represented in different locales.
With this release, we have enhanced our Auto Filters and added support for Filter by Cell Color and Text Color. Often we use color codes to highlight or differentiate different values in a table. Filter by color helps to quickly filter by one or more colors. Filter by color also works with cells formatted a particular way using
To accomodate these additional options,
we have also redesigned the Filter interface and have made it more compact.
Check out the screenshots below depicting Filter by Color on the Priority column. You can try it out for yourself on this
You could now right click on a cell and then add/apply a Filter based on the cell value, cell color or text color. You could also reapply the filter after making edits or clear the filter. These options are also available in the Filter submenu on the toolbar as well.
We have now made it easier to select/input ranges in our dialogs without the dialog obstructing the spreadsheet. You will see an icon placed next to the text field that asks for a cell / range. Clicking on that icon will collapse the dialog to a small size with just the input for the range. This component is typically called the Range Selector or Range Picker or in some cases even RefEdit. You could select the desired range in your spreadsheet and then press the icon again or hit enter to return to the dialog.
You could also try selecting the range directly when the focus is on that field without needing to click the icon. In this case, the dialog will automatically shrink to avoid being in your way of the selection. When the selection is done, you would automatically return back to the dialog with the selected range filled in.
Wherever we ask for a range such as in Insert Chart, Define Name, Audit Trail (Filter by Range), Show Published Ranges, Conditional Formatting, etc., you will see this option available.
We have added an additional option in Manage Rules of Conditional Formatting to filter the rules by a specified cell range. This is useful when you have lot of rules defined in your spreadsheet. You can also filter by a specific worksheet or list all rules in the whole document.
Several other enhancements, performance improvements and bug fixes have been gone into this update.
We also released couple of features in end of January:
You can now notify collaborators via email right from within the spreadsheet editor. Imagine that you have shared your spreadsheet with your co-workers and have asked them to fill in some data. And after a few days, they still haven't filled in the data. You can use this 'Notify Collaborators' to send an email right from within our application reminding them to fill in the required data.
'Notify Collaborators' is available under the Share tab. It is available for both the owner of a document as well as to those with whom it has been shared.
An owner of a document can notify all collaborators or specific people.
A collaborator can notify all other collaborators / specific people / owner / owners & co-owners.
The receipients will receive an email with the subject and message you provide. It will also contain a direct link to the document enabling them to access it quickly and perform the required task.
Zoho Docs has good folder management capabilities. But they weren't fully exposed within the spreadsheet editor. Now you can easily save your files right from within the editor. To save (move) a file to an existing folder, hover your mouse over the file name field at the top and click on the Folder icon that appears. This will open a pop-up that lists your folder tree. Select the target folder and hit Done. And you can now rename the file inline by directly clicking on the name of the file displayed at the top.
Try out these features and let us know your feedback. There are a lot more interesting features coming up.
But I'm waiting 2 years for additional option... =))
I wanna that my clients can edit range in file only some range sectors , now they can edit only full file without any limit. Btw I have some problems with some files... somefiles opens with problem like for example I have text in A2 but after open text take A1... but if clouse and check after few hours text will be on A1 again... few files have same problems, I have try different computers and different browsers.
Leave a comment on drag777's reply
Change topic type
Link this topic
Provide the permalink of a topic that is related to this topic