New Problems with Embedded Spreadsheet cells
I have used embedded spreadsheet cells for several years now, and it's always worked as I expected. During the past couple of months I have had recurring problems - severe enough that I may need to stop using Zoho Sheet for my intended purposes. Here is a blog post that explains one of the ways that I have used embedded spreadsheet cells: https://community.desire2learn.com/custom-widget-semester-countdown/ On the same blog, you'll also notice a "live" (not so alive, apparently) example of a Zoho
How to get rid of ' in Zoho shhet
When I export values to Zoho docs, they will be starting the numerical values with the character '. I don’t not know how to get rid of these. find and replace does not work in Google docs. If you exports them to excel are not visible and I can not do calculations. How do i do?
Sheet with two tabs - how do I hide one of the tabs?
I've searched and searched but I don't understand how to hide one tab that has formulas I need to hide from the public. I'm publishing my sheet with the embed option with the iframe. My first tab is an interactive calculator that works so that's good. Just need to hide the other stuff. Thanks! -Scott
Is this possible?
Hello all - I know this is probably an obvious question but I'm kinda tired of reading all the help sections and messing around with the program without finding a conclusive answer. Here is what I would like to do: I made a spreadsheet with only a few columns (I wanted one to be a drop down.... But I found that Zoho does not support them... lame... Anyway, what I need is about 30-40 computers at once to be able to access the spreadsheet and be able to change the data in two of the columns as they
Spreadsheet doesn't download
When I go to Spreadsheet the only thing I can see is a small rectangle in the center saying "Downloading" and nothing else happens. The Documents works correctly but not the Spreadsheet, does anyone know what the problem may be? Thanks.
zoho sheet - conditional formatting - date
Hello. I just started using ZOHO, and it seems very useful. As I did in Excel and in Google Docs, I want to color cell(s) if the value of date is after today using conditional formatting. but when I set 'after' I can only insert a specific date in the following field, not a saved word (as today, tomorrow, next week, etc.) thanks a lot, Lior.
Is there a way to keep website visitors from editing cells?
I know that any changes to cells are not saved... that's good. However, I don't want my visitors to even be able to click and edit the cells in a spreadsheet at all. Right now, if I click on a cell, I can type whatever in it... then the only way to see the original data is to refresh the webpage. Is there a way so that none of the cells are clickable? I've locked and hid the formulas but that does nothing for keeping this truly unwriteable. Thanks.
Fractions
Is it possible to format cells as fractions in Zoho spreadsheets? Thank you!
Filter by background color
Hi Wanted to know if you could implement, or if there is a way to filter using background color Excel's latest version have that option... please let me know. thanks
Empty Rows
Many of my worksheets consist of approx 120 - 150 rows. However, most worksheet somehow have additional rows, up to 2500.I tried everything I could think of to get rid of those additional row, but I cannot get rid of them. How do I do it please? Best regards Hans
Calculateing hours in a week problem
Hello, I am trying in spreadsheets to calculate the hours spent at work. I have the formula right, it gets me to the result i need, but the program doesn't know how to display it (i goes H:MM, but i need something like [h]:mm). Because every 24 hours added it goes back to 0, so if i have 12 hours and add another 13 hours, instead of displaying 25 hours, it shows only 1 hour. Any ideas? (sorry for the bad spelling - not my first language)
Zoho Sheets not loading
My Zoho Sheets will not fully load. When I try, they get stuck with the "Loading...." message. This happens with IE 10 and Firefox 25. I can, and have, successfully downloaded the sheets to my computer to get work done. Is there a fix for this? Steve
Hide columns
How do I hide columns?
Randomize formula only works to display a different word from sheet if it is closed and reopened
Hello, I have created this sheet https://docs.zoho.com/sheet/published.do?rid=iea9rc50e0eaabc63444e937ab6b1b88c6ef5 Currently, to see a new word displayed on the main sheet from the list of word from the Word of the day tab, I have to close the sheet and restart it. Is it possible to have the sheet in a way that by only clicking on the Word of the day list tab and then the Main page the words keep changing? Thank you
Permit input without saving?
I need a spreadsheet to serve as a calculator for specific game theory equations. Users must be able to input values and get results, but unable to save any changes made - same as a read-only xls on a PC. How do I do that?
Issues with Excel Viewer
Hi there, Much thanks to ZOHO for producing such an amazing program. Im trying to display spreadsheets in my webapplication however im trying to stream these documents from outside the webroot to increase security. I have a fileserver.php file which reads in the file name and the jobid from the URL ie http://www.blahblah.com/fileserver.php?filename=spreadsheet37.xlsm&jobid=4987 when i put that url in https://sheet.zoho.com/excelviewer it finds and displays the file. HOWEVER when its running through
The value of a cell, from one sheet to another sheet (in the same document)
Hi everybody! I am from Spain, so it's quite difficult to explain the question I have, but I will try it and I hope you will understand my problem, and, hopefully, you can give me a solution. I have created one document (spreadsheet) with different sheets in the same document. And I just want to put in one cell of sheet 4, different values of sheets 1, 2 and 3, so, to makes balances. I am trying, like in Excel, to put "=", and I go to the sheet, click the cel, and push Intro...and this should work,
Sharing spreadsheet
Hi 11 weeks ago I was able to share a spreadsheet with colleagues by clicking the share tab and entering their user names in the box that appeared. This facility no longer seems available. How do I now share the new spreadsheet with colleagues. As we are a school it is the free version of of zoho docs that we use. Help please as this new spreadsheet is for the next 8 weeks and we have been using zoho for the last 2 years. Thanks Elaine
Spreadsheets- how to make gradients?
I wish to insert a row which is just a gradient bar, but see no way to do that with Zoho. Any suggestions?
protect cells?
when I make a spread sheet how do I protect cell that should not be changed (Calculated cells) ?
Percent glitch
I have a column with % format. If I enter say 15.15 in this column it will first do 1515 without the decimal. After entering a second time 15.15 it will stay correctly at 15.15%.
Sync with Excel
Zoho docs for desktop synchs my pdf and word files but not exel ??? Does this not work?
Excel with protected cells
Hello, I do not see the option to protect cells in the spreadsheet is this possible? When importing sheets protected cells, these go unprotected, should I do so that when importing an excel book not unprotect the protected cells?
Embedding Spreadsheets on vBulletin
Here is a link to a public spreadsheet I've tried embedding on vBullein. HTML is enabled for forum. I keep getting the "Sorry, we could not process your request" error message. Here is the link: http://www.bayoubucks.com/forum/showthread.php?t=44083 Here is an old link to similar documents that I've embedded in the same forum over the years with zero problems: http://www.bayoubucks.com/forum/showthread.php?t=8791 Here is the html code that is problematic: <iframe width="500" height="400" frameborder="0"
I have a problem when adding decimal on spreadsheet it keep showing 0.
Could it be possible to show me how to fix this problem.
File conversion from XLSX
I have attempted to upload a couple of XLSX files, allowing the conversion to the Zoho format in the process. I get error messages. The files are under the 10 Mb limit. The reason for the errors is unclear. I can upload the XLSX files without allowing the conversion, but must download them to work on them. I've looked for a way to convert the files, once safely uploaded as XLSX files, into the Zoho format, but cannot find how to do that. How is it done?
Revamped VBA Macro Engine
We have been supporting VBA macros for the past three years in Zoho Sheet. Last month we made a significant revamp of our Macro execution engine. With this update, your macros could run faster by up to 75% than before depending on what your macro does. Here is a spreadsheet which generates Vicsek fractal (box fractal) using macros. There are 4 different fractals generated in 4 different worksheets. Click on the 'Generate Fractal' button in each worksheet to generate different fractals. To change
Why can't I pass a concatenated string as the argument to a particular subroutine I'm using?
In the code below, you'll see that: 1. An event handler makes calls to a subroutine called "DebugMsg" that provides an easy way to turn on and off MsgBox statements used for debugging. 2. Whether or not the messages get passed to an actual MsgBox statement is based on the value of the constant "DEBUG_MESSAGES" *** For some reason, the one line of code in "CODE EXAMPLE #2" throws an error, but the two lines of code in "CODE EXAMPLE #1" work fine. As far as I can tell, they are functionally equivalent.
Macros not working
macros seem to be recprding.. but they dont run they cannot be edited in VBA and they are npt visible when you click on view Macros What is the problem? What can I do? Thanks for a fast answer Loïc
"The server has encountered an error. Please try later."
When I open ZOHO sheet(no collaborator), the sheet crashes around every 2-3 minutes with this message. I had used this sheet before, but its the 1st time that I have such this error. What should I do for solution? Kind Regards
Gridlines
Is it possible to hide the gridlines ?
Hiding Tabs
How do you hide a tab on a sheet?
Printing Options on Embedded Spreadsheet
I have editable spreadsheets embedded on my website. I see an option to download as a .xls, how can I get a print option to allow my members to print their spreadsheet after editing it? Thanks!
Equals function among different spreadsheets
Hello, In both excel and google spreadsheets one can pull a data from a cell in another sheet with an equals function. Is there a way to do this with Zoho sheets. Thanks
Old URL does not work
Dear Zoho Sheet Team I notice that all URLs have been changed, but the old ones generally are still working. There is an exception in my Folder entitled "Wild Flowers" regarding each of the 158 pages. The old URLs on the yellow buttons "Next", "Previous" etc work ok, but clicking "Index A - Z" gives an error message. I have to edit the URL to the new one and then it works. I have done this on the first 7 records. Before I carry out this task, can you easily rectify this and save me a lot of boring
How to delete a file
I am not well versed in using Zoho. I would like to understand 1)delete a file 2)How to make a file Read only for other viewers while sharing and 3)A detailed help access. Thank You Venkatesh
Error publishing calculated column.
I have noticed what I think is a bug with the Publish range feature. I have several columns that are dependent on the column next to them to calculate the difference in date between today and a date in that column. The range allows me to publishes the date fine but the column that is calculated from the date simply displays as #NULL! on the website where I have it embedded. Oddly, if I am logged into zoho on the same browser at the time, the correctly calculated elapsed times are displayed. Am I
Spreadsheet is locked can't enter data
I have an excel based spread sheet. I can still view it but can't enter new data. I can select a cell but when I type nothing appears in the cell. Any ideas?
Co-owner of sheet cannot see the publish options under the Share tab....
I'm trying to share a zoho sheet to a friend so we can both edit it, I also want them to have the ability to publish the sheet in case they want to change the range published. I've set them as Co-owner of sheet but they cannot see the publish options under the Share tab. Is there any way to share this option to them ? They can only see Share and Collaborators at the moment.. Thanks for your help !!
Set a entry limit
Hi All, We use Zoho to sign animals up for spay/neuter clinics. The problem is we have everyone wanting 9am appointments. Is there a way to disable, say the 9am appointment when it reached 18 or some preset number? Thanks
Next Page