Problem with copying, pasting, sorting if cell contains a link
My sheet is: http://public.sheet.zoho.com/public/ganta77/cpc-tv-tipps Its a sorted sheet for a TV schedule. The columns are date, time, channel, and a link (naked URL). Since several days I've got problems with copying, pasting and sorting if the 4th column with the URL is included with the rest. In short: it doesn't work now at all, although it used too work properly. So I have to leave the URLS completely out. This seems a new bug. Another question: is there a way to display the date in german
Read/Write access users - I can't seem to make it work
Hello - We are just testing out Zoho and are trying to share a spreadsheet in Zoho sheets between 7 users. I have created the sheet and shared it with the other 6, highlighting the read/write access. A few questions: 1. When they sign up in Zoho and go to Zoho sheets, they do not see the file in the "Shared with Me" section. a. Is this where they should see the file I shared with them? b. If so, should I or they be doing some kind of account setting so the file shows up? c. If not, where should
Unable to open Zoho Sheets... again
I don´t know why but I can't, again, open my zoho sheets. I am logged and I can access to all other documents except the spreadsheets
File size limit, # of people file can be shared with
What is the size limit per file of a Zoho spreadsheet? Can it be shared to an unlimited # of users? My case: Would like to use it on a report needing consolidation of data from 150 teams. The average file size of the report is 15-20mb. Please get back to me on this as soon as possible. :) Thanks!
Unable to open Zoho Sheets
I can't open any zoho sheets from long time ago... What's happening?
Couldn't able to see a navigating bar in lower side
Hi Team, I wonder how I am missing a navigating bar in bottom side. I have a sheet with 7-8 column and could see 3-4 at a time..Then I just want to see other 4-8, I don't have a navigating bar in bottom. Am I missing something? Regards Shihab
Save Sheet via an custom javascript function
Hello, i am loading the Zoho Sheet in an iframe in my application. It works perferect. When the user saves the form, the Zoho sheet must be saved as well too. Since the sheet is running in an iframe i cannot call the function "saveremoteGEdoc();" since cross-browser-scripting is no allowed. How can I solve this problem? Anybody any idea? Looking forward to hearing your ideas. Andy
Our Business site disappeared
We have been working wit a business site and we can no longer login. The site is jetiii.com.
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
Next Page