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
Sharing - but other users changes do not save
I have shared a sheet with others. They are not registered with ZOHO. They can view the sheet, make input, but there is not way for them to save. Their permissions are set to READ/WRITE, but we can not find a way for their changes to save. HELP
Web Data Problem
Hey guys, I'm having a problem here. Whenever I try to import and online csv file, I get an error telling me that the webdata is not configured properly and no data shows up... Can you guys fix this? Thanks -building_429 P.S. I have shared the spreadsheet with you.
Hiding sheet menu's when embeded in a webpage
I am trying to place a calculator on my website. I have the sheet set up but when I embed the IFrame I get all the menu's and they clutter up the view. Is there a way to show the sheet with just the data fields and not all the menu buttons. I have seen several examples of this but can't figure out how it was done.
revising sheet without losing invitees
I wonder if there is a way to make a change to a spreadsheet offline and then updating the online version without creating a new document. Each time I export, and modify a sheet and then upload it, i have to send new invitations, which is confusing to the invitees. I may be missing the correct procedure to accomplish this and would appreciate being set straight on this procedure.
Definitions
Please define in the TIP during Inflation Spreadsheet: 1. Line 25: "Cumulitive inflation(felation) until.." 2. Sensitivity Analysis This blog is great but the spreadsheet could use a help section.
Ebed Zoho Sheet into website
I am having a problem with embedding my zoho sheet into my website. It will not show. It only shows a little bit of a picture but not the full spreadsheet. I tried the zoho instructions but it is still now working. Please help.
sheet
not workin in google chrome after last browser update
Switch to link zoho mail is not listed
In Switch to link zoho mail is not listed. Amar
import introduces sheets then i can't get to the right-click object menu
Hi, I can't delete sheets: right-click pulls up an object men; the object menu works fine inside the body of the XLS, but I can't for the life of me get it to work on the sheet tab. Either FF or IE (please don't ask for a screenshot, it's another Zoho issue for sure) and, the only reason I am trying to delete a sheet is that the import, for some reason introduces two extra sheets with names that start with #: http://sheet.zoho.com/corporate/1978922/davidharper/2-a-7-distributions-2 I took a sheet,
When I exported a sheet as a CSV file and opened it with Notepad then the values, which were in only one column, were separated by double apostrophes?
Layout configuration when printing
Are there controls in Zoho Sheet that allow you to define on how many pages a spreadsheet will print?
IF() syntax
Hi, I want to perform a function only if a condition is true. If the condition is not met then i want the cell to be empty / null. I've tried something simple like this =IF(0>1;1) This condition will obviously never be met, but rather than leave the cell blank it puts 'FALSE' into the cell. How can I make it completely empty (ie NULL). Thanks for any help.
Merging Cells
The ability to merge cells vertically would be enormously beneficial.
plug-in has too many bugs
The plug-in has too many bugs to enumerate, the worst of which is: it crashes Excel which is really something since Excel is hard to crash. Zoho sheet is generally unstable. I recommend you guys squash the many bugs and address basic usability before adding new features. Compared to other online office products, we hesitate to use sheets because productivity is lost. It is like a crapshoot going to use zoho; will we lose data? will excel freeze? etc ect David Harper
Next Page