Apostrophe was showing as ' but now shows as '
Help! I use apostrophes quite often in the text I use in Zoho Sheet. Previously, when I pasted a copied text field that contained an apostrophe, I would see EXACTLY what I copied including the apostrophe. Now I see the apostrophe in a copied text field replaced with 'apos;'. Also previously, if I typed an apostrophe in a text field, I saw the apostrophe - now I see 'apos;' instead!!!! Don't know what's happened, but please fix!!!! Thanks and Regards Bill Hunt.
Using VBA to import csv files
Hi, Could you tell me whether it is possible to use vba code to read in csv files automatically? I would like to use zoho sheet to analyze the results of a survey - stored as several csv files. I can do this manually using the import facility but would prefer to use a macro if possible. I've tried recording my actions but this doesn't work! Other than that this is a brilliant piece of software. Andrew Tregoning
mode=html problems
The embeded sheets that utilize mode=html have been intermittently blank. Please advise...
sheet functions not working
Even the simplest functions like "=I11" are not working.
Locking Cells
To Whom It May Concern: How can I lock data into cells? ie...cells that have formulas in them that can't be erased. Cheers, Peter J. Regan pj.regan@live.com
Problem with editing shared spreadsheer
Hi, I have shared a sheet with few people, however they are not able to edit shared worksheet. They can edit any other worksheet which they create on their own.
Help on HELP
I'm probably missing a simple point, but how do I get 'Help' in Zoho Sheet? There seems to be no obvious link. A specific example of where I need help is a situation where I want to create a line chart to compare the progress of two sets of values, but appear to be allowed only a single data source (i.e. one set of values) Thanks for any enlightenment.
Row heights
I cannot get the row height format to accept a number as the row height. It keeps going back to a much larger number for a row that has several lines of wrapped text.
embedding doc version into sheet cell?
Is there a way to embed (via formula, for example) the current doc version number into a sheet cell? This would be useful for tracking when the doc version is taken out of zoho for editing/distribution (eg pdf/excel/printing).
Version Control
Hi I want to share a xls file to multiple people & Aslo I want multiple can work one the same time on this file is it possible in ZOHO
regular expressions ?
Question: How do I tell Zoho Sheet to treat a string of chars as an expression ? Background: According to the docs, it should be possible to match strings using regular expressions. For example in the COUNTIF() function. I tried it using the sample in the docs: =COUNTIF(C5:C8;"all.*") But this treats the expression as a regular string to match.
Zoho sheet corrupts data in sheet and a list of other errors encountered yesterday
Yesterday I encountered extensive data loss and corruption with Zoho sheets, finally resulting in me having to have all the users email me the data and putting it into Excel myself manually. Although I did some initial testing in the last few months, this is the first time we tried to process this data with all the users. First let me describe how I use the sheet and then I’ll list all the issues I have: I have a group of people that place orders once a month. All the data is stored in a single workbook
Share count incorrect and names duplicated on display
When i view the shared users from the sheet, the count is incorrect, it only shows 10 shared users, when I have about 30. In addition it is combining names together in the dialog box. Shared a PDF of the screen with you at support@zoho.com
questions
Team, Can you help me in the below 3 things. 1-The sort option is allowing me only to sort a row or a column. Advice me how should I sort the table ? 2-How to add / sum a full column. [ by just selecting the column name - A or B or C . . ] 3-The content entered in the find box is searched, but not shown to me and It makes me to search for the highlighted . I already discussed with Ramesh about this. Thanks, Ash ash@adventnet.com
Zoho sheet errors
The sheet i have and am sharing with 1 other user is having error messages. Only the user is receiving them every couple of mins. Error 500 and an error 12030. I was hoping to pay for this service in the future, but due to the nature of the business i cant afford to move my project over with these errors and their frequency. Is there anything you can do?
New here so please help
I am new to zoho...and i kinda don`t know how to do somethings...so someone please help me if you are nice enough to....^_^ thank you
You are Awsome
Great work guys.. add me in your team!
Embedding ZOHO Sheet files in ZOHO Creator's HTML View ...
Hi: So far my use of spreadsheet files within the ZOHO Sheet platform has been quite rudimentary ... however, I am currently developing a ZOHO Creator Application for a client that requires the contents of a Spreadsheet to be embedded within an HTML View. I was able to develop the iframe tag with the src= value that enabled me to do just that ... however, I notice that the embedded sheet "gives the appearance of being able to be edited from within the HTML View" ... i.e. the user is able to enter
Error when opening workbook, error attached
When I open the workbook I receive the following attached error. Shared document with you at support@zohosheet.com Document name is Foodbank Order Sheet (2)
Creating Financial Reports and Ratio calculator in Zoho Sheet
I have created a Financial report in Zoho Sheet with a financial ratios calculator here http://public.sheet.zoho.com/templates/kmguru/balance-sheet-template-2 . and just wanted to share with others who may be interested in this. SMBOnline 360 http://smbdashboards.wiki.zoho.com/
Error Occurred
I keep getting an "error occurred" message when I open my sheets at work, although they are fine at home on the same PC. Sometimes they open and I can make a few amendments before the error occurs. Although all other Zoho apps work fine I guess it might be a problem with our network (I'm not in the IT dept and it's a school network). When I go to a1.sheet.zoho.com they seem to work fine and changes are saved - if I work on my spreadsheets there when I'm at work would they still be safe or is this
Write over next empty cell
I wish I could write over to the next empty cell without have to use the merge cell function just like the MS Excel.
Folders in Zoho Sheet
Is there a folders function in Zoho sheet? I am comparing the functionality of Zoho Sheet with Excel. Thanks...Rick
drag lower right square of the box highlight
drag lower right square of the box to continue the formula or pattern is an important function missing here
Sharing permissions changed when someone new joins group and clicks url in email
In reviewing the items in the forum, this was supposedly fixed. As I add new people to the group and they click the email url to access the sheet, the share permissions get changed for many sheets. Had just checked them all when someone was added to the group and complained that they could see other peoples sheets. I have corrected this many times now. Can you tell me it will be fixed. Is there some way to keep the share email from being generated till you fix this problem?
Uploaded sheet loses buttons on download
When I upload a workbook with the Excel plugin and then let the users edit it, when I download it again the button loses it macro link.
Can't download workbook to Excel
I have a workbook that errors out every time I try to open it using Excel plugin. It says it has an error try again later. When I export it from the Export menu in Excel format, Excel displays an error, can't read the file, it needs to be repaired. How do I get a copy of the file from Zoho?
Excel plugin not downloading sheet
I have a workbook that errors out every time I try to open it using Excel plugin. It says it has an error try again later. When I export it from the Export menu in Excel format, Excel displays an error, can't read the file, it needs to be repaired. How do I get a copy of the file from Zoho?
Best browser to use for Windows and Mac
What is the best browser to use for Zoho sheet? For the Mac and for Windows.
Frequent Prob's on sheet
The sheet hangs when we keep updating the sheet.Let us know abt the data limit storage for each sheet.
Copy of workbook does not copy share permissions
When I copy a workbook, it does not copy the share permissions. I would assume they are kept as part of the document and would be copied. Where are the permissions kept? How can I view permission assigned to each sheet without clicking on each drop down to view them? It takes forever to make sure what is assigned. It is also very slow to assign share permissions.
Export PDF for printing
Printing from the print icon is pretty limiting. The Export PDF option is formatted correctly and includes the highlighting and colors I originally set in Excel. When I export though, I am not able to find a way to export a single sheet to PDF. In addition when I share the sheet, the person I share it with does not see the export icon. Printing with PDF is a greatly improved priting option for Zoho. Any awy to make these changes so that anyone can export a single sheet to PDF?
Workbook tab limits?
How many tabs can I have on a workbook? How many users can I have sharing a workbook?
problem with the graph changes in Zoho sheet
The graphs in Zoho sheet used to automatically scale to fit the range of the data being graphed. Now they scale to fit the range of zero to the maximum being graphed. It's hard for me to explain, so I am posting the before and after examples. This is the old version. This is the new version Can we change it back to the original way? Or can we at least have control over the range so we can change it back to the original way ourselves? Why was it changed?
Local Copy Updating
Having set up my spreadsheet on an external hard disk, I can then get it onto Zoho using Import. I then edit on the site and want to get that back to my PC. I can do that via Export. The problem comes in when I want to edit locally again. The file saved via Export is on my external hard disk but when I imported it seems a copy got made in my user profile and it is that file I have to use if I want to edit again locally and save to Zoho. However I may not have access to that PC at that point so
Sorting issue
I am sorting the colums. But it is not working.
Creating symbol such as feet square and cube?
Not sure if I am asking a silly question... but I am not sure how to create the small number like 2 and 3 for feet square and feet volume? Can I even do that in Zoho Sheet? I tried googling and looking at the forum, but couldn't find any information about it. I don't even use Excel or any spreadsheet program before, so I am kind of clueless. Thank you, Amy
Row Height
Upon importing a spreadsheet the row height does not match the original and is condensed. Please advise how to fix row height to auto?
Problems transferring large files via Zoho Excel plug-in
I have just started using Zoho. It looks like a great service. However I have been unable to transfer my large desktop Excel workbooks to Zoho even though I am logged in and using the Zoho plug-in. The transfer appears to work up to ~6MB but fails on 7MB. Ultimately I want to be able to transfer files in excess of 20MB. I am getting the following error: 'Unable to save. Encoding is not proper.' Has anyone seen this problem? Any recommended solutions?
Linking data across multiple open spreadsheets
Does anyone know how to reference data in another open spreadsheet in Zoho Sheet? I've tried using the same format as is used in Excel eg in a cell in Document2, ='[Document1]Sheet1'!a1. An update to cell A1 in Document1 would then be reflected in an open Document2. What path should I use to access Document1? Can Zoho do this?
Next Page