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
Help with MACRO Conversion
Anyone who can help me convert this VBA Marco to the one the Zoho understands? Thanks :) Here's a link to the original file: http://sheet.zoho.com/public/uplbapsim/papsim-dec2009-a001-3 Sub WritePrn() ' ' Macro4 Macro ' Macro recorded 8/6/2001 by Tirso B. Paris, Jr. ' ' Keyboard Shortcut: Ctrl+p ' Sheets("HHModule").Select Range("A1:J30").Select ActiveWorkbook.SaveAs Filename:="C:\Apsm20\hhmodule.prn", FileFormat:= _ xlTextPrinter, CreateBackup:=False Sheets("Options").Select
When a owner of the shared sheet opens the public URL can you automatically open it in Edit mode?
I have shared a public sheet. When I open the public URL and choose Edit it is creating a duplicate copy right? Can this be avoided by automatically opening the sheet in normal edito mode when the owner is the one accessing and opening it? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
FORMAT BUTTON
Is it possible to edit the font and/or background colours on a button? Philip Chambers
BUTTONS
Is there a way of changing the font or background colour on a button? Philip
How to insert an image into the spreadsheet?
Dear zSheet Team, Please guide me how to insert an image into my spreadsheet? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
How do I increase the number of decimal places shown?
Hi, How do I increase the number of decimal places from 2 to 4 and prevent rounding? For that matter how do I access the formatting for a cell such a font, type, etc. I tried right clicking nothing except removal of formatting. When I click on a cell the proper number shows in the status line but within the document it is truncated to 2 decimal places. Thanks
Can not import a 40 mega byte excel sheet
Dear zSheet Team, I am trying to open a 40 mega byte excel sheet into Zoho Sheet account so that I can easily manage through my account. I am not able to import because of the following stingy restriction: Note:- - Supported file formats: xls, xlsx, sxc, ods, csv and tsv - Maximum file size allowed is 10 MB - Only unprotected files will be imported Viewer also does not support this. For your info, this is the excel sheet I am trying to view: http://rbidocs.rbi.org.in/rdocs/content/docs/68774.xls
When you close a sheet by (X) button a blank screen is presented
When you close a sheet by (X) button a blank screen is presented as in the attachment. It would be great if you could create a new sheet by default. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Next Page