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
from excel to zoho.
I migrated an excel file (attached) to zoho: https://public.sheet.zoho.com/public/uplbapsim/papsim-dec2009-a001-3 but if seems like it is not displaying the right values after the execution of the APSMRUN function. Need help for my last requirement to finish college. Thank you. Can't attach it here. because it's 5mb zoho limits upload to 1mb only
"Set as number" button missing
Hi All, I am using a sheet which contains several data types (dates, texts, numbers). The problem is that sometimes Zoho sheet thinks that the decimal number I entered (like "0.9") is a date and converts it to a date. Other numbers behave OK. I need a way to say to Zoho "hey, this is a number. It is not a date, it is not a text, a number!". How can I do that? Thank you, Michal
Function seems not working.
Is there an incompatible VBA Macro here to the ones zoho can read? Thanks Sub APSMRUN() STOCHSW = Application.Range("WPSW") 'Value of stochastic switch If STOCHSW = 1 THEN Select JUMP1 Range("NOW").Select Selection.Copy Range("START").Select ActiveSheet.Paste JUMP1: Call ADELEFIN Calculate Range("WPST").Select Selection.Copy Range("WPST1").Select ActiveSheet.Paste Dim NCYCLES As Integer Dim TMAX As Integer Dim NCROPS As Integer Dim NLIVST As Integer
Unknown error
Sub STOCHRUN() ' ' STOCHRUN Macro ' Macro recorded 5/4/2001 by Tirso B. Paris ' Revisions 6/3/2005 ' ' Keyboard Shortcut: Ctrl+s ' ' Record Starting Time 'Application.Goto Reference:="NOW" Range("NOW").Select Selection.Copy 'Application.Goto Reference:="START" Range("START").Select 'Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ ' :=False, Transpose:=False ActiveSheet.Paste Sheets("Summary").Select Columns("H:IV").Select
Is this possible?
Sub PgUp() ' ' PgUp Macro ActiveWindow.LargeScroll Down:=-1 End Sub Sub DoublePgDn() ' ' DoublePgDn Macro ActiveWindow.LargeScroll Down:=2 End Sub Sub DoublePgUp() ' ' DoublePgUp Macro ActiveWindow.LargeScroll Down:=-2 End Sub
Functions
Whats the difference between Call and Calculate? thank you.
在线表格过大，如何进行关键字搜索？
加载上，但是搜索不到！
Minus Symbol in Front of Numbers
I have a ZohoSheet for monthly child support where I just copy the previous month's data to create the new month's data. However, when I insert a row, and copy data from another row, and then change (e.g., change the $25 t0 $50), Zoho always puts a minus symbol in front of the number, so that it looks like this: -$50.00 However, it doesn't seem to act as a negative and I cannot figure out how to get rid of it. The only thing that works is to copy a row without the negative symbol into the misbehaving
Operation Timeout
Is there a way to access the server time of sheet.zoho? I've been told that zoho supports up to 100 secs before the server's operation times out. I need to make this time longer because i believe that this time is not enough to run at most 50 iterations of a very long linear equation. Is this possible in zoho? Thank you. \ I really need help here. This is the only program that hinders my graduation. Thank you very much :)
new Type mismatch error
I've been using this macro successfully for some time and when I ran it today it suddenly gives a type mismatch error on line 8. Sub Randomcise2() Dim i as Integer Dim numSheets as Integer Dim thisRandom as Integer numSheets = ActiveWorkbook.Worksheets.Count Randomize For i = 5 To numSheets thisRandom = WorksheetFunction.RandBetween(5, numSheets) Worksheets(5).Move Before:=ThisWorkbook.Sheets(thisRandom) Next i
Transfer Ownership of a Document to Another User
I have a ZOHO sheet that I created that I would like another user to take ownership of. Is there some easy way to do this without having the other user create it from scratch? Thank you!
Find and Replace in Sheet?
Is this supported and I'm just missing it?
Email address
My email address has changed and it is now vengsiva@gmail..com.How to change it?
Hyperlinks in Zoho Sheet
What is the method (if any) to embed hyperlinks into a spreadsheet?
copier/coller
bonjour pourquoi ne peut on pas copier/coller des données extern merci
Sheet Setup for ReadOnly Access for a User Still Allows Access to Run a Macro (via Button Click)
I have a multi-sheet document that i have setup for multiple users. When a tab is setup as read-only for a user they cannot edit the sheet contents as expected; however they still have access to invoke macros via a button on that sheet. In my case the button/macro performs updates that i would not like the user to be able to invoke. Is there anyway to prohibit users from invoking a macro/button on a tab if they have read-only access to that tab? I don't want to hide the tab since doing so will
=STYLE()
I would like to set the text color of a cell based on a value. After stumbling through the functions list, it appears that the STYLE() function is the one to use. However, the documentation for the functions may be technically correct but is absolutely useless. Put some example usages in the documentation... but I digress. Searching the web revealed some examples but none of them seem to work in Zoho Sheet. Could someone please give me an example of setting the text color of a cell based on
Operation Timeout
When will this occur in zoho sheets? Thank you.
Next Page