Zoho Spreadsheet as an input tool
Hi, I'd like to set up a zoho spreadsheet for the purpose of using it as a data source. I want to collaborate with other users to input data into the spreadsheet. Is it possible to establish a connection in Excel and link an Excel spreadsheet to an online Zoho sheet? This way, I could maintain the data in the spreadsheet on Zoho to leverage collaboration with others. For advanced data manipulation and reporting I want to use Excel, so I need to have an easy way to transfer data from Zoho to an Excel
Limits of Sheets
Hello, we are new on Zoho Docs / Sheets. Is there some information about "limits" - max. formula, etc.? Thank you :)
Import data from a web using sheet
Hello. I want import data from a web http://www.aemet.es/es/eltiempo/observacion/ultimosdatos?k=clm&l=3260B&w=0&datos=det I can import the data in two formats: Excel or CSV. When I do the import, some data appear with different format. I don't know why does this. I want also append data from every day in the same sheet, but this I don't konw how can do it. Help?
Can't log into my account
I can't log into my account using my email address and password so I tried to reset the password but the system just returns with a message saying that there is no such user. I'm sure that I'm using the right email address because I still have the email from Zoho through this email address when I reset the password from last time. While I can't open any Spreadsheet I created, I'm still be able to see and edit Spreadsheet that other users shared with me and at the right corner of the screen it still
Month/Year (date format) not available in spreadsheet
Month/Year (date format) not available in spreadsheet Example: March 2015 automatically becomes 1st March 2016.
Alignment problem in spreadsheet
Hi, I have just got my cell texts aligned right to left in all my sheets in Zoho Docs. It's impossible to align my texts manually, it's always fixed in right to left, is it a known issue ?
Conditional formatting does not appear in shared sheet.
Hi all! I 've shared a part of a spreadsheet i created to a forum but the various conditional formats do not appear. All data and formatting is visible as normal but not conditional formatting, for example the highest value of a list that's highlighted. Is this normal? Thanks, Mike
Forum responses in Sheet, Update new row of data entry with existing calculation formula
Hi guys, ZOHO is pretty amazing! I'm working on a small project for my class where i put out a survey form and gather data into the sheet. within the response sheet there are several calculations i put in the cells, Everything works great except whenever there is a new data entry from the form it adds a new row and won't automatically apply the formulas to the new data. Is there a way to automatically update the sheet when i get a new responses from the survey form? Cheers Weiqi
CSV files Windows sync vs. Upload
When I upload CSV file I can open it. When I sync same file with ZohoSync for Windows I can't. Is there solutions ?
Lost spreadsheet
Good evening After a few months without entering en Zoho a cannot find my spreadsheet. It is still in Zoho because a person a had shared it with passed me the link I had given her, but when I enter in my account I cannot find it. I guess it's only because I don't know where to look. Thanks for your help
Problem with editing cells
Hi Zoho ladies and gents, I'm having issues with editing spreadsheet cells. If I try to modify existing text or numbers in the top bar as usual, I can't--it just types my new text as if the cell is starting off empty. In other words, let's say my cell read dollrs and I want to add an 'a'. I click where I want to put it and type 'a'. Instead of 'dollars', I just have a Sometimes I can undo and at least save the existing text so I can modify it elsewhere, but much of the time, I end up having to retype
Multiple conditions in SUMIF
Hi, I need to sum a set of data based on three different conditions. All three conditions should be satisfied in order for the data to be summed up. I tried with SUMIF, but it seems to support only one condition. How can I do this? Kalpa Pathum Welivitigoda http://about.me/callkalpa
WANTED: someone to convert multipage Excel 2007 spreadsheet with multiple macros and buttons
Hi, I want to upload an excel spreadsheet that has multiple pages. It also has multiple macros and page buttons. The macros are primarily for formatting the pages for display and printing. I want to hire someone to convert the spreadsheet with all of its macros to ZOHO Docs spreadsheet and recreate the buttons and make the macros work. Anyone interested? Pierre 904-338-7295
Problem with cell editing
I have a problem with cell editing - lets say I typed a word into a cell but then need to make an addition - the cell will only show me the first word i typed in the cell (and the addition will appear in the "insert function" line above my spreadsheet)??? Also I don't seem to then be able to delete the original word i typed in. This is annoying as I need to see complete content of cell as typed in and not ONLY when I click the cell! Also, where is the "wrap text" cell function? Thank you. B
Invalid arguments: Object required
Hi, I am getting the following error in my macro code Invalid arguments: Object required Set objEmail = CreateObject("CDO.Message") Can you please help me how to create it use inside zoho docs Thanks Sarik
Where do my documents appear once I've saved them? And how can I access my templates?
I created a spreadsheet in Zoho Docs and saved it. Then I decided that I wanted to create a template from that to be used for other customers. I saved it as a template, but now I cannot find it (yes, I've tried "All Files" in the Documents tab). Then I tried using Save As to create a blank copy, figuring we could just open the blank one and use Save As again for future versions and customers, but again, it's nowhere to be found! (Side note: they do appear here to be attached as an example, but I
Cannot edit spreadsheet
I am trying to edit a spreadsheet on my web browser (Chromium 43.0.2357.6) but when I click on it it just comes up with preview not available and the only option is to download it. I am able to edit other spreadsheet and documents without any issues. Thanks
Spreadsheet Row Height keeps changing.
Every few days, the row height of our spreadsheets will go from 25 to 17 without us doing anything. Sometimes it will happen on one spreadsheet and sometimes, it will happen on all spreadsheets. Any reason for this? It always changes it to 17. Let me know. Thanks!! Laura
Problem with currency format dropping trailing 0s
Hi Zoho, In my spreadsheets, when I choose a 2-decimal-place currency format, quite frequently recently, trailing zeros are simply dropped in new entries (if they're in existing entries, they seem to stay). They show up again if I go back to Format and rechoose 2 decimal places, but I shouldn't have to. As an example, a new column of numbers I add appears as: $5.5 $6.27 $19 Instead of $5.50 $6.27 $19.00 This started happening a few months ago, just haven't asked about it until now.
G-Sheet to Excel?
~ 9 months ago I created the Google Sheet which I continue to fill with daily data. Then I performed these actions: File -> Download As -> Microsoft Excel (.xlsx), uploaded the file to Excel Online and saw my G-Sheet converted almost perfect. My main chart was clear. Since then MSFT or GOOG made some changes that now I don't get the conversion working anymore. Is it on purpose? Competition? I decided to try to use Zoho as mediator to accomplish the conversion. But it does not go anywhere, because
The Effect of Investment Expenses on a Portfolio - Spreadsheet graph problem
I am compiling a spreadsheet on 'The Effect of Investment Expenses on a Portfolio' Having difficulty with the graph as when I go to print I get numerous 14 digit numbers obscuring the graph I have tried changing the settings but nothing works Also cannot delete the 'Enter your values here' title as it keeps reappearing Help please
Referencing and other sheet with SUMIFS
Hi there, I'm unable to get the following code to work properly on zoho sheet. It works perfect on excel. But something about the pasting the formula to sheets is not working. =SUMIFS(Sheet1!I:I,Sheet1!J:J,">"&TODAY()-1)-SUMIFS(Sheet1!I:I,Sheet1!J:J,">"&TODAY()) I tried using the "dot" instead of exclamation. But, it seems like this not reading. =SUMIFS(Sheet1.I:I,Sheet1.J:J,">"&TODAY()-1)-SUMIFS(Sheet1.I:I,Sheet1.J:J,">"&TODAY()) Also, I tried specifying the cells on the same sheet. Didn't work:
can i share view of my xlsx doc online without a download
can I share view of my xlsx doc online publicly without a download if so how nothing seems to work
Advanced "Chart" engine with Auto-detection, Auto-expansion and Trendlines
Zoho Sheet has upgraded to a more powerful Chart engine with vibrant features to improve your charting experience. Auto-detect Chart ranges Charts in Zoho Sheet are as intelligent as its users. Just click on a cell anywhere in the range and go ahead and insert a chart, Zoho Sheet automatically detects the range. The feature is extremely useful when the data range is large and saves you from selection hassles. In case of non-contiguous data, it is also possible to manually enter the range in the 'Add
Link to data in another file
How do I create a formula to link to a cell in a different file? In the MS application I would simply enter the formula =SUM(and click on the cell in a different file and press enter)
Spreadsheet date functions
Hello All, Are there any of the following functions available: - Day of week - Month name Thank you. Edo.
Remote Server refused to save Sheet and Pres Documents
Hi, I use Zoho Editor with remote API code under PYDIO server 6.20 I can create any document as well as writer, sheet and pres I can save only writer document, but not able with sheet and show. Why ?? In the file named : ../pydio/plugings/editor.zoho/class.ZohoEditor.php I can see this part of code ! (…) $service = “exportwriter”; if (in_array($extension, $sheetExt)) { $service = “sheet”; } else if (in_array($extension, $presExt)) { $service = “show”; } else if (in_array($extension, $docExt)) { $service
Speed
Hi, I'm using one spreadsheet with may different sheets in it. It has a lot of colums in it and nearly every cell has a conditional formatting formula. The sheet is very slow in loading and in editing. One may type a letter in a cell, but you can only see it after a few seconds! This is very annoying and time consuming. I wanted to know wheater the speed issue has something to do with the conditional formatting, I have made a copy of the original and removed all of the cond format. And it's much
Question regarding input controls checkboxes
I have imported an Excel spreadsheet to Zoho Sheet. Upon import, everything looks great except the checkboxes did not import. I can see in Zoho Sheet where I can add input controls that appear as check boxes, but I need to add functionality. For example, the checkbox ideally links to a cell elsewhere in the spreadsheet. If the checkbox is checked (TRUE state), then this influences the grand total. In Excel, you do this by right-clicking and selecting Format Control where you can establish a cell
Locking specific cells in Zoho spreadsheet
Hi, I'd like to embed a spreadsheet on my website with a formula in it. Users can then key in variables and find out what kinds of values the formula throws up. Is there any way I can lock specific cells (and not every cell) in the spreadsheet? This is because I'll need these constants to calculate the formula. Thanks, L
Can't access my docs??
I can't access my docs this morning. I know Zoho is having email troubles and is in the middle of the Chennai floods, so I'm assuming this is due to those problems, but just wanted to make sure. Is anyone else unable to get to their Zoho docs?
No upload field available in Zoho Forms
I have created a form from a Zoho spreadsheet. But the option to add an upload field is not available. Why would this be? My screen: Zoho Help documentation:
Formula Help: adding date when row has an entry
Hi all, I've got a formula that checks to see whether data has been added to a row, and if so it adds today's date to a column. It works well. The only problem is that every time the sheet is opened, it recalculates, so all the dates are set to today! Is there a way of adding in some logic to the formula to prevent this happening, or to set "recalculate=0" to a column! Thanks for any help James Here's the formula: =IF(ISBLANK(A6);"";TODAY()) ...and here's a screenshot that might help: http://take.ms/RvzsF
How to adjust width or delete columns in Zoho spreadsheet docs?
Trying to learn more about using these docs. How can I adjust width or delete columns in Zoho spreadsheet docs?
Editing a Public Sheet
I created a sheet and marked it as public because I wanted to send about 100 people the link, and let them click on it, make changes and hit save. (It's a sign-up sheet for a teacher appreciation breakfast.) But I find when I follow the link myself, without logging into Zoho, I am not allowed to save my changes. Is there any way to use Zoho to do what I want to do? Or will anyone who wants to edit the sheet have to be invited using "share"? Will they have to join Zoho and log in themselves?
Are there plans to provide functionality of Microsoft's Power Pivot?
Microsoft's Power Pivot for Excel provides some amazing functionality. Does Zoho have any longer-range plans to provide similar functionality in its spreadsheet software? It would be a wonderful addition. Thanks. Irv
New Pivot Tables in Zoho Sheet
Pivot Tables lets you slice and dice the data in your spreadsheet and helps you gather meaningful insights from your data. Though Pivot Table was already available in Zoho Sheet, we have now completely revamped it, made it more powerful and have integrated it seamlessly into your spreadsheet experience. We provide you with an intuitive user interface where you can drag and drop fields into rows, columns, data and filter boxes to draw your Pivot Table. Here are the capabilities of our new Pivot
Zoom function
Zoho team, Can you add custom zoom function to worksheet ? Right now we don't have any choice.
Freeze Panes - Lock Rows and Columns
A new sub forum, 'Tips and Tricks', has been added to the Zoho Sheet forum and we are planning post tips and howtos related to Zoho Sheet in this sub forum. The first topic deals with Freeze Panes. When you have a large table of data spanning multiple rows and columns, it becomes difficult to keep track of which data you are looking at as you scroll down or to the right. The 'Freeze Panes' functionality solves this by allowing you to lock the row and column headings in place. These locked rows and
Error with zoho sheet
hey, one of my spreadsheets cannot be opened, i get an error message. sent the details to support@zohosheet.com already. It is quite urgent, any can help me? best
Next Page