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"
Running a Macro when Clicking a Cell
Hi, My problem: I have a list in sheet1. Now I want sheet2 to open when I click on a certain cell i call "cell2", and to open sheet3 when I click on "cell3" and so on... Is this possible? What I tried is: under "this workbook": Private Sub Workbook_Open(ByVal Target As Range) If Target.Address = "cell2" Then Worksheet("sheet2").Active End If End Sub and under "sheet1": Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = false On Error Goto ENEV REM add your code below
使用中的问题
1、纵向可以自动求和，横向必须手动求和，横向自动求和时会自动生成其他数据。 2、纵向无法合并单元格，横向可以合并单元格 3、合并后的单元格无法撤销 4、单元格中垂直方向无法居中
导入问题
为什么在一个地方能看见，在另外一个地方有看不见导入的表格呢？
koruma ve gizleme
merhaba, google docs'ta e-tablo hizmetinde hücrelerdeki formülleri koruma ve gizleme olmadığı için arayış içerisine girdim. Zoho Sheet, arayüzü güzel vs. ama bu da işimi görüyor diyemem. Bu özellik neden yok? Ya da ne zaman eklenir?
Where do I find documents I've saved?
I can't find the documents I've saved... which link should I click?
Option to Change: Cursor moves down when you press Enter | Options / Preferences
Is there a way to make the cursor (cell highlighter/selection) not move when you press Enter after entering information in the cell? As a more general question, is there an options/preferences menu or dropdown? Thanks, Jim Eoff
Problem with Zoho Spreadsheet
Hello, I am working on Zoho spreadsheet as a school project and I have noticed a major flaw which has been occurring repetitively in the past few days. When I add a button into an excel sheet, the button is there. However, when I change sheets and then subsequently return to the previous page, the button is gone. However, when I export to an excel spreadsheet, I am ramped by buttons which are in the Excel File but not online... What is going on?
Wrong data when opening a spreadsheet
Hi, I have a lot of formulas in my spreadsheet for calculating time, for example =IF(AND(B18>0;C18>0);24 *(C18-B18-VALUE(D18));"") Each time when I am opening my spreadsheet, the calculation is wrong. I have to press F9 and then the recalculation will be ok. That's pretty annoying. The same with the cell format. Some cells are formatted in english (0.50), some in german (0,50), don't know why. When I am reformatting the cells, the reformatting is reset when opening the sheet for the next time. At
@TXTNLRN requests, @Zohosheet, Add ability to add comment in Notification email of what was updated when a sheet is updated
Hello, It is me again. Scenario: I received an email when the sheet I had shared with another member was updated. However, It did not mention what was updated. Request: 1) Either add provide the ability to add a comment where user can enter what was updated (the way when the sheet is shared and an invite is sent). 2) Or Sheet includes which cells were updated. Thank you Staff TXTNLRN #TXTNLRN_Software_test http://www.TXTNLRN.com text: 512-850-4898 @TXTNLRN
File Menu in Zoho Sheet
With our next update in Zoho Sheet, we will be having the left sidebar closed by default. You will find a new File menu to access and operate on your files. Clicking on File > Open will bring the sidebar, from where you can select a file to open. This is similar to the File menu in Zoho Writer. This change will come into effect in the next 1 week or so. Here is a video preview to help you understand better. Benefits: More space for your spreadsheet editor. Inching towards having a consistent user
Copy Sheet
Does any one know a way to copy a sheet to an existing book other than copy and paste all the cells. When I copy and paste often all the formatting and formulas do not copy over properly. Thanks, Jerry B
Easy way to show data in zoho
Hello, Is it possible to pass XML or JASON data to sheet using POST? I am looking for feature something like this: http://sheet.zoho.com/view.do?url=http://... but want to avoid file creation on server side. Thank you!
新版本不好用
如今改后的版本左边栏根本看不到，也移不过去。
Removing duplicate cells ?
Hello, I did not find a function allowing me to remove duplicate cells. In Zoho spreadsheet I guess I should do first : a) rank column A (ascending) : Sub first() Sheets("Sheet2").Select Range("A1:C400").Select Selection.Sort Key1:=Range("A1:A400"),Order1:=xlAscending,MatchCase:=false,Orientation:=xlTopToBottom call kill_duplicate End sub This should work ok ;) b) then adapt in zoho the following that I use in excel : Sub kill_duplicate() 'First sort (ascending) the sheet by column A For i
How do you label the x and y axis of your choosing?
Hi, I have just recently started to use Zoho spreadsheets and I am overlooking something but I can't figure out what it is. When I edit my chart, I give it a title and each axis a label. I save and publish the chart along with the sheet but when I display the chart the x and y-axis are labeled X-Axis and Y-Axis respectively. What am I missing that my labels are replaced? Thanks for any help.
@TXTNLRN,asks,@zohosheet,Seems like the Exact function is not working correctly
Hello, Scenario: In Zohosheet I have a cell with text "sd@s.com,d1@d1.com" In another cell I have sd@s.com,sd@s.com In the third cell I am using the Exact function =IF(EXACT(L4;Z4);2;1) (Please note, I did type a comma between L4 and Z4 and wherever there is a semicolon displayed. Zohosheet changed it to a semicolon) The result is 2 which is incorrect. Should be 1. I did the same in MS Excel 2007 the Exact function =IF(EXACT(L4,Z4),2,1) and result displayed is 1 which is correct. Please advise at
mobile zoho
I used to be able to view my sheets on my Iphone just like online, but now mobile.zoho pops up and it's read only. How can I get around this so I can scroll/make changes to my sheet using my Iphone?
Sheet: functions only english
Hello, functions are only english available in zoho sheet. Can I uns german functions, espacially for correct date spelling. Bye Herbert
Freeze panes in sheet
I've used Excel and Google's spreadsheet and they freeze panes like they're suppose to - highlight the row, click freeze. Zoho says sheet will do it but it's not working.
Next Page