bug in zoho sheets
Very powerful software and works well for embedding my excel spreadsheet for the Explorer and Firefox browsers but bombs with "Error 500" in the Safari browser. Also didn't support SUMPRODUCT excel function but I got around it. Geoff Sharp
Unable to import csv as pivot table
The title pretty much says it all...When I select to import the .csv as a pivot table, zoho sheet seems to try to do something, but then just sits there. If I import the .csv as a normal spreadsheet and then try to create a pivot table from the data I get a "Problem creating pivot report" error. I'm attaching the .csv file I'm using, which is just test data and is very basic. I had to remove the .csv extension, b/c the forum said this extension was not allowed via this portal
Sheet Question
How do I print a spreadsheet with the gridlines showing?
Copy & Pasting in My Sheets
Is it possible that I am overlooking being able to copy & paste in my sheets? Also I have documents in Microsoft Publishing, is it possible to put these into zoho?
Feedback on Zoho Sheet
Firstly I would like to congratulate you on the commendable effort of getting something like this on the web. I know that there are competing product offerrings but Zoho seems to be the best of the lot that I have tried. Also like the integration with Google and Yahoo sign on. Those were the bouquets, here come the brickbats. I spent some time on Zoho Sheet and was disappointed by atleast a couple of things. First, by the time taken to update the values of the lower part of a range chain when a chain
Convert cell format back to numbers?
Hi there, I was once proud of my Excel skills and this seems like a real stupid newbie question to ask, but I'm just stuck... How do you bring a cell's content format back to plain numbers? Once I've (sometimes accidentally) pressed e.g. "set as text" or a date format there seems to be no coming back? There is a "clear formatting" option on right click, but that seems to handle only visual styles, e.g. bold. /H
Sheet view only only showing partial list...
I've done a number of contact searches in the contacts tab, using the search box on the right side of the screen and clicked search by account name and then typed in the company name. Each search result has over a 100 contacts but when I click on Zoho Sheet View for these searches, only 58 lines of contacts show up. Any idea why it doesn't show the full list? Thanks, Brandon
sheet formula
In any given cell, if I put in a simple formula, i.e. (=D18-C18/2) it does not compute properly - leaving off the (/2) portion of the equation. What to do.
Calculation problem - time minute to seconds
calculation problem: im trying to transfer a working formula from excel into the zoho sheet this is to calculate the seconds from a time format input = eg. 23:00 (23 minutes) = 1380 sec 23:30 ( 23.5 minutes) = 1410 sec and so on when my formula is in the Excel sheet the results are : 29:51 || =IF(A5="","",A5*24*60) || the result is 1791 but if i put the same set of formula into zoho sheet 29:51 || =IF(A5="","",A5*24*60) || the result is #VALUE the # value starts if i'm using 24:00 and then onwards
pivot table
hello i tried to import an excel sheet and to make pivot, unless i import csv i cant do the pivot, can anybodey help?
Read Only
In sheets...I want to have a sheet read only. Currently when you mark it read only the person you shared it with can select - copy and paste. I want them to read only. Am I missing something here?
Zoho Sheet - Good Potential, with Bugs
This is my first time using Zoho Sheet. It has good potential, but has a few bugs: 1) When I merge cells across a row, I can't reduce the row height. I can set a new row height or drag to a new row height, but it then pops back to the old row height. Besides fixing this, a nice feature would be to have a setting that allows the rows (and columns) to automatically resize to the amount of text in the cell. 2) If entering a number in the format x.y.z, it automatically is converted to a date. I cannot
NOW() Function in Sheets results in wrong time
On my PC its now 13:31 but NOW() results in 4:31 PM. Any advise to get the right system time?
URL for chart in zoho sheet not showing...
Firstly, I think you've done a fantastic job on this - I'm super-impressed! Unfortunately, however, the thing I really wanted this for (to be able to create dynamic charts I could then embed into a blog) isn't working (for me). I create the chart, and then press publish in the bar above the chart, but nothing happens... I've set sheet.zoho.com and *.zoho.com into my 'trusted' websites (as the company I work for has some quite harsh security settings on 'normal' websites). Any ideas how I can start
How do I avoid the rounding of large numbers
I'm currently importing csv values from my Creator app into Sheet which include the Record ID field. This field contains a very large number and when imported Zoho Sheet seems to round off the last 3 digits. Is there a way to get the entire number to import properly?
How can I make it protected and filterable and searchable
I have put one spread sheet on zoho sheet Account is ju@compuaddons.com How can I make it non changeable . How can I make it filterable or searcheable on column head How can I display on webpage
Error
This is the error that I receive: "Problem while creating pivot report" Please help! Thanks, Rodney
Pivot Table is broken
Hi guys, I get the following error: "Problem while creating pivot report" It just won't create a pivot table. Please help. Thanks, Rod
VERY DANGEROUS ERROR
Try placing the following formula in a cell: =60*5.2 Notice that the result is 312. Now replace it with the following formula: =60*5,2 Notice that the result is now 300. This is very dangerous as scandinavian countries use the comma as the separator for decimals. They risk getting wrong results. I found out this the hard way...
Display local pivot table excel sheet online
Hi, I have a local excel spreadsheet that contains interaction pivot table. Is there a way to display this spreadsheet online using Zoho, so that user can interact with pivot selection to see that data? Thanks in advanced. Angelina
dates appearing wrong
when a date is entered on the data sheet it is appearing as wrong ...sir pl fix this bud
Hidden rows on export!
On opening an exported Zoho workbook with two sheets, I was disappointed to find that some of the rows had seemingly NOT exported yet totals included values from the missing rows! Then I saw that some of the row numbers are missing, i.e. the rows are obviously hidden, yet show up in Zoho! What can possibly cause this? Also, although the rows are HIDDEN in EXCEL, I cannot UNHIDE them! Help!!
Spreadsheets
Is there any way to add a button to send the contents of the spreadsheet via email to a specified address? Also, Is there any way to add a link to Paypal?
Spreadsheet view size - Zone Capability?
I just loaded my first spreadsheet onto your website and it looks good except for the size of the cells. I need to Zoom to about 50% for it to look good on screen. How can I do this?
Import online file into spreadsheet
Hi, I have a quick question about importing online data into a spreadsheet. If I set the spreadsheet to get the data every so often, will it continue to do so when the spreadsheet is closed and another spreadsheet within zoho is open? How about if zoho is closed completely? Thanks -David
how to join personal group?
Do Zoho had instructions on how to join Groups? Using Google/Yahoo Do Zoho had instructions on how to access shared folders? Please advise. Regards
Printing of data from a share sheet
It seem like there is no print or page setup or print ranges when the sheet is on share mode? People whom i share Zoho sheet had been trying to locate a icon to print everything nicely in a same format but it seem that they cannot do it. they had to copy to excel and do it again. Please advise
Sort/Format Macro says it's running, but doesn't complete or do anything...
Why isn't my macro working? When I run the macro SortScores, the message "Running Macro" appears in the upper right corner of the sheet, but it never completes and when I finally interrupt it, nothing has been done. The purpose of the SortScores macro is to first, sort the List on the left by Scores in descending order, then copy the sorted result to the right to completely overlay the 2nd list (this is so my published ranges for both lists expand and contract as rows are added or deleted), and
When we try to generate ticket id it gives server not responding error.
HERRAMIENTAS
EN EL PANEL NO SE ENCUENTRA VISIBLE HERRAMIENTAS
Emergency Issue With Zoho Sheets!!!
We have had a number of problems with Zoho Sheets, this is an emergency as the business relies on Zoho Sheets, with 15 people working on them all day. It all started with the sheet owner not being able to share, she then downloaded and reuploaded the sheets into new sheets and re-shared. She deleted the old sheets which were in her Trash. Unfortunately everyone had duplicates in the Shared to Me folder, so they ended up working in different sheets. The sheet owner then deleted the sheets which
POST Method of UploadBook API by passing URL(or path to file) in content parameter
Hi, I am having problems in getting the POST Method of UploadBook API by passing URL(or path to file) in content parameter to work. Can you please provide a sample code? Preferable one of each (passing a URL and passing path to file on server) Thanks Steve
GuestView link sent in invite email.
Greetings, When sending out invites I noticed there is a preview link, if this link falls into the wrong hands what is stopping the public from viewing my private spreadsheets? Is there an option to not send or disable this link? "The document shared for collaboration can be viewed at : http://sheet.zoho.com/GuestView.do?<insert jibberish here>"
Can't copy sheet...
Hi, For some reason, I cannot copy a sheet within a spreadsheet imported from excel. I've done this before with a previous version of this same document successfully. Are there security measures that I'm not aware of? Thanks, Sean
copy and paste
trying to copy and paste cells between tabs in a spreadsheet, however the 'edit' copy and paste options aren't coming up on my Firefox browser. Is there a special way to do this on ZOho?
naming new sheets in a spreadsheet
Hi, when creating a new sheet in a spreadsheet, I can't work out how to name it. When I click on the 'sheet 1' tab down the bottom and write it writes in cell A1 rather than as the sheet name. Any clues anyone?
sheet 单元格无法设置格式！
并且打印带表格线表格时会多出许多横线！
Remote Api - (400) Bad Request
Hi Guys, First of all ... Wow! love the zoho's work (editors, viewers, api's). I really need you guys' expertise on this subject. I have sent my three .htm sample files to support@zohosheet.com. They are used to open remote docs and save them to a remote server. I am able to view and save a Writer document with no problem, but with the Sheet I get (400) Bad Request, and Show i get a 500 Internal Server Error msg's. Will you please have a look at the html I sent and inform me of what im doing wrong.
Large Numbers Broken
I am linking to the following HTML table: http://www.runehead.com/clans/ml.php?clan=kngkyle&skill=Overall&sort=name Everything is working except for 3 numbers, as you can see from this screenshot: http://img338.imageshack.us/img338/4346/scr1249093944.jpg They just do not show up at all. Please help. EDIT: You can't copy and paste numbers larger than 950,000,000 either. Just shows nothing. Thanks
Crooked Rows in Firefox 3.5
Hello. I love Zoho, but today after switching browsers I've encountered a problem when viewing the zoho sheet files from Firefox 3.5. The rows are mismatched with the numeral indicators on the left. I've tried different views on firefox and still, the same result. This does not occur in Internet Explorer. Any thoughts?
Next Page