@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.
Inventory Sheet
I need to get this VBA script running. It works fine in excell, but when i transfer it over to the Zoho spreedsheet it is completely broken, Basically the way it worked in excel is that you would click on a a cell in column L and the macro would enter all information from columns G-J into the activity log and add or subtract the amount of the item from the main inventory form. Right now the marco'ed enter button does not work. it wont transfer the date and it doesnt reckonize the index number that
feature
i would like to know if you can add a feature that will make a cell flash/blink. this is specially helpfull form me when a deadline is about to approach.
Unable to Detect the Presence of Collaborators
A group of us joined Zoho today to utilized the spreadsheet function however even though we are all logged in, the system shows "0 Viewing." Am I missing a setting? Also the spreadsheets do not update automatically as it should. We have to hit SAVE to update.
@txtnlrn,asks,@zohosheet, how long does it take to open a shared #zohosheet?
Hello, Scenario: I shared a Zohosheet with my customer. Gave him the access writes to read and write. When he tried to access the zohosheet it opened as a read only. I tried to assist. I set another email address of my to share the same zohosheet. Logged in with that email address. Clicked on the zohosheet and the system kept displaying loading or generating ... filename. What did I miss? Thank you Staff TXTNLRN @TXTNLRN
@TXTNLRN,Requests,@Zohosheet, Add checkbox ability to select all versions or certain versions in Version History
Scenario: 1) Marked a version on a spreadsheet that I am working on. 2) Wanted to delete previous versions from the Version history. Results: Currently, Had to click on Delete link for each version. Request: Add checkbox ability to select all versions or certain versions in Version History
Inserting Headers
How does one insert a header on the spreadsheet? I do not see an item from any of the pulldown menus that allows inserting a header or footer.
copy paste
I am trying copy and paste into sheet but it is not taking it. I copy from different websites on the net. p_f_s
Unmerge Cells
How can I unmerge cells in the Zoho Sheet? Regards Ashish
@TXTNLRN,asks,@Zohosheet, Could not find Print preview and Layout options
Hello, Scenario: 1)While working on a spreadsheet using Zohosheet, wanted to preview the print version and change the layout. Results: 1) Could not see the Print Preview or Layout/Page Orientation Option. Question 1) Is this true or did I miss a step. 2) If true, do you plan to add the feature into the Zohosheet roadmap. Thank you, Staff TXTNLRN @TXTNLRN Text: 5128504898 http://www.TXTNLRN.com
Loading message
I have some sheets which are loading very slowly. How do I get the message "LOADING......" (either static or scrolling) on to the screen, so that people know that it is still loading? Can anybody help with advice please? Many thanks. Kind regards Hans
offline access
needs to have offline access codyc1515
Zoho sheets-shared access problem
I have set up a spreadsheet with 23 different tabs ,and given users access only to their own tab to update. However one user cannot access their tab from their log in and everything they try to open the file it comes up with an error Any ideas?
Operations to avoid with multiple sheets?
Are there any operations which should be avoided when working with multiple sheets? Twice now, I've had something more or less like the following happen: * Do some work on sheet A * Switch to sheet B and work there for a little while * Switch back to sheet A to find it altered in strange ways (missing or quasi-missing rows?) It's kind of disconcerting. I want to make sure it's not something I'm doing wrong before reporting it as a bug, though. [The work on Sheet B has involved column resizing/adding/deletion,
.NET doesn't save the spread sheet.
Hi, I have tried saving spreadsheet after editing it. I use the remote api. The port 80 opened for the web site. There is no Firewall, and the saveurl.aspx is saved in the public directory and can be access through the url publicly without any sign in credentials. I already posted a topic but that was not yet published by the zoho community though it has been a long time. Don't know the reason. Here are the codes: 1. zoho.htm The contents inside this file is: <form method="POST" action="http://sheet.zoho.com/remotedoc.im"
Hide/Show fields...
any update on when the ability to right click on a column/row and hide/show will be available? This is really important to us. Thanks.
Zoho sheet - collabedit mode problem
If a .xlsx file is opened in collabedit mode, it opens correctly the first time but if it is already present (remoteDocStatus isPresent=true) and we open it again, then it shows 'Error Occurred'
Unable to delete cells
It seems that you either allow to delete rows or columns. If I wanted to delete a block of cells and wanted to move the otehr cells up, the functionality is not available. This is creating a lot of empty space in my spreadsheets since my spreadsheets are in 3 sections that run parallel to each other. When I delete cells from one section, all other sections get impacted.
spread sheets failing
spread sheet won't consistently maintain accurate totals. simple sums are in error.
@TXTNLRN,asks,@zohosheet, unable to scroll a zoho sheet on a mobile phone when not logged into zoho
Hello, Scenario: 1) Go to mobile.zoho.com using a mobile phone 2) View a zoho sheet that has more than 5 columns and 6 rows. Result: I was unable to scroll further than 5 columns and 6 rows. Scenario: 1) logged into my zoho sheet account 2) Viewed the same zoho sheet that has more than 5 columns and 6 rows. Result: I was able to scroll further than 5 columns and 6 rows. Viewed enitre sheet. Questions 1) Is this true? 2) Does one need to sign into Zoho sheet to view the entire sheet? If yes, would
Failed to export my sheet
Dear Sir, When ever I export my sheet, It get damaged. I tried many times but all the time it get damaged. Please help me to resolve it so that I can use it correctly. Waiting for your response. It'll be a pleasure, if I will get a mail on same. Regards, Abhinandan Sharma apsplacements@gmail.com
Lost Spreadsheet
Thank you for the new layout. Its definitely better. But It caused a problem though. When I opened the files, I lost two three spreadsheets! I saved four only the oldest spreadsheet was saved. Help!
Change in Administrator
How do I change ownership of my Zoho spreadsheet to another individual? I have left my old role and would like to transfer management of the Zoho sheet to another individual. Thank you, Dianne dtomarchio@rougevalley.ca
external data updating
The linked data in my sheet doesn't automatically update every 15 mins as scheduled. to update the data I have to manually refresh or reload the sheet from the server. itsnogoodaskingme
External data grab linked to a reference cell
I am trying to set up an external data link - namely, pulling in the current price of a stock (can be from anywhere...Yahoo, Google, etc). I want to set the function up such that the stock symbol is entered in another cell and my external data link knows to grab that for the operation. In excel there was an add-in function that allowed me to scrape data this way. Here is a sample of the string used: RCHGetTableCell("http://finance.yahoo.com/q/ae?s="&$A7;3;">Revenue Est";" Avg. Estimate ") Note that
@TXTNLRN,asks, is it possible to have the text in a cell be aligned vertically?
Hello, is it possible to have the text in a cell be aligned vertically? I wrote some text in a cell and wanted it to be aligned vertically so that it would take less space. I looked for the option could not find it. Did I miss any details Thank you Staff TXTNLRN text 5128504898 @TXTNLRN
@TXTNLRN,requests,Add capability to display the number of character in a cell
Hello, Currently, it looks like when typing characters - numbers or letters, there isn't a display of the number of characters in that cell. Requesting to add capability to display the number of character in a cell. Appreciated. Staff TXTNLRN @TXTNLRN
保存済みファイルが開けない
いつもZohoSheetを利用させていただいています。 ３～４日前にサービスの版更新がされましたが、更新後からそれまで毎日使用していたファイルが開けなくなりました。版更新前後に使用しないファイルは開けるのですが、版更新前後に使用していたファイルだけが開けません。安心してエクスポートもせずに使用していたものですから、古くてもかまいませんが、なんとか開くことはできないものでしょうか。一部分でも戻せたらと思っています。壊れたファイルでもテキストで一部復活でも構いません。壊れたファイルのままでも構いませんので、ご検討よろしくお願いします。 また今後、版更新前にはお知らせいただけたらと思います。 User: sharackz mail: sharackz@hotmail.com
server error
Hi , i have lots of times that i get a massege that say that there are server problems and the file can't be loaded or there are lots of times that i get a massege that there are server problems and the sheet that i'm working can't be save and tha tit was saved XXX seconds ago . the massege also offers me to save any un saved info and re-open the sheet. i will be happy to understand the reason for this and the way to avoid it. it make the work very hard... Dagan
Sheet will not load
I have not been able to load my Zoho Sheet for a few months. It is titled "Skills Calculator". I am able to open my other sheets, but there is always an error when i try to open this one no matter what computer or browser i try to load it on.
Next Page