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)
ZOHO Sheet import extern DATA
I want to import follow extern Data: http://upthis.de/dlf/p6u102/quelle.txt but ZOHO Sheet dont took the Tabulator as separator
what controls the which sheet is displayed when publishing (embed) to website
Hi, When embedding, we would generally prefer to display the 1st sheet in the workbook. But it seems that sometimes it is the last sheet, does something control this logic; is there a way to insist the 1st sheet is published? Thanks, David Harper
Display of zero value fields.
It would be good if cells that return a zero value displayed with nothing in them as they do in Excel when the "show zeros" is unchecked in the options menu. I have tried IF(****,***,"") but 0:00 is still returned in a time formatted field.
Zoho sheet deletes Custom Views and set Rows to 0 height when using Excel add-in
If I upload an Excel workbook to Zoho that has Custom Views, it deleted the Custom views. If I upload an Excel workbook to Zoho and change any data in a cell, the Row the cell is edited in is set to 0 height when downloaded back to my computer. See attached .doc file with jpg's of the results. If you need the before and after Excel files I can email them to you.
Feedback Form
I'm currently evaluating Zoho for a client, they are currently using Google Docs with an emphasis on the Spreadsheet. With Google Docs Speadsheet you have the ability to build a form that can be placed on the internet, which any person can fill in and when the form is submitted it adds the data to a spreadsheet (this is an example of the form - http://spreadsheets.google.com/viewform?formkey=cnF3MXl5VHVUaEZCNEVrc2dzUTR5bWc6MA ) I need to find something that does something similar with Zoho.
api key clarification
Hi, This is sailaja , i am already using zohowriter, it is working fine for documents but i need work with excel files also in my application, but excel files are not opening do i need to give request with another api key are any another way to support Please any one help me. Thanks and Regards N.Sailaja
Write spreadsheet data from url
Sorry for the long post, but I'm a newbie. Short version: How do I use the url to write cell data to an online spreadsheet? Long version: I'm a physician working with an electronic medical record (EMR). Our EMR templates have the capability to include links to websites. We use this capabiliity to link to a wide variety of clinical tools or calculators to aid in decision making. The clinical tools we use are built on often simple formulas using clinical variables already coded in the EMR. The
Insert copied cells
I use this feature a lot in excel and I do not see a way to do this in Zoho. This is a deal breaker for me to make the switch to Zoho. Would it be possible to write a macro to accomplish this perhaps?
For websites
Hi, I believe the following could be a great idea: Imagine a bank showing their interest rates and an example calculation of what one would have to pay given some parameters. It would be so much better for the bank to use Zoho to present this calculation so the users could modify the sheet in any way they wanted. This would enable users to try different scenarios that might be more complicated than the basic calculation. There are two features that are needed in order to make this easy for the websites:
Tabs keep going out of order
The tabs in our shared workbook are in order and labeled by date. Everyday they are totally out of order. How can we fix this?
Unauthorized to use Zoho Sheet?
Is anyone aware of why all the other Zoho features EXCEPT sheet would open on Firefox?? This is the one I signed up to use and it gives me an error page that says "Unauthorized Access" when I try to switch to it.
Auto save question
One of the features I saw and like about Zoho sheet was the Auto save feature. I have been working with a colleague remotely on a spreadsheet, but she had it open for 1 hour and it never autosaved once! I thought I found a preference where you could say "Autosave every X minutes" but now I can't find it. What am I missing? Thanks, Gee
drop down menu
Drop do how do you do drop down menus?
About ZOHO excel sheet
Dear Sir, first of all i would like to congratualate on the zoho sheet.It is very nice tool for SMB and individual users. It would be more helpful if you introduce features such as 1) folder view ( where main user can save files in different folders for different users. Here in the current version it will be difficult to find out the excel sheet as when the no of files increase. folder view will be more helpful option) 2)setting up auto filters ( as we do in the excel sheet setting up auto filters
can't find my sheets
Hi, I cannot find my sheets on the left side. They have disappeared.. I can find them in the "document" application in Zoho Business. Can you do something about it ? Than you for your help Pascal
Using Ctrl-C in embedded sheet causes page to skip upwards
Using Ctrl-C in embedded sheet causes page to skip upwards in Firefox, Chrome, and Safari. No skipping in IE.
Images missing when exporting
Hello, I have a sheet that contains images (logos, etc...). I need to export it or print it but in all cases, the images are missing when I try to export or print the sheet. (Same result for any export type and print) Is this a known issue or is this only me? Thank you, Thomas
Losing pull downs
When I import a spreadsheet into Zoho Sheet, I am losing some functionality, specifically pull down menus. Any ideas?
Saving of full workbook and automatic save on sign out
Because I can't access the forums properly (see separate feedback/post), I am submitting this problem even though it may have been reported previously and a resolution provided. In the past I was able to sign out without saving and Zoho Sheet would automatically save my work. That now no longer happens. Also when I clicked on the 'Save' icon in any sheet of a workbook, all sheets were saved, not just the current sheet. That, too, now no longer happens. Is there any option setting I can make to revert
Disappearing formulas!
I have a spreadsheet set up with an 'IF' statement containing a formula in the final column of each row that gives me a cumulative total of transactions to date, i.e. it adds a value in the immediately-to-the-left-cell to the immediately-to-the above-cell, but only if the immediately-to-the-left-cell is not empty. The formula is replicated in many rows ahead of where the last transaction has been recorded. This has been working OK since I started using Zoho — until now. Now the formula mysteriously
Lost pulldowns
When I bring a spreadsheet into Zoho Sheet, I lose the pull down menus that I had in the heading categories. Any ideas on how to fix this? Thanks.
Zoho Sheets in Google Chrome
Is there any issue with Google Chrome recently as I am unable to load Zoho Sheets? I try other browsers and it work fine.
Personal Macro Workbook
It would save me much time if my VBA macros were available to all of my Zoho Sheet workbooks. I could not find a way to create an equivalent to Excel's Personal Macro Workbook. Having the capability to establish a reference in the VBA Editor to another workbook -- making that workbook's macros available -- would be an ideal solution to the problem. Separately, many hours were lost yesterday when I tried to use VBA to take cell values [X = range().value] and use them in an equation [Y = 2* X].
The row labels are not aligned
Can you tell me why the row labels are not aligned with the rows? See My spreadsheet see how the row labels (1,2,3,4,...) are shifted from the rows? Thanks, David
Merging cell
Why can't we merge cell vertically? I have tried but It can be horizontal but not vertical.. Please help. Regards,
How to retain selected column widths within Zoho plugin
Hi there, My problem is as follows; In all our spreadsheets, our column widths have been selected to certain widths (irrespective of the content data). If I upload to Zoho, when I open documents within the Plugin, the column widths default to a standard size (usually larger than I need them to be) If I change them back (within Zoho plugin), they will only default back when reopening the document. Therefore, Does anyone know how to retain column width information, or is this not possible? Thanks
Next Page