access my documents from Sheet after uploading them to Docs

access my documents from Sheet after uploading them to Docs

Hello everyone,

first, let me say this is a very good product. Hats off to you for you have done an excellent job.

I have started using zoho intensively in the last two days and hence started to find some bugs and/or annoyances along the way. so i decided to use zoho notes to write down my 'queries/suggestion/help please thoughts' and then merge them using zoho writer (if i can) and post them to the forum. This is going to be a long post and it feels more like a blog but i don't have a blog and i actually need answers or work a rounds to my questions.

A) As mentioned above i wanted to insert the notes i wrote to make writing this post easier but unfortunately i couldn't. so i have to copy/past. I opened zoho notes in a different window to minimize disruption.

B) On Sunday after noon i uploaded 90% of my documents to zoho docs. All files were either in office or OOo formats. However, i couldn't access them from sheet or writer. I went to sheet to access one of the files and i just couldn't see it there. It was not listed nor do i have access to my zoho docs from there. This is very strange and doesn't really make sense. I mean the files are on the server now so how hard is it to access them from the zoho sheet or writer application.

Apparently, after importing to docs i have to do another import step. To where you ask? I have no idea (I am being sarcastic here because the file is already on the server). The files are already imported to zoho docs, so import it again to where?? Anyway, when i ticked the check box next to a file and chose 'more actions' the import function was available so i used it. what happened was that the file (which in this case was located in a folder i created within the 'my folders' hierarchy) was moved/created in the main folder and had no extension (the original had .xls). And one more thing, there was a '+' instead of the spaces between the words in the file name. And, of course, now you have two copies of the same file. One that has a '.something' extension and one doesn't. One already in a neat organized folder and one just floating around.

By doing that the file became available for the other zoho applications.

Issue#1) why can't I access my files from the applications themselves before doing this extra import step. One of the benefits of docs is that I can organize my files in different folders but the way things are now defeats the whole purpose of organization. The extra import step is keeping duplicates of the files floating around which will count against my storage space limit and will make things look cluttered. Furthermore, in the 'view' box to the left of the application is a list of the files with no organization especially the folder organization I made in docs. What's that all about. Also, now, after editing the document and moving it back to the folder it came from originally (and deleting the same one with the '.something' extension) the file remains viewable from sheet/writer. Two or three months from now (when I have edited or created many many files) why do I still see a file that I no longer use. For easy access, maybe. But wouldn't it be much simpler and logical to keep things organized like how I made them in zoho docs and be able to access them directly from the application itself.

C) If you click on a folder in zoho docs you will be able to edit it from there but it will remain in the '.something' format and will not show in the 'view' box of the sheet/writer application after you finish. And also I discovered that I can't even organize the files that actually do show up in the 'view' box of the application itself (this more related to the previous point).

Issue#2) so how can i organize what i view in zoho sheet/writer?
The reason for coming back to this point is the following: zoho doesn't provide a plug-in to OOo. The only means to access zoho and see the files on zoho is the 'OO integrator' extension for OO. That extension only shows the files in sheet or writer and not docs. So if i want to edit something using OOo i have to: log-on to zoho, import file from docs to sheets (which as i said before in itself does not make sense), logout, go to OOo, use the OO integrator extension to see the file so i can finally edit it. Surely the program designers at zoho must find such approach illogical and time wasting. Not only for OOo users but also for on line zoho users who have to switch back and forth between zoho docs and the other applications just to get to there files. There must be a simpler way. I think all will be solved if we can access the files on docs from sheet or writer (with the same folder organization rather than just see a big list).

D) My last point regarding zoho docs and its integration with other zoho applications is this: after doing the extra 'import' step you have to rename the file to get rid of the '+' that replaced the spaces. So you do that. Then if you click on zoho sheets, for example, button/tab on the left (if you are on zoho personal page, that is) to go to the application you will find that the name hasn't changed yet. Refreshing the page will do the trick. However, there is a problem...

