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
Worksheet_FollowHyperlink does not work
Rem Sheet Module Option Explicit Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Select Case Target.Range.Value Case "Insert After" MsgBox Target.Range.Value Target.Range.Offset(1, 0).Select Selection.EntireRow.Insert Me.Range(Selection.Offset(1, 0), Selection.Offset(1, 0).End(xlToRight)).Select Selection.Copy Target.Range.Offset(1, 0).Select ActiveSheet.Paste Case Else End Select Target.Range.Select End Sub
Sorting Ignores Frozen Panes
I have a sheet with the top row frozen, but when I sort on a column it re-sorts my header row in with the rest, freezing a new row instead. I'm sorting by right-clicking on the column header and selecting 'Sort Ascending'. The expected behavior is for sort to ignore the frozen row and only sort the other rows. I can't figure out how to get it to not sort on the header row and mix up my headers with my data. Please let me know if there is a workaround.
Problem with using € - defaults to a minus figure!
Hi, having problems using the Euro symbol. I need a formula to calculate 15% of a figure i.e. €188*0.15 but it keeps coming up as -€28.20. Any ideas/suggestions for rectifying this would be great, Thanks
Can we sort rows 25 to 30 based on ascending order of column K
Can we sort rows 25 to 30 based on ascending order of say column? I tried I could not do, any idea??
Office Plug-in Issues
I can log in to Zoho via the Office Plug-in, but am unable to Open any documents either from Sheet or Writer Save documents to Zoho Add to Zoho Publish in ZohoThis has only started in the past few weeks.
Need help on how to automactically refresh after user logs in
Hi. I have created a spreadsheet and then shared with a select number of people. Then, I embedded the shared link for the spreadsheet in my blog. When the other people go to my blog, they can access the spreadsheet privately by logging in using the embedded section. However, they get a continuous loading message and cannot see the sheet shared with them unless the users click refresh. Is there someway I can get around them having to refresh after logging in to view the sheet I shared to them privately?
Sheet/column/row/cell language and locale
Dear Zoho Sheet Team, As far as you might know there are lots of languages and locales around the world. Not all of them use period as decimal part separator. For example, in our native language (Russian) the separator is comma. We are facing big problem with locales in Zoho Sheet, especially while pasting/coping data to/from. THere are no any clarifications/explanations. I have some question: 1. What is the default locale for just created file ? How is it calculated? 2. How can i change that locale?
Can't obtain interactivity on uploaded spreadsheet
I have developed a interactivity tool using a spreadsheet... it works in excell but on uploading to ZOHO it does not... why? As a complete newby if I achieve loading to ZOHO and it appears to work, what name or location do I use to let my friends find it on the web?
Share and collaborate in real time does not act
Share and collaborate in real time
How can I hyperlink from one Zoho Sheet to another?
Dear zSheet Team, I would like to hyperlink from one Zoho Sheet to another? Both of them are private ones. For my internal reference I need to have them linked. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
HYPERLINK function is urgently required!
I been using other Web2.0 spreadsheets that have Hyperlink function as I need links to be displayed as a text word link "More" etc. However, I am very disappointed that Zoho Sheet does not have any function like this. Please confirm when can this function be available as I am in the middle of deciding which Web2.0 to use for a major project. Thanks. davealviso
Linking Cells
I just heard about ZOHO and signed up mainly to try out your spreadsheet. I haven't been able to find any way to link cells, either between modules or between sheets. I have not been able to check all user comments and queries, but for me this would be a major problem. ws41edge
How do you place hyperlinks in cells?
Dear zSheet Team, Please help clarify how to hyperlink a cell to another sheet/cell in the same workbook or another workbook. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Importing Hyperlinks from Excel
I imported a sheet from Excel that contained Hyperlinks. They are not displaying properly in Zoho, they all display "REF#" in the cell, and the cells contain "=HYPERLINK("[link text]";"[display text]") Is there any automated way to convert these links to be readable by Zoho? Is there a Macro that you can give out to convert these links?
Zoho sheet
gibts ne möglichkeit textmarken zu setzen um mittels hyperlink zwischen Tabellenblättern oder Zellen zu springen? Gruß Jens
Zoho sheets not functioning in IE
Over the past few days, certain spreadsheets are not functioning in Internet Explorer (any version). The sheet hangs when trying to load, and fails. However, it will work in all other browsers like Safari and Firefox. The problem is the same with several shared users when using IE.
sharing spreadsheet
Hi, I've created a spreadsheet template that I wish to share with some of my colleagues. However, where the share button is normally, I just see a publish button. I do not wish to share with everyone, just the staff that I invite. Can someone help? Thanks, Karen Latremouille
Gerer fichier avec sécurité
Bonjour, Je souhaite savoir si, via l'option "Liez les données externes" dans une feuille Sheet, on peut lier des données situées sur un serveur dont l'accès est protégé par mot de passe. Et donc le cas échéant quelles seraient les modalités d'insertion du mot de passe ? Merci d'avance de votre retour.
New Features: Repeat Last Action, Insert Cut/Copied Rows/Columns and Hyperlink
You might have noticed the constant updates to Zoho Sheet of late. Here are 3 more features that have been added to Zoho Sheet recently: F4 - Repeat Last Action Insert Cut/Copied Rows and Columns Insert Hyperlink Here is a screen cast demonstrating each of these features. Read further below to learn more about these new features. F4 - Repeat Last Action: You can now repeat the last action you made on your spreadsheet by using the keyboard shortcut, F4. It is quite handy and helps you get your work
Buttons not saved
SOS Dear Sheet team I inserted a range of buttons into my "Plants" sheet. They all disappeared. Every time I inserts buttons they have disappeared when I close and reopen the sheet. This does not happen on all other sheets. Please help quickly. Many thanks Hans
电子表格链接外部数据时有问题
当我链接imdb网页时提示无法解析给出的URL， 请用其他URL重试。 http://www.imdb.com/chart/top 开始我以为是被屏蔽了，无法链接，结果用tor还是这样 而且我直接换成IP地址也不行 http://72.21.203.211/chart/top 这些都可以在网页中直接访问，但链接数据时都提示无法解析给出的URL
Append ONLY
Hi, I wish to upload a spreadsheet, and allow anyone to view (READ). However, when it comes to WRITE access I want to restrict WRITE access to simply APPENDing further data to the spreadsheet, but not to edit existing data (however it would be very useful to be able to add notes to existing data). Is it possible to restrict WRITE access to appending only? Can this be done with a Form? TIA
Next Page