Unable to copy the error message
Dear zSheet Team, This is a related issue to http://help.zoho.com/portal/en/community/topic/zoho-sheet-crashing-too-often-today. The error message "The server has encountered a problem. We are sorry. We recommend that you copy the data that you entered till now, paste it elsewhere and then create a new document and try again". does not seem to be copy-able. It looked like you have overriden clipboard functionality for the sheet. But can you also provide a diagnostic copy for the user to copy and
Can buttons be cloned or copied to another sheet within the same workbook?
Can buttons be cloned or copied to another sheet within the same workbook?
Use REPT() to draw in-cell bar charts / sparklines
The REPT() function is used to repeat a text, 'n' number of times. This can be used in interesting ways. For example, you can use this function to draw a bar chart within a cell. Here is a sample spreadsheet which uses the REPT() function for in-cell charts. This spreadsheet holds the statistics of previous Wimbledon championship winners by Country. The range B3:B16 is named 'gentscount' and the range F3:F13 is named 'ladiescount'. Cell D2 is named 'maxbars' and it refers to the maximum width of
How can I create macros to shift cells in each direction?
I am using the code below: Public Sub ShiftCellsToDown() Selection.Insert shift:=xlDown End Sub Public Sub ShiftCellsToUp() Selection.Insert shift:=xlUp End Sub Public Sub ShiftCellsToRight() Selection.Insert shift:=xlShiftToRight End Sub Public Sub ShiftCellsToLeft() Selection.Insert shift:=xlShiftToLeft End Sub However, when I run these macros, only the shift to right works.
How can I display the cell contents from another sheet using sheet index rather than sheet name?
I have a workbook that it is every expanding and the name of the worksheets change. However I always want to display information on the first worksheet that is pulled from the 4th worksheet, despite the 4th sheet name changes.
Excel formula to Zoho formula
Hmmf - just finished writing this - tried to add a Google doc and it crashed the page and now I'm having to start again. Anyway, I'm new to Zoho, and I'm trying to use Zoho to create an HTML or iframe version of an excel spreadsheet I've made which I then plan to paste in a Wiki page in Moodle. It's so my students can add their own grades to their own grade sheet - and automatically get the correct overall grade shown. Once up and running I'd like students to be able to add predicted grades and also
Bookmark your spreadsheet
Here is how you can bookmark your spreadsheet. This could be useful when you want to open a spreadsheet by default as soon as you sign in or to create bookmarks for several of your spreadsheets. Open the sidebar using File -> Open (Ctrl+O) or the sidebar handle on the left Right click on your file listed under My Sheets. You will be presented with the browser's contextual menu. To bookmark a file: On IE, select 'Add to Favorites...' On Firefox, select 'Bookmark This Link' To copy the link to the
Default file in Zoho Sheet
Is there some way to set one file as the default sheet in Zoho Sheet, rather than it opening on a new workbook everytime?
Cells not updating unless I close sheet and reopen.
I haven't had this problem until today. For some reason, I type =(5*P35)*.01 in a cell and it doesn't convert to the value, unless I close the sheet and reopen. I then set the format to %, and have to again close and reopen sheet. It was working fine yesterday, :(
Insert multiple rows and columns
To insert a row or column, you will normally select a cell/row/column where you want to insert the row / column and use the 'Insert' menu icon available on the toolbar (refer the picture on the right). You can also right click on the cell and then choose the corresponding Insert menu items. Now if you want to insert multiple rows/columns, here is what you have to do. Select as many rows as you want to insert and then do a right click on the selected row headers and click on the Insert Row Above /
Time Format
It should display the whole length of time even when it is bigger than 24 hours or 48 hours. For example, if the time is 50 hours, it should show 50:00 instead of 2:00.
copy/paste
How do you copy/paste between sheets?
#1 goto another sheet #2 find the next empty row
My development is going well and I appreciate the answers I have gotten form the Zoho staff..... #1 I would like my macro to be able to leave sheet1 and go to sheet2 . #2 I would like my macro to be able to search down the sheet for the first occurrence of an empty row.... discovering that the first cell in the row is empty would be sufficient. Best 99guspuppet PS I feel that I am missing the obvious... where do I find code examples and tutorials ?
evolution
First of all congratulations for this achievement, which may in some cases to dispense with php / mysql Question 1 do you integrate validation to create dropdown lists limit of 1 GB it will be even larger pay
Detailed Employee TimeSheet
Ive noticed that when I clicked the button to generate a detailed timesheet on the employees timesheet page the report was generated fine. Then I made changes... Now when I click the Detailed Timesheet button it gives me the old data that was generated before i made the changes. I went down to the bottom and recalculated the employee timesheet then tried again. Still no luck. I then went to the reports on the top and generated a detailed timsheet report. This generated the correct updated report...
removing people from shared sheets
is there a way to remove someone from all shared worksheets without having to do each one individually? thanks Dan
Want to compare a cell from sheet1 to a cell in sheet3
Thanks for your previous help ....... My non-working code is ........ if ( ActiveCell.Value =Sheet3!A2 and Sheet1!B2 =Sheet3!B2 ) then Range("C12").value = " successful logon" Range("C13").value ="David Kimball" end if 99guspuppet
Information is Not Saving in Sheets
Hello, Is there any reason that information is not saving in our spreadsheets despite hitting the save button? Thanks
I have 3 sheets 1 , 2 , 3 I would like to lock sheet three so only I can modify it
I have 3 sheets 1 , 2 , 3 I would like to lock sheet three so only I can modify it or look at it.
Using Macro to copy data from sheet3 to sheet1
I would like to copy data using a macro ..... copy data from cell A2 thru A18 on sheet3 to B12 thru B28 on sheet1 thank you
Zoho dies very slowly ..... development becomes impossible
Update: 2011m06d10 The Zoho staff has been very helpful and now I am well on my way to accomplishing what I wanted to do Hooray 99guspuppet I was building a spreadsheet to monitor inventory. I had some ideas that I liked and everything seemed to be going along well. I asked some questions and I was told that Creator might be a better fit. I tried Creator and it seemed nice. My partner did not like it though.... so I returned to using Sheet. At the time I returned to Sheet .... I was 70%
Pulling certain field data only
Hi, We have a sheet of data with all our website product info including name, SKU, price etc. - this is on sheet 1, and will dynamically change as we add new products to our site (as its a live CSV feed). We want to give one of our suppliers access to sheet 2, whereby they can add in comments such as stock levels and latest purchase prices. So is there a way for us to: 1. Highlight / select rows from sheet 1, and have them only appear in sheet 2? 2. Have only certain columns of those rows appear
Linking external data
Hi, I have a live URL that provides a CSV of all the products on our website (we use it to populate Google Product Search). I've added the URL into my Zoho sheet and scheduled it to get the data each day. It does pull in the data but I can't get it to format correctly in tab delimited. Its just pushing all data into column 1. How can I change this? Thanks
Sharing excel sheet in real-time
I have a large modeling excel sheet where a group of people will need to be working on it simultaneously. Can Zoho allows real-time simulatenous collaboration? ie I could see in real-time the changes of the other user who are accessing the same file as I am. Thank you.
logon questions for spreadsheet
I am very new to Zoho stuff #1 I want limit a spreadsheet to allow one person at a time ..... to logon to the spreadsheet. ( with a password and logon name ) #2 I want to access the logon name in a VBA macro. ( The logon name of the person who is logged on ) Best 99guspuppet
How to set spreadsheet cells to NOT block text flowing from cell to the left?
How can i set cells so that they do NOT block text flowing in from the cell/s to the left?
Google Chrome - Cannot Select/Click Cells Using Mouse
This probably a known issue but I cannot select or click in a particular cell when I open a Sheet in Google Chrome (I can do so readily in Firefox). In GC I can only move to or select cells using the keyboard. The version of Google Chrome I am using on my Windows laptop is 11.0.696.71. Also unable to report a problem or ask a question from within Chrome (formatting bar does not appear and Sub forum dropdown is blank).
Time Calculations
I'm trying to put together a simple time-tracking spreadsheet in Zoho Sheet that allows me to have the following columns: Activity (simple text field) Starting time (time format) Ending time (time format) Time Spent (difference between Starting and Ending times) The problem is the final field. How can I get the difference between the starting and ending times? I don't see a function that allows making this calculation. I would have thought this would be something fairly simple.... George
modify data in sheet
hi, I've got several sheets in my document and I need to modify them to a given criteria. I'm willing to write a small program to do this. The program is intended to open the given document, modify content (like deleting some rows, altering some values etc) and save. So for this what API should I use? Is there any sample code written using the API, that I can refer? Thanks in advance
set cell data
Hi, I am new to macro writing in Zoho and wanted to know if there is a way i can assign a value to a cell to be equal to the current active cell. Thanks, Pascal
Chart - line graph - clipping of labels; lack of control over x axis labels
I seem to be unable to attach my Zoho Sheet document through the Zoho Docs tab. No documents show up. (I'm unsure whether a Zoho Sheet falls within the category Zoho Docs.) The Sheet I'm having difficulty with can be viewed at https://public.sheet.zoho.com/publish/graham101ia/graham-s-absp-rating. Two things which are not ideal are: 1) clipping of one of the Data Labels (labels attached to points on the line graph) at the top edge of the Chart. This happens whether or not a Chart Title is
external data link
Hi, am trying to import a web data to online sheet from below link. http://www.mcxindia.com/SitePages/BhavCopy.aspx But data is not getting downloaded.. pls help
Can't see docs
I can't see my uploaded docs. Having Problems or is it just me?
Online Embedding Question
Guys, I am new to Zoho sheet and I'm sorry if this has been asked ad nauseum. I have a spreadsheet that is embedded in a website I am writing. All I need to know is if there is a way to make changes to the sheet "saveable" online or is the online/embedded version totally read-only. Thanks, A.V.
Consistent Error Messages
The users are receiving this error message consistently now with every use...is there a notable reason for this? Or anything we can do...? Thank you!
color of chart data
HI, Is there any way to change the color of data series in a chart. Eg., if i have 3 days and data for these 3 days the bar chart will show 3 bars. I want to change the color of the bars according to my preference. Is this possible? Thanks, Subin Luke
Exported sheet, pictures missing
Hi, I made a spreadsheet with some pictures. When I try to export the file, the pictures do not show. Is there a way to solve this? Thanks.
Zoho very slow in China, can't use at all.
I use Zoho sheet. It become very very slow since last week. It is not useable at all now. Is this happening in China only?
Strikethrough text
Please enable Strikethrough font style for zoho sheet
zohohosheetの計算式がたびたび消えてしまいます
zohohosheetの計算式がたびたび消えてしまいます 計算結果がすべてクリアされてしまうことが月に数回あるのです。 単純な2つのセルの合計計算の数式なのですが、どうしてこのようになるのでしょうか？ 対処方法があれば教えてください 例： =SUM(I78*J78)のような単純な数式です
Next Page