Issue of line height in Zoho Sheet
Hi, all! My System : Ubuntu 9.10, Firefox 3.5.5 When i write some Chinese character in the Zoho Sheet, the height of sheet line is larger than the line number of the left site. Please see the attached picture. Thanks! Steven Deng.
Stock Function
It would be nice if Stock function featured dividend capability.
ZohoSheetの日本語うちこみの際の問題
ZohoSheetでセルに日本語を打ち込む際、 最初の一文字目が必ず半角英数字になってしまいます。 例：「みかん」と打ち込もうとすると「mいかん」になってしまう。 使用しているOSはXPsp2で、言語はIME2007です
工作表不能更改名称？
工作表不能更改名称？用什么方法可以改名称？
不能删除工作表？
不能删除工作表？不知道如何删除工作表？
Hyperlinks and/or VBA Workaround
Hello, I have some hyperlinks in an Excel document that refer to other locations in the same document. I have figured out how to create a macro button using VBA that goes to another tab, but I am having difficulty creating a macro button that will simply scroll down "X" number of rows. My understanding is that to do this in Excel, one uses the GoTo function, which is not supported in Zoho. Is there a workaround for this? I have tried the following Application.GoTo Sheets("Sheet2").Range("A100"),
Issue of Font Color in Zoho Sheet
Hello, I find a issue of font color in Zoho Sheet , please see the following information. My system : Ubuntu 9.10, Firefox 3.5.5 Issue : The font color of TextEdit(address & data input) and dropdownlist(font list) is the same as system theme , but the font background color is white not as the theme. My computer has a custom theme with white text. So i can't see the text in these places. Please see the attached image. Suggestion : Change the text color to black. Thanks! Steven Deng.
Use of Macros
I use the following in Excel.....Sub Plan()'' Plan Macro'' ActiveSheet.Unprotect Application.Goto Reference:="Plan" Selection.Copy Application.Goto Reference:="Option" ActiveSheet.Paste Range("B10").Select ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=TrueEnd Sub.....but this doesn't work in Zoho as it gives me the error message unknown function "Goto". Can you help?Thanks
Export problem
In export to MS-Excel Workbook or 97-2003 workbook sums are appearing wrong.
Graph Problem - Source Data
Ok. So I'm trying to graph data from another sheet and it keeps saying "specify a valid sheet name" I have a sheet called "Info" and here is what i'm trying to put as the data source I want it to graph from B11 to C75 ='Info'!$B$11:$C$75
Copy Macro Help
I did a record macro to copy data from one spreadsheet into another spreadsheet and it works in a way. But not the way I want it to. Let me see if I can show it. <iframe width="500" height="400" frameborder="0" scrolling="no" src="http://sheet.zoho.com/publish/polardude1983/copyhelp"> </iframe> Sub copymenow() ' ' copymenow Macro ' Created by polardude1983 on Sat, Nov 2009 05:18:28 PM ' Range("C5").Select Selection.copy Range("D7").Select ActiveSheet.Paste End Sub When it copies it doesn't copy
Formula Help
I am trying to see if i can convert my wonderful and extremely complicated spread sheet from excel 2003 to zoho. Anyways here is the formula that I have that works in excel 2003, but not in zoho =IF(AND(H16="Male",H16="male"),"8",IF(AND(H16="M",H16="m"),"8",IF(AND(H16="Nursing",H16="nursing"),"12",IF(AND(H16="N",H16="n"),"12",IF(AND(H16="Female",H16="female"),"2",IF(AND(H16="F",I3="f"),"2",IF(AND(H16="Woman",H16="woman"),"2","enter male or female")))))))
EMBEDDING GOOGLE CALENDAR INTO ZOHO
CAN IT BE DONE?
当我有7个工作表时，我无法再导入表格了。是有数量限制吗？
如题，谢谢！
New to sheets, have some questions....
Basically, my search skills are terrible, and I am having no luck searching for some kind of template.... I want to keep track of expenses, medicines taken, money made, etc, basically, all the things of day to day life. I am hoping to find a template of some sort to help. I would like to have it figure up weekly, monthly, and yearly totals and averages as well. Any hints, tips, pointers, or such? Or am I going to have to make a sheet for each other, from scratch, for 365 days of the year? Thanks
Folder to arrange
Hi team, This is site is an ultimate site to store the sheets & docs online. But the only thing the site is lacking behind is we can not create folders to organize our folders. It should have an option to create folder to keep our docs or sheets in an organized manner. Thanks, Sreeram Murty.
User manual
Hi, Do you have a user manual for Zoho Sheets? I can't seem to find basic edit operations like -Fill -find & replace Thanks, Christopher
Date conversion to US format
Hi, when I enter a date into a spreadsheet, such as 14/9/09, it is automatically changed to 9/14/09. Whilst this may be great if you live in the US, the rest of the world uses dd/mm/yy. How do I stop ZOHO writer from automatically 'correcting' my dates? Julian
Why the data is not synchronized in sheet.zoho.com when two or more guys editing the same shared sheet?
- Failed in two accounts editing the same sheet in two computers - Failded in one account editing the same sheet in two computers. Both are ok in google spreadsheet, it shows in different color when the user is click the cell. Zoho is so bad on sheet. I lose too many datas when editing a file with team members. If this problem or bug is not resolved, I think Baihui in China won't delveops well, and zoho will never be a greater in this industy.
复制和黏贴的问题，还有中文输入的问题
测试一下ZOHO的在线EXCEL文档，从电脑里面的EXCEL文档里面拷贝的数据无法黏贴 新建EXCEL文档后，切换中文输入法（搜狗拼音）之后，每次输入的时候，会自动将第一个字母作为英文输入，举例说明，比如我输入“zhangwei”的拼音后，在表格中会出现“z”的英文字母和“hangwei”的拼音格式 不能自动保存？
Willl spreadsheet cell overflow ever be implemented?
The lack of a cell overflow function ala Excel (where text that is longer than the current cell will show up in the next cell if that cell is empty) is a deal-breaker for me. I've seen comments from Zoho staff in the forums all the way back to early in 2007 saying this was "on the to do list". Does anyone have a timetable as to when this might be implemented? Thanks.
Sort Ascending / Descending Clarification
When sorting columns in sheets I find it a little confusing. Basically I just want to do a straight sort either a-z or z-a. The problems I have are.. 1a. The pop up describing the options when one chooses to sort is confusing to the average user like myself. It says `Do you want to expand the selection? Click OK if you want to expand the selection. Click Cancel if you want to continue with the current selection' Usually in a pop up like this clicking cancel means you no longer want to perform the
zoho sheet cell formatting shuts down my browser
Hi, I dont know if anyone else has this problem. But when I try to format cells in zohosheet (i.e. making grid marks in a spreadsheet), the whole application freezes and I have to shut my browser down and restart to work on my spreadsheet again...Are they going to fix this bug?
Uploading workbooks using C# .NET
Hello, You guys are the best!!! We are trying to upload files using the uploadbook api using C# .net but are confused on how to pass the content parameter. Below is how we are trying to post the content parameter but its not working. Would really appreciate it if you could help us out. WebRequest request2 = WebRequest.Create("http://sheet.zoho.com/api/private/xml/uploadbook?apikey=2d9c5895578aa11de5e04233325638f&content=F:\\ABC\\efg.xls&contentType=xls&workbookName=efg.xls&ticket=" + TicketID);
Sheet and link external data
I have a Creator application receiving data from a web site. This Creator app is linked to my Sheet via the Link External Data function. I can successfully import the data manually using the Refresh action, however - the schedule periodically import of 30 minutes does not update the Sheet. The set up is similar to this example http://blogs.zoho.com/creator/mashup-with-external-data-in-zoho-sheet Does the schedule import work?
Test please ignore
Test please ignore
Linking cells from different ZOHO sheets
Does anyone know how to do this - or indeed link cells from separate tabs
Update multiple tabbed sheets
Is it possible, in Zoho Sheets, to update multiple sheets at one time? For example if I have identical data for 12 of 36 sheets, can I select the 12 sheets and then enter the data into the relevant cells all at once? Thanks!
Zoho spreadsheet
Hi, I am a current user of google spreadsheet. As i am suspecting that there is leak of info, ( spreadsheets are shared), i wonder if zoho track the ip address of each user who view the document? Is it single login per user or mulitple Rgds,
Zoho Report and Zoho Sheet
I have generated a Zoho Report from Zoho Creator information - a Zoho Summary report. This has also been embedded back into Creator. I would now like to use the summarized figures from the Zoho Reports table in Zoho Sheet, ultimately to schedule an import of summarized figures for Sheet to work on. What is the best way of doing this ? I have tried 'Publish'ing it but I get a password protect error, even if I try the non-login option. Any ideas ?
how to build a new function using VBA?
Hi all, I have a specific problem. I want to use this user-written Excel function on my Zoho Sheet. Straight copying does not work. But do you have any idea how I still could make it work? Thanks very much! Laszlo
Hiding rows and columns in sheet
What happened to the ability to hide rows and columns. This feature is critical to our continued use of your product. You have just removed a CRITICAL feature.
Zoho Sheet questions
Hi Everybody, I'm a first time Zoho sheet user and an Excel power user (basically everything except VBA coding). I'm pretty excited about the sharing possibilities that Zoho sheet offers, and am working on trying to convert a simple Excel model I have to Zoho. Things I have questions about: 1) I have a couple of drop-down menus in the Excel document that the user selection an option from. The options are pre-defined using a list hidden elsewhere in the sheet. Does Zoho offer drop-down functionality
how to input a part of an external data into Zoho Sheet?
hi, i am new on Zoho Sheets, i just wanted to know how to input a part of an external data into Zoho Sheet? for example: http://www.youtube.com/watch?v=lGKemE_vEQs i only want to get views "62,963 views" on my Sheet and also Auto-updated, is there any formula? does it wor on Zoho Sheets? Thank You
Importing xls files to Zoho sheets
Hi, I created an INVOICE report in ZOHO CRM, one of the columns is the Invoice date in dd/mm/yyyy format. I exported this report in .xls format, saved it and then imported it to ZOHO SHEETS. The problem is with the date field. It shows as: '01/07/2008 The apostrophe makes the date unusable, and it can't be removed with the replace command, because it is only visible in the Formula bar, not the actual column data. Can you help? Christopher
Understanding the Display
When the form is displayed on my web page, it shows my signon name and then says 9 views. First, is there anyway to NOT show my signon name? Second, what does 9 views mean?
Server Error
Error 500:Internal Server error
Kindly reopen the file
I am so sick of getting told to reopen the file because of an error. What's causing this?
Error
We keep getting an "error occurred" in one of sheets and we can't open them unless I copy it and then use the new file. Any ideas? Thank you.
Pre-sale questions: Google Docs features, support, sharing/editing
Hi, After evaluating Zoho Sheets and comparing it to the spreadsheets of Google Docs, I have a good view on the features and capacity of both services. Zoho definitely offers great tools, however I still have a few questions. 1. It seems that Google Docs spreadsheets are quicker to load. On the same Mac, Google Docs spreadsheets load around 50% faster than Zoho Sheets. Will there be a speed bump anytime soon, or is there a way to load sheets faster? I will be opening loads of sheets each day, so
Next Page