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.
Just wondering if Zoho can support upto 50+ iteration of a very long linear program
I am migrating this XLS file to a webapp. The original xls document has macros that compute for a 25-50 year of projection hence involves a very long linear program with atmost 50 iteration. I was just wondering it the computation time of this would cost an operation timeout in zoho. I get an average 5min simulation run using excel. Would 5 minutes or more cause an error timeout for zoho? Thank you.
Help? Macro Error
I receive an error here : Invalid class for field get: The line with the * is the line that caused that error. Thanks for the help. Sub IALLOC() ' ' IALLOC Macro ' Macro recorded 24/06/2004 by Tirso Paris ' ' Dim II As Integer Dim IB As Integer 'Sheets("Irrig").Select Range("Irrig").Select Range("A107:F119").Select Selection.ClearContents For II = 0 To 8 'Application.Goto Reference:="IIndex" Range("IIndex").Select ActiveCell = II Range("A106:F106").Select
How do you copy and paste between two Zoho Workbooks?
Dear zSheet Team, I need to copy a sheet from one Zoho Workbook to another Zoho Workbook. Is this possible? Because when I copy one and open another the Zoho Clipboard seems to become empty. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Insert a picture into Sheet
The choices for inserting an image into a spreadsheet are restricted to Local (i.e. my desktop) or url. What I would like is to insert an image stored in my ZOHO image folder. Is this possible through the url option? Thanks, johnzpig
有关zoho的技术问题
您好， 我和我的同学正在使用zoho共享一个文档，期间有同学反应之前输入zoho sheet 的内容会消失，请问这个问题怎么解决呢？ 谢谢！
Pivot Tabl Output
I want to be able to either print copy or export pivot table output so that I can produce a printed report from it but I cannot find any way to do it. All the export options and the print button pop up a message saying "not supported for Pivot Table/Chart." Can someone please help. Peter Wills
How to correctly translate this?
Sheets("Options").Select Application.Goto Reference:="R50C1" Application.Goto Reference:="R2C1" I translated it thru this: Sheets("Options").Select Range("R50").Select Range("C1").Select Range("R2").Select Range("C1").Select Is this the correct way?
SORT
I have had to split my date into 3 columns because the dd/mm/yy format is not supported. I need to sort into Y, M, D, TIME order so that the rows follow sequentially. Can I do this without using 2 sorts? The Custom Sort only appears to give 3 sort criteria. Please advise. Philip
how to convert this? thanks
'RECORDING MACROS Sub CopyToBase() ' CopyToBase Macro ' Macro recorded 7/12/98 by Tirso B. Paris, Jr. ' Keyboard Shortcut: Ctrl+ b ' Record Simulation Results as Base Application.Goto Reference:="SIMRESULTS" Selection.Copy ActiveWindow.SmallScroll ToRight:=5 Range("Q2").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False ' Record Base Value Added (Basis for Value Added Growth) ' Application.Goto Reference:="BaseSumVal"
Will this VBA script run in Zoho?
will this run? any tips in converting? thanks! :D 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" Selection.Copy Application.Goto Reference:="START" Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets("Summary").Select Columns("H:IV").Select Selection.EntireColumn.Delete
How to insert an empty checkbox?
Hello, How to insert an empty checkbox in zoho spreadsheets? Thanks for your reply.
How to convert this?
Sub Macro6() ' ' Calculate Range("C1050:K1069").Select Selection.Copy Range("C1076").Select Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False End Sub Thank you :)
Freezing Panes
Whenever i freeze panes the buttons are brought under that pane hence, i can't see the buttons i created. here's the link: http://sheet.zoho.com/public/uplbapsim/papsim-dec2009-a001-3
Cell Text Overflow Feature Update
Hi. There have been requests for many years asking that ZoHo Sheet allow the labels in one column to flow into adjacent cells. There have been responses saying that it is on the TODO list and will be worked on for three years. As of this writing it is the last half of 2011 and the feature still does not exist. Please provide a reasonable update and set customer expectations as to whether or not this feature will exist before the end of 2011. Important company decisions are being made about moving
Next Page