关于zoho自动保存问题
你们上面怎么没有自动保存功能,我希望有自动保存功能,同时也有个保存的时间即时提醒,能具体看到有没有保存到,免得很久的心血一下子就废除了。。。。
How can I use User-defined Cell Format?
Hi, I want to sum cells that contain data of "hours". I could not found the way to set a value of hours over 24:00. It start again from 0:00 if it go over 24:00 With OpenOffice I've used User-defined Cell Format like this "[H]:MM;@". How can I set same cell format with Zoho Sheet?
IPad
How do I scroll down on a spreadsheet when I open it up on an Ipad?
error message 12152
Hi There, keep getting this error message, just wondering what it means and whether there is a way to stop it happening? regards Dan Littlehales
possible bug
Hi there, keep getting an issue where by certian items in the last column I've used are duplicating themselves in all columns right to the end, causing error messages because of the number of cells used etc. please see attached document for an example of this problem. the only way to solve this is the export and completely start again in another sheet. is there a way to stop this happening or make it easier to solve the problem. regards Dan Littlehales
How many cells are supported in a sheet?
How many cells are supported in a sheet?
How many sheets are supported in one workbook?
How many sheets are supported in one workbook?
sorting
I am having an issue sorting my database.... it only sorts through column R. after that the data stays where is was before I sorted it..... Any thoughts????
Can not open Zoho sheet
Everytime I click on the link to open this product I get an errir saying "error occured" and I can not gain access. Please help! Thanks!
can't make these interactive.
Hello... I have tried imports and have tried creating brand new and super simple spreadsheets in Zoho. I cannot get them to be interactive through a web browser. I have tried to embed on dynamic and static web pages. Am I missing something? http://marketoutperformer.com/calc-test http://supercleanweb.com/calc.php
错误
经常出现:错误12030,无法打开,请重新打开文件!
excel
您好-本人沒有電腦所以借用他人的電腦 因字型不足所以到線上試 打好後匯出文章,發現不同於線上的設定及顯示
What is the character limit for cells in zoho spreadsheets?
What is the character limit for cells in zoho spreadsheets?
by using a .cfg type file, I could just click on the file in the fav bar and go right there, pl read, thanks..
I have tried using the "keep me signed in" on numerous computers, I have both XP home and Vista home, with both if I close the window and go back to your site, i have to sign in again which makes me think that feature is not working. heres the suggestion: ability to save the path to a file in the favorites bar (IE8+) so, say I save a list of things i need, rather than log in & go there, if I choose to save my login info, I could just click the link and the spreadsheet would come up with the file
Formating spreadsheet
Can anyone let me know how you can define the page setup and print area for an excel spreadsheet so that it downloads in landscape and not portrait when downloaded as PDf, Thanks Rob
Cut & Paste Problems - Help
When ever I cut and paste anything that has blank cells or paragraphs of text the alignment gets all messed up and the copy paste is useless. I tried everything i could think of with no luck. I tried from CSV file, no luck. The crazy part is that same problem exists if I cut and paste from excel directly or if I cut and paste from another document within Zoho sheet. The only solution is too upload new files everytime but this doesn't work since I have many detailed comment fields and they won't import!
More than one plot
Is there a way to plot more than one data series at a time? When I go to 'Data Range' I can only enter one column or row. I'd like to plot more than one set of data on the same graph. Thanks!
2 questions Re; Alternatives to a high cost 401k or 403b plan SS
1. Which investment return is actually calculated? In the assumptions or in the calculated fields? Please explain. 2. When you wrote "extra cost in 401k", correct me if I am wrong but I interprete that as above the cost of a taxable account. But I don't know. Please advise. I am the alternate chair of my former employer's 457b/403b committee and went to get some data that clearly shows how costs affect tax deferred plan in comparison to taxiable or Roth accounts. We are setting up a criteria for
Problem in configuring WebData when linking external data
I am getting the message 'Problem in configuring WebData' when trying to use the Link External Data function to import data from one of my Zoho Creator views that I have exported as a CSV feed not requiring login details. What am I doing wrong? Thanks for help.
zoho sheet下方的标签区无法正常显示
zoho sheet下方的标签区无法正常显示,红色区域范围内
Freezing Panes
I'm trying to 1 row of a simple spreadsheet I'm using in Zoho Sheet and it keeps telling me to "freeze panes" but when I click on that option, it's not allowing me to do it. I go back and click "more actions" and it still says "freeze panes". I'm using Google Chrome for Windows if that helps.
Charting/Graphing
Looking to (1) use log scaled axes and (2) add trend lines to data. Can this be done? Is there a help screen? Regards, dB
This is not user friendly
I like this sheet but it is not user friendly can u make it as user friendly i have some problem with this site i cant update the datas As i am using this as the real time project. For example: I had created the datas into pivot table if i am updating the datas in the master sheet it must automatically update in the pivot table. So that i can use this site as the real time project
zoho sheets
I have had a spread sheet developed in excel format with a macros installed. When I try to import it to zoho sheets I can not duplicate the sheet. The sheet allows me to enter information onto a main sheet, and by pressing the generate rep sheet button all leads will be distributed to each rep for private viewing so the other reps can only see and update their leads.I am currently using zoho crm and I would rather have this method. I have attached the excel sheet.
FORMATS
I would find it very helpful if you add the HOURS format, so that when I calculate weekly hours, I get an accurate count. Google docs has this features and excel has this feature, but I dont see it in zoho sheet. Another feature that I really like in google docs is the FORM feature, this makes it very much easier to enter in data that I need to record everyday and some of the data is repeated many times, so the Forms also allow for the most common data to be populated by default, but allow me to
Public Sheet to default to Edit mode
I would like to make my public sheet default to the Edit mode (not the Read Only mode)...most of the people that will be using my sheet don't look around for options and buttons to click to be able to edit...they just expect the page to load and be able to edit the info in the sheet. Please help!
Zoho Microsoft add-in
I downloaded and set up the MS add-in. The toolbar is there on Excel on my computer, and I'm able to log on, however I cannot open a spreadsheet. I get a script error message. Help appreciated.
I can not rename a tab in spreadsheet
I right click but it does not do anything...I've tried it in 3 sheets. SZ
Lock cells
I would like the feature to lock cells from editing (for example formulas calculating the tax you have to pay on an investment) abdullahadam
Unknown function: _default
Just wondering if anyone can help me, I am getting the error Unkown function: _default in the following code on the line that is highlighted. Sub UpdateStock() ' Dim c As Range Dim QTYSold As Integer Dim count As Integer QTYSold = 0 For i = 1 To 100 If Sheets("Sales").Cells(i, "B") = "RUS" Then QTYSold = QTYSold + (Sheet2.Cells(i, "C")) Sheet1.Cells(2, "D") = (Sheet1.Cells(2, "C") - QTYSold) End If Next i End Sub
Spread Sheet
very gooooooooooooooooooooooooooooooooooooog i like iiiiiiiiiiiiiiiiiiiiitttttttttttttttttttttt
VB Time Outs
I run a particular VB macro every quarter to update a set of spreadsheets. The macro inserts and deletes a couple of columns, does some range copying and pasting, and updates some equations. It worked fine on many spreadsheets for a year or more, but now I'm getting script time-out errors. The only real difference is that my spreadsheets are somewhat larger (about 50 rows and 20 columns). The errors do not always occur at the same line in the code. In fact, every once in a while the script executes
[Bar Charts] X-Axis starting at 0
Good evening, It is my first day around here. I just migrated from Google Docs, because it lacked me some important functionalities. My question is if it is possible to edit this chart in order the X-Axis to start in 2250, instead of 0. This way it would be easier to analyse the bar globally and compare its values. Best regards, Pedro
Embed, allow usage and printing but NOT download of XLS
I want to embed a sheet in a web page and allow any visitors to fill in data and have the spreadsheet calculate the answers for the viewer and let them print the results but I do NOT want them to be able to download the XLS sheet and take my calculations and layouts with them. The embedding went ok, and the calculations were also ok, just do not want them to get the xls. Please point me to the correct research area.
My sheets
Can I possibly undo a change on one of 'my sheets' that another user I have shared it with has made? Also, if I share one of 'my sheets' with multiple users, can I see who made what changes? I want to be able to combat against the possibility of a user I am sharing a document with making accidental or incorrect changes and corrupting the data for all. Thank you.
对每一行设置权限
教育局准备对下面每一个学校10年来的数据作一个统计,每个学校每一年的数据报上来我再作汇总很麻烦,我想共享一个工作表,大家都在这个表里填,而每个学校只能填自己学校的数据对别的学校的不能修改,就需要对每一行设置一个权限,有没有这种功能?
Count all cells in a row with the word "Monday"
Hi, Question 1 I am creating a sheet and I need to count how many rows has a certain partial string match. I first tried to count all the rows with the word "Monday" by using this code: COUNTIF(A1:A100;"*Monday*") This displays 0 as a result, which is wrong. I then clicked on one of the date fields I want to sort and noticed that the underlying code for the date is different than the display in the cell. The cell displays: Monday, August 09, 2010 The underlying code displays: 08/09/2010 Is this
初次使用Zoho Sheet的感受
1、表格中用右键菜单粘帖不成功,但用ctrl+V可以 2、中文输入状态下,切换到其他application,再返回sheet,第一个输入字母是英文状态,之后才能够中文输入 3、是否可能发布文件给几个特定的人,让他们无需注册和登录而通过一个特定的链接查看文件,而不是公开发布。 4、没有找到帮助按钮
鼠标右键 点 复制 完后,要被 复制的 ...
鼠标右键 点 复制 完后,要被 复制的 东西被删除了
有编辑查找功能否?
咋找不到编辑查找替换功能?
Next Page