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
Private view for filters
I've been trying to choose between EditGrid and Zoho for a business need here. Zoho is great, as it is being supported and is developing over time, but there are a few features I'd like to put on the request list: 1. Private view for filters. On EditGrid, if one user filters, only that user's view is changed. So different users can filter differently depending on what portion of the spreadsheet they are working on. In Zoho, it appears that if one user filters, all users get that same filter,
Printing problem
When I try to print a sheet it only prints part of the page.
Sheets duplicated and lost
Several of my sheets have been deleted and many are now mysteriously duplicated. Can't seem to determine why this happened but I'm concerned a lot of my data over the last few months is gone. Can you please help asap?
A couple of small points
Dear Zoho Sheet Team I have been accessing my sheets happily through Zoho Docs, but suddenly I can't any more! What's the reason? The second point is that the public URL doesn't let itself copy any more! Look forward to hearing from you. Kind regards Hans
Opening sheets
Hello How do I make sure the tops of my sheets are displayed when opening? Many thanks and regards Hans
How do I sum the values?
I have the following table, I need to sum the values that match three criterias, for examble sum the total revenue of all deals that will close in november, are in forecast in the IS territory. Is there a formula for such thing. In Excel I used a sum(if... but i can't seem to embed this formula here, and in google docs the sum(filter... works. WON YTD setiembre octubre noviembre Total Forecast #REF! #VALUE! #VALUE! #REF! IS #REF! #VALUE! #VALUE! EA #VALUE! #VALUE! #VALUE! Upside #VALUE! #VALUE! #VALUE!
Link to my public zoho spreadsheet.
When I navigate to my public zoho spreadsheet in I.E. the page begins to load but then goes blank. However, I can view it in print view as well as html view. Although it does work on other browsers, IE is the one we most often. Any thoughts/suggestions on how to fix? fyi the link is: https://public.sheet.zoho.com/public/e_moran/field-crew-board-1
Zoho Sheet will be redirected to Zoho Docs
In a step to unify and showcase the office apps under one common web address, Zoho Writer, Sheet and Show will all be accessible from the Zoho Docs URL: http://www.zoho.com/docs, starting Nov 23, 2012. As soon as you sign in to Zoho Docs, you will land at the Zoho Docs Explorer, which lists all your files. You can open your files from there, create new spreadsheets, or upload your existing spreadsheets. You can create folders and organize your files better. Learn more about Zoho Docs at http://www.zoho.com/docs.
Product Enhancements
Zoho Sheets is a great product, but for me and many others it would be materially enhanced if I/we could: hide and lock particular columns/rows/sheets, rather than just hide and lock formulas (this is crucial) improve the presentation of embedded spreadsheets by giving the option to remove column and row headings and scroll bars. Thanks!
Regular problems with saving files
Dear Zoho Sheet Team, Our users have been complaining about problems with saving sheets for years, literally. I can confirm the problem still exists. Usually it happens with "not imported" files, those which users just upload in native format (MS Excel, for example) and edit them online. They get problems regularly - one user add something, saves file, then other adds and first user lost his changes. That happens time to time in many files. I reported you a problem with document where you can check
how can i create thick overall borders
I can find thick bottom, but cannot find thick other borders. In most cases, I want an overall thick borders - top/bottom/left/right. How can I do it?
Tex formulas into ZohoSheet
I need insert Tex formulas from ZohoWriter into ZohoSheet. Can you help me, team Zoho? Please, thank YOU. Very good job.
Worksheet_Change event not firing
No matter what sheet I try it on, the Worksheet_Change event never seems to fire. For example, if I put some simple code in a macro and run it, it executes fine, but if I put the exact same code in the Worksheet_Change event, it never executes. If I do the exact same thing in Microsoft Excel it works fine. What am I missing? Jon
Sheet tabs not showing at bottom of workbook
I have a workbook with two sheets and there is not a tab at the bottom to toggle between them.
I want everyone in my group to be able to make changes on the original sheet, so everyone know what is left in he inventory. Does anyone know how to change "saving" parameters?
Below is the warning I get when I open this sheet!
Can't scroll down on iPad
Hello I Can't scroll down on my sheet via the iPad app or mobile site I can only see to line 51 and cannot scroll down. How do I scroll. Thanks
User-made Buttons disappear when Freeze Panes is selected
I have created some buttons that fire VBA Macros. If I select Freeze Panes, buttons in the "Frozen" area disappear, but buttons in the scrollable area stay visible. Selecting Unfreeze Panes, the buttons are again visible. I want to keep the buttons on the screen at all times, and they will scroll off the screen if I place them in the scrollable area. Obviously, I don't want to have to keep Freezing and Unfreezing Panes, or scrolling to the buttons to use them. Any assistance is appreciated!
How do I get everyone in the group to be able to change/update on the original sheet?
As you can see I get this Note: at the top of the sheet (see below screen shot) I want to let all the leads be able to change the original sheet! Is there a way to to that?
multi-user views change when one person filters - how to avoid this?
I have 6-7 people that will be looking at shared sheet - but when one of them uses a filter, then everyone's view changes to that now filtered view. I suspect no way of avoiding this - but hope someone may have cheeky way to address this? Perhaps having a sheet per user, but then how to ensure that data is consolidated amongst all sheets? Any other ideas? Thanks.
Error in HTML view (Share - Public)
Hello! I created a document. I shared it (Share - Public). Link in html view - https://public.sheet.zoho.com/public/romarast/astra-price-podushka-grechka?mode=html But, row 52 duplicated in HTML-view. This happens with any document in html form - an error in row 52. In Normal view (https://public.sheet.zoho.com/public/romarast/astra-price-podushka-grechka)- everything is ok. For example, a document other guy also has error in row 52 - https://public.sheet.zoho.com/public/dadash2525/dgs-2012-sirali-liste?mode=html
date format problem
您好! 目前提供的包含星期的格式只有: " 星期二,八月15, 2006 dddd, MMMM dd, yyyy ", 但当我选择此格式后日期显示为英文: Wednesday, November 07, 2001 但选中单元格,值为: Nov 7, 2012 问题1, 为什么会显示英文日期? (我已在个人信息中设置时区为中国 东8区, 地域为中国) 问题2, 能否让其显示中文 日期,如 二 11月6日 2012年 建议1: 对日期增加 自定义显示格式 ,便于使用者根据需要显示.
collaboration
Is there a way to collaborate (edit and save) without logging in into zoho? Like google has encrypted URL that anybody can access without login. I need sheet solution for my wiki
Cannot inport Excel files in Sheet?
Help! Cannot import Excel file(s) in to Sheet. What's up?
De-duplication
Is it possible to remove multiple rows at once? Example, If i have my master database of contacts uploaded to Zoho sheets, and I want to remove any unsubscribers on a weekly basis, can i do this in an efficient way? So say i want to remove 100 random (but specific) rows at once from the worksheet, is there a simple way to do this? I normally do this in Access and run what we call a De-dupe - But im looking for an online solution and I dont want to have to upload a fresh database every week - I need
Cell Colors
How do I find out the color code of a cell? For instance, I need to know the color code (RGB) of the blue background in my bird register. https://sheet.zoho.com/open.do?docid=795532000001417485 Thanks for the information. Hans
How to delete a row?
There used to be an X button in the menu to delete a row in Sheets. It's gone, now there's an Insert menu but I can't find any way to delete a row. We use Sheets to manage weekly orders and need to delete and move info a lot. We can copy and paste the cell contents but are now left with loads of empty rows we can't get rid of - we tend to have blocks of 10-50 rows to delete at once. Any help?
Collected Images
Hi Is it possible to sort the collected images. I have about 900 and find it time consuming and boring to scroll through all these to find one collected before. Any ideas please? On the same subject, I assume if I delete collected images I will delete them somewhere in my worksheets; am I correct? Hans
Zoho Sheet 3.0 - New User Interface, Filters, Conditional Formatting and More
We are pleased to announce the release of Zoho Sheet 3.0 with a host of new features. https://sheet.zoho.com The first thing you will notice as soon as you login is the user interface revamp. Zoho Sheet has undergone a major facelift and is now consistent with our word processor, Zoho Writer, and our presentation software, Zoho Show. We now have what we call the MenuTab, which is a combination of Tabs, Menus and Toolbars. To open your existing files, you will have to click on File and then choose
import excel spreadsheet macros update button dont import
I have a pretty simple spreadsheet that allows a pull-down to select values for a few cells cells and an update button served by a simple macro to recalculate the spreadsheet. Importing the spreadsheet does not seem to pull in the ability to pull-down and select the variable cells nor does the update button even appear or appear to have been included in the imported content. Is this what I should expect? any thoughts on why this might not work correctly?. NO error messages . It just does not
Embed options for Zoho Sheet in webpages?
The embedding method of sheets with iframes is cool, but are there any way to pass some options or parameters when I fetch the sheet? Sometimes it's good to let the viewer see the traditional view of a spreadsheet, but other times I really just need the functions and not the rest... It would be nice to pass options for: Sheetname/link - visible|hidden Column/Row headers - visible|hidden Scrollbars - all|vertical|horizontal|none Singlesheet - Able to select specific tab in sheet
Does Zoho Sheet include Forms?
I have it in my excel 2003 file, its when i click on a button a popup comes of of a bmi calculator. I think its some kind of VBModule or something. here is a pic of what it looks like in excel 2003
Two suggestions for Zoho Sheet
1, There should be a way to clear the contents of a row without clearing the formulas in the cells. Is there a way to do that? 2. Excel and other spreadsheets have a way of creating a dataform for entering data into a spreadsheet -- an easier, more attractive way of interacting with the sheet. I don't see a way to do this in Zoho. Any chance this could be added? Thanks.
Next Page