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/
How to Convert VBA to Zoho Macro
Anyone how knows how to convert this? Thanks Sub ClearSummary() 'This macro clears the summary sheet for recording purposes' Sheets("Summary").Select Columns("H:IV").Select Selection.EntireColumn.Delete Sheets("Options").Select End Sub
Zoho and Huddle
Hi I use Huddle workspace and when I create a online spreadsheet from huddle i do not get the full features of Zoho WHY? Can I create a Zoho spreadsheet, save it and link it ot my huddle account? Cheers Mel
SaveAS XLS and HTML
I need to versions of the submited spreadsheet - an XLS and a HTML File. Is it possible to post both versions? Best regards, Andy
SEARCH function in spreadsheet
How do I search for text in the spreadsheet? Example, we have a job number register. We list the job number (1000) and the customer name (ABC Company). We need to be able to search for job numbers or customers in this spreadsheet. We have hundreds of jobs listed and it would be much faster to be able to find the names with a search. Please let me know asap. Thanks,
Help creating a spreadsheet
How do I get this sample brief report to work for me Zoho spreadsheet? Date: May 20, 2011 Buyer: John Rutger Item: Rado Automatic Price: $3,100.00 USD Commission 5%: $155.00 USD Fees: $135.00 USD Forwarded to Jennifer Jorgensen: $2,810.00 USD Reference Numbers for Jennifer Jorgensen: 645-333-8907
Where did all my Edits go??
https://public.sheet.zoho.com/public/rm2dance/cosmetics-industry-map "I saved to my account" so where is the most recent edits??
row selection error
my spread sheet is selecting the row two rows below my selection point. How can I fix this? Sapoty
Unknown function: Goto
I imported an excel file with macros in it. I believe that Zoho supports macros and as i was trying to assign a macro to a button with the macro coming from the excel file i upload it does not execute and says that Unknown Function: Goto. How can i resolve this? Does zoho support goto or it has another function for it? thank you. Here's the link: http://sheet.zoho.com/public/uplbapsim/papsim-dec2009-a001-3
Goto Function
I have this excel sheet imported from microsoft 97-2003. It has macros in it and the buttons have been removed upon importation. So i made button(base-titles) and was trying to assign the imported macro (Gototitles). But i received this error. Unknown function: Goto here's the link to the zoho sheet:http://sheet.zoho.com/public/uplbapsim/papsim-dec2009-a001-3 Thank you for your help.
unable to view the shared sheets in office plugin
Dear sir, I found this is very intresting tool for online geeks.But you can make this still more interesting by adding few more options i sent in previous mails. this time I got with one more requirement. I shared the excel sheet with Avinash ( my close fiend) in zoho online sheets. I was surprised that avinash was not able to open the sheet with zoho office plugin. I worked out and found that shared excel sheets are not viewable with office plugin. Aviniash found out something in zoho that is create
Sorting problems!
Very simple sheet, no formulas. First row labels (DATE, NAME, ETC) which I've "set as text" so it won't sort along with the data. I only sort by column A (DATE), I select the column, right click sort descending, I'm SURE to answer OKAY to "expand selection?", and yet.... my dates have gotten hopelessly fucked up. Sorted without the rest of the data in rows. Or, sometimes the column just WON'T sort-- data seems frozen. Only been using this for about a week, I'm afraid to keep using it for fear of
#NAME?
I've been editing this spreadsheet i imported from excel 97-2003. I changed a value of a cell and it keeps coming back to #NAME? what does this mean thanks. Need reply asap.
font color and background color
we cannot change the font or background color-- it's not allowing us to select.... we're using from China, Guangzhou?
Allowing Shared Users to Export Workbooks with Hidden Sheets
I've read through the blogs and found out that once you hide at least one sheet from a shared user, they no longer have access to the export functionality to save a local copy of the sheet. Is this correct? Is there anyway to override this and still allow users to export the workbook even though there are hidden sheets (without having to set the hidden sheets to Read-Only)? If not, is there any plan to perhaps allow the ability to export the workbooks and not include the invisible sheets? (i
Wrap text button deleting data
Sometimes when I hit the wrap text button after I've entered a long(er) list, my data disappears. I can't retrieve it with the back button - it's just gone. This is becoming frustrating. Am I using the button correctly? Mostly it works fine - the problem seems to occur when I've entered more than three items. Please help.
Format issues with downloaded public sheet
I would like to download/import a public sheet into Excel, however when I do it places all the information into one column. I would like the Excel sheet to stay the same format as I see on the website. So I don't have to spend tons of time formatting data. I have the link of the sheet (for example: http://public.sheet.zoho.com/sheetview?do). I have installed the latest plugin into my computer and am using FireFox 3.2 Please help. I have tried everything.
Link External Data
'Link External Data' allows you to periodically sync up the data in your spreadsheet with data available on the web in the form of CSV files, HTML web pages (tables) and RSS feeds. This is quite powerful if you want to make use of live data in your spreadsheet. Learn more about this feature from the blog posts we wrote as it evolved: blogs.zoho.com/sheet/link-external-data-comments-and-more blogs.zoho.com/sheet/sync-up-remote-data blogs.zoho.com/sheet/rss-feeds-into-your-zoho-sheet-plus-new-charts
IE8 Script Warning "Stop running this script?" during Macro Code execution
I am seeing a prompt in IE8 while executing a macro for a ZOHO Sheet. The prompt is as follows: "Stop running this script?" "A script on this page is causing Internet Explorer to run slowly. If it continues to run, your computer might become unresponsive." An example of the code causing this is pasted below: Sheets("Sheet1").Cells(3,2) = 1 Sheets("Sheet1").Cells(3,3) = 2 Sheets("Sheet1").Cells(3,4) = 3 Sheets("Sheet1").Cells(3,5) = 4 Sheets("Sheet1").Cells(3,6) = 5 Sheets("Sheet1").Cells(3,7)
Next Page