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.
Importing an Excel file into Sheet2
I want to have three simple Excel spreadsheets in three sheets in the same document. But when I select Sheet2 and import the file, it overwrites sheet1. How do I do it?
Zoho Sheet - trendlines for line charts
I retried Zoho after seeing the "Fake Office" posts. Super impressive. One feature I miss from desktop Excel that I wish were in your spreadsheet app: The ability to add a trendline to a line chart.
Import from Skydrive is required
Dear zSheet Team, Similar to the 'Import from Google Spreadsheet' feature that you have in your menu, it would be great if you could also have a 'Import from Skydrive' feature. Skydrive is just gaining momentum and has glaring bugs including missed out usability testing too.
How to access a specific Sheet module by URL ?
Is there a way for end users to specify a specific Sheet module by URL? Admins would like to keep all related sheets on one file for easy maintenance. Users in different areas want to focus on their specific sheet (only 'ONE' of the sheets) most related to their functions and also need to reference all other sheets when needed.
Use Filters in your Zoho Spreadsheet
We are glad to inform that 'Filters', one of the most requested features, is now available in Zoho Sheet. Filters help you to filter your data and let you focus on and analyze specific segments of data. You can filter by text, number or date. For columns containing numbers, you can additionally filter by Top/Bottom 'N' Items/Percentage. Functions like SUBTOTAL() have options to exclude hidden/filtered rows. It can be used to calculate results based on the Filter you apply. The filters menu also
Unable to click into cells
Hi, I am having no success when trying to click into cells. I able to navigate into cells using my keyboard but I can't click into cells to edit or input. Any ideas why? Using IE and not downloading the sheet as its a shared document.
Publish range of cells - interactive
I have a workbook with multiple sheets. Most of the sheets contain formulas and background information. The final sheet has a calculator that takes input for some variables and then displays the results of the calculations. If I embed the entire workbook to a page on my external site I can navigate to the final tab and input data that runs the calculations. I want the interactivity, but I want to hide all of the other sheets. If I embed a range of cells on my external site I see only those cells,
Is the new interface a step back?
Hi It may be a coincidence, but since switching over to the new interface, I have many problems: - The links from B-001 INDEX to the individual sheets don't work. When clicking on a bird, I get the comment that the server has problems - Many cells which should be merged, have been split - When I want to open a document, it doesn't list all documents in alphabetical order like the sidebar used to do - The filter doesn't work I don't know where to go from here, the whole bird register is unusable and
Next Page