Zoho Sheet inserts strange values while dragging down a formula
Dear Zoho Team, I've just made some experiments and can't figure out what's happening. I have a cell with a value '2011-01'. I drag this cell down by mouse and expect it would be something like 2011-02 (or at least 2011-02, as in OpenOffice by default). But it becomes '202 - yes, with that apostrophe at the beginning. Furthermore, if i have a value 2011-100 and the drag it down, everything will be correct, next cell will have 2011-101. First of all i thought it was related to date somehow. But
No Longer Able to Export Shared Sheet
About 6-8 weeks ago we no longer have the ability to export a shared sheet. When selecting File-->Export-->(Any available download type), the action does not respond. I setup the shared document for the owner and am currently a shared member. The document link is: https://sheet.zoho.com/open.do?docid=1323873000000006015
Script Error in MS Office Plugin
The pulgin doesnt work in excel or word. This is the error from excel. Any help?
Conditionally Displaying Columns
Can I conditionally display a column in list view? I only want to display the column if there is a value associated with it.
British date support
Hi, I find it particularly annoying that whenever I type dates Zoho Sheet insists in formatting them in US date format (i.e mm/dd/yy), even if I've set the date format to dd/mm/yy) - can this be fixed at some point please?
最好有筛选功能
少了自动筛选功能的话,是用Excel者不能容忍。
Office Plug-in not working from Excel - No response on File/Open command
I have an existing zoho sheet. from excel, after login, open Zoho Sheet has no action/no response. Originally i received an error message. But after several application restarts, no errors and no response.
running total
how do I setup a column which does a running total of another column?
INT does not round negative numbers down
I'm trying out Zoho to see if I can use it as a replacement for Google Docs. In trying to use the INT function to round all numbers down; it is rounding negative numbers up. The example shown in the documentation: https://sheet.zoho.com/functions#INT does not work. (It rounds -1.3 to -1 instead of -2.) This is breaking compatibility with another spreadsheet I'm trying to migrate over. Thanks!
displays negative
When a field is in euro and include decimal places, displays negative
Inserting a one sheet template into a multisheet Zoho sheet file
Is there a way to insert a Zoho Sheet template (one sheet) into a multisheet Zoho sheet file? When I try to copy and paste the template I have created into a Zoho blank sheet in a multisheet file, again it is inconsistent, the formatting of the template does not always come through. In an Excel file I can insert a template I have created, or move or copy a single sheet from one Excel file to another. Can this be done in Zoho sheets? Please let me know. Thanks.
Array Formulas in Zoho Sheet
Zoho Sheet now supports Array Formulas. An array formula is a formula that can perform multiple calculations on one or more items in an array. Array formulas can return either multiple results or a single result. They provide you with more power to your calculations in your spreadsheets. For example, the following spreadsheet uses Array Formulas. The formulas used are explained below the embedded spreadsheet. Here are the array formulas used: Multi-cell array formulas are used in the Current Price,
No formulas in exported sheet
I 've exported a sheet to xls, xlsx and odt and the formulas are not there - what am I doing wrong?
seguridad de las hojas
alguien me puede ayudar, con respecto a como podria proteger las hojas individualmente asi como se hace en el excel
How many days' history a sheet can maintain version?
Dear zSheet Team, How many days' history a sheet can maintain version? Is this value configurable? I see versions upto a few days only when my sheet is month's old. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
CALCULO DE HONORARIOS
HOLA ME PODRIAS ENVIAR UNO QUE SEA CON EL 11 % DE IVA POR FAVOR Y PODER GUARDARLO EN MI PC GRACIAS
User form error
Hi there In my spreadsheet I keep getting an error in relation to one of my command buttons attached to a user form. The error is: Unknown function or field: Show. However the command button and user form works perfectly on my Excel spreadsheet. Any ideas?
Copying and pasting a range from a Zoho sheet into a Zoho writer document
We have moved to Zoho Writer (instead of Word) and Zoho Sheet (instead of Excel). However, I cannot seem to copy (via highlight) and paste a specific range of a Zoho sheet into a writer template. It loses all the formatting. The only way I am able get something approximate using Zoho for the entire process – and this is not stable, it changes all the time – is to publish/embed using html from a Zoho sheet to an external site, and then in Zoho writer, insert it as html, Copying and then publishing/embedding
Set focus on today's date
In my sheet in column A I have a list of dates. I would like to focus on today's date on opening/viewing the sheet. I've managed to get this working in Excel using the find function/macro but I get an error in Zoho sheet if I try to use the same code. Here's the code that is working in Excel just for reference: Sub Workbook_Open() Dim FindString As Date Dim Rng As Range FindString = CLng(Date) With Sheets("Sheet1").Range("A:A") Set Rng = .Find(What:=FindString, _ After:=.Cells(.Cells.Count), _ LookIn:=xlFormulas,
Share difficulties
Zoho was great for a multi-sheet spreadsheet. I was excited at what it allowed me to do compared to google spreadsheet. However, perhaps I was expecting too much. I set permissions on five out of nine sheets and then it no longer allowed me to edit permissions. Is there a limite on the number of sheets you can do this for?
Sharing ZOHO Sheets
I am making a spreadsheet that I want my group to access and enter their information in weekly. Some of them aren't very good at computer work. Is there an one click link that will take them directly to the spreadsheet instead of having to go through the sign in and then find the spreadsheet? I would also like to protect certain cells so that they can't be changed. I can't find a way to do this. Is it possible or not? Thanks
How to Sync Zoho Spreadsheets with My PC?
I like to have my files ( mainly spreadsheets ) sync or backup automatically with my PC. How to do? How to keep an offline copy of my files?
Import names and email from Zoho spreadsheet into Zoho Mail
IS there a way to import names and email address from a zoho spreadsheet into Zoho mail
Question on how to use application to launch a browser with sheet open
Hi, We're trying to integrate the following feature into our C++ based application. We want to allow the users to click a button to launch a browser with associated Zoho sheet open in it. We used ShellExecute to open the URL listed below from the application with our apikey, but it didn't work. https://apihelp.wiki.zoho.com/Open-Document.html Can you help to tell us the URL we should use, please? If this is not the right way to do this. Can you tell us how can we achieve this goal, please? Any help
sort by color
hi team, zoho spreadsheets doesn't contain "sort by color" option. Which makes me, again,dependent on Ms excel for the proceedings.
Problems with charts and formulas
Hi, I have a sheet embedded in my website, as can be seen on the following link http://www.planfinan.com/home/planificacion-financiera-acp/modelo, all thoughts about work correctly and make any changes to the first sheet "data" the other results are updated with new values. Also the graphics values are updated, you can check to see the values of the graphs of the sheet "Rtdo_2". But the problem appears when we move from sheet to sheet in order to display other values. When we return to the graphics,
query on formula
boss talaga po bang magkaiba formula nung column ng 2010 and 2011 na "# of accts. under process by the branch"? paki check nga po.
copying a sheet from one workbook to another workbook
How does one copy a sheet from one workbook and merge it as a new sheet in another workbook?
Mass Upload
Hi I was wondering what kind of format I should use in Excel to upload properly when uploading leads. Leads example: Business Name address zip phone If I make it in this format will upload properly?
Missing documents in Zoho Sheet Chrome app
Some documents that are visible in the web-based Zoho Docs are not showing up in the chrome app. As far as I can tell, they are just regular .xls documents. srinivas
Unusable - Connection lost
Hi, I am using soho sheets online on Safari, and it is very unstable. with "connection lost" coming up every 10 - 20 mins, I do not have a problem with the internet. please fix this as when ever you click the re-open you lose all changes/data you made. there needs to be a fallback, that allows you to save the data should the 'connection get lost' cheers
您好,我有个很大的疑问!
为什么Zoho sheet 在导入表格后没能保持原来表格的功能呢?比如Excel非常好用 查找功能。现在导入之后却没有啦!拜托!为什么?
问题很~~~~
为什么Zoho Sheet的电子表格总是出现:“服务器出现技术问题,请重新打开文件夹后再试!”一直都用你们的这个软件,总是出现这样的问题真是太不方便了;而且有时候还不能记录,也有记录完了,第二天就不见了的问题,希望你们能完善一下,东西丢了真的很着急!!!!!!
Have a button Save As
Hello, I would like to have the button Save As for a sheet edited in Zoho Sheet. I used to have this functionnality in Zoho Docs, but now that I converted my sheets to Zoho Sheet, I am not able to do it anymore. Many thanks! Christophe Mendez | Head of Consulting Services
does not share sheets properly with my users
Hi. I am trying to use zoho to share grades with my students. Basically, I have made some score calculation sheets (the first few sheets) and then I have created an grade output sheet for each of my students with the remaining sheets I have made. After that, I tried to share one sheet with each of my students using the share function and their emails. However, whenever a student logs in to view his/her sheet, somehow other sheets that I did not share are shared automatically with the student. Consequently,
Insert rows messes up chart source data
even tho chart source data is locked with $ on ranges. inserting a row..causing the lower rows to fall out of the source data range.
Lock Cells!
Zoho, Google, and Microsft all allow you to share online versions worksheets, but don't allow you to lock cells or formulas from manipulation. Why on earth would this feature not be implemented before giving the ability to share? Is this a conspiracy?
editable
is it posible to have members edit the data via the embeded sheet on our webpage?
wonderful site
I would like to thank you for this amazing and helpful site and applications. It is worth spreading and sharing. I just wanted to say thanks and to make a note about a bug when importing the file as excel sheet the browser downloads a wrong file with a weird extension of (.do)....i hope you fix it soon. Greetings
Recien entro en sheet
mis conocimientos de la pagina electrónica, son del lotus 123, del año 1986, quisiera saber si me pueden ofrecer una guía para usarla ó como debo hacer?, muchas gracías
Next Page