Unneeded sheets not to be shown ...
Zoho Sheet, I would like to draw your attention to https://www.zoho.com/zoho_faq.html#5 public spreadsheet. The specific spreadsheet has data only in the first sheet and Sheet 2 and Sheet 3 are just boilerplate contents and is empty. I think whilst publishing empty boilerplates need to be pruned off. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Equivalent for "f4" key in Sheet
Hi to all my name's Marco; I'm new here at zoho and I've been trying it! I must say I feel very good with it and that I'm happy to find an online tool for my works that is nice and helpful.. My question is that in Microsoft Excel, when I want to "set a command" , I select it and then I press F4 so that what is on that cell will repeat in the cells I want it to drag ,so what's this equivalent in zoho sheet? By the way, in OpenOffice the equivalent is "Shift + F4" and I haven't found the equivalent
importing text files to spreadsheet
Hi, Recently, I created a zoho spreadsheet, either by copy/pasting a text file, or by importing it, and I thought it automatically detected that it was a tab-seperated file, and the results were perfectly formatted two column file. I am unable to duplicate that process. Is there an easy way to do this? Thank you. motownmutt
Validación de datos
Hola, Quisiera saber si contamos con algún manual, no he podido encontrar cómo trabajar la validación de datos.
Script Error: sheet.js
Hi, I get an Internet Explorer Script Error every time I open a sheet from Excel 2007. The details arbelow: Line: 15214 Char: 1 Error: Invalid argument Code: 0 URL: http://js.zohostatic.com/sheet/v35_22/js/sheet.js I am running IE 8.0 on Windows XP Professional SP3. Any assistance would be greatly appreciated. Lars.
Error Occurred Problem while Opening the Document
Imported an excel file but it won't open.
Error when removing comment
when I select two cells that has comments and select remove comment from right click menu, only comment in first cell is removed.
Limitar la opción de una hoja publicada
Una vez publicada una hoja de cálculo en una web, ¿podemos evitar que el usuario acceda a "Visual Basic" con "Alt + F11?
Eliminar columnas y filas
Al insertar el "iframe" de una hoja de cálculo en mi web (GoogleApps) no consigo eliminar las filas y columnas en blanco sobrantes. Lo he intentado desde la misma hoja antes de publicarla pero sin éxito. Gracias anticipadas.
That would be a nice feature !
Once i was updating my sheet file, i saved my edits and closed it. Then i opened it today, and i found that somehow i have deleted a row in the previous time, and i can't remember its contents. It'd be nice if Zoho can create revisions or at least take a copy from the sheet file before editing it and save it somewhere, so i can undo my changes if i want that. Thanks and keep the good work . . .
Doesn't work on iPad
Please the problem with iPad
Paper Options Missing
When I try to export my excel file in PDF format, I can't choose if I want to export in portrait or landscape. Please have a look at same function in Google Docs.
Ocutar y proteger celdas de fórmula
Cuando publico una Hoja de cálculo en una página web con la opción de pegar el "iframe", y me aseguro de seleccionar la opción de "Ocultar y proteger celdas de fórmula" no funciona, puesto que cuando lguien se conecta a la web puede acceder y modificar esa celda.
Celdas protegidas
Al generar el código HTML-Iframe para publicar una hoja de cálculo en una página web, el programa te pregunta si quieres proteger las celdas con fórmula. Aunque respondas afirmativamente, cuando accedes a la página igualmente te permite modificar esas celdas, provocando que el resultado que genera sea incorrecto, y por tanto, obligando a refrescar y volver a introducir los datos. ¿podemos evitarlo? Un saludo
fontbug2
Enviroment WindowsXP Chrome5 Lang Japanese
font bug
Login form(iframe),Privacy policy and some menu cause a font-bug. But File menu dont have bug. Please fix this.
Link to open another Worksheet
Is it possible to link a cell to open a separarte worksheet within a spreadsheet. I am creating an index in the first worksheet to open other worksheets in the file
Zoho Sheet Changes Report is Inadequate!
When any of those people I gave them the right to edit an specific sheet applies changes to the sheet, I receive a notification in my email. The problem is this notification isn't complete at all and doesn't provide adequate information for the changes. Sorry for comparing with Google Docs again, but please check how they notify administrator about the changes a user has done!
Labels for X axis
I can't insert or define labels for X Axis which makes any chart look useless
We can not add . it only allows , how do we solve this?
Question is above. Valentin
Browser Tab View problem
Suppose I have opened different spreadsheets in tabs of a browser. When I have a look at these tabs, I see them all showing Zoho. Indeed they show the name of spreadsheet after Zoho, but when the number of Tabs is a lot,we can see only Zoho word. In Google Docs, I can see the name of every spreadsheets ,which is too convenient to locate when there are too many tabs open.
Leading Zero
Is there a way to format numbers as text? If we are entering UPC codes preceded with a 0, the zero is dropped. There doesn't appear to be an option to format numbers as text. eakaufman
Zohosheets functionality
Terrific application. Thank you. Works very well. My only suggestion might be that it would be nice if you could elect to have no grid lines, as Excel allows. ....But that is nit picking. Thanks again.
Share Invitiations Not Being Delivered
Hello - I have tried sharing documents with several different business colleagues - some with corporate firewalls, and some without. IN almost every case, they have had trouble receiving their share invitations. A few found them trapped in their spam filters (hoping you're working on whitelisting). But several others never received them at all. I then tested the sharing in Sheets in particular and found the same thing when sharing to other email addresses of mine. The delivery rate is less than 50%.
Cloud SQL external data "Problem in configuring WebData."
I have a Zoho Spreadsheet in which I have several external data links from Zoho Reports via Cloud SQL. After creating the shhet several weeks ago, the links pulled the data in flawlessly. Now they're all broken saying "Problem in configuring WebData." When absolutely nothing has changed.
How to save documents in Zoho?
How do I save a spreadsheet or document I've opened from an email in Zoho into Zoho Sheets or Documents? - D
Comments on web
Hi there, Why can't I add comments at the bottom of the sheet? it says comments, and when I click the link, it opens a comment site, and I can type comments, it does not show up. The link to my site is http://www.fsworld.co.za/index_files/logbooksample.htm Thanks Jakes
URGENTLY NEED TO EMBED IMAGES IN SHEET
Hello; It appears that images inserted into sheets just "float" on top of the sheet. If you resize the cells or sort the sheet the images don't move with the cells. We urgently need to be able to embed images into the sheet so that they will move with the cells. Can this be done? Thanks Gino
グループ招待時の入力を簡単にして下さい
グループ作成時、現在はメールアドレスをフルで人数分ペーストしなくてはなりません。 アカウント名での入力に対応をお願いします。 ドキュメントへの招待リストにある名前から直接グループに振り分けできるとなお良かと思います。
VBA zoho sheet ".Find" and "for each next"
2 sheets : first sheet got a list of names in column "a" second sheet got a list of more names with a value in cell B I need to bring back on the first sheet in regard of the matching name (if the name has been found) I got an error on the ".Find" if not, any idea to solve that issue ? thanks for help Sub getvalue() ' For Each cel In Sheets("Feuille1").Range("A1:A100") With Sheets("Feuille2").Range("A:A") Set trouve = .Find(cel.Value, LookIn:=xlValues, lookat:=xlWhole) If Not trouve Is
hücre koruma fonksiyonu
hücre koruma fonksiyonumu yok yoksa benmi göremedim (exel de)
hyperlinks
I cannot understand why it is not possible to select text and insert a link just as easy as one can do in any Office suite.
Problemas Guardar
Buen Día Tengo compartido un archivo de excel, el usuario tiene el permiso de Lectura/Escritura, puede ingresar datos en la celdas pero estos no quedan guardados, qué se debe de hacer para que los cambios sean actualizados correctamente? Saludos.
Help! Spreadsheet disappeared!
One of my spreadsheets—the important one, of course—has disappeared. It's not in the trash. Where could it have gone? How can I get it back? The title of the sheet is "Term 2".
Filtros
Cómo puedo ingresar un autofiltro para un determinada columna en Zoho Sheet?
How does a shared user save the spreadsheet?
How does a shared user save the spreadsheet? He was given read/write permissions. Is there a save button?
How to link to a document stored under documents.
I have a spreadsheet and need to be able to use a hyperlink or other method to link to a pdf document I have saved. I don't need to download the pdf just want to be able to click on the link and display it. Is this even possible at this time. Thanks.
Norwegian translation
Hello, I just completed (100%) the Norwegian translation of Zoho Sheet. I notice that most of the other products have not been translated, or not completed. For the translation of Zoho Sheet into Norwegian I used the very good module found here: https://translate.sheet.zoho.com/l10n.do 1. How can I translate other Zoho programmes (such as Mail, Writer etc.) with a similar tool? 2. As a Zoho Business user, is it possible to use the Norwegian version in Sheet, whilst using English for the other programmes
Stock function and cell formatting
Hello Forum, I am trying to fetch some stocks in a sheet. I use a brand new sheet, set an entire column to currency € and fill it with =STOCK("xxxx.xx"). At first it works great, all cells show the stock price correct in EURO. I can save the sheet and access it later without problems. However after a week or so the cells start to show garbage, it first looks like strange dates and when I try to set them back to Euro, they show astronomical numbers. If I delete the cells and re-enter the formulas,
Pivot Table - Sum of Time
I have a table w/ following structure; "Daily time log" Start | End | Category | Duration 10:00 11:00 Project 1 (end-start) = 1:00 11:00 12:00 Project 2 (end-start) = 1:00 13:00 14:00 Project 1 (end-start) = 1: 00 Now, when I attempt to create a pivot table, it was not possible to create "SUM" of duration. "category" as row - categorize "duration" as data - SUM of duration Zoho sheet identifies duration value as "text" hence "SUM" is not possible. what
Next Page