Error Messages/Data Loss
Hi there, We use zSheet in work to share between 4/5 people on a daily basis and are experiencing some very annoying problems. On an almost hourly basis, we all seem to get the following error message: 'The document has encountered a problem.....this document was last saved....we recommend you copy and paste the data..' We also lose data we've entered when we log out and log back in which takes time to put back in and is really inefficient. Lastly whenever two people are typing on it at the
Remaining Problems
Dear Zoho Sheet Team I wish to list remaining items which I am interested in and would be pleased to know whether these functions are now supported? 1 I wish to group / ungroup rows 2 Can images be inserted into cells? 3 Can buttons be inserted into cells? 4 Can cells be merged vertically? 5 Can text be rotated 90 degrees? I look forward very much to your reply, many thanks Kind regards Hans
Insert Row Above function messes up other cell data
"Insert Row" function shifts or deletes data in other cells! It's so maddening, I cannot use zoho if this isn't resolved. I've tried Firefox 3 & IE 7 on a Windows machine, also tried FF on a Mac, same problem...
zoho sheet copying column 1 into all colums
when opened this morning I found that the spread sheet had copied column 1 across into into all columns. I have several copies of the same spread sheet, with minor variation. I have to go back about 5 copies to have it as it should be. How do I correct this?
Split the function
i have this function: Sub STOCHRUN() Range("NOW").Select Selection.Copy Range("START").Select ActiveSheet.Paste Sheets("Summary").Select Columns("H:IV").Select Selection.EntireColumn.Delete Range("A1").Select Range("WPSW").Select ActiveCell.value = 1 ' Dim NSR As Integer Dim N1 As Integer Dim N2 As Integer NSR = 3 N1 = NSR + 1 N2 = NSR + 2 ' ' INSERT THESE TO AVE AND STDEV RESPECTIVELY For I = 1 To NSR Call APSMRUN
HELP PLEASE - 'Error Occurred. Problem while Opening the Document.'
Please help. I have been trying to get in touch with someone in support or sales for the last week and no one has gotten back to me. We are considering using Zoho for all of our business applications, but if we can't get past basic problems, I am concerned we won't be able to integrate Zoho into our system. The problem: I have several sheets shared with around 5-10 team members. Often, they report a problem when opening the shared sheet with them. A small rectangle box appears on screen that says
Spreadsheet add row bug
steps to reproduce: 1: click on row with right button 2: Insert row above 3: type something. The text you enter is posted in another cell instead of the new cell created. Thanks.
Server Outage?
Since late hours of yesterday till now none of the sheets are opening up and new sheets could be created. It just throws an error 'Server encountered error' and asking to open the sheet again. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Suggestion for Zoho Sheet
first of all, this software is awesome! but i'd like to suggest two things that i use a lot in Microsoft Excel and is not available up here... One of them, is the ability to copy the cell above. In Excel, the command is Ctrl-D , and for me it's extremely useful. is there any shortcut like that in zoho? Another one, is, when selecting multiple cells, it shows the sum, average and count and here shows only the sum. And also, in excel i can select multiple cells using the "Ctrl" key, and this is not
Changing owner of Zoho sheet
Can the owner of a particular Zoho sheet be changed?
different options
Is there a way to include drop down options, filtering, locking cells and creating a button to run different macro's?
capabilities of Zoho Sheets
Can someone let me know if the following functions are available with Zoho sheets: Drop down options filtering locking cells creating buttons to run macro's subtotaling (example =subtotal(9,D2:D200)
Sugerencias
Añadir: Capacidad para mostrar/ocultar filas y columnas Capacidad para mostrar/ocultar la división de las celdas Capacidad para formatos condicionales Saludos.
Timeout Error during GetResponse method
We are using the Zoho API to edit documents with our web application. One of our users has been using the zoho interface on our web site to edit their excel document. Till recently they were able to edit the document “AR WRS Inventory Control Reports Draft II.xlsx” (tried to attach, but, getting blank error while attaching). Then they made some changes to it “AR WRS Inventory Control Reports Draft III.xlsx” (tried to attach, but, getting blank error while attaching), and the document cannot be
problem with https url parameter while opening csv document
I get following error when opening a csv document from this url: https://ms.filestoragecenter.com/20111010/TMPFADEMO0.1818070.6295540.630477/38223.csv if I change the url to be http (http://ms.filestoragecenter.com/20111010/TMPFADEMO0.1818070.6295540.630477/38223.csv), then it works. more info: another https url (https://filestoragecenter.com/facorp50/infopages/38223.csv) works! https://filestoragecenter.com has a GoDaddy certificate. https://ms.filestoragecenter.com has a SecureTrust certificate.
i am not able to rename excel sheet
I am getting rename option but it is not changing the name.
Remove one sheet from a spreadsheet
I do not see how to delete one entire page (for example sheet2 and sheet3) from a new spreadsheet. Is is easy to "add a sheet", but how to delete one??
can't see tabs in embedded spreadsheet
I just got a new PC, and now can't see the tabs on the embedded spreadsheet. Everyone else can, so the problem lies with Explorer I think. Any ideas?
Macro's
How can I create a icon to run a macro, so I don't have to click the Macro's button, then click "run macros"?
Does VBA code work in Zoho Sheets?
I'm new to Zoho Sheets and would love to be able to share my spreadsheet with the following code. It works perfectly in Excel (adds a timestamp to each row when the row is updated), but doesn't seem to work in Zoho. Can you give me some assistance into what I might be doing wrong? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$C$3" And Target Range("A1") = Date End If End Sub Thanks, Jenny
Filter
sheet 可以有 filter 功能嗎? 例如我有 1000 列資料, 但我只想看裡面有 bracelet 的.
Merging
Hello, Currently we are able to merge cells "across" but not able to merge cells "up & down". Can you see this as being a feature in the near future? Cheers, Paul.
where are add, subtract, multiply, divide ACTIONS
Does the sheet have the excel style actions to add, subtract etc , justing using the mouse there is the sum ACTION , but other mouse only actions would be useful frankfx23
When can we insert a checkbox in zoho sheets?
When can we insert a checkbox in zoho sheets? Now it it not possible. I had request this a while ago, they told me, this request is noticed in the roadmap. Do you have any idea when we can may this feature expected? Thank you for your response.
Help with Graphs
Hi, I have 2 columns, one date and the other Number for each date. Now, I want to create a Graph, that shows the trend over the period of time and grouped by month. I think the Area chart would work with each area representing one month. But am unable to make it work. Please let me know how to create this. Thanks, Lepide.
Call Data From Another Spreadsheet
How do I call data from a certain cell in another spreadsheet on zoho?
Unable to freeze
Hi, I am unable to freeze more than one row in Chrome. Is this available or Chrome not compatible? Thanks, Lepide.
External data link overwrites formulas
I have data being imported from a google spreadsheet. When it is imported into zoho, either manually or auto refresh it inserts a blank cell where i had a formula. A very very simple example of what i mean would be: Data is being received into column A. Then column B uses a formula to show same info. A B 1 test test (formula would be ... =a1 2 test2 test2 (formula would be ... =a2 When data is updated from external sheet,
Selection.copy
If i use this. Will it copy the value in the range/cell or it will copy the formula within that cell/range?
Application Defined error:
What does this error mean? Here's the code where i got that error. (the one in bold was the line where the error registered.) This code is originally written in excel and migrated it to zoho's version. Also attached in this post is the original excel vba macro. Here's the link http://sheet.zoho.com/public/uplbapsim/sept20 Zoho Sub APSMRUN() STOCHSW = Application.Range("WPSW") 'Value of stochastic switch If STOCHSW = 1 Then Goto JUMP1 Range("NOW").Select Selection.Copy Range("START").Select
Locking Cells
Has ZOHO implemented a way to lock cells yet? I don't mean freeze pane. I need to lock cells so that only certain cells on a shared sheet can be edited.
Stock Function Cell Reference
Trying to use stock function to reference ticker symbol in another cell. Is this or will this be available in ZOHO Sheets? ex =Stock(A1,"Price")
reference in stock function
Hi, I am trying to use the function "stock". it takes 2 arguments. it works ok when i hard code these 2 arguments like =STOCK("MSFT"; "PRICE") but when i do cell reference, it doesn't work =STOCK(A2;B1); my cells looks like this symbol price MSFT =STOCK(A2;B1) is the syntax wrong or is it not supported? any other work around? thanks Sasi
Lots of #CIRCULARREF inside document
Dear Zoho Sheet Team, I've imported a document, have been working with it and found it contains lots of #CIRCULARREF error in different rows. See the screenshot. As you might see there is no any circular reference. If i enter that cell and press Enter this error is gone. How can i do this for the whole document? And what was the cause of that error? P.S. During work with document i saw regular error with your server. Zoho SHeet asked me to save the data and reload the document. What's happenning?
Copy between sheets fails to copy images
Dear zSheet Team, One of my Zoho Workbooks has four sheets in it. I copied five rows from Sheet2 to Sheet 4. It was able to paste properly the textual content of the rows. One of the rows had an embedded image. The image failed to make its way through to the destination. Please fix the bug asap. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Chart
I made a chart. the data on the chart came from e.g. sheet2 and the charts are on sheet3 so i copied the data on sheet3 from sheet to and the graph was generated. but when i changed the data in sheet2 the graphs were gone :( Zoho doesnt support dynamic graph? a graph that changes value when the cells' values change?
破烂！！
只不过添加一行数据合计一下就什么技术问题，数据都保留不下来，真是烂！
Can you specify the sheet name also in the message?
Dear zSheet Team, When I delete a sheet you are responding with a message as below: " The selected sheet will be deleted permanently. To delete the selected sheet, click OK. To cancel the deletion, click Cancel." I would appreciate if you could mention the sheet name also in the sentence and rephrase the message as below: "The selected sheet (Sheet 2) will be deleted permanently. To proceed with the deletion click OK. To cancel the deletion, click Cancel". Wouldn't this be more friendly? ---- Deepak
Incorrect import of spreadsheets with external links
Dear Zoho Sheet Team, I've just imported a spreadsheet with some sheets inside it, where cells have links to other sheets like: =IF(ISNA(VLOOKUP(RC[-4],Changes!R6C[-4]:R3805C[-2],1,0)),"","EXCLUSIVE") After import these cells don't refer to those cells, but have non-calculated formulas with that text: =IF(ISNA(VLOOKUP(RC[-4],Changes!R6C[-4]:R3805C[-2],1,0)),"","EXCLUSIVE") If i press F2 on the particular cell and then press Enter, cell's formula has been changed to =IF(ISNA(VLOOKUP(RC[-4];Changes.R6C[-4]:R3805C[-2];1;0));"";"EXCLUSIVE")
Copying to clipboard copies only 40 rows!
Dear Zoho Sheet Team, I've just got a claim from my user, she has just started using Zoho and got a big problem: when she selects, for example, 3 columns and press Ctrl-C, Zoho Sheet ALWAYS copies first 40 rows to the clipboard in that case. I've checked this and can confirm: it's impossible to copy column from Zoho to OpenOffice or Thunderbird, for example. Sometimes it copies 40 rows, sometimes 56 and so on. No logic at all. Could you please explain how to copy data? We can't download huge files
Next Page