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?
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
Next Page