Google Chrome - Cannot Select/Click Cells Using Mouse
This probably a known issue but I cannot select or click in a particular cell when I open a Sheet in Google Chrome (I can do so readily in Firefox). In GC I can only move to or select cells using the keyboard. The version of Google Chrome I am using on my Windows laptop is 11.0.696.71. Also unable to report a problem or ask a question from within Chrome (formatting bar does not appear and Sub forum dropdown is blank).
Time Calculations
I'm trying to put together a simple time-tracking spreadsheet in Zoho Sheet that allows me to have the following columns: Activity (simple text field) Starting time (time format) Ending time (time format) Time Spent (difference between Starting and Ending times) The problem is the final field. How can I get the difference between the starting and ending times? I don't see a function that allows making this calculation. I would have thought this would be something fairly simple.... George
modify data in sheet
hi, I've got several sheets in my document and I need to modify them to a given criteria. I'm willing to write a small program to do this. The program is intended to open the given document, modify content (like deleting some rows, altering some values etc) and save. So for this what API should I use? Is there any sample code written using the API, that I can refer? Thanks in advance
set cell data
Hi, I am new to macro writing in Zoho and wanted to know if there is a way i can assign a value to a cell to be equal to the current active cell. Thanks, Pascal
Chart - line graph - clipping of labels; lack of control over x axis labels
I seem to be unable to attach my Zoho Sheet document through the Zoho Docs tab. No documents show up. (I'm unsure whether a Zoho Sheet falls within the category Zoho Docs.) The Sheet I'm having difficulty with can be viewed at https://public.sheet.zoho.com/publish/graham101ia/graham-s-absp-rating. Two things which are not ideal are: 1) clipping of one of the Data Labels (labels attached to points on the line graph) at the top edge of the Chart. This happens whether or not a Chart Title is
external data link
Hi, am trying to import a web data to online sheet from below link. http://www.mcxindia.com/SitePages/BhavCopy.aspx But data is not getting downloaded.. pls help
Can't see docs
I can't see my uploaded docs. Having Problems or is it just me?
Online Embedding Question
Guys, I am new to Zoho sheet and I'm sorry if this has been asked ad nauseum. I have a spreadsheet that is embedded in a website I am writing. All I need to know is if there is a way to make changes to the sheet "saveable" online or is the online/embedded version totally read-only. Thanks, A.V.
Consistent Error Messages
The users are receiving this error message consistently now with every use...is there a notable reason for this? Or anything we can do...? Thank you!
color of chart data
HI, Is there any way to change the color of data series in a chart. Eg., if i have 3 days and data for these 3 days the bar chart will show 3 bars. I want to change the color of the bars according to my preference. Is this possible? Thanks, Subin Luke
Exported sheet, pictures missing
Hi, I made a spreadsheet with some pictures. When I try to export the file, the pictures do not show. Is there a way to solve this? Thanks.
Zoho very slow in China, can't use at all.
I use Zoho sheet. It become very very slow since last week. It is not useable at all now. Is this happening in China only?
Strikethrough text
Please enable Strikethrough font style for zoho sheet
zohohosheetの計算式がたびたび消えてしまいます
zohohosheetの計算式がたびたび消えてしまいます 計算結果がすべてクリアされてしまうことが月に数回あるのです。 単純な2つのセルの合計計算の数式なのですが、どうしてこのようになるのでしょうか? 対処方法があれば教えてください 例: =SUM(I78*J78)のような単純な数式です
New in Zoho Sheet: Strikethrough and other enhancements
The latest update of Zoho Sheet features the following enhancements. 1. Strikethrough: Zoho Sheet now supports the ability to set the 'Strikethrough' format to cells. This can be used in cases where you want to mark a task as completed in a task list spreadsheet or to eliminate a few options from a list. Here is a screenshot demonstrating its usage. 2. Chart and Image object enhancements: Chart and Image objects objects now use the common UI component used for Buttons. Selecting and acting upon
Please Add Paste Special Function
For updating a spread sheet with thousands of entries the Paste Special feature is required to do any calculations where just the Value is desired. Your copy to clip board work around is only good for a single entry at a time. We are currently working on thousands of entries at a time. Thanks for your consideration to add Paste Special as a feature.
LOOKUP function won't link to another sheet any more
I have been using this function "=LOOKUP(B3;$Data.A2;B6)" for a year or so, but now it is not working. It will work properly is the data table is on the same Sheet but not when I use the "$Data." to access data on another sheet in the same workbook. The function is on sheet named 'Enter' and the table is on sheet "Data".
troubles embedding a spreadsheet
I have embedded another spreadsheet in my website, but now I have got the same problems that I had in the past. You can see in the link : http://www.planfinan.com/home/punto-equilibrio 1. Description of the chart axes are not fixed after modifying 2. Can not change the value of a cell more than once, after it appears on the bottom right "cell is protected" I reported these two problems on another occasion when I came up with another sheet. These were solved but I thought that was fixed for all the
Web data refresh
Hello, Is it possible to have a 1 or 2min refresh for web data. Thanks
Can´t Pivote
Can't Pivote any sheet of my book. Appears a message of some trouble Thanks
Sheet: in text mode, can't make simple text changes due to contant HTTP Status 400 error message
HTTP Status 400 type Status report message description The request sent by the client was syntactically incorrect (). That's what I keep getting, and all I'm doing is trying to remove some characters in some fields so that I can migrate my database up the Zoho CRM properly. I'm just eliminating character such as "<", ">", "|", and double quote marks. I managed to get 300+ done and saved correctly last night after fighting this problem of getting this message constantly. Now, today, it won't
The request sent by the client was syntactically incorrect () Error as well
I am getting HTTP400 The request sent by the client was syntactically incorrect () error as well when trying to create a pivot table. Any suggestions what I am doing wrong?
Please wait to edit message does not clear
When trying to edit a shared sheet, get the message "Please wait to edit" and it does not clear. Can't edit the sheet.
Bug when selecting new language found
Dear all, When I signed up to ZohoSheet, I was working in Spanish and thus whenever I created a sheet and published it in my website, the buttoms "Click to edit" and "Full screen view" were in Spanish: "Clic para editar" and "Vista de pantalla completa". However, my sheet is aimed to an English speaking public, and therefore I changed the language to English from the menu "Languages". Now, all the menus are in English, but for any new or previous sheet that I create/open and publish in my website,
Unable to export Zoho Sheets
Hello, Recently I imported a CSV file in to Zoho Sheets and updated it with loads of information. While importing i had two options to choose, I selected the option that let me create pivot tables/graphs easily. The sheet I've now does not support copy/past, formatting and many other excel features. I would like to download/export this data. But when I try to export a blank Excel file is exported. May I know how can i export this data?
Images move by themselves
In a zohosheet file, I have pasted a lot of images. It is a project tracking sheet, and having images of the products is a GREAT HELP! However, some users complain that all of a sudden, some of the images just move around in the sheet and are no longer locked in their original cells. Does anyone have any idea what is causing this? A major headache right now! I can share the file with customer support if that is needed. Thanks,
percentages
Hi, I can not understand the reason because when I type a number in a cell with percentage format show me the number multiplied per cent : for instance : put in 45 and show finally 4.500 I have other spreadsheet that it doesn't happen in the same way, but I haven't found out when it happen or not. I am sharing the file "punto de equilibrio" with support@zohosheet.com in order to solve this. Thanks for your help Isidre
意见
能否给一个备注中文名的地方
Sheet
Why do you not have superscript and subscript options in Sheet as you do in Writer? These are used quite frequently in math/statistics work.
IPad scrolling
It's annoying that the zoho sheets cannot be scrolled down or up in iPad. Please fix this asap before we decide to move out. Regards.
More than one sheet open at a time?
I have looked and tried to find in Sheet how to have more than one Sheet open at a time, like in Writer. Does such a function exist?
Running a macro in the "close"state
I have spreadsheet in the iframe, which is updated with external data, I managed to find and apply the number color macro for values below 0 to be red and valued above zero to be green. However, the macro does not execute when external data updates. How do I correct this? Current result after a while the value turns positive but remains red and vice versa. thank you for your help
Currency in Real
Put currency in Real (Brasil) Please! . R$ 9.000,99 (Point, coma) Zoho is good- Thanks..
意见
1、共享数太低,2、能否将所有页面都制作成中文界面。
How do I edit an imported excel spreadsheet using Zoho Sheet
I've imported a excel speadsheet into a project as well as saved it as a Zoho doc spreadsheet. I can't seem to open the spreadsheet usng Zoho Sheet. It only allows me to open it as an excel spreadsheet.
forms/controls and macros
Wow - I'm very excited to find out that you support online VB macros uploaded from excel documents. This is a huge improvement over Google docs. Nice work. So here's the rest of the feedback: Sheets needs support for controls and forms as well. For instance, I uploaded my excel doc (complete with macros, buttons, combo boxes, etc.) and while it appears that the macros should work - none of the controls/forms show up! This would be a great improvement! Thanks, Paul
Error using CEILING AND FLOOR functions
I am not able to use CEILING and FLOOR functions available in mathematics genre. It gives an error #NAME! when used. I used =FLOOR(3.3333) and required result is obviously 3. Thanks Ankit Mittal
formatting cells
Hi I have a few questions on formatting cells in zoho sheets: 1. I have entered negative numbers and some appear as -100 while other cells appear as (100). How can I make the formatting consistent throughout? 2. Can I add conditional formatting? So for example if a number is negative show it in red, if positive in green? Are there any plans for adding the ability to link to a cell from a different workbook, not just cells from within a workbook? Thanks.
Shared Worksheet Problem
I have excel workbook, it has two worksheets. The first worksheet is allowed user to enter data and view the result. The second worksheet has all the formulas, it calculates based on data enter from the first worksheet. Everything is working fine MS Excel(desktop), now I want to share workbook using Zohosheet. But I don't want to allow user to download/export/save as our excel workbook. The other problems I am facing with shared workbook are: 1) All hidden worksheets are visible after exporting shared
Step thru function in VBA editor
I'd love to have the ability to step through a macro
Next Page