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...
bug in zoho sheets
Very powerful software and works well for embedding my excel spreadsheet for the Explorer and Firefox browsers but bombs with "Error 500" in the Safari browser. Also didn't support SUMPRODUCT excel function but I got around it. Geoff Sharp
Unable to import csv as pivot table
The title pretty much says it all...When I select to import the .csv as a pivot table, zoho sheet seems to try to do something, but then just sits there. If I import the .csv as a normal spreadsheet and then try to create a pivot table from the data I get a "Problem creating pivot report" error. I'm attaching the .csv file I'm using, which is just test data and is very basic. I had to remove the .csv extension, b/c the forum said this extension was not allowed via this portal
Sheet Question
How do I print a spreadsheet with the gridlines showing?
Copy & Pasting in My Sheets
Is it possible that I am overlooking being able to copy & paste in my sheets? Also I have documents in Microsoft Publishing, is it possible to put these into zoho?
Feedback on Zoho Sheet
Firstly I would like to congratulate you on the commendable effort of getting something like this on the web. I know that there are competing product offerrings but Zoho seems to be the best of the lot that I have tried. Also like the integration with Google and Yahoo sign on. Those were the bouquets, here come the brickbats. I spent some time on Zoho Sheet and was disappointed by atleast a couple of things. First, by the time taken to update the values of the lower part of a range chain when a chain
Convert cell format back to numbers?
Hi there, I was once proud of my Excel skills and this seems like a real stupid newbie question to ask, but I'm just stuck... How do you bring a cell's content format back to plain numbers? Once I've (sometimes accidentally) pressed e.g. "set as text" or a date format there seems to be no coming back? There is a "clear formatting" option on right click, but that seems to handle only visual styles, e.g. bold. /H
Sheet view only only showing partial list...
I've done a number of contact searches in the contacts tab, using the search box on the right side of the screen and clicked search by account name and then typed in the company name. Each search result has over a 100 contacts but when I click on Zoho Sheet View for these searches, only 58 lines of contacts show up. Any idea why it doesn't show the full list? Thanks, Brandon
sheet formula
In any given cell, if I put in a simple formula, i.e. (=D18-C18/2) it does not compute properly - leaving off the (/2) portion of the equation. What to do.
Calculation problem - time minute to seconds
calculation problem: im trying to transfer a working formula from excel into the zoho sheet this is to calculate the seconds from a time format input = eg. 23:00 (23 minutes) = 1380 sec 23:30 ( 23.5 minutes) = 1410 sec and so on when my formula is in the Excel sheet the results are : 29:51 || =IF(A5="","",A5*24*60) || the result is 1791 but if i put the same set of formula into zoho sheet 29:51 || =IF(A5="","",A5*24*60) || the result is #VALUE the # value starts if i'm using 24:00 and then onwards
pivot table
hello i tried to import an excel sheet and to make pivot, unless i import csv i cant do the pivot, can anybodey help?
Next Page