Issue#3) if, like me, you use zoho personal as your starting page to access the zoho universe, the page always loads with the mail tab open. If you navigate to a different tab and click 'refresh' on your browser, the page will load back with the mail tab open rather than the tab you were on. I found that extremely annoying and frustrating. Why take me away from the page that I am already on? What's the purpose in that? Other than to annoy me, that is?

Issue#4) how can I make zoho personal my start page when I enter the zoho 'universe' or my home page for that matter without having to enter my login info so often.?

E) moving along now to other things. One thing to mention, if you want to add an existing sheet/writer document in zoho notebook it will not work. Other people are having the same problem. I went to the forum yesterday and asked about it but no response yet. I think zoho engineers are aware of the problem and are trying to fix it before replying to us.

F) I thought zoho sheets was good. Functionally and visually. As a matter of fact, the whole zoho browsing experience is very visually appealing and beats Google docs in that sense. Zoho sheet has many useful functions. However, there are some minor points that I discovered along the way.

Issue#5) if you write something in a cell and the text overflows the boundaries of the cell (or exceeds the cell width of you like to call it that) and move to a different cell you won't be able to see the 'excess' text. The normal behavior of Excel and OOo is that you will still be able to see the excess text after the cell looses 'focus'. Not with zoho sheet. The extra text hides under the adjacent cell and the only way for you to see it is to select that cell again (have it in 'focus'). For a more permanent solution, you have to merge that cell with adjacent cells or resize the column. Both impractical solutions because in many cases either or both methods will mess with the way the sheet looks. I believe this is a bug in zoho sheet and needs to be addressed.

Issue#6) regarding the visual aspect, I think it will be wise it offer users more choices than the basic three that you do right now. I know this is a productivity suite but enhancing the overall visual experience of your users can be a major factor in making them take the leap into the online office world and choosing you rather than google, for example. See how the ability to customize Firefox was a big factor in its success. I think zoho should do the same.

Issue#7) did I mention that when you refresh zoho personal it takes you back to the mail tab rather to were you where. God, this is annoying.

G) zoho calender is smart and easy to use. I don't know if I can sync it with anything because I haven't tried that yet. However I did notice something unusual.

Issue#8) when adding an appointment in calendar there are only half hour intervals available to choose from. So if my appointment is at 13:45 or 13:50, for example, I can only choose 13:30 or 14:00. not all appointments run at half hour intervals. So this needs to be fixed.

Issue#9) along side calander there is contacts and I have a major beef with zoho contacts. No one on earth has one email account only. Many people have more than mobile number and much more have more than one work number that you get can access to them through. Why is zoho limiting our choices. If zoho engineers can't make up their minds on what we want then let us add custom fields. That way every one will be happy. And we must be able to add photos to contacts. If zoho is trying to lure the MS Office users then at least offer them something similar to they have. MS Outlook contacts is one of the best and you could add photos to your contacts there since 2003.

H) if I didn't want zoho personal as my start page then my next best thing would be zoho desktop. It is like opening MS outlook but with access to your documents.

Issue#10) however you need to add the contacts container on the page. And if you sort out the mess of file accessibilty from docs, as I mentioned towards the top of my post, you will be able to remove all the application containers and just keep the docs container thus minimizing clutter and freeing up space.

I) I use Flagfox extension on my browser. The Geo location tool indicated zoho to be in the US.

Issue#11) why don't you have servers set up in Europe to make things go faster for us (I live in Germany). Surely extra European based servers will mean more speed and better experience for those customers plus maybe more storage that you can in turn offer your users.

Issue#12) fix your spell checker in writer. Honestly it is rubbish. It doesn't recognize mistakes correctly and when you want to correct one word it just changes everything else. By the time I reached the fifth paragraph I had to re read and fix the mess that spell checker caused 4 times. So I got fed up and closed the document in zoho. Opened it from OOo using the before mentioned extension and continued working on it. So fix it. Do it like the one in Word. Very effective.

Issue#13) why don't you have an official plug-in for OOo users. Not interested in those users. Are you only after MS Office customers?

That's it. These are my initial thoughts and problems with zoho. I hope you can offer help to the issues that already have a solution or a work around and try to sort out the ones that don't. I am actually looking forward to the response of any zoho engineer or customer service personnel to see what are they doing to solve these issues or will be doing to sort things out.

Many thanks
Luay Kanaan (just another IT guy)

























































    Access your files securely from anywhere









                          Zoho Developer Community




                                                • Desk Community Learning Series


                                                • Digest


                                                • Functions


                                                • Meetups


                                                • Kbase


                                                • Resources


                                                • Glossary


                                                • Desk Marketplace


                                                • MVP Corner


                                                • Word of the Day


                                                • Ask the Experts



                                                          • Sticky Posts

                                                          • My Zoho Story #19 - How and IT service provider, CTSP, are streamlining customer support using Zoho

                                                            My Zoho Story is a video podcast series where we connect with Zoho users worldwide to hear from them about their experiences with Zoho and how it became an integral part of their everyday business life. Our recent 'My Zoho Story' took us to Australia
                                                          • My Zoho Story #18- How Mirage Visual Limited achieved enhanced customer service experience, using Zoho

                                                            My Zoho Story is a video podcast series where we connect with Zoho users worldwide to hear from them about their experiences with Zoho and how it became an integral part of their everyday business life. Our recent interview with Sam Blenkiron from Mirage
                                                          • My Zoho Story #17 - How Superior Trucking Payroll Service scaled their business with Zoho

                                                            My Zoho Story is a video podcast series where we connect with Zoho users worldwide to hear from them about their experiences with Zoho and how it became an integral part of their everyday business life. In our recent episode, we had the opportunity to
                                                          • Update on the upcoming Zoho User Group meetups - Q1

                                                            Hey Zoho Community!  How're you all doing? We have an important announcement about the Zoho User Group meetups this quarter - Owing to the looming threat of COVID - 19, we're recalling several of our ZUG meetups that can't be run locally and are pulling back our Zoho teams who have traveled for these events. We have also suspended Zoho meetups run by our local partners and user group leaders as we do not want any of our users to come in harm's way. For those of you who have not seen the email about
                                                          • Eighth day of Christmas - Zoho Recruit

                                                            Check out the story behind our sixth day of Christmas post. ​ The eighth day of the 12 days of Christmas relates to Zoho Recruit  "On the eighth day of Christmas my true love sent to me: eight maids a milking, seven swans a swimming, six geese a laying, five golden rings, four calling birds, three french hens, two turtle-doves, and a partridge in a pear tree." The eight maids walking up with portfolios in their hands signifies Zoho Recruit's recruitment solutions built to provide diverse, end-to-end


                                                          Manage your brands on social media



                                                                Zoho TeamInbox Resources



                                                                    Zoho CRM Plus Resources

                                                                      Zoho Books Resources


                                                                        Zoho Subscriptions Resources

                                                                          Zoho Projects Resources


                                                                            Zoho Sprints Resources


                                                                              Qntrl Resources


                                                                                Zoho Creator Resources



                                                                                    Zoho CRM Resources

                                                                                    • CRM Community Learning Series

                                                                                      CRM Community Learning Series


                                                                                    • Kaizen

                                                                                      Kaizen

                                                                                    • Functions

                                                                                      Functions

                                                                                    • Meetups

                                                                                      Meetups

                                                                                    • Kbase

                                                                                      Kbase

                                                                                    • Resources

                                                                                      Resources

                                                                                    • Digest

                                                                                      Digest

                                                                                    • CRM Marketplace

                                                                                      CRM Marketplace

                                                                                    • MVP Corner

                                                                                      MVP Corner







                                                                                        Design. Discuss. Deliver.

                                                                                        Create visually engaging stories with Zoho Show.

                                                                                        Get Started Now


                                                                                          Zoho Show Resources

                                                                                            Zoho Writer

                                                                                            Get Started. Write Away!

                                                                                            Writer is a powerful online word processor, designed for collaborative work.

                                                                                              Zoho CRM コンテンツ






                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方




                                                                                                          • Recent Topics

                                                                                                          • Multi-Unit Inventory with Flexible Unit Selection (Purchase in One Unit, Sell in Another)

                                                                                                            We need multi-unit inventory management in Zoho Books with the flexibility to choose units (e.g., Box or Piece) at the time of purchase or sale. For example, if 1 Box = 10 Pieces, we should be able to record purchases in Boxes but sell either in Boxes
                                                                                                          • Disputed Purchase Invoices

                                                                                                            We have recently moved to Zoho Books from Sage. In Sage we were able to post a purchase/vendor invoice but mark it as on dispute. This would usually be a pricing query or if something was damaged. It would show in their ledger, so we could agree their
                                                                                                          • No TDS Deduction

                                                                                                            In some of our case, where we are reselling items at the same rate we purchased. In this scenario, Indian IT Law has a provision to request customer not to deduct TDS if the transaction value is same. TDS is paid by us (intermediary reseller) before we
                                                                                                          • CBSA - GST CHARGES on imports

                                                                                                            Hi there, We have a questions about landed cost categorization. We received a shipment from overseas. CBSA invoiced us for the GST on the items. Now we entered the CBSA-GST as a separate bill and attached it as landed cost to the main invoice based on
                                                                                                          • Zoho Books

                                                                                                            How do I manually insert opening balance?
                                                                                                          • Sales order & purchase order item links for item details

                                                                                                            This is fantastic for checking lots of things, I use it a lot. It would be great to see it extended to invoices & bills On another note, may as well throw in my favourite whinge ..... Wish you guys would get the PO receive differences sorted urgently,
                                                                                                          • Bank charges are applied. Please select a bank account.

                                                                                                            Hello, I'm trying to add bank charges to a customer payment, but I get the error message "Bank charges are applied. Please select a bank account." I found this old thread, where it says that I need to "select a Bank account for the 'Deposit To' dropdown
                                                                                                          • How to add receipts

                                                                                                            How to add receipts
                                                                                                          • Support for auto-upgrade in TrueSync (for Windows)

                                                                                                            WorkDrive TrueSync app now supports auto-upgrading to the latest version for Windows OS. You must manually download and install the TrueSync app version 3.4.0 to avail this feature. Download the latest TrueSync app for Windows (version 3.4.0) Supported
                                                                                                          • WorkDrive API Documentation

                                                                                                            WorkDrive provides users and developers an extensive set of APIs to help integrate functionalities of Zoho WorkDrive with other Zoho applications and third-party tools. We have published the official WorkDrive API Documentation page for all external users.
                                                                                                          • March 15, 2023: Zoho Docs is discontinued

                                                                                                            As of today (March 15, 2023) Zoho Docs is discontinued for all users. We would like to thank our customers for trusting us for so many years! Going forward, we're confident you'll enjoy using Zoho WorkDrive for all your advanced file management and collaboration
                                                                                                          • Introducing WorkDrive 4.0: Enhanced productivity. Advanced data administration. (Phase 1)

                                                                                                            Hello All, We're excited to share the release of WorkDrive 4.0, which includes important new features and enhancements focused primarily on productivity, secure collaboration, data administration, integrations, and user experience. Read the official announcement
                                                                                                          • Ask the Experts: Five-hour live Q&A session with Zoho WorkDrive product experts

                                                                                                            Have questions about WorkDrive 5.0? Let’s talk! We recently launched Zoho WorkDrive 5.0, packed with powerful updates to help your team work smarter, stay secure, and get more value from your business content. From content-centric workflows and AI-powered
                                                                                                          • External download link limit

                                                                                                            Can You please help us to understand this For Zoho WorkDrive external users, the download limit is a maximum of 5 GB total download size and a maximum of 50 first-level files and folders What is the meaning of first level? We are using these files in
                                                                                                          • Dynamically catching new file creations

                                                                                                            I have a team folder with many subfolders, and in those folders we add new documents all the time. I'd like to have a workflow or script to notify me (and then take other actions) when a file is added anywhere in that structure that ends in "summary.txt".
                                                                                                          • Rotate an Image in Workdrive Image Editor

                                                                                                            I don't know if I'm just missing something, but my team needs a way to rotate images in Workdrive and save them at that new orientation. For example one of our ground crew members will take photos of job sites vertically (9:16) on his phone and upload
                                                                                                          • Workflow workdrive rollout

                                                                                                            Hi! When will workflow be rolled out to all users? Thanks.
                                                                                                          • Sync desktop folders instantly with WorkDrive TrueSync (Beta)

                                                                                                            Keeping your important files backed up and accessible has never been easier! With WorkDrive desktop app (TrueSync), you can now automatically sync specific desktop folders to WorkDrive Web, ensuring seamless, real-time updates across devices. Important:
                                                                                                          • 🚀 WorkDrive 5.0: Evolving from a file sharing app to an intelligent content management platform: Phase 2

                                                                                                            Hello everyone, WorkDrive's primary focus has always been to provide an intelligent and secure content management platform, simplify collaboration, and be the central repository of files for all Zoho apps. In our previous announcement, we unveiled the
                                                                                                          • Creating and managing a Team Folder using WorkDrive TrueSync

                                                                                                            Hello everyone, Are you tired of constantly switching between your Desktop TrueSync app and the WorkDrive web app to create and manage Team Folders? We’ve made things easier for you. You can now create and manage Team Folders directly within the TrueSync
                                                                                                          • Edit images seamlessly with WorkDrive's built-in Image Editor

                                                                                                            Are you tired of switching between multiple tools just to make simple edits to your images? We understand the hassle, which is why Zoho WorkDrive now comes with a built-in image editing tool, powered by Zoho Annotator. This tool allows you to edit images
                                                                                                          • Supercharge your email workflow with WorkDrive's add-in for Microsoft Outlook

                                                                                                            Consider this: You’re handling a critical project, and your inbox is packed with important attachments, email threads, and client communications. The back-and-forth routine of downloading files to your computer, uploading them to WorkDrive, and manually
                                                                                                          • Secure and promote your content with Custom Watermarking

                                                                                                            Imagine this: You’re a professional photographer who regularly shares your work online with potential clients and collaborators. Recently, you notice that some of your images have been reposted without any credit or permission. This not only impacts your
                                                                                                          • Join us in Singapore for the Zoho WorkDrive User Group meetup!

                                                                                                            Hello, everyone! Exciting news! We'll be hosting an upcoming Zoho WorkDrive user group meetup in the beautiful city of Singapore this November. At this Zoho User Group meetup, we'll guide you through ways to use WorkDrive as a platform and build custom
                                                                                                          • WorkDrive TrueSync now supports ARM64-based Windows devices!

                                                                                                            We’re excited to announce that the Zoho WorkDrive TrueSync app now fully supports Windows devices with ARM64 architecture! Whether you're working on an ARM-based device or an x64 processor, you can now enjoy the same seamless file synchronization experience
                                                                                                          • Option to Disable Download for Documents Shared via Permalink

                                                                                                            Dear Zoho Writer Team, Currently, when sharing a Writer document using the regular permalink (Collaborators with external users), there is no option to restrict the ability to download the document. While the external share link allows such restrictions,
                                                                                                          • Important update for WorkDrive TrueSync users in China Data Center (CN DC) & Chinese language users in other DCs

                                                                                                            Dear WorkDrive TrueSync users, We recently identified an issue affecting users who have set their WorkDrive TrueSync app language to Chinese (Simplified/Traditional). During the auto-update process, the app would not restart automatically and unexpectedly
                                                                                                          • How to Download a File from Zoho WorkDrive Using a Public Link

                                                                                                            How to Download a File from Zoho WorkDrive Using a Public Link If you're working with Zoho WorkDrive and want to download a file using a public link, here's a simple method to do so using API or a basic script. This approach helps developers or teams
                                                                                                          • WorkDrive TrueSync for macOS 26 (Tahoe) Beta

                                                                                                            Hello everyone, With Apple unveiling the macOS 26 (Tahoe) Beta, we know many of you are eager to explore the latest features and enhancements. We’re excited to support your enthusiasm! As part of our commitment to delivering seamless cross-platform experiences,
                                                                                                          • domain not verified error

                                                                                                            Hi when i try to upload a video from zoho creator widget to zoho work drive iam getting domain not verified error.I don't know what to do .In zoho api console this is my home page url https://creatorapp.zoho.com/ and this is my redirect url:www.google.com.Iam
                                                                                                          • Live Webinar: Getting Started with Zoho WorkDrive - A Complete Overview

                                                                                                            Hello everyone, We’re excited to invite you to our upcoming live webinar! Discover how to set up your team, bring in your data, and make the most of WorkDrive’s collaboration, organization, AI, and security capabilities. This session is perfect for anyone
                                                                                                          • Calendly One-way sync- Beta Access

                                                                                                            Hello Community, Many of our Zoho Calendar users have expressed their interests in Zoho Calendar and Calendly integration. We've been tightly working on with Calendly team to provide a two-way sync between Calendly and Zoho Calendar. However, there have
                                                                                                          • The year that was at Zoho Calendar 2023- Part 2

                                                                                                            In continuation with our previous post on all the exciting updates and improvements that have shaped Zoho Calendar over the past 12 months, Lets delve into more: Bring your calendars together- Introducing Zoho Calendar and Outlook calendar synchronisation
                                                                                                          • Tip of the week #18: Change the event organizer in Zoho Calendar.

                                                                                                            We cannot always be available to conduct an event when we organise one. In these circumstances, you can use Zoho Calendar to change the event organizer at any moment before the event begins. This way, you can avoid cancelling the event while still taking
                                                                                                          • Tip of the week #20: Create and manage multiple personal calendars.

                                                                                                            Zoho Calendar provides users with the facility to create and manage as many calendars as required. All these calendars can be managed and edited as per user requirements. You can alter the calendar view, make changes to the calendar theme, share the calendar
                                                                                                          • Tip of the week #24: Subscribe to the calendars of a Zoho Calendar user.

                                                                                                            Calendars that are created by Zoho Calendar users can also be added to your Zoho calendar. All public calendars listed by the users will be available when you enter the email address. You can choose the calendar you need to subscribe to. Once the email
                                                                                                          • Tip of the week #26: Import/ Export calendars in Zoho Calendar.

                                                                                                            Any calendar on the web or calendars that you create in any other calendar application can be imported in to Zoho Calendar. This will help you to add the events from the calendars that you import to your Zoho Calendar. You also have the option to export
                                                                                                          • Removing calendar for zoho email group

                                                                                                            How do I make it so that an email group created in Zoho Mail does NOT have a calendar? I have a couple groups for our phone systems voicemails - one for each department. Voicemail recordings are sent to this groups email address so they have access to
                                                                                                          • Tip of the week #27: Edit personal calendars in Zoho Calendar.

                                                                                                            In Zoho Calendar, the personal calendars you create can be edited to make changes you need to make. Edit a Personal Calendar The following changes can be made to the personal calendar by editing it: Calendar title Calendar color Reminders and Description
                                                                                                          • Tip of the week #28: Show/ hide, enable/ disable and empty/ delete your calendars in Zoho Calendar.

                                                                                                            The popularity of online calendars has soared in recent years. It's used both for personal and professional reasons. Calendars have evolved into an effective productivity tool in our lives, from creating events for birthdays and anniversaries to scheduling
                                                                                                          • Next Page