Can row and column names be removed when embedded in webpage?
I have a sheet embedded in my web page. Works great. I'd like to be able to make it look less like a spreadsheet. Can I not show the row and column names? You know, like, Col A, B, C and Rows 1, 2, 3...
Freeze Header Columns/Rows
Is there any way to freeze header columns and rows? If not, when will that feature be implimented, as that is a feature that I pretty much need before being able to adopt a system. -Justin jmyer (at) incrementaladvantage (dot) com
Link to external data by sql
Hi guys, I'm trying to get my company to switch from Office to Zoho, mainly for the collaboration capabilities. One thing which is really missing for me, is the ability to pull data from an SQL data source (mySQL in our case) automatically. Is there a way to do this which I have missed? Do you have any plans to add it? Thank you, Near Privman
Office plun-in comment conversion error
When I convert a Zoho sheet for modification in xl 2k10, the Office sync plug-in removes carriage returns from comments when convertion occurs, and so make the comment unusable. It'd be corrected, I think.
Selection Buttons
Hi I have a number of registers amongst my sheets where birds, mammals, insects etc are listed in alphabetical order. Is there a possibility to have selection buttons at the top of the sheet (A - Z) and by clicking on a button it takes the viewer straight to that particular section. This would save a lot of scrolling, which a lot of visitors do not like to do. I look forward to hearing from you. Kind regards Hans
How many sheets / workbooks can I create?
I am new to using ZOHO and would like to use it extensively for my blog for various purposes. Now I need to know: How many workbooks can I create in a free account? (I have no plans to buy any paid stuff right now) What are the limitations (other than number of workbooks, if any) in free account as compared to premium/paid version? Thanks in advance for assistance Mohit
电子表格无法输入数据
你好，我的电子表格没法输入任何数据，不知道为什么？
Is it possible to set an e-mail notification for event listed in Sheet?
Hi, I am new to ZOHO. Is it possible to set an e-mail notification for event listed in Sheet? And how to do it? I know how to do it in Calendar, but I need to make notifications for some dates listed in Sheet. Thank You!
Cells do not merge
Hi On my sheeet "Birds Q - Z I have title blocks which are 4 horizontally merged cells. It has so far worked perfectly on dozens of items, but in rows 50 and 51 the third and fourth cell refuse to merge! As soon as I try to merge, it goes back to split cells. It's a mystery! What am I doing wrong? Many thanks for any help! Hans
Embedded sheet = You do not have permission to access this document.
I had a simple public sheet embedded into my Typepad blog. It worked for years, now it displays "You do not have permission to access this document." I re-embedded the code, republished, and still get the same display in my blog. The URL is http://www.coffeehabitat.com/2008/03/what-does-a-gre.html I am moving this blog to Wordpress, and have the same problem. I also re-embedded the code, republished, cleared my cache, and still get the same display. The URL is http://www.coffeehabitat.org/2008/03/what-does-a-gre/
Multi-layer folder - can tagging do a similar job?
I am seriously looking at "Zoho'ize" our company's document storage and sharing. It will be huge since we have several geographically diverse offices who need to share/cync data all the time. Zoho Sheet and Writer can well be an ideal solution - with one exception - tagging. While I love tagging personally, and on my PC, tagging has become the primary means of organizing files, our other users in the office may not be so thrilled. Our shipping team, for example, stores files under a folder such as
Macros keep disappearing
I've created several sheets in ZOHO Sheet all with a number of macros to perform repetitive tasks such as data manipulation and formatting... However, they keep disappearing from the macro list, comes up "No Macros Found" this is happening on several sheets and appears to happen randomly.. its is getting quite annoying to be honest as I'm now having to continually re-enter the macros.. So, in effect I've replaced a set of repetitive tasks with another repetitive task of re-entering the macro !!...
Cell borders
I've imported a sheet that uses some thick and thin borders. It imported keeping the formatting, but now that I've edited it some borders need repair. The border button doesn't allow me to do all the fixes- for example I can't put a think border on the only on a left or right side of a cell. In fact, Zoho only lets me add a thick border to the bottom. And looking more closely, this sheet uses thin, medium, and thick borders... I see from older posts that a more advanced border edit feature was planned,
Zoho Sheets
The cell comments don't seem compatible when dowloading to Excel. Format is considerably jumbled. Have tried various versions of Excel, is all the same problem. Actually, more current versions of Excel are worse. I have tried 2003 and 2007 versions of Excel under both XP and Win 7
paste
Why am I unable to paste info from other files into Zoho files?
Finding option is not working properly
Finding option is not working properly in zoho sheet please look in to it and solve asap.. Regards J.Lavanya..
Would it be possible to allow a member who only read rights to view or chat with other shared members?
Scenario: I shared a Zoho sheet with two members.To one a provided read only access and the other member with read and write. When I started the chat session the member with only read access was not part of the conversation.. Suggestion: To have all members who are sharing the sheet be about to chat. Staff TXTNLRN http://www.TXTNLRN.com Text 512-850-4898
zohosheet表格中列能否按第一个字的汉语拼音排序
zohosheet表格中小区列能否按第一个字的汉语拼音排序 编号 小区 楼层 套型 面积 设施 装修 价格 906c 1号大院附近 6F/6 3+2 90 部分设施 中装 38.5 909c 79大院 3F/5 2+1 70 空调太阳能家具 中装 38.8 891c 79大院附近 1-2F/2 130 独门独院 中装 81.8 830c 上海西路 1-2F/2 3+2 80 独门独院 中装 35.8 东大院 1F/1 3+1 105 中装 85 844c 东大院 4F/5 2+1 60 管道气 中装 34.2 845c 东大院隔壁 3F/5 3+1 72 精装 37.8 647c 东湖望景苑 4F/6 2+2 100 车库10平方 精装修 54.8 908c 中天花园 12F/18 2+1 85 毛坯 46.8 851c 中天花园隔壁 5F/6 3+1 100 平地车库15平方 精装 42.8 887c 中径路血站 5F/6 3+1 82 空调设施齐全 中装 38.5 842c 丰登路 6F/6 2+2 78 设施齐全 精装 37.8 丹桂苑 6F/6 2+2 90 车库19平方，阁楼90,2+2太阳能灶具
Add capability to resize the comment box
Hello, Request to add the capability to be able to resize / shrink and expand the comment box. See screen shot attached. Thank you Staff TXTNLRN Call or Text 5128504898 http://www.TXTNLRN.com
Live Updates not getting refreshed in excel collaboration.
Hi, I am trying to collobarate an excel document between two users. I am not looking for saving the file now. i just want to see the live update and chat window. I will list out what i have done. First i created an HTML file as below <html> <form method="POST" action="http://sheet.zoho.com/remotedoc.im" enctype="multipart/form-data" target="_self" accept-charset="UTF-8"> File : <input type="file" name="content" size="38"> <br> <input type="hidden" name="apikey" value="my api key"> <input type="hidden"
Track Changes by Author?
We are using Zoho Sheets between a group of us in different offices. However we are running into a major drawback: We currently can not see who is authoring each cell. For example...once I create the template and set it to share, I want to be able to have anyone in the group be able to edit it. However when they add or change a cell, it should add a little note or tag to the cell with the users screen name or initials or something. this way if in the future we want to look back and see who made an
In Zoho sheets when the owner of the sheet makes an update....
Hello, In Zoho sheets when the owner of the sheet makes an update.... An email with the link is not being sent to all members sharing the sheet. What am I missing ? Thank you Staff TXTNLRN send a text to 512-850-4898
losing information
hi there, am having problems with data disappearing when I paste it in from Excel. whenever there are more than about 500 lines pasted in they appear to be copied in correctly and saved etc. but then when I go back all the data has gone. is there any reason for this and is there a better way to copy this information in so I won't lose it. I am copying in to an existing worksheet which 3/4 other people have access to. thanks.
VBA code is not working, but works perfectly in Excel.
I'm having a rough time getting my VBA codes to work in Zoho, while it works perfectly in Excel. UserName: In Excel, I use the WorkBook_Open() and Application.UserName functions to get the UserName logged in. I know this is not possible (soon?) for Zoho. So instead, my understanding is that I need to label a cell as 'UserName' and then the user is required to input their UserName before editing. Not fool-proof or error-proof, but it is a slight workaround. However...its not working for me. And im
Problems with Right Clicking on the Sheet
When you right click on the shreadsheet the browser context menu appears with the Zoho Sheet Behind. You can get the correct context menu to appear by holding down the mouse button. Also pressing the alt key on the keyboard appears to fix the context menu in place. I haven't seen this issue mentioned in any forums yet. jtmitc
Importing Spreadsheets
I would like to be able to import an excel file directly to a zoho sheet within an existing document and have all the formulas intact.
为什么我们填写不了东西
我们的文件打开了填写不了让我们十分郁闷
What is the point in showing blank sheets in Zoho FAQ?
I would like to draw your attention to http://www.zoho.com/zoho_faq.html Point Number 12. Sheet 2 and Sheet 3 are blank. I believe these can be pruned away right? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Fetching Data
Hi, I have a database in zoho creator and i need data from my database to be pulled into zoho sheet.In the database i collect the number of sendouts and placements from each employee on a daily basis. What i need is the total of that to be pulled in the sendout and placement cells in here. How can i do this. I also have information about sendouts n placements stored in zoho reports, would it be easier to pull information from zoho reports or zoho creator. Thank You
How to make columns sortable
I've created a spreadsheet that I have embedded into a web page. I DO NOT want visitors to be able to edit the spreadsheet but I DO want to give them the ability to sort columns by ascending or descending order. I can't seem to figure a way to do this. Is it possible? If so, how? Many thanks, CB
shout box in shared files
It is wonderful that every shared files w/ online users can talk live. It wols a be a lot more wonderful if we can also personalize the fonts, insert smileys just like a live embedd shout box can be edited.
Sharing doesn't work
I have tried time and time again to share a document with some collaborators and it doesn't work. Please fix
How can Filter Row Data (Set on Row Topic)
How can i Filter Rows over Row Head Line Description? Auto-Filter: We support auto-filters when imported as CSV files. Again you would need to select the Tabular Data option while importing. Filters for normal spreadsheets will be supported later. When is later?
Border formatting
Hi there, I'm trialing Zoho just now and was wondering if there's the option to format cell borders? Basically just want the option to outline cell borders with different colours and thicknesses. Thanks, g
simple(?) VBA help
I am getting the message "Encountered error at line 9 :Invalid arguments: Object required" when I try to run the macro below, which I copied from http://www.mrexcel.com/forum/showpost.php?s=4ab5add6c1156e7e667e8fe62208e2e3&p=266170&postcount=3. Can anyone explain why? Public Sub main() Dim oRange As Range Dim oComment As Comment Dim sText As String 'Use object variable to hold range. In this example Sheet1 Cell A1 Set oRange = Sheets("Sheet1").Range("A1") 'Use object variable for comment Set oComment
Sheets
One major problem I have with sheets is that if I have multiple tabs in a single sheet, each time I move between them the interface scrolls back to the top. If I have a tab that is a summary of some fairly large set of data on another tab, and I want to enter content on that other tab, its frustrating to have to scroll down each time I change tabs. Charlie
Merging Cells Down
It would be very useful to be able to merge cells down in adition to sideways
My sheets have gotten SLOW. Need advice.
I've been using Zoho sheets for a couple of months-- my objective is to create a few databases that I can sort by date or name, and also insert hyperlinks of images. I've created three such sheets, and as I progress, I've found that using them becomes slower and slower. Perhaps my plan is too ambitious for each sheet? My main sheet is currently about 220 lines, 30 columns. As it's grown, it's becoming more and more sluggish to use. Should I instead create individual sheets for smaller date ranges,
Difficulties with spreadsheet editing
The Zoho spreadsheet feature is great for display. I like how I can not only access it from a website, but I can also edit from the site. Since I don't care about others doing the same, I am not worried about people "stealing" it. However, I have come across some non-user friendly aspects of the service. First, no easy to access "undo" feature. I tried to move some of the data I already typed in to different cells, but I wanted to undo it. I couldn't find an undo option. Ctrl Z only changes
how to: format "german style"?
is it possible to format dates in a zoho-sheet in german style "dd.MM.jjjj" (for instance: 03.10.1989)?
Next Page