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
zoho sheet -required field
Can i set individual cells to be required? I want to ensure that a user completes a cell that is required
Spreadsheet Manager Help
When i try add a number like 28.2 It changes it to a date, this is really annoying so can you please tell me how i can stop this.
有没有类似google tasks的产品
rt
Cell reference not getting updated
Hi Zoho Sheet Support Team, We are polling external data(RSS) every 24 hours, suppose the data appears in cell a8, we are referencing this cell in another cell d8 by using =a8, now the values are changing every 24 hours in a8 but they are not getting updated on d8, this was working fine before you guys made changes in UI of Zoho Sheet, I have shared the Spreadsheet with support@zohosheet.com, you can check the different values present in a8 and d8 cells in 'hr' sheet for better understanding Many
Don't allow user to Save/Download shared Excel File
I have excelsheet containing complex formulas. I want to share excel sheet with other user, but I don't want to allow user to download or save as shared files. Users can enter data and can view/print results. I tried 2 options: 1) I shared excel file via email. But with these option user can save as shared file with new name. 2) I can embed excel file into blog/web page. But with these option user don't have print option. Please advise.
UNEXPECTED OUTCOMES.
The spreadsheet embebed in my website (http://www.planfinan.com/home/planificacion-financiera-a-c-p/modelo) has been working properly for months. Nevertheless, currently, it is issuing wrong results. When it comes to changing some data, in fact, cells U16 and T16. I assume, you have updated something on "ZOHO Sheet" settings, so that, I am not able to find out what's not working accurately. I hope this information has been of use. Thanks for helping. Isidre.
Make a Spreadsheet READ ONLY ?
I'm working off a master spreadsheet and mostly copying and pasting into new documents. I would like to have the ability to make a document read-only to prevent destroying the original data. If this function already exists, sorry, but somebody please enlighten me. by the way, this tool seems better than google spreadhsheets so far!
X - Axis Title
When I try to change the name of a "X - Axis Title" into the options of "Edit Chart", after clicking "ok" the changes do not keep. I have tried many times and each time it occurs the same. Thanks for your help Isidre
How do u edit and save it when u already extracted it out of zoho?
Well. I have a forum for some games and i linked that spreadsheet to the website and i wish that i could edit it from the website. is it possible? i tried to click on edit and type in some things. but after that. i can't save it. And when i refresh that website. Everything is back to blank sheet. Pls advise on this if there's a way to do it.
Is there any API provided to update the content of a sheet?
help ...
Colors
most days i am not able to select certain colors, the mouse will not highlight the color to change colors on the grid
data filters
Microsoft Excel is currently the name of the game when it comes to spreadsheets. Nothing else seems to come close. But Zoho could go a long way in gaining parity by adding data filter functionality to the mix of capabilities. Even if I could filter just one column at a time, that would be a huge start. Please consider this. Thanks. - Bal
Sheet, Chromium and iBus
Zoho Product: Sheet OS: Ubuntu 10.04 Browser: Chromium (8.0.552.237 (70801) Ubuntu 10.04) Other: iBus (http://en.wikipedia.org/wiki/Intelligent_Input_Bus) To input Chinese and other languages, iBus is needed on Ubuntu. How to reproduce: On the above system setting, enter some text to cells of Sheet. Use arrow keys to move around the cells with text, the text will disappear. PS: No problem on Firefox, no problem on Chrome of Windows. It is possible the fix should be done on Chromium, not Sheet.
Gridlines in Zoho Sheet?
Is there a way to produce grid lines as they are available in Excel?
Autorun macro after last external data update ?
Hello, I have an url ("external data") checked every 30 minutes. ;) How can I make zoho sheet, to run a specified macro just after the last external data update ? Thanks in advance ;)
エクセルで作ったデータを使いたいが、その解説がないので使い方がわからない
わかりやすい説明がほしい、そういう意味で素人とのインターフェースがない 誰か第三者の解説や説明を要する エクセルで作ったデータを使いたいが、その解説がないので使い方がわからない
Shreadsheet could share data real time or not?
Google spreadsheet could share work together real time. That mean if one guy was writing in one field , others could view his modification meanwhile. Could zoho realize this function or not?
Sheet Crashes
Our sheets have crashed twice in 24 hours and I have had to reset to an earlier version. the older version today was 36 minutes old. This is NOT GOOD because we have approx 10 different people accessing the sheets to register trainees. We have no way of knowing if we have lost info. This is a huge project and a huge problem for us trying to mange the project. Please fix this bug!!!!!
"Error occured while adding the workbook to zoho sheet"
While attempting to save, or add a file, the Zoho plugin for Office failes every single time with the above message.
Data corruption on alternate sheets?
When working with multiple sheets, are there any operations one should avoid? Twice now, I've had workflow which goes like: * Work on sheet A of a workbook for a while * Switch to sheet B, work on it for a while * Switch back to sheet A, find it decidedly not in the state that I left it in (eg, missing data in cells or row / values on wrong row). At first I thought it was that "delete row" or "delete column" was applying to all sheets, but it doesn't seem to be that simple when I go back and look
OUTSTANDING ITEMS
Dear Zoho Sheet Team I wish to summarize the outstanding items on my sheets "Birds A-G", "Birds H-P" and "Birds Q-Z", all of which I reported previously. If these remaining bugs could be removed, then my bird registers would be perfect. Birds A-G Each time I open the sheet, the following problems with buttons occur, no matter how many time I correct them, it doesn't seem to save my corrections: Item 23 Goldfinch: The "Top" button slips down Item 24 Goosander: Two additional "Next"
Next Page