Importing Spreadsheets
I would like to be able to import an excel file directly to a zoho sheet within an existing document and have all the formulas intact.
为什么我们填写不了东西
我们的文件打开了填写不了让我们十分郁闷
What is the point in showing blank sheets in Zoho FAQ?
I would like to draw your attention to http://www.zoho.com/zoho_faq.html Point Number 12. Sheet 2 and Sheet 3 are blank. I believe these can be pruned away right? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Fetching Data
Hi, I have a database in zoho creator and i need data from my database to be pulled into zoho sheet.In the database i collect the number of sendouts and placements from each employee on a daily basis. What i need is the total of that to be pulled in the sendout and placement cells in here. How can i do this. I also have information about sendouts n placements stored in zoho reports, would it be easier to pull information from zoho reports or zoho creator. Thank You
How to make columns sortable
I've created a spreadsheet that I have embedded into a web page. I DO NOT want visitors to be able to edit the spreadsheet but I DO want to give them the ability to sort columns by ascending or descending order. I can't seem to figure a way to do this. Is it possible? If so, how? Many thanks, CB
shout box in shared files
It is wonderful that every shared files w/ online users can talk live. It wols a be a lot more wonderful if we can also personalize the fonts, insert smileys just like a live embedd shout box can be edited.
Sharing doesn't work
I have tried time and time again to share a document with some collaborators and it doesn't work. Please fix
How can Filter Row Data (Set on Row Topic)
How can i Filter Rows over Row Head Line Description? Auto-Filter: We support auto-filters when imported as CSV files. Again you would need to select the Tabular Data option while importing. Filters for normal spreadsheets will be supported later. When is later?
Border formatting
Hi there, I'm trialing Zoho just now and was wondering if there's the option to format cell borders? Basically just want the option to outline cell borders with different colours and thicknesses. Thanks, g
simple(?) VBA help
I am getting the message "Encountered error at line 9 :Invalid arguments: Object required" when I try to run the macro below, which I copied from http://www.mrexcel.com/forum/showpost.php?s=4ab5add6c1156e7e667e8fe62208e2e3&p=266170&postcount=3. Can anyone explain why? Public Sub main() Dim oRange As Range Dim oComment As Comment Dim sText As String 'Use object variable to hold range. In this example Sheet1 Cell A1 Set oRange = Sheets("Sheet1").Range("A1") 'Use object variable for comment Set oComment
Sheets
One major problem I have with sheets is that if I have multiple tabs in a single sheet, each time I move between them the interface scrolls back to the top. If I have a tab that is a summary of some fairly large set of data on another tab, and I want to enter content on that other tab, its frustrating to have to scroll down each time I change tabs. Charlie
Merging Cells Down
It would be very useful to be able to merge cells down in adition to sideways
My sheets have gotten SLOW. Need advice.
I've been using Zoho sheets for a couple of months-- my objective is to create a few databases that I can sort by date or name, and also insert hyperlinks of images. I've created three such sheets, and as I progress, I've found that using them becomes slower and slower. Perhaps my plan is too ambitious for each sheet? My main sheet is currently about 220 lines, 30 columns. As it's grown, it's becoming more and more sluggish to use. Should I instead create individual sheets for smaller date ranges,
Difficulties with spreadsheet editing
The Zoho spreadsheet feature is great for display. I like how I can not only access it from a website, but I can also edit from the site. Since I don't care about others doing the same, I am not worried about people "stealing" it. However, I have come across some non-user friendly aspects of the service. First, no easy to access "undo" feature. I tried to move some of the data I already typed in to different cells, but I wanted to undo it. I couldn't find an undo option. Ctrl Z only changes
how to: format "german style"?
is it possible to format dates in a zoho-sheet in german style "dd.MM.jjjj" (for instance: 03.10.1989)?
INSERTING IMAGES
I have to insert images into my spread sheets. When I alter the width of any column or height of any row or when I insert colums and rows these images do not move and are all misaligned. I have to move each one manually which is a very time consuming job. How can I prevent this? Many thanks. Hans
not saving properly
Hi, I just noticed that my changes aren't being saved properly, this is a recent thing but my last few updates on my zoho sheet are not being saved properly even though it definitely says my changes have been saved before I close the sheet! But the next time I open it the most recent changes have disappeared. Can anyone tell me what's wrong? I'd appreciate any help, thanks. Ann
Problems with a project
I'm considering using my current Free account with Zoho in order to do the following: -I'm starting a website and want to offer to my users your document/spreadsheet embed tool to publish my spreadsheet (with all calculations and the template) This way, users could use the template I have built and play with the numbers and filter certain data to generate a reporting. -The data that I'm using is available from a web link for direct download into a zoho sheet form a third party website. -In order
user resitrictions...
Is there away to restrict users to only the worksheet that they need to work on?
Can't export a specific spreadsheet
Hello, I've got three spreadsheets in Zoho Sheet. Last week I was able to download all of them, in any format. Now suddenly, I can't download one of them. I've tried it in different options (in the upper menu, on the sidebar) and I even did a save as to an new spreadsheet. Nothing seems to work. Zoho starts loading my browser, and then it just stops. Strangely enough I still can download the other two spreadsheets. Help! Thanks Freek.
Turn off automatic recalculations when moving between sheets
I notice that while moving between sheets my rand() formulas recalculate and mess up the previous figures I had fixed. Is there a way to turn this off? Thanks!
Positive cell values displaying as negative
I have a column of numbers I'm adding up. I'm inserting new rows as payments are made. For the most recent rows, positive numbers (i.e., $55.24) are displaying as negative numbers (i.e., -$55.24). There is no formula in the cell, just a value that I typed in. I tried retyping it. I tried deleting the row and re-entering, etc. and it still shows up as negative. Of course, the totals are off as well. What's going on? This is a pretty scary error.
format cells based on regulars
Is it possible in zoho sheet to format cells based on regulars, like in google docs Best regards Jens
I can't open zoho sheet
Hello, I can't open zoho sheet, in fact, i have only the logo "zoho sheet" in the top-left corner but nothing else ... (on XP => Firefox 3.6.8, Chrome 5.0.375.127 and IE 6) I tried to search in this forum, but i didn't find any problem like this. Can you help me please, Thank you. mazelerat_steven ps: zoho calendar works well
Sheet does not work in IE9
Sheet does not work in IE9. Any workarounds?
How to set a fixed width of column/cells
Is there a way to set a 'fixed' width for cells in zoho sheet? I know how to adjust the size of the colums.... but after I past a large block of text into a cell, it expands the cell size again. (yes, I have turned off word wrap) How can I set a fixed width so the cells don't change size each time I add data to a cell? Thanks.
insert date
I can not insert DATES in any sheet... Any sugestion?
Applying Pre-Defined, Zoho Parameter Driven Formatting to Zoho Sheet View BEFORE generating
I currently have a specifically formatted excel spreadsheet that we use to track our prospects and typically need to print out a hard copy on a bi-weekly basis to present to and utilize during staff meetings. It currently is not using any sophisticated formulas, xrefs, calculations, etc, however font types, sizes, cell text alignment, predefined column widths, text wrapping, etc, cell background colors are all parameters that have been established. Is there a way to define and set all these parameters
importing Google documents (spreadsheet) in Zoho
Hi, Is there a way to import documents (spreadsheets) directly from Google to Zoho with the URL ? The only way I know is to export from Google and import to Zoho. Thank you for you reply Pascal
Add-ins
Hello, I do not see tools > addins like in my offline spreadsheet. Is there a way to add in a function that calls data from external sites? My spreadsheet are not working becuase they can't retrieve information from sites like yahoo.com
Exporting spreadsheet makes some rows bigger
I have a spreadsheet in Zoho which looks fine, but when I export it to a .ods file it makes the height of every 20th row bigger. I thought it might be due to wrapping, but nothing in the cells would account for this. I have also tested exporting it as a .xls file and I get the same results. If I export as .csv I can only get one sheet at a time, but the height is the correct size. Is this a known issue? I tried to attach the file as a .ods but it won't let me here. So, here it is as a .xls file.
Currency
Hello, Every time I make a changement in my zoho sheet the currency sign changes from Euro to Dollar, automaticly. How can I turn this off?
excel spreadsheets
Is there any way to get an individual cell to appear exactly as typed ? It seems to condense and leave spaces out when I want to seperate letters and words for easier viewing.
Decimals please help
I have not been able to get that to work most likely because I have a function to combine with it.. I am taking cell P1 dividing it by cell D1 and then adding cell S1 to it to come up with a number in cell B1 that I want to reduce to just 1 or 2 decimals. Right now I am using =Sum(P1/D1+S1) How would I put that so that it displays a number with only 2 decimals?
Zoho Sheet Lead Id Column Suppression
I am quite new to Zoho CRM and I have been testing the Zoho Sheet View specifically when creating a spreadsheet for the purpose of presenting at weekly meetings and I was wondering if there is a way to suppress by default the first Lead Id column so it does not show up on the spreadsheet whenever a sheet is generated. I am specifically working in the Prospects section. Any help would be greatly appreciated.
Updating Spreadsheets
I have a spreadsheet I want to update, and I don't see how to do this. So, I am simply deleting the current one and replacing it with the new one. In Google docs, I could do this rather easily, but I don't see where the option is on Zoho spreadsheets. I am assuming it's there, I just can't find it. Any help would be appreciated.
Viewing (not editing) on iPhone
I would like to view a spreadsheet on iphone but i can only see some of the rows. Being able to edit would be magnificent!
zoho administrator rights
hello, i'm using zoho sheet for my work. I made a staff roster in a sheet for my employees. The roster changes every week. All the employees ar logging in with the same username en password, so do i. Everyone can make changes in the roster. Is there a possibility that just one person can get admin rights , so that he is the only one that can make changes. The others can only view the roster, but can not make changes. Regards Jack
Cell Protection
Is cell protection possible ?
How long to upload
How long should it take to upload a 6 mb file into Zoho? Is it even capable of handling that? There's about 20 worksheets in the file I'm trying to upload. So far it's taking 1 1/4 hrs and isn't done yet.
Next Page