Feedback on Zoho Sheet
Firstly I would like to congratulate you on the commendable effort of getting something like this on the web. I know that there are competing product offerrings but Zoho seems to be the best of the lot that I have tried. Also like the integration with Google and Yahoo sign on.
Those were the bouquets, here come the brickbats. I spent some time on Zoho Sheet and was disappointed by atleast a couple of things.
First, by the time taken to update the values of the lower part of a range chain when a chain cell is updated in the upper part.
For example if I have a column of 100 cells, the values of each of which depend on a single cell in another row, based on a formula. If I change the value of this single cell, the values of each of the 100 cells in the first row should get updated via a formula. Like for an interest rate calculation scenario if I change the interest rate the interest payable every year changes. The time takes is just not acceptable, though I like the yellow highlighting of the cells that were updates/affected by the change.
Second, on a very related note the dragging of values or formulae from one cell to another vie the plus drag takes a long time when the number of target cells is large. So if I define a formula in one cell and want to drag it for a 100 cells, it takes way to long to update. Though I like the fact that you guys have put in the functionality to update cell numbers in a formula on the drag and to not change the cell when preceeded by a '$' sign. That was impressive.
Lack of ability to quickly format cells is an issue. For example if my numeric data has inconsistency in the number of digits after the decimal, ranging from no values after the decimal to 8 values after the decimal point, and I want to make them all uniformly have only 2 digits after the decimal, I have to keep playing with the Decrease/Increase decimal button to get them all to uniform lenghts. An MS Excel kind of Format option on the context menu would be really helpful, with the features offerred by the Format option available.
Lastly, for the time being cause I will likely follow up with more requests for enhancements the more I use Zoho, the inability to lock cells and protect sheets is a major drawback especially when sharing files. It is a very common scenario when you want to share spread sheets where you want users to be able to modify values for some cells but not give them the ability to modify any calculated fields for fear of them messing up the formulae. This is something that most power users who stop short of becoming Excel VBA programmers would want.
Keep up the good work guys, hope to see more updates and a more robust suite of applications that can actually replace the desktop based traditional productivity suites. Also hope that some of my suggestions above are inculcated to make this a more user-friendly feature rich app..
Those were the bouquets, here come the brickbats. I spent some time on Zoho Sheet and was disappointed by atleast a couple of things.
First, by the time taken to update the values of the lower part of a range chain when a chain cell is updated in the upper part.
For example if I have a column of 100 cells, the values of each of which depend on a single cell in another row, based on a formula. If I change the value of this single cell, the values of each of the 100 cells in the first row should get updated via a formula. Like for an interest rate calculation scenario if I change the interest rate the interest payable every year changes. The time takes is just not acceptable, though I like the yellow highlighting of the cells that were updates/affected by the change.
Second, on a very related note the dragging of values or formulae from one cell to another vie the plus drag takes a long time when the number of target cells is large. So if I define a formula in one cell and want to drag it for a 100 cells, it takes way to long to update. Though I like the fact that you guys have put in the functionality to update cell numbers in a formula on the drag and to not change the cell when preceeded by a '$' sign. That was impressive.
Lack of ability to quickly format cells is an issue. For example if my numeric data has inconsistency in the number of digits after the decimal, ranging from no values after the decimal to 8 values after the decimal point, and I want to make them all uniformly have only 2 digits after the decimal, I have to keep playing with the Decrease/Increase decimal button to get them all to uniform lenghts. An MS Excel kind of Format option on the context menu would be really helpful, with the features offerred by the Format option available.
Lastly, for the time being cause I will likely follow up with more requests for enhancements the more I use Zoho, the inability to lock cells and protect sheets is a major drawback especially when sharing files. It is a very common scenario when you want to share spread sheets where you want users to be able to modify values for some cells but not give them the ability to modify any calculated fields for fear of them messing up the formulae. This is something that most power users who stop short of becoming Excel VBA programmers would want.
Keep up the good work guys, hope to see more updates and a more robust suite of applications that can actually replace the desktop based traditional productivity suites. Also hope that some of my suggestions above are inculcated to make this a more user-friendly feature rich app..
Topic Participants
ahmad.maredia
Ramesh Sripathy
rennie
Godwin
Sticky Posts
Slicers are now available in Zoho Sheet—filter your data interactively
At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,Check out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the FormatFormat and analyze spreadsheet data with Zoho Sheet's Table
While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,Introducing Data Bars: Graphically represent changes in data within the cells
Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient methodZia in Zoho Sheet now makes suggestions on conditional formats, picklists, and checkboxes
Zia, Zoho's popular AI assistant, has been helping users succeed across Zoho applications since inception. In Zoho Sheet, Zia helps users efficiently build reports and analyze data with recommendations about data cleaning, charts, and pivot table. Also,