Sorting in published range
Hello, I'd like to ask, if there is some way to allow visitors of my web to sort / filter my embed range of cells? (I don't want to publish whole document, but only some cells)
Freezing
I can not find the "freeze" function, so I can freeze titles in rows, etc...
Vertical merging
Is this possible? ajbfca
Conversion from excel to zoho during upload does not work
when I try to upload an excel 2010 xlsx file, the conversion into zoho sheet format does not work, and consequently I cannot view the uploaded file in the preview. when I repeat the upload now with a much simple excel 2010 file (less functions etc) it works Q: are there any known features in excel that prevent zoho to perform the conversion ? Thanks, Achim
Buttons in frozen row area
If we could put Buttons in the locked/frozen row area we could create a simplified macro menu system
Can't Update Spreadsheet - Says "guest present on the spreadsheet"
When I log into Zoho Docs and go to my spreadsheet in the bottom right it reads "guest present on the spreadsheet" and won't let me edit or update any of the cells on it. I have no idea how to update the spreadsheet now? Any ideas?
How to make a horizontal spreadsheet into a vertical spreadsheet
I'm trying to change a long Zoho Sheet from a side-scrolling (left to right) to an up-and-down scrolling sheet. Does anyone have suggestions for how to do this? Thanks.
Pie Chart
How are labels inserted on the pie chart legend?
where are the comments???
Hello. I just converted a google doc sheet to Zoho Sheet (originally was an Excel file). I can't find a comment that was in the google doc sheet. Where did it disappear??? Thanks a lot, Lior.
How to alter row heights
Hi, I am unable to find a way to alter my row height. Can someone help me? Thanks, Jay
Est-il possible de protéger des cellules?
Bonjour, Est-il possible de protéger une cellule ou une plage de cellule contre l'écriture quand une feuille est partagée?
New Features in Zoho Sheet: Editable Public Spreadsheets, Collaborator Presence Revamp and Formula Reference Toggling
Recently, we have made the following enhancements to Zoho Sheet which will enrich your experience. Editable Public Spreadsheets Collaborator Presence and Panel Revamp Formula Reference Toggling Editable Public Spreadsheets This feature lets you share the spreadsheets you create using Zoho Sheet publicly on the web with password security. You could use this feature even with users who haven't yet signed up with Zoho. You can avail this feature from Share settings. Once you decide
Bug in Custom Format for Date
Hello, good night! I'm facing some problems in Zoho Sheet, while trying to format automatically dates in my sheet. Here in Brazil we use the format dd/mm/yyyy...that's what I chose as custom format for my sheet. But if I insert January 2nd, for instance, typing 02/01/2015, Zoho atumatically changes it to 01/02/2015...and thats February 1st. I don't know why these changes occur. I've typed 24/12/2014, for instance, and it doesn't change to 12/24/2014. Can u help me please??!
I can´t open Zsheet files in Google Drive
Today, I can´t open Zsheet files in google drive. Zoho put a command line in the navigation bar, but the documento don´t open. What is happening with my file?
Zoho Sheets -- copy and paste of a single cell causes entire sheet display to refresh when doing the paste
I am working with s 13,000 row spreadsheet. When I right-click on a cell and select Copy and then right-click on an empty cell and click Paste, the entire spreadsheet disappears for a second or two and then reappears with the formerly empty cell filled in. The refresh of the display is unexpected and surprising. Is this a bug? Is there something I could do to stop this from happening? Thanks.
Need to read a zoho sheet document on Excel
I need to read a Zoho document on Excel and to have data updated currently. I've tried to use the HTML published version of the document https://docs.zoho.com/sheet/published.do?rid=ctdnu07c9dce2917b400e9ce0e918759ee098&mode=html Same way I've used to do with Google docs, but it had not worked. How could I have the data updated on Excel? Is there a way to have the file published on a CSV format? Best
Freeze more than 5 Rows or Columns?
I'll bet I'm not the first to ask: Why can't we freeze more than five rows or columns? There are some times when it would be VERY helpful to be able to do so. Or is there an upgrade version that allows this? Thanks, Greg
Tracking down Spreadsheet Errors
Hello, Does Sheets offer Formula Trace other feature to assist locating errors in a formula? I have created a complex sheet and am off by a small amount making it difficult to locate my own error. Thank you Davd
Cannot change cells in embed sheet
I have zoho sheets embedded in my blog and I can no longer change cell value in the cell itself. The only way to change the value is to go to the formula bar at the top. Thanks, Shayne
Today Function not working
The today() function is not loading the current day when the sheet is loaded. It is loading the date when I entered the today() function. Thanks, Shayne
Error in Today Function
The today() function is not loading the current day when the sheet is loaded. It is loading the date when I entered the today() function. Thanks, Shayne
pivot tabel
Cant create a pivot tabel any one knows what i am doing wrong??
Pivot tabel
Hi! I'm trying to do a pivot tabel and i cantdo the pivot because it always appears this error: your edit is not applied to the document. please try again later. does any one knows how to overcome this problem??
Goal Seek through VBA
I was wondering if it was possible to run Goal Seek through VBA. I have tried writing it as I do in Excel and it doesn't seem to work. If it is not supported yet, are there plans to support it? Thank you.
Automatically Move Cursor from Left to Right
I am using a Barcode Scanner and entering Data. My Data Needs to move from Left to Right when each part is scanned. Can I do this in Zoho? With Excel you go into options and select the direction you wish the cursor to move. New to Zoho. Thanks for the help.
how do I do procentage
how do I get de sum of a procentage
Unable to open xls files
Lately, I've been unable to open xls files. This issue is also present with Google Sheet.
Customers report cannot see iframe content
I have started getting reports over the last few weeks that people cannot see the iframe inserted on a page. I insert my on a website using the publish range and insert the iframe code, so I can update the prices within zoho. This has worked OK for years, but recently people are saying they can't see the iframe, and they seem to be increasing numbers. Sometimes Safari, sometimes Internet Explorer, never Chrome and it works OK on iPhones and iPads. Has something changed? Is anyone else having this
How secure are my hidden formulas?
Hello, I am writing a spreadsheet to be shown on a wix website that uses confidential formulas that cannot be shared or viewed by anyone, including (for safety sake) zoho. When i use the hide formulas function, how secure is this? and what happens if the hidden function is down for a day or so, will by formulas be available to see? also will they be able to be viewed by Zoho programmers or employees? Thank you for your support!! -Kenneth M.. Brooks III
Unable to Move or Copy/Paste a merged cell
Hi, This issue started this morning across all users of our Zoho Sheet Workbook where we cannot move a merged/unmerged cell from one cell to another. Even Ctrl+C and Ctrl+V copies over the colour of the cell and not the text itself. Prior to this we would just hover over the outline of the cell and drag and drop it in to the desired location, however this does not work anymore. Please advise of fix for this. Thanks
offset not work ?!
https://docs.zoho.com/sheet/ropen.do?rid=1d772438222c67af6465785f486b2b4b34025 in excel column MEDIC work with this formula Data Validation =OFFSET($AD$2;MATCH(C3;$AC$3:$AC$138;0);0;COUNTIF($AC$3:$AC$138;C3);1) in zoho not work :( pls. help!
ipad and smartphone users can't edit the spreadsheets I share with them
I have set up a spreadsheet in Zoho Docs for members to input data. They all have read/write privileges: using windows browseers users have no problem entering data in the cells, but using the apple ipad users cannot input data, they only get a viewer mode when they access the shared file. How can I solve the problem, so that apple ipad users can also input data into the spreadsheet? Thanks for your help! Edit: Not just an ipad problem: Users also cannot modify the sheet using smartphones with Firefox
Copying data from one sheet and pasting it onto another sheet.
Hi I have quite a simple requirement. I receive data in the form of a spreadsheet which I open in Zoho sheet. I have another sheet which has a number of tabs pre formatted and are used as reports. All I want to do is to copy the data from the first sheet and paste it into the second sheet. From there I can manipulate it. I can copy and paste between 2 tabs on the same sheet but can not workout how to do it between 2 sheets. On my pc I can happily copy and paste between 2 excel spreadsheets. I am
unable to copy & paste between doc earlier today
I have no problem to transfer information within the same document. However, I couldn't copy information from Doc. A, then paste to Doc. B... I don't have this problem until earlier today. I asked around, none of my friend could copy & paste info between 2 sheet doc. any more. Would you help to solve this problem? Thanks
Problem with shareing Excel files
Hey, I'm trying to share excel files with another Zoho user. I share file entering another user's email, then it gets confirmation and notification. Also that file becomes visible, but after shared user refresh Zoho docs dashboard page, that file disappears and it is not visible also in "Shared with me" folder, also in another folders. How to solve this problem? What do I do wrong? Thanks.
i can open any folder in my account
hello since yesterday i can open any folder in my account it shows "loading" .... and nothing happens i am alone like this ?
Cannot open my folders ...
After click the folder(s) I chose, it showed "loading" for a long time, and just that ..... I tried to use other computers, and they were the same.
Unable to scroll down on my sheet on IE8 and windows XP
Hi there since the upgrade to zoho i can still access my zoho sheets ok, however, i am unable to scroll to either side or up and down to access more of the sheets. I seem to be able to do this from my home computer so I assume it is a compatibility issue with IE8 and windows XP? as i am not an administrator on my work computer I am unable to upgrade to IE9 or switch over to firefox etc. Will this issue be getting resolved at some point? Cheers
Forms in spreadsheets
Hi, I need to enter some data and show results by querying that data. For that purpose is it possible in zoho docs to create a form in spreadsheet? Kalpa Pathum Welivitigoda http://about.me/callkalpa
Allowing anonymous users to add data to a spreadsheet possible?
Hello, I want to create a simple list of data which is then filled by lots of people e.g. an adress list, none of them have zoho accounts, so technically their are anonymous. Is there a way to do this? Currently all I get is a published page which is write protected. I have no idea how to turn the write protection off
Next Page