zohosheet(67 - days ago)Page: Welcome
@kdinesh: we have added support for buttons. Kindly check http://blogs.zoho.com/sheet/new-in-zoho-sheet-insert-buttons-xlsx-support-time-zone-preference
smithscf(137 - days ago)Page: Welcome
Please support custom functions. Scientists and engineers need a Zoho Sheet program to calculate many types of custom functions, frequently repetitive. Please put it at the top of your list as we really don't need many of the features used in business!!! Otherwise, there is only Excel, which although lacking in so many ways, is still highly useful in engineering education. Thanks!
ajasmine(217 - days ago)Page: Welcome
Currently we are not supporting custom function in Zoho Sheet. We will look to support this in future.
cobyzoho(225 - days ago)Page: Welcome
As Microsoft points out, Microsoft can't "anticipate every calculation need of every user", nor can Zoho. Therefore, Microsoft provides, and Zoho should too, "the ability to create custom functions".
I can create the custom function in a macro module, as I can in Excel, but you don't seem to want me to execute it. I get an "#Invalid Formula!" error message displayed in the cell.
This is a HUGE, crippling omission, a major error!
-----------------------------------------------------------
Create your own worksheet functions
Although Microsoft Office Excel 2007 includes a multitude of built-in worksheet functions, chances are it doesn’t have a function for every type of calculation you perform. The designers of Excel couldn’t possibly anticipate every calculation need of every user. So instead, Excel 2007 provides you with the ability to create custom functions, which are explained in this article.
http://office.microsoft.com/en-us/excel/HA102189961033.aspx
ajasmine(265 - days ago)Page: Welcome
Yes, You can create functions and you can call that function in any procedure or other functions. You can't call that function directly from a cell as Excel functions.
walter_ochynski(269 - days ago)Page: Welcome
Is it possible to create functions as with EXCEl VBA?
kdinesh(373 - days ago)Page: Welcome
Can I create a Hyperlink in Sheet1 which will take me to Sheet2?
kdinesh(373 - days ago)Page: Welcome
Is it possible to create buttons which run the macros, rather than going to the macros menu?
ajasmine(406 - days ago)Page: Track Editing Time
Select the sheet name(e.g.Sheet1) from the left panel of the macro editor and copy the above code and paste it into the editor. Save the code and close the editor. Now change the cells in the Sheet1 where you pasted the code, you can see the current time is set to the first column of that changed row.
pvojnisek(406 - days ago)Page: Track Editing Time
I have just copied the code into macro editor (This workbook).
Unfortunatelly, nothing happens changing any cells in my sheets.. :-(
P
sasi(494 - days ago)Page: Find and Replace
This macro cannot be applicable for format related replacement.
For example Currency format changes, '$' symbol was replaced by 'USD'.
It was possible by using " Selection.cells(i, j).Text " tag.