Sheetでエラー発生
ファイルを開けません。 「シートを開く際の問題発生」といったメッセージが表示された。 Docsと同じようなエラーです。
Protecting cells
Need to protect cells while in public area if not anybody will tamper with the structure or information provided in a spreadsheet. You either have collaborative work spreadsheets or you have public type that require protection for certain parts. When can we expect that option?
Protect sheet or link sheet to other sheet
Hello all I'm a new Zoho user. I have an issue. I have developed a projectmanagement method in excel. This works really good and clients want to use it aswell. I want to give them access over the internet so that more people are able to use it en get informed. That means I have to protect my links and calculations over the 15 tabs to prevend damage and unauthorised use. Does anyone have ideas how to do this? Is Protecting cells/tabs an option? An alternative is to leave my method in one sheet and
Can I assign a note to a cell?
I need to add different notes to many individual cells (as can be done in Excel). Is this functionality available, or incoming? ;) Thanks
Zoho Sheet API doesn't allow to make a sheet public
Hi, I've been trying to integrate zoho sheets to my page, I'm able to upload a sheet but now I need to publish the sheet and I don't see any function on the REST API to publish or share a sheet
Formatting numbers
Hi, by default numbers are formatted like "1,234.56". How can I change the format into "1.234,56", like it is used in many non-english speaking countries. Kind regards, Frank
Is there anyway to ROLLBACK or RECOVER an earlier version of a sheet?
We used the Zoho Notebook with a sheet page, we had data and someone did a sort which moved some data out of place then their IE crashed. Thus they could not UNDO to fix their mistaken sort. Is there any way to REVERT to an earlier version of a sheet? I have manually fixed my sheet but would like to know my options if this happens again. What are backup options (I hear there are some if you're not on FREE, what's the $ for NOTEBOOK + SHEET?). Thank you.
Diferent axes on charts
I can't do a chart whit different axes. I need put different values on different axes.
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
Next Page