Format problem
Whenever I try to type 1-9 then the numbers are comforted to a date consisting of those numbers. I need to what I can do about this and other alike format problems that I might encounter.
Calculating time
Hello, how to calculate time, e.g.: end time - start time - break? 6 pm - 8.00 am - 30 minutes = 9.5 hours Thanks in advance Vrumfondel
export to spreadsheet limited to view?
trying to export my entire database using spreadsheet export but apparently it only exports those records on the view (so if you show 100 records only 100 export). Surely there must be another way? I realize you can use csv, but when you have special characters, csv is sometimes a pain... thanks rg
??? How to add 1 Decimal to whole numbers
Hello, Thank you for the last information as it almost completely resolved my issues. There is one thing that can make processing my information easier and that is if I could make a whole number derived from more than 1 other cell be displayed as 98.0 rather than 98. Right now I have it worded as Round(Sum(R1/6+S1):1) and most numbers come out as 93.4, 91.5 etc. but other numbers come out as 98. If I could force all sums to be displayed with 1 decimal even if that decimal was 0 it would make this
ZOHO的电子表格反映速度慢
大家好： 我是新的ZOHO用户， 我们刚刚接触ZOHO的在线电子表格， ZOHO的在线的功能让我们惊叹。 可以现在我们用的是个人版的，在使用SHEET 进行操作的时候我们发现它的放映速度有点慢， 这个是什么问题。
Trying to link and regularly updated spreadsheet from excel onto Zoho sheets
Hi, I have an excel spreadsheet that has a constantly updated tally. The actual numbers in this tally are actually linked/uploaded from another, more secure excel file that I cannot upload to Zoho. As the tally changes in the secure sheet, it also updates in this 2nd excel tally sheet that I made up (lets call it sheet 2). I wanted to share Sheet 2 with co-workers, so they could see the updated tally and so, imported it onto zoho. Unlike google docs, zoho actually imports the tally as well. (google
When editing a formula, the cell involved should be highlighted with different colours
Hi everybody, IMHO when I edit a cell containing a formula, it would be very useful (and usable ) to have the cell involved highlighted with different colors. Example =C3+C1. C3 should be green as well as the C3 cell borders. Same thing for C1...what do you think??
how to hide XLS files columns, right-click menu does not have the
how to hide XLS files columns, right-click menu does not have the I am chinese I can"t English Thank you
Zoho sheet info showing in a Google search
I recently made a sheet which I made public. I decided to delete this as I could not be sure that the details should be publicly available. The sheet is deleted and no longer exists, however all the details can be seen when searching on google. See for example: search my name "peter walton-jones" and at the bottom of the page is the line from my (now deleted) sheet with my details all showing. How can this be fixed? pete wj
Does Zoho have a knowledge base for Sheets?
Se other Zoho products have a Help section. I just want to know how to bold every word in a row and to make every column as wide as the "biggest" content in any one cell.
Sharing limited to 20: workaround?
I'm a teacher currently working in China, where Google Docs are often blocked. I'd like to use a Zoho spreadsheet instead, but the limit on sharing with a maximum of 20 people makes Zoho useless to me. Is there any way to expand this limit?
Text cuts off where new cell begins
Please refer to the attachment I included. If you open the spreadsheet in ZOHO, the only words/letters you should see are: Externshi. When I open it in MS excel, where I created it, it says Externship Timesheet. Apparently the letters are getting cut off where the new cell begins, and I don't want this to happen. Is there a way to not have this happen? I tried using some of the options I saw in ZOHO, but nothing seemed to work. Any assistance with this would be greatly appreciated, and thanks in
Row numbers deeper than the row height
As well as the issue of the out of position rows which others have commented on I find that my row number text size means that they are being obscured by the row below, ie getting cut off at the bottom. Changing the browser text size doesn't seem to affect things. Firefox 3.5 / Linux Any ideas?
using the <insert Button> button
The new <insert Button> feature is great! I'm trying to write some VBA code to change the button's color when it is selected. Could you give a list of button attributes and properties so a button can be identified and its color changed? Thanks! Dwain
How can I reference a cell in a different spreadsheet?
Moving Cells
Suppose you have a column of 3 cells, and then a fourth cell that sums the 3. If you move the 3 cells, the reference in the fourth cell to the sum should update to their new location. Microsoft Excel, Google Spreadsheets and Open Office Calc all work this way - Zoho Sheet does not.
Sorting causes cell coordinates within formulas to change
Great tools, but I have a problem... Here is an example of some data I want to sort. The value are pulled from other sheets using forumlas. Notice the tallies are not in order. http://screencast.com/t/YmNmNDNmND Now here is how I am attempting to sort the values: http://screencast.com/t/OTY0ZjQyM2 Here is what the results look like: http://screencast.com/t/Nzc2YTg5 The cell coordinates in the formulas have been adjusted, and they should not be changed. Now they are pulling the wrong values from the
Access to restricted IP addresses
I have two queries. 1) If you right click in a cell you get an option of pick from a list. But how to generate a pick list? or where to make entries so that the pick list will be available? 2) We found that after sharing any application of zoho with our team members, we are unable to control their capacity to change/ copy/ share the data from a location other than from office. In a situation where we want many employees to collaborate but not to break the confidentiality, this may not desirable.
Spreadsheat does not save or allows concurrent editing
Hi all, I've been experiencing some errors with the spreadsheets, they are as listed: - Does not save automaticly or manually. when multiple users are logged in. - When multiple users are logged in they can see who is on the same spreadsheet, talk to them but are unnable to see changes made by others. This always happens when we are closing projects and entering/accessing non stop. Is there any limitation that i don't know? Or is there any solution.to this problem? Thanks in advanced -
Unable to access sheets
When i try to access Sheets i got this error below. Apache Tomcat/5.0.28 - Error report HTTP Status 401 - Unauthorized access type Status report message Unauthorized access description This request requires HTTP authentication (Unauthorized access). Apache Tomcat/5.0.28 same problem on firefox, ie6 and ie 8 no problem accessing writer, docs I tried accessing via http and httpsthanks!
#unknown_error
I receive an #unknown_error when I change a value from a whole number to a number with a decimal. Can't for the life of me figure out why. Any help would be appreciated. Thanks!
Moving a tab from one sheet to another, is it possible?
I have a template saved (it has one tab) and I want to pull this template tab into an existing sheet, is this possible and if so how is it done? Thanks!
httpClient sheet problem
Hi, I am using Httpclient PostMethod method = new PostMethod(postMetod); method.addParameter("url", url); method.addParameter("saveurl", saveurl); method.addParameter("filename", name); method.addParameter("id", id); method.addParameter("format", "xls"); client.executeMethod(method); where : post :http://sheet.zoho.com/remotedoc.im?apikey=Some api&output=editor url: some url SaveUrl :some save url id:some Id zoho response iz nothing , when I use same links , id's ect it all works from html form
Chart Size
Hi- I want to create a series of published charts with a consistent look. However, it seems the look of each chart depends on the size of the chart in the spreadsheet. How do I set the size of each chart using numerical dimensions, instead of dragging the corner with my mouse? Also, is there a way to make the published image independent of the chart size in the sheet?
agrupar
como se agupa una serie de celdas?
can't invite; can't save shared sheet
I created a Zoho sheet, saved it, and shared it with one person, read/write setting. I sent an invitation to that person. Clicking on the link in the received invitation, takes you to the sheet but there is no option to save it, even though was shared with read/write permissions. So I tried again, but this time when I send the invitation, the shared user never gets the invitation email. So now I can't invite, and when I do, that shared person can't save their changes. What gives?
embedding excel sheet into website or get html code for sheet
i am trying to take a sheet which i imported and get the actual html code. it works great on the documents, but not the sheets. i want to take the sheet and put it on my website making it interactive for any visitors, can this be done? JD
Multiple Zoho Sheet Suggestions
Zoom-in/Zoom-out: Is this still not supported? I see that it is not as of April 2009 here: http://help.zoho.com/portal/en/community/topic/view-6-12-2009 Row Alignment: I am having issues similar to those identified previously (http://help.zoho.com/portal/en/community/topic/row-alignment) with my rows not properly aligning to the row labels. I assume this is still being looked at? Charts (colors and axis scale): I have not been able to find a way to adjust these, and assume customization is not
Urgent
Dollar sign and date&time does not work. when i click on them , nthing happens. please help me if its possible hamid.reza.mesgari (GMAIL)
how can i upload a new version of sheet?
how can i upload a new version of sheet?
Themes
Hi there first off I want to thank you guys for putting out a great product out there and is a tool that I use for work everyday and very reliable, one thing I would like to have more is the theme section, more variety is great and I'm looking forward to see this in the future. Thanks and keep up the good work Sincerily Jay
无法插入按钮(Can not Insert Button)
在电子表格中无法插入按钮。 “Insert Button”is disabled in Sheet.
使用在线excel时浏览器占用内存巨大
只使用了贵公司的在线excel功能 但是每次打开都非常耗时间 IE浏览器显示占用内存90%以上，有卡死现象 IE7.0和360IE中均如此 这样非常影响使用
速度太慢了
看上去功能很强大，也很乐意去尝试，不过速度太慢了，我打开了sheet界面后，点击任何的单元格，都出现“网页上有错误”的提示。无法正常使用。
Zoho sheet
Avec nouvel écran HD, les numeros de lignes ne sont plus affichés en face des lignes, ce qui rend l'utisation impossible. Merci de faire le nécessaire.
Error Occurred; Problem while Opening the Document
this error message is uninformative. has anyone else encountered it. what is likely the problem? how to resolve it?
Repeated alert when using Zoho Sheet
When I open a sheet for some reason today I keep getting a persistently repeating alert. It's a modal dialog so it's extremely inconvenient, as I have to press the OK button, otherwise I am unable to do anything. Here is a screenshot of the alert. http://anroy.wiki.zoho.com/Sheet-Alert.html Thanks.
Sorting not working properly
I have a sheet that we use in Notebook and Sheet, simple list - basically a todo list with a few date columns, description, etc. When we try to sort (select whole range), it does not sort properly. Does empty cells or formatting cause issues? I'd be happy to share this sheet with support staff to look at it. Simple sheets with simple data sort properly, but it seems that once a mildly complicated list is generated, it all breaks.
size of file to be imported
Is there a size limitation when I import an Excel file into Zoho Sheet? I am trying to use this for the first time.
Zoho plugin and shared sheet-properties en some other questions
We work with zoho shared sheets to communicate with some of our customers about pricing. On some non-public (for the customer hidden sheets) calculations are being made, and the answers are being presented in a worksheet that is openly shared with the customer. We find that working in the zoho environement for big spreadsheets is not very user-friendly. We therefor have the zoho plugin installed and with help of this plugin we temporarily edit the entire spreadsheet in Excel, and save it back to
Next Page