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..
Writer
Get Started. Write Away!
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..
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
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,
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー