Zoho docs still free for personal?
just find the interface changed when login. Zoho docs still free for personal? THX
Offset function spreadsheets
Offset function using cell the formula is located in results in #CIRCULAR error even though the reference is valid. When comparing two sets of similar data contained in adjacent columns, I am used to the following: =Offset(g10,0,-5)=Offset(g10,0,10) , in the column between two sets of data to be compared. The false values highlight differences and I then shift or move data to line the comparison data up. Without use of offset function, moving the comparison data makes the comparison formula also
Data Validation and Blank Cell Option
I have an Excel spreadsheet that we use for estimation of construction costs. A key feature of this spreadsheet and used, in many of the cells, is Data Validation with a drop down choice (either from cell range or a list) and I have tried to export this to Zoho Sheet. Most of the spreadsheet exported fine but I had some issues with the Data Validation and decided to re-write the cells. The problem I am now having is that I need to have a blank cell which is the default, and I need help in doing
Google Chrome on Linux. Cell contents are deleted when pressing arrow keys.
Google Chrome on Version 36.0.1985.125 Ubuntu 14.04 LTS When editing spreadsheets on Google Chrome, shifting cell focus by pressing the arrow keys deletes the contents of the cells. Using Firefox on the same system does not replicate the issue.
unlimited users
I am trying to use this program to share a few files with about 15 people. When I signed up it said for the free version there is unlimited users. However, once I started using the product it says I can only have up to 10 users. Can you shed some light on the discrepancies here? If I can only have 10 users this is quite disappointing and misleading. I already took the time to do up the documents I wish to share.
Using macro to enter relative reference formula
Running the following macro ActiveCell.FormulaR1C1="=RC[-5]*RC[-2]" in cell G17 results in #UNKNOWN error with cell contents =B17*RC[-2] i.e., Zoho is correctly translating the first relative reference but is treating the second relative reference literally.
Long text is not displayed on top of subsequent blank cells
In desktop spreadsheet applications such as Microsoft Excel and OpenOffice Calc, if text that is entered into a cell is too big to fit in that cell, it is automatically displayed on top of the following cells in that row, even if the cells have not been merged, as long as those subsequent cells are blank. In Zoho Sheet, this does not happen. This can be very frustrating to our users, who often compose their work in Excel and then import it into Zoho. They find that while there text was being displayed
Printing
Up until lately I have been able to select all on my spreadsheet and then do a print in a web browser. Here lately this has barely been working. Today it took 20 minutes to print one page. I await your response. Thanks
Font size
Is it possible to change the font size to size 200, or is it limited to the 72?
Macro enabked spreadsheet
Hi # I am new to Zoho Docs and was recommended by a friend. I was wondering whether there is anyway I can have VBA (macro enabled) spreadsheet available on Zoho so I can share the documents with colleagues. Thanks in advance for your help
Hide Gridlines
Hello Support, Is there any way to hide the gridlines in a spreadsheet? Thanks very much
Rollover
Hi Is rollover possible on Zoho docs and if so, how do I do it? Thanks Hans
Stock Option Quotes
Is it possible to obtain quotes for stock OPTIONS (i.e. puts and calls) in Zoho Sheet? Also, please note that the format for stock options on U.S. exchanges has changed. Thanks
Cell Protection in Zoho-Sheet
I imported an xls file with some colums protected, but once in Zoho, all protections were gone. My main use of Zoho would be to import xls files with only data input cells un-locked. Or, the ability to lock cells again, once in Zoho. Is this possible? Thanx
Spreadsheet Display Problem
Recently, we have been suffering a vertical shift of part of the spreadsheet. It can sometimes be solved by refreshing the page, but not always. It goes without saying that this can be a major problem if the shifted parts happen to line up. See image.
conditional formatting bug in zoho sheets
To whom it may concern, I have experienced on numerous occasions lately a problem in Zoho Sheets where the conditional formatting within a spreadsheet automatically disappears on a periodic basis. Needless to say, it is frustrating to have to redo all previous work and be unable to rely upon Zoho Sheets as a viable alternative for generating reports and presenting data. Is your staff aware of this problem and, if so, does it plan to fix it anytime soon? Thank you kindly, JCH
Save Function for embedded excel Sheets
I have managed to embed an excel file that was uploaded to Zoho. It's just a simple spreadsheet with milestones that need to be met versus employees. Once complete they have to option to click the dropdown and select an option but for some reason, I can not figure out how to get it to save after they update it. Basically we change one selection, refresh page and it just shows the original document and publishing it just seems to show the image. Thanks
Integration with PHP web application
Hi, I am creating a web application using PHP where users can upload, view and edit documents. Documents will be kept on Linux server where the web application will be kept. I have started developing it and got the AuthToken however got stuck after this. I am following instructions given at https://www.zoho.com/docs/zoho-docs-api.html Is there any sample PHP code for reference ? Thanks, Dan
CRM Documents
Hello Is there a way to change the left side navigation bar in ZOHO CR Documents? on our page https://crm.zoho.com/crm/ShowDetails.do?module=Documents I have our documents separated in their respective folders But when a users login the document view is confusing for them because they sell all documents by default The top 2 selections do not show the folders. How can I make the defaulft documents view to be the "Document Library" Please see screen shot
Comments disappear
Every time i save a sheet and then reopen the sheet in zoho, the comments disappear. Is there anything we can do to keep this from happening? Thanks, Len
Viewing Shared Sheets in Zoho Mobile
Hi! I share several workbooks in Zoho Sheet currently with groups I have set up. I recently found out that these individuals can't view the sheets in Zoho Mobile. Is there a function to allow them to also be able to view these sheets in the mobile verison? It would be very helpful! Thanks!
Shared File - How to input the collaborator user name when inputting data
Hi, I have created a file which is shared by a few collaborators. The file comprises a few macros which upon clicking on a button will input rows of data from a source sheet to a target sheet. Assuming each row is comprised of 10 fields, upon clicking this button, these fields will be populated in 10 target columns of the target sheet. I would like for this macro to populate an 11th column with the system username of the collaborator using the spreadsheet but can't find a solution. Many thanks
Currency Conversion
Hello, I'm imported a spreadsheet from Google Docs which included currency conversion but now on Zoho Docs, that currency conversion is broken which has subsequently broken the spreadsheet. Is there a formula or another function I can use to replace this functionality? Thanks.
is there a currency converter fuction like google spreadsheet =GoogleFinance("CURRENCY:EURUSD")?
is there a currency converter fuction like google spreadsheet =GoogleFinance("CURRENCY:EURUSD")?
Hide Column and Row Headings in Zoho Spreadsheet
Hello, I am just trialling Zoho but I need to hide the column and row headings before I purchase Zoho. Is there a way to achieve this? Thanks
FV
Hi folks, I am looking for some help. I am making a loan calculator and if I use a number with two decimal places for the year I do not get an accurate FV. If I use 1 decimal place there is no issues. ie I can use 3.5 without a problem but if I use 3.49 the results do not match what excel produces for FV. I am a bit OCD with things having to be perfect so this is not really acceptable for me. Any suggestions?
Moving values between pages
Is there any way to move/copy values between pages ?
New Release - Gray Theme, Improved Collaboration and more
We are pleased to announce the new release of Zoho Sheet with the following new features, new UI and enhancements. New Gray Theme Where is the Save button? New Sharing Options Improved Realtime Collaboration Spreadsheet Settings (Locale and Time Zone) Paste Special Typeahead / Auto Completion New Gray Theme Zoho Sheet now sports a gray theme in tune with Zoho Writer and Zoho Docs giving you a more standardized user experience. Do you like the new gray theme? Let us know whether you like it or not
Upload a 410kb VBA Macro
I got a 410kb excel macro when upload in zoho can't use it, just downloading. Why does not it happen before with 2 macros loaded months ago?
Zoho Sheet not exporting or printing images in spreadsheet
I have a spreadsheet that automatically generates a proposal form for my business and at the top we use our company logo. I put the logo into the spreadsheet using "Insert -> Image" but when I either export to PDF or try to print, the image is not there. How can I rectify this situation?
Conditional Formatting & Data Validation
Hello. I'm a relative newcomer to Zoho Sheet and I was wondering if there are any plans to add Conditional Formatting and Data Validation functionality in the near future? I understand that these can be achieved by creating macros, but this seems rather an unwieldy way to go about it, and not really an option for an inexperienced user. We're investigating the plausibility in migrating to Zoho from Google apps. A large part of the type of spreadsheets we use rely heavily on the implementation of conditional
Urgent requirement - Data Validation & Sheet Protection
In addition to "drop down menu lists", the other important features required in Zoho sheet is "Data Validation" and "Sheet Protection" to make it really useful. It will surely lead to increase of public usage of Zoho sheets.
Data Validation
Hi, I have been trying to insert data validation in my excel document but i cant find the option,.... can anybody help me with that... as when i upload the file with data validation enabled it appears as a plain file with no functions... Its a little urgent can anybody help me with that...
Data Validation
Problem description: I have a shared sheet with my colleagues and they keep on entering different date format, even in text format. Suggestion: Can we have a data validation function per cell so we can have users entering only specific data types (ie. date) into a cell? This will be great, thank you in advance.
How do I validate data
Anyone worked out how to validate data in ZOHO?
Function not updated after deleting rows
Hi, I was working with a spreadsheet when I noticed a small issue. I have some numbers in row 1, 2 and 3 and a function in row 4 (=SUM(A1:A3)) Now when I delete row 3 I expect the function to update to =SUM(A1:A2), instead it is unchanged (just moved up to row 3) and gives a #CIRCULARREF! error. Regards, Rob
Data Validation / Drop-down lists
Hi Zoho, I have read requests in previous threads going back around 2 years for this feature. Do you have any update on this, or perhaps could you suggest a work-around that I could use to re-create the feature that I'm using in an Excel sheet? Many thanks, Dean
Docs unavalible.
The docs and all spreadsheets are unavailable . When I push the link for docs, nothing appears.
Zoho Sheets
I have s sheet embedded in my blog. It does some calculation and user can input numbers. My question is can numerous people on the Internet use it at the same time without causing issues with the results?
New in Zoho Sheet: Text to Columns, Filter by Color, Range Selector and more
Last week, we released an update to Zoho Sheet with the following new features and enhancements: Text to Columns Filter by Color (and other enhancements to Auto Filter) Range Selector Filter by Cell Range in Manage Rules of Conditional Formatting And here are a couple of features released in end of January: Notify Collaborators Save to Folder Lets look at each of them in detail: 1. Text to Columns: The 'Text to Columns' functionality (available under the Data tab) lets you to split data in cells
Next Page