Is there a sheet that already exists that is called "dofollowblogs" ?
Is there a sheet that already exists that is called "dofollowblogs" ?
Server 500 Error : Internal Server Error
My client has a very distributed virtual workforce who are using Zoho Sheets throughout the day. They all work in the same spreadsheet workbook but usually on different sheets. They are receiving the following error quite a bit, I'm also getting the error. Error 500 Internal Server Error Kindly reopen the file and try again It is making work almost impossible for some. Is there any resolution? I notice that in previous forum posts you suggested people visit http://a1.sheet.zoho.com , however
Unable to correctly create Stock Charts
Hi, First, I'm a really big fan of zoho, and I am considering using zoho primarily or even solely for a new business I'm starting. Right now I'm testing some things out and I'm running into a problem: I am trying to create a candlestick chart. Here is the url for my test spreadsheet: http://sheet.zoho.com/public/brandonjwilhite/testchart I'm pretty sure the data series are in rows, because when I try to tell zoho they are in columns I get an error. Please, can someone tell me what I'm doing wrong?
Problem with Zoho Sheet WORKDAY function
Hi, I'm seeing a problem with the WORKDAY function. Here is the scenario: Cell c6: 9/24/2009 (A Thursday) Cell d6: 2 Cell e6: 9/28/2009 (A Monday. This will be my holiday) Cell c7: =WORKDAY(C6;D6;E6) The result in c7 is "#Invalid Formula" The result is the same when d6 is any of 2, 3, or 4. For all other positive values in d6, the result in c7 is as expected. Can anyone else duplicate this? Is this a bug, or a user error? Thanks.
problem in export to csv
I have imported Excel file in ZOHO spreadsheet. After that,i have exported that file into CSV. That time i didn't get the correct value for the date column. For example i have "Invoice Date" column with Date Format "dd-MMM-yy" (02-Jun-07). But in CSV file it is coming as 39265. Please rectify this issue. Thanks in Advance
Images in Zoho Sheets are not included when Exporting to XLS file (and other file types)
When I try to export an excel copy of a Zoho sheet that has an image imported into it, the export to file feature does not include the image. Is this a known issue?
How to open an uploaded sheet in Zoho sheet editor from C#?
Hi, Zoho sheet is powerful! I have a question. How to open an uploaded sheet in Zoho sheet editor from C#? How to invoke the speadsheet GUI to edit the sheet? Could you please provide the sample code?
Column widths incorrect for 2nd and 3rd published ranges
I have 3 publish ranges in this Zoho spreadsheet that I have arranged side-by-side (horizontally) with a couple of empty columns in between each range. The first range begins in column A and ends in column G and when I insert that range into this web page page, the columns are the widths set in the spreadsheet. The problem is the column widths of the 2nd and 3rd published ranges do NOT display on a web page with the correct widths. And, if I leave the ranges in their current positions, there does
Pivot tables from Excel spreadsheet .xslx
After I imported an .xslx spreadhsheet into Zoho Sheets, I entered some information and went to create a pivot table. I had a major problem because highlighting the fields I wanted did nothing to show the categories of the sheet. I checked out the tutorial on the blog about creating a pivot table from a .csv and did not find that helpful to what I was having a problem with. After tinkering for a few hours, I finally realized that Zoho does not recognize any column categories if you highlight
text to columns
how can I do 'text to columns' in a zoho spreadie?
Charts Not Updating
Hey, I am having a problem here with published charts not updating. The image itself on the spreadsheet updates but the image link withing the URL and the place where it is published still show the old charts. Am I doing something wrong here? Thanks -David
Publish Range Format Options
Hi, is it possible to control the column width format when publishing a range from Zoho Sheet? At the moment the HTML snippet publishes the desired range, but does not use the column width that appears in the spreadsheet.
Merge
Would it be possible to merge cells in the same column as well as rows?
no save in shared spreadsheet
When i open this spreadsheet in snow safari, there is no save icon for a shared user even though they have been granted full read/write permissions. Why is this? When will you fix it? thx gil
spreadsheet printing options
I see the way to insert page breaks in a document but is there a way to insert page breaks in a spreadsheet to control the prints of a long spreadsheet? And, is a print preview option? And is there a way to select the area of a spread sheet to print so that part of a spread sheet may be printed?
Found a bug in Zoho Sheet
I'm using this app for the first time, and I am absolutely a fan! Way better than other online spreadsheet apps! I did find a bug however: When unmerging cells (by right-clicking and selecting remove format) There is a bug that causes cells to the right of the merged ceel to become unreachable with the cursor...
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?
Next Page