Import online file into spreadsheet
Hi, I have a quick question about importing online data into a spreadsheet. If I set the spreadsheet to get the data every so often, will it continue to do so when the spreadsheet is closed and another spreadsheet within zoho is open? How about if zoho is closed completely? Thanks -David
how to join personal group?
Do Zoho had instructions on how to join Groups? Using Google/Yahoo Do Zoho had instructions on how to access shared folders? Please advise. Regards
Printing of data from a share sheet
It seem like there is no print or page setup or print ranges when the sheet is on share mode? People whom i share Zoho sheet had been trying to locate a icon to print everything nicely in a same format but it seem that they cannot do it. they had to copy to excel and do it again. Please advise
Sort/Format Macro says it's running, but doesn't complete or do anything...
Why isn't my macro working? When I run the macro SortScores, the message "Running Macro" appears in the upper right corner of the sheet, but it never completes and when I finally interrupt it, nothing has been done. The purpose of the SortScores macro is to first, sort the List on the left by Scores in descending order, then copy the sorted result to the right to completely overlay the 2nd list (this is so my published ranges for both lists expand and contract as rows are added or deleted), and
When we try to generate ticket id it gives server not responding error.
HERRAMIENTAS
EN EL PANEL NO SE ENCUENTRA VISIBLE HERRAMIENTAS
Emergency Issue With Zoho Sheets!!!
We have had a number of problems with Zoho Sheets, this is an emergency as the business relies on Zoho Sheets, with 15 people working on them all day. It all started with the sheet owner not being able to share, she then downloaded and reuploaded the sheets into new sheets and re-shared. She deleted the old sheets which were in her Trash. Unfortunately everyone had duplicates in the Shared to Me folder, so they ended up working in different sheets. The sheet owner then deleted the sheets which
POST Method of UploadBook API by passing URL(or path to file) in content parameter
Hi, I am having problems in getting the POST Method of UploadBook API by passing URL(or path to file) in content parameter to work. Can you please provide a sample code? Preferable one of each (passing a URL and passing path to file on server) Thanks Steve
GuestView link sent in invite email.
Greetings, When sending out invites I noticed there is a preview link, if this link falls into the wrong hands what is stopping the public from viewing my private spreadsheets? Is there an option to not send or disable this link? "The document shared for collaboration can be viewed at : http://sheet.zoho.com/GuestView.do?<insert jibberish here>"
Can't copy sheet...
Hi, For some reason, I cannot copy a sheet within a spreadsheet imported from excel. I've done this before with a previous version of this same document successfully. Are there security measures that I'm not aware of? Thanks, Sean
copy and paste
trying to copy and paste cells between tabs in a spreadsheet, however the 'edit' copy and paste options aren't coming up on my Firefox browser. Is there a special way to do this on ZOho?
naming new sheets in a spreadsheet
Hi, when creating a new sheet in a spreadsheet, I can't work out how to name it. When I click on the 'sheet 1' tab down the bottom and write it writes in cell A1 rather than as the sheet name. Any clues anyone?
sheet 单元格无法设置格式！
并且打印带表格线表格时会多出许多横线！
Remote Api - (400) Bad Request
Hi Guys, First of all ... Wow! love the zoho's work (editors, viewers, api's). I really need you guys' expertise on this subject. I have sent my three .htm sample files to support@zohosheet.com. They are used to open remote docs and save them to a remote server. I am able to view and save a Writer document with no problem, but with the Sheet I get (400) Bad Request, and Show i get a 500 Internal Server Error msg's. Will you please have a look at the html I sent and inform me of what im doing wrong.
Large Numbers Broken
I am linking to the following HTML table: http://www.runehead.com/clans/ml.php?clan=kngkyle&skill=Overall&sort=name Everything is working except for 3 numbers, as you can see from this screenshot: http://img338.imageshack.us/img338/4346/scr1249093944.jpg They just do not show up at all. Please help. EDIT: You can't copy and paste numbers larger than 950,000,000 either. Just shows nothing. Thanks
Crooked Rows in Firefox 3.5
Hello. I love Zoho, but today after switching browsers I've encountered a problem when viewing the zoho sheet files from Firefox 3.5. The rows are mismatched with the numeral indicators on the left. I've tried different views on firefox and still, the same result. This does not occur in Internet Explorer. Any thoughts?
i cant export spreadsheet
i have been exported this file and now i cant, i am upset...i cant believe all the work i did and i cant export.
Add operations with time
Hello; Is it possible to add some feature to allow adding time type values up to a total value instead of counting from zero when 24h are passed? Like 10:00 + 10:00 + 10:00 = 30:00 and not 06:00 ? This would be the same as excel's time format "37:30:55" or "[h]:mm:ss. If this operation is already possible, please tell me how. Many thanks!
unable to charge all sheets of xls file
Hi team ZOHO thanks in advanced for help and sorry for my english. I have a problem , when I upload my file that is composed of 9 sheets , the file apear with all sheets in zoho but only the first and second are charged with a correct data and formula , the next are only a white sheets, no data no formula. regards emanuele
"Find", "Save & Exit", "Share", "Edit" and data integration questions
Hi, I am a new user and this will be a lengthy set of questions so appreciate any help out there. We really like the idea of using Zoho to share documents between our two offices (east and west coast). However, I have a few reservations before I get the office on board. Since we will primarily be sharing Excel sheets, the questions pertain to these. Here goes: - There appears to be no "find" function to use on worksheets. This is important if we're looking for a specific SKU on a long sheet,
sheet refresh display
i creat a excel ,several sheets. i wanna when i change one of sheets,the others can refresh at the same time,but in fact ,i found some can work ,some not ,in this case, i must click it ,refresh it again,than it can be work.why and how can i deal with this question.thanks!
Embedded view won't display in Internet Explorer 6
I'm using the iframe embed in a Wordpress website and for some reason the spreadsheet has stopped displaying in Internet Explorer 6. The sheet displays fine in Firefox and IE 8, but many of the users accessing this site are using school district computers and can't update to a newer version of IE. Any idea why this might be happening? Let me know if you need any more information. -Adam
paste as
I think it were quite useful, if one could "paste special" or simply "paste as text", in order to get rid of formulas, but keeping the values (e.g. for an id column).
Custom Currency
Hi Even though all the major currencies are covered I think the ability to add a custom currency would be great, so what do you think folks?
VLOOKUP FUNCTION PROBLEM
Hello, i have a problem with the VLOOKUP function in my sheet http://public.sheet.zoho.com/public/tonimoreno/indicemasacorporal2 in cell D2. This function doesn't work correctly and always returns the last content of the range. Can you help me?
не переноситься файл!!!!!
xls файл переноситься частично. Только первый лист как сделать чтобы перенеслись все остальные!!! helppp!!!!
Import.do api
Hi, I am trying to upload a file (.xls) its working fine using uploadbook api. the only problem is i am not able to see images embeded in the file when i am uploading using api. although when i use your Import functionality from interface it is working fine. so i thought of using import.do api. but this is opening up an interface after uploading the file. i just wanted to import a file from a url and then returning me back the response of the workbookid created... how do i do that...
Open Sheet in ReadOnly Mode using API ?
Hi, Can u please advise how do i open a sheet in read only mode using api which is posted on your server. i have necessary docid,ticketid,apikey I am using api for displaying it in my appln. pls let me know
Randomly losing data in cells
Every time I edit a sheet, some of the data from my latest changes disappears. I originally uploaded a multi-sheet Excel spreadsheet which included spanned cells and borders. The first image shows what it looked like after I saved the spreadsheet. After waiting a couple of minutes (until my firefox browser's "working" indicator stopped spinning) I switched to another sheet and then switched back. All the data was there. I then closed the browser. I came back about 30 minutes later to verify that
How can I draw histogram with zoho spreadsheet?
I want to draw a histogram for a set of data. How to use zoho to make it come true? The chart existing can not meet this requirement.
Zoho Sheet Tabs
I am trying to work with a larger file with several tabs in Sheet, but my tabs never stay in their order, but rather continuously shift or change spots as I go between sheets. Can I stop this from happening or lock the tabs in place? Thank you.
Foglio Presenze L'Aquila
Per permettere una miglior programmazione delle attività d'ufficio siete cortesemente invitati a compilare il seguente foglio di calcolo indicando con una X i giorni in cui sarete presenti in ufficio per l'intera giornata, con una Y i giorni in cui sarete presenti per mezza giornata.
Apply formula to column
How do you apply a formula to a whole column?
Organization Groups do not appear
Hello, I am trying to share a document to a preregistered group in my organization. When I click on share, then Add Groups , the list of the groups of the organization does not appear and I cannot share the document with the groups.
Date auto-formatting
Tried adding a value in a cell as 9 - 10 to track the time 9 to 10, the value changed as 09/10/09 . Works the same as in Excel. So, tried adding 9 - 9.30, the value changed as 09/09/30. Excel maintains it as 9 - 9.30 only. Finally, I added it as 9 - 9:30 and it worked.
what type zip do I use
When I try to use winzip to bring in an 8 mb file...I get an error message that states that winaipwinzip files are not supported. What should I use to zip my local file so that I can export it to sheets?
Remote API
Hi, Firstly, I would like to really appreciate the work which you'll have done... its really great, there are no words to describe it... its just awesome. We have created a tool which will do the authentication & rest of the job @ our end. We are just making the users open those sheet in editable interface for which they have access using your Remote API. We are using http://sheet.zoho.com/remotedoc.im method to open up the document. We are able to open the document as welll we are able to
Sharing of Groups Not working
Please advise I had create some group and sharing the worksheet by group but the person cannot access the sheet or any documents shared to him/her, please help? do i had to share by users id? Regards
Odd error
States spreadsheet I am attempting to import is password protected when it is not.
Conditional Formatting
Hi Support / anyone I am trying to modify the macro below to just modify cells C5:C6 as once I get that working I can then use the macro in a spread sheet where I need to target the conditional formating to only certain rows / columns. Can some one help please! Cheers Peter REM Sheet Module Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = false On Error Goto ENEV REM add your code below If IsNumeric(Target) Then Dim grade As Range Set grade = Cells(Target.Row, Target.Column+1)
Next Page