Where do my documents appear once I've saved them? And how can I access my templates?
I created a spreadsheet in Zoho Docs and saved it. Then I decided that I wanted to create a template from that to be used for other customers. I saved it as a template, but now I cannot find it (yes, I've tried "All Files" in the Documents tab). Then I tried using Save As to create a blank copy, figuring we could just open the blank one and use Save As again for future versions and customers, but again, it's nowhere to be found! (Side note: they do appear here to be attached as an example, but I
Cannot edit spreadsheet
I am trying to edit a spreadsheet on my web browser (Chromium 43.0.2357.6) but when I click on it it just comes up with preview not available and the only option is to download it. I am able to edit other spreadsheet and documents without any issues. Thanks
Spreadsheet Row Height keeps changing.
Every few days, the row height of our spreadsheets will go from 25 to 17 without us doing anything. Sometimes it will happen on one spreadsheet and sometimes, it will happen on all spreadsheets. Any reason for this? It always changes it to 17. Let me know. Thanks!! Laura
Problem with currency format dropping trailing 0s
Hi Zoho, In my spreadsheets, when I choose a 2-decimal-place currency format, quite frequently recently, trailing zeros are simply dropped in new entries (if they're in existing entries, they seem to stay). They show up again if I go back to Format and rechoose 2 decimal places, but I shouldn't have to. As an example, a new column of numbers I add appears as: $5.5 $6.27 $19 Instead of $5.50 $6.27 $19.00 This started happening a few months ago, just haven't asked about it until now.
G-Sheet to Excel?
~ 9 months ago I created the Google Sheet which I continue to fill with daily data. Then I performed these actions: File -> Download As -> Microsoft Excel (.xlsx), uploaded the file to Excel Online and saw my G-Sheet converted almost perfect. My main chart was clear. Since then MSFT or GOOG made some changes that now I don't get the conversion working anymore. Is it on purpose? Competition? I decided to try to use Zoho as mediator to accomplish the conversion. But it does not go anywhere, because
The Effect of Investment Expenses on a Portfolio - Spreadsheet graph problem
I am compiling a spreadsheet on 'The Effect of Investment Expenses on a Portfolio' Having difficulty with the graph as when I go to print I get numerous 14 digit numbers obscuring the graph I have tried changing the settings but nothing works Also cannot delete the 'Enter your values here' title as it keeps reappearing Help please
Referencing and other sheet with SUMIFS
Hi there, I'm unable to get the following code to work properly on zoho sheet. It works perfect on excel. But something about the pasting the formula to sheets is not working. =SUMIFS(Sheet1!I:I,Sheet1!J:J,">"&TODAY()-1)-SUMIFS(Sheet1!I:I,Sheet1!J:J,">"&TODAY()) I tried using the "dot" instead of exclamation. But, it seems like this not reading. =SUMIFS(Sheet1.I:I,Sheet1.J:J,">"&TODAY()-1)-SUMIFS(Sheet1.I:I,Sheet1.J:J,">"&TODAY()) Also, I tried specifying the cells on the same sheet. Didn't work:
can i share view of my xlsx doc online without a download
can I share view of my xlsx doc online publicly without a download if so how nothing seems to work
Advanced "Chart" engine with Auto-detection, Auto-expansion and Trendlines
Zoho Sheet has upgraded to a more powerful Chart engine with vibrant features to improve your charting experience. Auto-detect Chart ranges Charts in Zoho Sheet are as intelligent as its users. Just click on a cell anywhere in the range and go ahead and insert a chart, Zoho Sheet automatically detects the range. The feature is extremely useful when the data range is large and saves you from selection hassles. In case of non-contiguous data, it is also possible to manually enter the range in the 'Add
Link to data in another file
How do I create a formula to link to a cell in a different file? In the MS application I would simply enter the formula =SUM(and click on the cell in a different file and press enter)
Spreadsheet date functions
Hello All, Are there any of the following functions available: - Day of week - Month name Thank you. Edo.
Remote Server refused to save Sheet and Pres Documents
Hi, I use Zoho Editor with remote API code under PYDIO server 6.20 I can create any document as well as writer, sheet and pres I can save only writer document, but not able with sheet and show. Why ?? In the file named : ../pydio/plugings/editor.zoho/class.ZohoEditor.php I can see this part of code ! (…) $service = “exportwriter”; if (in_array($extension, $sheetExt)) { $service = “sheet”; } else if (in_array($extension, $presExt)) { $service = “show”; } else if (in_array($extension, $docExt)) { $service
Speed
Hi, I'm using one spreadsheet with may different sheets in it. It has a lot of colums in it and nearly every cell has a conditional formatting formula. The sheet is very slow in loading and in editing. One may type a letter in a cell, but you can only see it after a few seconds! This is very annoying and time consuming. I wanted to know wheater the speed issue has something to do with the conditional formatting, I have made a copy of the original and removed all of the cond format. And it's much
Question regarding input controls checkboxes
I have imported an Excel spreadsheet to Zoho Sheet. Upon import, everything looks great except the checkboxes did not import. I can see in Zoho Sheet where I can add input controls that appear as check boxes, but I need to add functionality. For example, the checkbox ideally links to a cell elsewhere in the spreadsheet. If the checkbox is checked (TRUE state), then this influences the grand total. In Excel, you do this by right-clicking and selecting Format Control where you can establish a cell
Locking specific cells in Zoho spreadsheet
Hi, I'd like to embed a spreadsheet on my website with a formula in it. Users can then key in variables and find out what kinds of values the formula throws up. Is there any way I can lock specific cells (and not every cell) in the spreadsheet? This is because I'll need these constants to calculate the formula. Thanks, L
Can't access my docs??
I can't access my docs this morning. I know Zoho is having email troubles and is in the middle of the Chennai floods, so I'm assuming this is due to those problems, but just wanted to make sure. Is anyone else unable to get to their Zoho docs?
No upload field available in Zoho Forms
I have created a form from a Zoho spreadsheet. But the option to add an upload field is not available. Why would this be? My screen: Zoho Help documentation:
Formula Help: adding date when row has an entry
Hi all, I've got a formula that checks to see whether data has been added to a row, and if so it adds today's date to a column. It works well. The only problem is that every time the sheet is opened, it recalculates, so all the dates are set to today! Is there a way of adding in some logic to the formula to prevent this happening, or to set "recalculate=0" to a column! Thanks for any help James Here's the formula: =IF(ISBLANK(A6);"";TODAY()) ...and here's a screenshot that might help: http://take.ms/RvzsF
How to adjust width or delete columns in Zoho spreadsheet docs?
Trying to learn more about using these docs. How can I adjust width or delete columns in Zoho spreadsheet docs?
Editing a Public Sheet
I created a sheet and marked it as public because I wanted to send about 100 people the link, and let them click on it, make changes and hit save. (It's a sign-up sheet for a teacher appreciation breakfast.) But I find when I follow the link myself, without logging into Zoho, I am not allowed to save my changes. Is there any way to use Zoho to do what I want to do? Or will anyone who wants to edit the sheet have to be invited using "share"? Will they have to join Zoho and log in themselves?
Are there plans to provide functionality of Microsoft's Power Pivot?
Microsoft's Power Pivot for Excel provides some amazing functionality. Does Zoho have any longer-range plans to provide similar functionality in its spreadsheet software? It would be a wonderful addition. Thanks. Irv
New Pivot Tables in Zoho Sheet
Pivot Tables lets you slice and dice the data in your spreadsheet and helps you gather meaningful insights from your data. Though Pivot Table was already available in Zoho Sheet, we have now completely revamped it, made it more powerful and have integrated it seamlessly into your spreadsheet experience. We provide you with an intuitive user interface where you can drag and drop fields into rows, columns, data and filter boxes to draw your Pivot Table. Here are the capabilities of our new Pivot
Zoom function
Zoho team, Can you add custom zoom function to worksheet ? Right now we don't have any choice.
Freeze Panes - Lock Rows and Columns
A new sub forum, 'Tips and Tricks', has been added to the Zoho Sheet forum and we are planning post tips and howtos related to Zoho Sheet in this sub forum. The first topic deals with Freeze Panes. When you have a large table of data spanning multiple rows and columns, it becomes difficult to keep track of which data you are looking at as you scroll down or to the right. The 'Freeze Panes' functionality solves this by allowing you to lock the row and column headings in place. These locked rows and
Error with zoho sheet
hey, one of my spreadsheets cannot be opened, i get an error message. sent the details to support@zohosheet.com already. It is quite urgent, any can help me? best
Conditional formatting
Hi, I have a spreadsheet with conditional formatting on each cell. I wand to change the cell color as soon as there is a value in the cell. Now all works perfect, except.. when I close the browser and reopen the spreadsheet the conditional formatting is not active anymore. Although the rules are still there. I have to open the conditional formatting dialogue, where I can see all rules and click ok. At this point the conditional formatting gets active. Please help. thanks Ernst
Text color and boldness changes randomly on my spreadsheet
Suddenly my spreadsheet BOLDS random text in a lot of cells on the spreadsheet when only one cell is supposed to be bold. It also randomly changes a lot of cell text color to red when maybe only 1-2 cells are supposed to be red. This just started happening a day or so ago. I will change it back and a minute later it's back to being bold and red again. Any ideas what is causing this?
Which browser is best for Zoho sheets?
I've been using zoho sheets for a few months now and the past few weeks, it has appeared much less stable. Sometimes my document won't load after I select it. Other times, it locks up every few minutes as I'm trying to enter my data. I'm on Win 7 and have tried many browsers including Chrome, Opera, IE, Firefox. IE seems to be the most stable at the moment. I'm not sure what else to do. Any suggestions? I only have one file in sheets.
embedded sheet - no saving?
hi, when i embed a zoho sheet using an iframe, my changes that i make are not saved in zoho! is this normal? do i have to check a checkbox somewhere? cheers!
Adding documents to rows ?
Hi, I would like to know whether Zoho Docs has the option of addings attachments to rows similar to what smartsheet has ? If not, is there any plans for it's implementation. This is very important deal breaker for us. BR - BM
Recreate your old Pivot Tables and Pivot Charts in Zoho Sheet
Recently we launched a new version of Pivot Tables in Zoho Sheet which brings in new capabilities and makes it more powerful. Read the following post to learn more about the new Pivot Tables: https://help.zoho.com/portal/en/community/topic/new-pivot-tables-in-zoho-sheet Please note that if you have been using the old Pivot Tables and Pivot Charts, then you would need to recreate those with our new Pivot Tables feature. The old ones will stop working by end of Oct 15, 2015. Unfortunately, there is
Re-calculating auto-job-list once a week or month
Hi, I develop a site for my virtual business company usable in Microsoft Flightsimulator X (FSX). It have a full automatic assignment/job-generator based on the ZOHO spreadsheet-system in the background of my site. It works great as random-job-generator. But it re-fresh every time somebody visit the page. That's of course the standard/basic way of spreadsheets, how it work, to my thought. But I need a system, formatting, formule, code that once a week or month automatic re-fresh the jobs instead
Macro to send email with button push
Hi, Would like to know if it's possible to send an email notification through a Macro instead of the notification tool on a spreadsheet. My spreadsheet is such that when the user completes a task line, i would like the task line to be emailed to an individual. Also, if a cell is changed, would like the email automatically generated. I have the code to do this in Excel, but it doesn't work in Zoho. Thanks! :)
Inporting images from spreadsheet
Hi all, I am new here so be gentle. Here is my problem and I am sure I am doing something silly but I just cannot sort it.My website company exports all the products and info into a zoho tsv file which is ok but I don't seem to be able to inport back the images to the site from the sheet. The images are on an external server and I have attached a screenshot of what I am trying to inport. I am sure this should work but I cannot sort it so help please, Bob
Zoho Sheets Scripting Limitations..
Does anyone know if the scripting process within Zoho Sheets has the same scripting limitations as the App Scripts Limitation of executing for only 6 minutes? I understand the process needing to make sure its not a rogue process, but if a script is traversing through a spreadsheet it seems that the process would continue to run.
Formula fails to address a range in another sheet
I was experimenting with the following COUNTIF formula which works fine when used on the same sheet; =COUNTIF(B$12:B$10004;A4) However, if I address the same range in another sheet, it fails to return a result, i.e.; =COUNTIF(LOG.B$12:B$10004;A4) What am I doing wrong ?
No touch function for Zoho docs!
Hi, I got a touch screen notebook running Windows 8.1 and found out Zoho docs ( spreadsheet and word ) do not work with touch functions such as scrolling up or down...it's only possible by scroll bar! These days touch screen Windows based devices are getting more and more popular and it's a must for Zoho to improve this point.
Summarizing data in a cell rannge in spreadsheets
Hi, I have a number of spreadsheets under different groups as follows, GroupA Category1 Category2 Category3 GroupB Category1 Category2 Category3 GroupC Category1 Category2 Category3 All these spreadsheets have the same format. My requirement is to get a particular cell range (say A1:B5) from each spreadsheet and display them in a tabular format (column header is the file name, and the rows would be the data in the cell range). I tried Zoho reports, and to create a table I can use only one spreadsheet.
Automatic update in Excel from Zoho Sheet
I need to read a Zoho document on Excel and to have data updated currently. I've tried to use the HTML published version of the document https://docs.zoho.com/sheet/published.do?rid=ctdnu07c9dce2917b400e9ce0e918759ee098&mode=html Same way I've used to do with Google docs, but it had not worked. Is there a way to have the file published on a CSV format? Best
Problem editing cell in Sheets
This may be a basic question: When I double click on a cell to edit its contents, the cursor moves to the end of the text toward the right side. I have encountered a cell that does not behave that way - when I double click on it, the text disappears and the cursor is on the left in what looks like a slightly larger cell covering the text .I am unable to edit the contents of the cell. What is causing this? Thanks.
Next Page