Formating cells
Hi! Is there a way to have an image as cells background? Marko
Remote saving problem ?
Hi, We are trying to integrate Zoho Remote API on our server... All is fine width Zoho Writer ... read/write docs is OK ! But with Sheet and Show... we can read documents, and save... but the changes are'nt really saved... Do we forget any thing ? Then url for submitting ... : http://www.soludesk.com/zohoa.html (you can use it ... ) The code : <form method="POST" action="http://export.writer.zoho.com/remotedoc.im?apikey=07d54740819543ec46003acca43d6251&output=editor" target="_blank"> <input
goal seek
Hello, I would like to know if is it possible to use the function "goal seek" in Zoho Sheet? Thank's Josep
Share a Sheet and hide the formulas
Hello, Is it posible to share a Sheet for edditing with other members and to hide the formulas and Macros? Thanks Josep
How do I attach a comment log to a spreadsheet?
We would like to attach notes to client spreadsheet and make it accessable to all employees. We cannot find a link to do so. Is there one?
cannot merge two or more cell between row
i found that we can only merger between column. Perhape we can merge row also
Find/Replace on Zoho Sheet
I cannot find an option to Find/Replace when using Zoho Sheet. Am i just missing it somewhere? I use a status page at the front of my sheet and without Find/Replace functionality I wont be able to use the product since manually changing code every day is not desirable. Thanks
Beta
When do you plan to finish the beta status?
Hot To Make Fixed Column Titles?
Row one in my table I want to make as titles that are permanently in row one. I have frozen the panes so that row one is fixed in place when scrolling down and up. But the data in row one is not frozen. If I order a column alphabetically the data in row one is reordered with it and so my titles can end up anywhere in the document. How do I fix or freeze row 1 and its data to stay fixed on top?
Can we have custom formulas (User Defined Functions) in ZOHO?
In Sharepoint we have Excel services that allows us to add our addin that contains UDFs. If the same behavior we want with ZOHO; can we implement that some how.
Switching Between Sheets - Load Problem
I have troubles sometimes switching between different sheets. It seems to happen after I try loading one sheet which gives me an error. Then when trying to load any of my others I get the graphic of it saying it is loading the selected sheet but it lasts forever and loads nothing. I cant load any other without closing the browser tab and reloading zoho. I use firefox 3.53
Can we insert shapes and call-outs in ZOHO sheet?
For our collaboration requirement we need to be able to insert shapes and call-outs within our sheet. Is it possible with ZOHO sheet for now. If not when we can expect this?
Trouble copying macros from Excel
Hello, I admit that I'm a VBA dummy. I'm trying to get conditional highlighting into my document and I've read all the posts on the subject, but still couldn't find enough to help with my particular case. As a workaround, I recorded the following macro in Excel and then tried to paste in to the new editor. The following error appeared "unknown field name: FormatConditions." Any help would be greatly appreciated! Thanks. - Jen Sub High() Range("H2:AE11").Select Selection.FormatConditions.Add
MS Office plug in bug
Please check the error below out. I tried to reinstall Excel, IExplorer, Mozilla, Zoho plug in and the error remains... Internet explorer script error line 1542 char 1 error invali argument http://js.zohostatic.com/sheet/v35_11/js/sheet.js // $Id$ /** * IMPORTANT NOTE: This compressed javascript includes thirdparty javascripts * listed at http://sheet.zoho.com/html/thirdparty.html * The original javascript sources are available in the above location. */ if(!Array.prototype.indexOf){ Array.prototype.indexOf=function(_1){
Plotting the x axis on a line graph...
I apologize in advance for being such a noob. I was interested in using Zoho Sheet to make some simple line charts for two columns of data. I wanted the first column of data to represent the values of the x axis, while the second column is the actual data set. Every line chart I make, the x axis just ascends from zero upward in increments of .5 units. I've looked through the menus in hopes of finding a way to define the x axis, but I can't find one. I'm sure I've missed something. Any help
User Documentation?
Are there any user manuals for Zoho features or are we just supposed to figure out how things work from the toolbar menus? At the moment I'm looking for documentation of Sheet operation, specifically,I need to do a find and replace on a column but I can't find anything as a place to begin to learn how to do this. On line user manuals in general would be a great help; particularly if the contain info as to how to do stuff from a regular browser and from Safari on my iPod.
Sheet and Firefox - Problems loading
Help! Up until recently I was able to launch the application sheet on a seperate tab whist in ZOHO Business, it now says problem loading page - timed out. Please can you help me find out why? I can not access it from ZOhO Business. I have accessed it by going to http://a1.sheet.zoho.com/home.do# as you have recommended to others with problems. Thank you for your help, L.
Why some cell borders not appearing in preview or printout?
Using Firefox on Mac, some cell borders do not show up either in preview or in printout. I tried removing all borders and re-bordering, but the same cells go unbordered again. Very frustrating after hours preparing a sheet. Any advice appreciated.
EditGrid
Two products, Zoho and EditGrid. The later, can Hide Sheets, and Gridlines, Zoho can not. Can you not implement these two basic functions? You have such a good product but lack these essential features.
Features / Timescales and Limitations
Hi, in reviewing Zoho Sheet (and forums / blogs) against other tools for a potential business application, I have the following questions.. Limitations - can you give guidance for the following.. 1) Recommended maximum spreadsheet size (number of row / columns or MB) - we are currently having performance issues with a 1.7MB spreadsheet (one sheet, with no formulas) that has about 700 rows and columns up to column IV. 2) Is there a limit on the amount of data that can be brought in through the 'link
Link between Sheets and Documents
Can you tell me if files I create and update or import into Sheets will automatically become a show up in Documents? I need to know if I have a file in sheets, that the rest of my team will be able to access and update as needed. Thanks. Tyrika
Zoho sheet excel sheet not correctly copied
Although much of a spreadsheet is correct on one sheet there has been an extra column created'oct 09' with some totally inappropriate data.the sheet still seems to be running so cannot make a copy for attachment
Can't remove sharing on Sheet
I click "remove" or "change" on the sharing dialog box but nothing happens. Is anybody else having this problem?
ranges in pivot table
hello how can i set the ranges in pivot table to ranges that i want and not the default ranges that it gives? i.e: pivot gives me 1-8, 9-16, 17-24 and i want 1-5, 6-10, 11-20, 21-24 thanks
Is there a sheet that already exists that is called "dofollowblogs" ?
Is there a sheet that already exists that is called "dofollowblogs" ?
Server 500 Error : Internal Server Error
My client has a very distributed virtual workforce who are using Zoho Sheets throughout the day. They all work in the same spreadsheet workbook but usually on different sheets. They are receiving the following error quite a bit, I'm also getting the error. Error 500 Internal Server Error Kindly reopen the file and try again It is making work almost impossible for some. Is there any resolution? I notice that in previous forum posts you suggested people visit http://a1.sheet.zoho.com , however
Unable to correctly create Stock Charts
Hi, First, I'm a really big fan of zoho, and I am considering using zoho primarily or even solely for a new business I'm starting. Right now I'm testing some things out and I'm running into a problem: I am trying to create a candlestick chart. Here is the url for my test spreadsheet: http://sheet.zoho.com/public/brandonjwilhite/testchart I'm pretty sure the data series are in rows, because when I try to tell zoho they are in columns I get an error. Please, can someone tell me what I'm doing wrong?
Problem with Zoho Sheet WORKDAY function
Hi, I'm seeing a problem with the WORKDAY function. Here is the scenario: Cell c6: 9/24/2009 (A Thursday) Cell d6: 2 Cell e6: 9/28/2009 (A Monday. This will be my holiday) Cell c7: =WORKDAY(C6;D6;E6) The result in c7 is "#Invalid Formula" The result is the same when d6 is any of 2, 3, or 4. For all other positive values in d6, the result in c7 is as expected. Can anyone else duplicate this? Is this a bug, or a user error? Thanks.
problem in export to csv
I have imported Excel file in ZOHO spreadsheet. After that,i have exported that file into CSV. That time i didn't get the correct value for the date column. For example i have "Invoice Date" column with Date Format "dd-MMM-yy" (02-Jun-07). But in CSV file it is coming as 39265. Please rectify this issue. Thanks in Advance
Images in Zoho Sheets are not included when Exporting to XLS file (and other file types)
When I try to export an excel copy of a Zoho sheet that has an image imported into it, the export to file feature does not include the image. Is this a known issue?
How to open an uploaded sheet in Zoho sheet editor from C#?
Hi, Zoho sheet is powerful! I have a question. How to open an uploaded sheet in Zoho sheet editor from C#? How to invoke the speadsheet GUI to edit the sheet? Could you please provide the sample code?
Column widths incorrect for 2nd and 3rd published ranges
I have 3 publish ranges in this Zoho spreadsheet that I have arranged side-by-side (horizontally) with a couple of empty columns in between each range. The first range begins in column A and ends in column G and when I insert that range into this web page page, the columns are the widths set in the spreadsheet. The problem is the column widths of the 2nd and 3rd published ranges do NOT display on a web page with the correct widths. And, if I leave the ranges in their current positions, there does
Pivot tables from Excel spreadsheet .xslx
After I imported an .xslx spreadhsheet into Zoho Sheets, I entered some information and went to create a pivot table. I had a major problem because highlighting the fields I wanted did nothing to show the categories of the sheet. I checked out the tutorial on the blog about creating a pivot table from a .csv and did not find that helpful to what I was having a problem with. After tinkering for a few hours, I finally realized that Zoho does not recognize any column categories if you highlight
text to columns
how can I do 'text to columns' in a zoho spreadie?
Charts Not Updating
Hey, I am having a problem here with published charts not updating. The image itself on the spreadsheet updates but the image link withing the URL and the place where it is published still show the old charts. Am I doing something wrong here? Thanks -David
Publish Range Format Options
Hi, is it possible to control the column width format when publishing a range from Zoho Sheet? At the moment the HTML snippet publishes the desired range, but does not use the column width that appears in the spreadsheet.
Merge
Would it be possible to merge cells in the same column as well as rows?
no save in shared spreadsheet
When i open this spreadsheet in snow safari, there is no save icon for a shared user even though they have been granted full read/write permissions. Why is this? When will you fix it? thx gil
spreadsheet printing options
I see the way to insert page breaks in a document but is there a way to insert page breaks in a spreadsheet to control the prints of a long spreadsheet? And, is a print preview option? And is there a way to select the area of a spread sheet to print so that part of a spread sheet may be printed?
Found a bug in Zoho Sheet
I'm using this app for the first time, and I am absolutely a fan! Way better than other online spreadsheet apps! I did find a bug however: When unmerging cells (by right-clicking and selecting remove format) There is a bug that causes cells to the right of the merged ceel to become unreachable with the cursor...
Next Page