Formula RECHERCHEV() doesn't work ?
Hello I am making a database and i need to index my data using the formula RECHERCHEV() who works on Office Excel and LibreOffice Calc. I am unable to use that RECHERCHEV() formula on ZOHO Sheet (give me #NULL!) I am not an expert but it works pretty well on Excel and i made the same formula. Can someone help me ? I can share the sheet it's pretty easy to understand what i want to do. Thanks.
HTML View not working since last maintenance
Since the website was down for maintenance on 27 April 2013 and now is online. The spreadsheet view can be seen https://docs.zoho.com/sheet/published.do?rid=9jhz5d5bcf0ce7a494a719fa5a81e5d98553c But the HTML view is not working https://docs.zoho.com/sheet/published.do?rid=9jhz5d5bcf0ce7a494a719fa5a81e5d98553c&mode=html Hope you can check for us. Paul M.
Problem with Dropdowns After Uploading
I have a workbook that was created in Excel with some dropdowns built into it. When I upload it to the site here the dropdowns no longer work. Am I doing something wrong? It is an .xlxs file if that makes a difference.
Unable to create a sheet document (without import) ..
Hello I am unable to create a sheet document here https://docs.zoho.com/index.do I am on |Favorite| > [All documents| Where i try to create an empty sheet i got a error page. How can i fix it ? please. Thanks.
Referencing a cell from another sheet
My workbook has multiple sheets. Each sheet has some calcluated totals in certain cells. The front master sheet has a list of everything that is detailed on the other sheets, with the totals. These could change at any time, so the totals need to be references to the other cell's value, not a fixed number. So on the master sheet, I put in =, then go the other sheet and choose the cell and hit Enter. In regular Excel, this works. But in the Zoho sheet, it doesn't work. I have to edit the result by
embedded sheet not displaying info in field
www.ranchsortinginfo.com Have embedded code on the above site. I only want one cell with an amount in it and wish to display only that cell. I have reduced the code to read: The cell info is $1.94, but displays blank on the website. <iframe width="150" height="75" frameborder="0" scrolling="no" src="https://sheet.zoho.com/publish/palominopropane/ppg"> </iframe> Any help or suggestions appreciated. Amy
can't split cells
Merging cells works OK, but splitting doesn't seem to work at all. Anybody else with this problem? Any help? Thx
formulas
how do i apply function noyes
Office Plugin not saving VBA code?
Hi, I just installed the Zoho Office Plugin, opened up Excel 2000 (which as advertised it does work with), created an Excel file including some VBA code, saved the file locally, then used the Zoho plugin to Save the workbook. I then closed Excel completely. I logged into Zoho, went to my Documents folder, the Excel file was there. I then used the downloaded icon to download it and open it as an XLS file. It opened fine, but when I checked with Alt-F11 for the code, Module1 was not there nor was
UK Date Format
It's been a long time since I last asked the question but still don't a see a solution. Is it possible to enter dates in UK format? i.e. 3/1/10 means 3rd January not 1st March
Autocalculating of the cell "address" doesn't work with complicated formulas
Dear Zoho Sheet Team, I have a (simple) forumula: =IF(C5="*";CONCATENATE('from ';b5+2.5);b5+2.5) It works fine. But when i try to "pull" it by mouse to the end of the column it isn't being autocalculated/autoupdated. So it always the same, but must be something like: =IF(C6="*";CONCATENATE('from ';b6+2.5);b6+2.5) =IF(C7="*";CONCATENATE('from ';b7+2.5);b7+2.5) etc. Thank you.
adding and configuring Comments in Zoho Sheet
how can I make my comments in Zoho Sheet visible all the time?
Why is it impossible to make a sum function
Hello Zoho Team, I've created a spreadsheet and it is impossible to use the SUM function! Could you help me to solve this problem please? Thanks Fabien
User defined cell format works wrong
Hi, As far as i can see, you still do not support different document locales (such as Russian), so we can't enter date and time in our local format. As workaround, i added a user defined format 'dd.mm.yyyy'. It works fine, when i select already entered dates and change cells format. However, when i format empty cells with that format and then enter date like '03.05.2013', Zoho Sheet makes it '05.03.2013'. How can we eliminate that behaviour? Users do not understand they have sometimes enter dates
Pivot Table scroll isn't working
There are two vertical scroll bars on the Pivot Table page - one inside the Pivot Table and one for the whole page. Neither scroll bar is working. Also, the table is missing some data.
Selecting Cell Problem
Hello, For the past two days, when I go to select a cell on my Zoho Sheet, it automatically selects one that is 2 cells down from the one that I want. I keep having to arrow up to get the one that I intended on selecting. Please help. Thanks!
Unable to Save Spreadsheet
I am constantly receiving the below error message when trying to save a spreadsheet whether from work or from home. This has been occurring for the past several days but also occurs intermittently since we've started using this product the end of last year. Error: Unable to save. The document exceeds the prescribed size limit (i.e., 65536 rows and 256 columns per worksheet or 1 million cells per workbook). Please reload the document to continue working. The data entered in the last few seconds
Drag-Copy multiple cells with CTRL increments Date
Hi Zoho - great suite of applications and for free! Superb. Basically, I expect Sheet to behave like Excel - I hope that's not "wrong" as such? One thing I can do as expected is to select a cell with a date in it and then "drag" the bottom right corner of the cell down to fill in the cells below. When I do this, the date increments by 1 day for each cell. When I hold down the "CTRL" key while I'm doing the drag, the date does not increment. This is good. HOWEVER Unlike Excel, when
sheet vba http request
I saw a blog post from a couple years ago about adding http request functionality to Zoho sheet vba scripting (https://help.zoho.com/portal/en/community/topic/revamped-vba-macro-engine). I couldn't find any documentation on it currently, has it been implemented or is it still likely to be added in the future? It would be really fantastic if it is - it would add a lot of functionality for me.
Header/Footer
Hi, I've imported an .ods file into zohosheet, but I can't see where, if at all, I can modify the header/footer. It seems like you do recognise the info and preserve the data, since if I export it back to pdf it is still visible. Thanks, Marko oo
There is difference in results of YEARFRAC formula
There is difference between Zoho Sheet and Microsoft Product in results of YEARFRAC formula. You can download a test file from this site(http://plugtest.opendocsociety.org/doku.php?id=scenarios:20100415:yearfrac) and result is this(http://www.slideshare.net/slideshow/embed_code/16726545?startSlide=30). I do not know which one is right but there is difference.
how to add 7 days to a date?
I update a spreadsheet weekly and would like to write a formula that says "add 7 days to the date in cell c2" How would I do this?
adding days to a date
Hello, I would like for a cell to be the result of adding 7 days to a different cell. How can I do this?
Downloaded PDF file does not have pdf extention
When I want to print a sheet, I download it as a PDF file. It downloads on my desktop without the proper pdf extension. Everytime I have to rename the file - add the pdf extension. Anything I can do about it?
How to remove email address underlining?
How to remove email address underlining in a sheet? I already tried to remove hyperlink, to remove formatting. Nothing works.
Page loads to embedded sheet not at top
I have had for some time a Zoho Spreadsheet embedded in several blog posts on my Wordpress web site. Recently, I noticed when a post containing this sheet (actually, any Zoho sheet, I tried a few tests) is viewed, the page momentarily loads properly, then it skips down the page to the sheet. I see that this occurs in Firefox, Safari, and Chrome, but not in IE. It also occurs in different recent versions of Wordpress. This appears to be a Zoho problem. I have other posts that use iframes (one a Zeemap
Please Help
How can i save my excel file on the embeded file from my blog
[How] Synchronized ranges on different sheets
For example, I have 3 sheets. Sheets 2 and 3 have an own table per sheet. On the Sheet 1 I want to have both these tables and it have to be synchronized. For example, when I modify a cell in the Table of the Sheet 2 - It also modifies in the table on the Sheet 1 (which includes 2 tables from Sheet 2 and 3). Otherwise: when I modify cells in the table on the Sheet 1 - it modifies in the table of the Sheet 2. Do you have such feature now? If not - Are you going to do it?
Can I duplicate a document
can I duplicate any of my documents into a new one and then edit it from there? If so can someone tell me how? Thank you
Problem in Export of Zoho Sheet into Excel
Im not able to export the data from zoho sheet into excel. I need the data urgently pls help.
Error Occurred alert when attempting to open Sheet document
When I click on the link for any saved Sheet document, the sheet does not load and following error message appears: Error Occurred Zoho Sheet Error Occurred Problem while Opening the Document Creating a new sheet, saving it, and attempting to open it gives the same error state. Hopefully this will be resolved soon. KM
How does (or why don't) AND(...) work with/as an array formula function?
Note: Gnumeric and ZOHO Sheet works the same way so there could be a good reason for it. Say we have two collums with a x and y patttern x x x y y x y y Add the same pattern 3 times to get some data. Lets say we would like to count the rows containing x in both columns. I did expect this formula to work: =SUM(AND($A1:$A12="x"; $B1:$B12="x")*1) (Finish with CTRL+SHIFT+ENTER to specify array function). But it does not and returns 1 rather than 3. A formla that works is =SUM(IF($A1:$A12="x";
edit sheet using api
Hello All. Sorry for my bad english. Please point me in right direction to find out how I can edit own Spreadsheet using Zoho API. Zoho API Guide contain API's to share, download, upload, list, get content etc but not Edit. I tried download sheet, modify and upload it back, but it stores with different ID and do not replace target sheet. Thanks for your time.
Can Not Export
Hi, I have used this product for about two years now. I had setup a sheet to be shared with multiple users, using the ability to grant permissions per sheet so that users can only update their individual sheet. I see that this feature is no longer supported for new sheets, but my current sheet has preserved the original permissions. However these users do not have the ability to export/download the sheets to their local PCs. If i change everyone's permission to Read/Write, they can export
Looking for Sheets user guide or help file
Can't find help anywhere for Sheets. What have I missed. Where should I be looking. Thanks
Unable to retrieve price for several stocks
Hi there! I am given to understand that Zoho sheet uses Yahoo Finance as its source data. Accordingly I use the STOCK symbol to retrieve data. It works for some stocks such as stock("niftybees.bo") and returns correct data. But I have not been able to make it work for others such as STOCK("HDFCTOP200GR.BO"). This stock code is available in Yahoo Finance but in Zoho sheet it says Invalid symbol. Please let me know what I am doing wrong or how else to correct it. Thanks.
Line Chart - y scale or range
Hello, I have data in a small range between 45.5 and 46.25, with two digits after the point. If I plot it in a line chart, the lower border is adjusted accordingly to 45.5, however, the upper border will be fixed to something like 48.5. Due to this behavior, the peaks in the data are less visible than they would be on a smaller scale. Is there any possibility for me to either adjust the scale of the y axis, or its upper limit? Any help will be greatly appreciated. Best Regards, Jenny
Kindly need a macro to find a certain cell
Hi, I have worked with macros in Excel, but usually rely on taking an existing macro and modifying it to my need; I am not good enough to write one from scratch yet. I'm wondering if anyone would be so VERY kind as to show me the code needed for this simpe function: GIVEN: * There is a cell in column A that displays the text "TODAY". * The row in which "TODAY" is displayed changes every day, but is always in column A. MACRO DOES THIS: * With the user-selected cell starting anywhere on the sheet,
See only first 30 rows.
I can't scroll down. I can see only the first 30 rows of my data. This is new problem I found. Please correct, and get my all data back.
Published range, no line between cells
Hello and thanks for this very useful app! Question is, I use a published range (iframe) as our organization's calendar -- http://www.ruhaniat.org/index.php/2012-06-04-19-59-45 When I look at the sheet in sheet.zoho.com there are fine border-lines between cells. But not when viewing it in as published. There's nothing separating the cells. Is there a way to make the cell borders visible in the published view ?? Thanks -- Howard Ballinger
Next Page