Collabedit does not refresh when typing is done
Hi, I was recently interviewing the candidate & there was coding question using collabedit. The problem that we faced was collabedit did not refresh when candidate was typing the code. I have seen this problem multiple times with different candidates now it keeps happening on day to day basis. In-order to resolve this issue, candidate has copy his content from collabedit , refresh the page and paste the content. after that I can see what candidate is typing. once candidate stops typing for some time
Is there a collaborative-editing feature in sheet?
Hi, Testing out Zoho for potential use by my company (instead of say google docs). One must-have feature is collaborative editing, where two or more people are "in" the spreadsheet and making changes to it at the same time. One forum post I read implies that this is supposed to work, but I just tested it. - Neither of us could see edits being made by the other - Both of us saving a modified sheet ended up with the last one saved "winning", losing the others changes So, is this supposed to work? If
Pick from drop down list
I want to format cells to be able to "pick from a drop down list." I don't see this function??? TK
Errors using If then Statements in a Macro
I have created a macro that uses If then Statements. About half of the If then Statements work fine but, the other half, when the statement is true give me an Application Defined Error. No error if the result is False. Below is an example of one If then statement that works and one that doesn't work. I've named the Cells on the worksheet but even if I use the cell reference (A1), I still get the error message. If I put the "IncludeTuition" instead of the "IncludeBookFee", then the If statement
Set Colour of a cell if amount is negative.
Dear All Is it possible to automatically set a cell to change colour if it is negative? I had a look at the functions and it seems you can get the colour using cell() command but I did not see any mention of changing the cell colour. Thanks Colin
Zoho Sheet computation bug
This is my 1st use of this forum. Forgive (& correct) me if I'm not on protocol or if there is an existing forum on this. Zoho sheet had a bug years ago that I brought to the attention of Zoho at the time. I'm super impressed with the new sheet and writer applications and am using them as default. However the same bug still remains and that bugs me. As an example, put into cell A1 the number 0.05 and into A2 the formula A1*2 then drag A2 down to A31 Below is the result, with the SUM of the numbers
Reverting back to an older version of Zoho Sheet
Hi Is it possible for me to open worksheets in older versions of Zoho Sheet? The reason I ask is because earlier this year I spent a lot of time putting together a VBA macro which, after recent updates, no longer works. I've spent hours trying to fix it to no success, and to me it appears that the more recent versions are much slower and more prone to errors, which is unfortunate because I had enjoyed using Zoho up to that point, and it is the only online office application I know of which supports
VBA Conditional Query
Hi, could someone here please help with the following dilemma i'm having? I have zero skill with code but after reading a few posts here, ive pieced together the following VBA code to 'almost' achieve what i want. Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = false On Error Goto ENEV If Target.Column = 10 Then ' 10 means Column J If Target.value<0 then Target.Interior.Color = RGB(255,0,0) 'Red fill colour ElseIf Target.value>0 then Target.Interior.Color
copy/pasting formular
I'm having a problem copy pasting this formula (Q2:AA2 on the DATA sheet) IF(ISERROR(FIND(NAVN;C1;P2+LEN(NAVN)));"";FIND(NAVN;C1;P2+LEN(NAVN))) (cell Q2) IF(ISERROR(FIND(NAVN;C2;P3+LEN(NAVN)));"";FIND(NAVN;C1;P3+LEN(NAVN))) ( cell Q3) somehow the reference to C1 will not be changed to C2 if there is no error (and why isn't there an IFERROR command?)
How do I change the border colours in zoho sheet
Hello, plesae advise how do i change the colors of the borders in zoho sheet?
unmerge or split cells?
here it is July 2013 and like people over the past years I can't get merged cells to unmerge or split. No reaction on the split cell command. Removing formatting still does not do it. Once a cell is merged it seems stuck. Any workaround even? Thanks, Greg
Sharing individual sheets to different people?
Could you tell me please when you will bring the individual sheet sharing functionality back? Also when the email notification on modification will be restored?
Zoho Sheets is slow to load. Please enable caching.
Hi Zoho team, I was working on Zoho Sheets for the first time as an experiment to see how things on the web work. While comparing Google Sheets and Zoho Sheets, I enjoyed the features Zoho sheets provides. But one big annoyance prevents me from using it full time. There is no caching. I switched between sheets on the bottom, going back and forth between 7-8 sheets, and each time, the sheet was loading from fresh. I even tried to navigate within the sheet (of 200 rows) and even then some rows
Spreadsheet does not load
Hi, I am very happy since I use Zoho Sheet. But since the last upgade, I can not anymore load one of my speadsheet. Either it takes a very very long time to load, or I recieve a message "servor error". The spreadsheet address is: https://docs.zoho.com/sheet/ropen.do?rid=hd3vbce764cabc69f4254840477a7af1e87f5# Could you help me? Thank you Thierry
Sou Brasileiro
Uso o Zoho Sheet, agrade�o a vers�o em Portugu�s, mas para que possa utilizar mais satisfat�riamente o produto, preciso do s�lbolo do Real, a moeda do meu pa�s (Brasil) R$ Agrade�o
*HELP* Spreadsheet to Message body for e-mail
I'm using this website to make a spreadsheet for a registration form for a part that has to be a table, show total amounts, etc. When the customer clicks the Send button when they are done filling out all field on spreadsheet and non-spreadsheet all that shows up in the e-mail is everything but the spreadsheet. What is the code I have to use for the table to be able to put it in the message body for the e-mail? For the fields that I don't use from this spreadsheet use the codes, First Name: [your-name1]
Embedding sheet in applet
Hi, Can zoho sheet embed in applet? Regards, Praveen
Horizontal alignment
No matter how many times I direct the horizontal alignment to align on left it keeps reverting to align to right side. Whenever I put a new spreadsheet entry this happens. I then (Ctrl-A) select all, go to format and select horizontal alignment to left and that fixes it; temporarily.
Drawing in Zoho sheets
I need to create a project netwrok. I have the boxes set and need to draw arrows to show the project flow and preceding activities. How do i do this in Zoho sheets
Can we protect a spreadsheet from downloading.
I like this application.. but overall i want additionally like.. if i have restricted a spreadsheet with user group and their role like read only or read / write only.. But still user can download the file.. is there a way to password protect is so if i want then only user can download or something like a option to disable download feature for selected account. please reply urgently.
Is it possible to change the cell sizes for the entire sheet?
Is it possible to change the cell sizes for the entire sheet? Thanks
How to stop export of spreadsheet
Hi, How can I restrict an xls sheet so that a person sharing is not able to export, or copy and paste the data?
Notify Shared Users ZohoSheet
Did you remove the option to notify shared users in ZohoSheets? I have a shared user and I used to be able to send a notify email with a link to the sheet when I made changes. That no longer seems to be on the shared menu or am I just missing it? Thx. -Rich
Excel Workbook Issue.
Bonjour, My Excel workbook (2.5 MB with few rows) once successfully uploaded and imported into Zoho (according to the message provided by Zoho) does not show into Zoho Sheet. It only says: The preview of this spreadsheet is being generated. It will be available after few minutes. If you like to download this spreadsheet, Please click here to... The only option I have is to download the file and edit it in my local Excel application. What should I do to make it work? Thanks. PM
can column width or row height be changed?
may i know if column width or row height can be changed? thanks mamaboy
sheet
I cannot figure out how to (I do not know your terms) 'fill the gap', 'delete a line', 'merge cells'...etc... on a spreadsheet. I created a spreadsheet with 143 line items, deleted 4 lines, but cannot ' fill the gap' on the sheet. Pease help. Thanks
DATE FORMAT
Please advise. Trying to create a spreadsheet where one column contains date in dd/MM/yy format and another contains the time in HH:MM format. My first problem is that when I enter any date, other than one in the current month, the format changes to mm/dd/yy or MMM dd,yy. I suspect it's something to do with the MM rather than mm? Why is the mm option not available anyway? Also want to sort sheet on date first and then time so rows are displayed in date and time order. The sort option only appears
Paste Values
I am trying to figure out how to paste a column of numbers as values. Has anyone figured it out?
How do i copy cell's value not formula
Dear Zoho Sheet Team, Is it possible to copy value from cell, not the formula? For example, a have a cell with a formula like =A1*1.18 and would like to copy the result to another cell? Can't see that function. Thank you.
connection to server has been lost
Now able to get into zoho but still getting the message that the connection to the server lost and to open the file again, do so same message. This happens every time I try to load the sheet. Have logged on using the same computer and a different persons login, this works fine (opens in a new window) Have tried as myself on different computers, connection lost retry message. (reloads on the same page) As the author of the sheet I would like to be able to get access as myself and not have to use
Page header and foot note
Hi there, Just started using Zoho sheet after many years of Excel. I cannot find the function of adding a header or foot not in a sheet. I cannot find the Page set up funtion either, e.g. adjust sheet margins etc. Can someone help?? Best regards KOD
Numbering
Hi! I would like to know how to add a column with an automatic numbering system, numbering our clients. At the moment if I look at my spreadsheet it's just a long list of names and information. By numbering each client, the list will be more structured and easy to work with. Please help? Kind regards, Ninke
Can someone help with this Martlett code?
In Excel, this code works, but in Zoho, nothing happens when cells A3 through A100 is clicked. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Not Intersect(Target, Range("A3:A100")) Is Nothing Then Target.Font.Name = "Marlett" If Target = vbNullString Then Target = "a" Else Target = vbNullString End If End If End SubWhat it
How to save Zoho Sheet online?
What happened to the save function in order to save Zoho sheets? Up until the end of last month (April 2013), I have been updating our Zoho sheet .xls file wiithout problem, but now cannot do it. Why is this? I don't want to 'Save As' a document or template, just save it like I could before, so that each time I sign in to Collaboration APP Docs it is there each time. How can I now do this? If this function has been deliberately removed, could I ask why this is?
signing out of spreadsheet
Hi Can you tell me why this message keeps appearing when I try to use the sign out at the top right corner with the spreadsheet open. The page you requested was not found Sorry about that! The page you were looking for may have been moved or the address misspelled. 1. It is possible that you typed the address incorrectly. 2. The page or file you are looking for has been moved or does not exist Surely the sign out is a link within zoho spreadsheets, so it has to be something that is wrong at your
How to limit a data feed (external data) to 100 rows
I have a URL to a website that provides lottery results going back many years. It is updated twice a week. I only need to review in my Zoho sheet the most recent 100 rows. Is there a way to use the external link process to limit the feed to just 100 rows? Here is the URL (for reference). Thanx. http://portalseven.com/lottery/megamillions_winning_numbers.jsp
Hide and lock formula cells doesn't seem to work
It has been a while since I have used Zoho, but I remember using the hide and lock formula cells in the past to protect cells in a document that I published. Now when I try to use that option, it does not seem to work. I can change/delete the cell contents in cells containing formulas. This used to be my workaround for not being able to protect cells. I'm pretty sure that I'm not missing anything on how to activate the option to hide and lock formula cells. I just go to Publish and click on the
Charts are not showing in HTML view
Hi, Maybe I have not used the search function good enough, but I couln't find a topic concerning my issue. The problem I'm facing at the moment, using the Zoho Sheet trial, is that when I publish my workbook in HTML view, the charts that I have created within Zoho do not show. Whilst in editing mode I can see the charts correctly, in HTML view the charts are replaced by an image not found logo. Did I do something wrong or is this a known bug?
Spreadsheed edited by someone with "remoteapi" but not by me
Hello, i got constant problem with my spreadsheet - someone is editing it but i don't know how it is possible. But from start: I created Calculator with spreadsheet: https://docs.zoho.com/sheet/published.do?rid=hym92cbe12f0b69f44f62a5d3624d15407c30 Before Zoho 3.0 all was fine. No one could edit it when shared that link (it was: https://public.sheet.zoho.com/public/kicksaw/pokelifecalc-1, instead of that above). Now after this patch i found that someone constantly edit that calc and i need to make
Auto save not saving
Hi, I thought I was going to like the new auto save instead of manually saving every time, but now not so much. Everything I updated in my spreadsheet the other day is now back to the way it was before I updated it. Even worse is all the NEW data I entered is MISSINGfrom the 9th of April through to the 26th. Just vanished! :( Auto save "saved" it every time, so I can't imagine what happened? Do we still need to "save" manually again before closing the page when we are done using it? I am very
Next Page