Spread Sheet
very gooooooooooooooooooooooooooooooooooooog i like iiiiiiiiiiiiiiiiiiiiitttttttttttttttttttttt
VB Time Outs
I run a particular VB macro every quarter to update a set of spreadsheets. The macro inserts and deletes a couple of columns, does some range copying and pasting, and updates some equations. It worked fine on many spreadsheets for a year or more, but now I'm getting script time-out errors. The only real difference is that my spreadsheets are somewhat larger (about 50 rows and 20 columns). The errors do not always occur at the same line in the code. In fact, every once in a while the script executes
[Bar Charts] X-Axis starting at 0
Good evening, It is my first day around here. I just migrated from Google Docs, because it lacked me some important functionalities. My question is if it is possible to edit this chart in order the X-Axis to start in 2250, instead of 0. This way it would be easier to analyse the bar globally and compare its values. Best regards, Pedro
Embed, allow usage and printing but NOT download of XLS
I want to embed a sheet in a web page and allow any visitors to fill in data and have the spreadsheet calculate the answers for the viewer and let them print the results but I do NOT want them to be able to download the XLS sheet and take my calculations and layouts with them. The embedding went ok, and the calculations were also ok, just do not want them to get the xls. Please point me to the correct research area.
My sheets
Can I possibly undo a change on one of 'my sheets' that another user I have shared it with has made? Also, if I share one of 'my sheets' with multiple users, can I see who made what changes? I want to be able to combat against the possibility of a user I am sharing a document with making accidental or incorrect changes and corrupting the data for all. Thank you.
对每一行设置权限
教育局准备对下面每一个学校10年来的数据作一个统计，每个学校每一年的数据报上来我再作汇总很麻烦，我想共享一个工作表，大家都在这个表里填，而每个学校只能填自己学校的数据对别的学校的不能修改，就需要对每一行设置一个权限，有没有这种功能？
Count all cells in a row with the word "Monday"
Hi, Question 1 I am creating a sheet and I need to count how many rows has a certain partial string match. I first tried to count all the rows with the word "Monday" by using this code: COUNTIF(A1:A100;"*Monday*") This displays 0 as a result, which is wrong. I then clicked on one of the date fields I want to sort and noticed that the underlying code for the date is different than the display in the cell. The cell displays: Monday, August 09, 2010 The underlying code displays: 08/09/2010 Is this
初次使用Zoho Sheet的感受
1、表格中用右键菜单粘帖不成功，但用ctrl+V可以 2、中文输入状态下，切换到其他application，再返回sheet，第一个输入字母是英文状态，之后才能够中文输入 3、是否可能发布文件给几个特定的人，让他们无需注册和登录而通过一个特定的链接查看文件，而不是公开发布。 4、没有找到帮助按钮
鼠标右键 点 复制 完后，要被 复制的 ...
鼠标右键 点 复制 完后，要被 复制的 东西被删除了
有编辑查找功能否？
咋找不到编辑查找替换功能？
Published sheet inside website results in #ref being desplayed
I have a control excel spreadsheet from which I then create a simplified version 98% with linked cells. IE file 2 is linked to file 1 inside my computer. I then upload file 2 to zohosheet and go to publish range. The resultant codes I paste into my website but the result shown inside the website becomes #ref in all the linked cells. The only cells to desplay is where I have used standard excel formulae with a link back to sheet 1 It matters not which version of excel I use the same problem occurs
Scrolling up and down in Zoho
How do I scroll down to view cells/rows that are below the initial spreadsheet view. The scroll bar that would normally be on the righthand side is grey and can't be used. Is there some way I activate it? I can't see any rows below 19...
PARABENS
Bom dia aos desevolvedores do ZOHIO. Realmente é um ferramenta ON LINE que funciona similarmente aos OFFICEs instalaods. Waldir Lins Jaboatão - PE / Brasil
impossible to freeze pane again
I did undo "freeze pane" to check if I would find a way to freeze a column together with a row. 1/ after that impossible to re-active it, either on a row or a column,on any tab of my spreadsheet. please help 2/ how do you freeze pane row + column combined together I posted a private feedback many days ago, with no answer, so i make it public now thanks Daniel
idiomas esta misturados
Os idiomas portugues Brazil e portugues Europa estao misturados. Há partes do menu em um idioma e partes em outro. Verifiquem.
can not open sheet file？
Popup a window : Error Occurred Problem while Opening the Document
Opera right-click menu not available
Version 10.10 Build 4742 Platform Linux System i686, 2.6.30.5 Qt library 4.5.1 Java Java Runtime Environment installed I can't access the right-click menu in sheet, just gives me the Opera default menu. This was noted as a fixed bug in May 2009 but for me it's still an issue. Any ideas?
Zoho Sheet Functions
Maybe its a dumb idea to ask but is it possible to get a list of all the functions available at present in Zoho Sheet? Thanks to all who can help here.
zoho sheets
i am looking for a way to set up a lead tracking sheet, were i can enter all information onto a master sheet. i have 4 reps that woulkd need to updtae thier sheets. my problen is setting up the sheet so i can have each rep log in with a password and only see thier leads.
Probleme mit einer Hochgeladenen Excel Tabelle
hallo zusammen, ich hätte da bezüglich Zoho einige fragen... 1.) Ich würde gerne eine vorhandene excel Tabelle hochladen, die mit Mini-Bildern in einer Spalte (A) eingefügt wurde. Allerdings wenn ich diese vorhandene Excel-Liste hochlade, sind die Bilder nicht mehr in der dazu gehörigen zeile. Die Bilder verschieben sich sozu sagen nach lust und laune, weiter nach unten, und ich müsste theoretisch gesehen alle bilder manuell in die dazugehörige Zeilen neu verschieben. 2.) Ich habe in meiner vorhandenen
Date Auto-Formating
Hi, i'm new to zoho sheet, ive noticed that when i paste something like 18/06 - 10:00 it auto-formats accordingly to the option selected in date/hour tool. But i'd like not to have any formatting, i want to keep it 18/06 - 10:00 but sheet automatically changes it once pasted. Is there anyway to disable this feature ? If not, can you add a date and time format that is "18/06 - 10:00" ?
list of keyboard shortcuts?
Where do I find a list of keyboard shortcuts for Sheet? I want to know how to do things such as formatting of text inside a cell (e.g. I stumbled across Alt + Enter to force a line break). I can't find any specific "how to's" in the "Help" area.
Auto-refresh?
Hi there! First of all, thanks for these wonderful applications! I'd like to know if there is an option to refresh my sheet every xx seconds? When we are several to work on the same sheet on different computers, it would be very useful if the sheet refresh by itself instead of loading it again... Thanks!
Can't Share a Sheet
I am not able to share a sheet I have created in Zoho. When I attempt to share it when the person hits the link all they get is a partially loaded page that doesn't even let them read. Also when the user signs up it is not in their Shared With Me list. I have tried this with two users.... Note: This is pretty urgent
Public Text Frame
Can I put a frame on my public Zoho worksheet, that public or registered users can post comments ?
Internet Explorer muestra comprimida la Hoja de cálculo
He insertado el "iframe" de una hoja de cálculo en mi web (www.planfinan.com -- Introducción, Plan Financiero, Modelo), pero IE lo muestra comprimido, no ocurre así con Chrome, Safari o Firefox. ¿Alguien sabe porqué?
VBA Macro writing
I have a spreadsheet made that is a schedule and I need to stop people from signing up for multiple jobs at the same time... any ideas?
PROBLEMAS CON EL NAVEGADOR
Tengo errores cuando abro mis hojas con internet explorer, pero funcionan correctamente con Firefox. He detectado errores en estas hojas: http://public.sheet.zoho.com/public/tonimoreno/triangulos-rectangulos http://public.sheet.zoho.com/public/tonimoreno/cubicaje-y-peso Ambas funcionan correctamente en Firefox y en mi ordenador con OpenOffice, ¿alguien me puede decir donde está el problema? Gracias por vuestra atención
creating a lead tracking sheet
i am trying to create a sheet where there is a master sheet and it has 5 sales reps on it. after i input the information on to the master sheet i want my reps to have access to only tier leads. can this be done. i can assign email address or password for each rep to open their leads only.
CSS for Sheet?
I was wondering if it is possible to modify the CSS of an embedded Zoho Sheet? My website has a black background making the sheet title unreadable. And I currently have all my cells with a black background with white text, but the hyperlinks remain dark blue and almost unreadable. I've included an example with a darker background so you can see what I am describing. Thank you for a wonderful product!
Addition/Functions Won't Work
I'm running a test amongst 24 of my partners sharing one spreadsheet on several different web pages. We select "click to edit" and try testing the functions (basic addition), and about half of my partners are experiencing no addition within the cells. In other words, they could enter data all over the table and the "sum cells" are only showing the value for the last data entered into an individual cell. For the other half of my partners, things work just fine. Here's a link to one: http://www.bayoubucks.com/forum/showthread.php?t=8843
Unable to import spreadsheet saved in MS office 2010 beta
Hi there, I couldn't import some spreadsheets saved with MS office 2010 beta. (even .xls or .xlsx) but can with other versions. Also while importing sheets with VBA module compiled in Ver. 2010 the macros doesnt show up in the imported file. I have filed a feedback regarding this and i have got a (quick) response stating a "some parsing error while importing the file" for the file import problem. Awaiting Zoho sheets to support docs/sheets saved in MS Office 2010 beta soon since the MS office 2010
Offer templates
Zoho Writer has many helpful templates that can become modified for my use. I would like to find templates for Zoho Sheet too. It would help me and other recognize the many possibilities with this service. Some Zoho employees could study the templates offered by Microsoft and Google sheet to onte what are most popular and then adapt them for this setting.
Problem with Zoho spreadsheet
There is a problem regarding the alignment of the spreadsheet's rows. They become increasingly disparative as you go further down the document
Search an entire workbook?
How can I do a search across multiple sheets in a workbook? I was looking for an "Entire Workbook" option under the "Find" function, but the only options I see are "Current Sheet," "This Column," and "This Row." Is there any way to do a cross-sheet search? Thanks for any help.
Controlling acces to shared document
Hi, I am new in Zoho. It's first online web app for documents that I really like, but I have the problem: I am sharing one Sheet with one person, I've added her e-mail as read only, but the link which this person received is... public. Anyone who gots this link has access to read my Sheet. How to secure my Sheet for password protected access? Or only for Google account login: for me ( I am accessing Zoho from my Google Account and this second person should use her own login information to have access
Colaboración
Es dificil entender como compartir un documento con laguien, por ejemplo, si está en Mis Plantillas, no se puede compartir con un amigo, hasta que lo pase a Mis Hojas, no es intuitivo. Tambien esta muy oculto el chat y le hace falta un icono de ayuda en la barra de menus. Por lo demás EXCELENTE! Gracias
Freeze Panes
Hi, I am not bale to Frees more than 1 line. I want to freeze formatted lines the Freeze option is available only for 1 time then I get the UnFreeze as an option in the More Action drop down tab
Zoho Public Sheet Suggestions
I just observed from the public sheet https://www.zoho.com/zoho_faq.html that as per one of my previous bug report, this has been changed and corrected. Now I see an explicit button called 'Click to edit', 'Save to Excel' and 'Full Screen'. I have a few suggestions. (1) Once I use 'Click to Edit' it is disabled. Instead of disabling how about toggling it as 'Stop Edits' so that it would be like a on/off binary state switch. (2) Along with 'Save To Excel' can you get me an option like 'Save to Zoho
How Zoho Sheet import to update the existing sheet
Did Zoho able to import file to update the existing sheet? We see google docs able to upload the local file to update the existing spread sheet but we did not see on the ZOHO sheet...
Next Page