Axis labels on graphs
My published spreadsheet Go-LCY contains two simple histograms. Whenever I try to label the axes the label seems to disappear after several minutes. Do the graphs need to be saved distictly from the entire sheet or is this a known bug that might be corrected? sidsaucer
Conditional Formatting
I would like to have conditional formatting in sheets (like Excel). I find it very useful.
Joining vertically adjacent cells
I can easily join cells that are adjacent to each other horizontally (left-to-right). But when I mark cells that are vertically adjacent (top-to-bottom), even if they are in just one column, an attempt to join them is ignored, they remain separate cells. I'm not sure whether this is a bug or a feature request, but it should work anyway. I'm using Firefox 2.0.0.16 on Win XP Home 5.1.2600 SP2. Thanks, Klaus
Problem with sheet updating from creator
Dear support I have set up a live dashboard based on a series of tables that are updated automatically from creator. What I have found is that the live dash board changes over time as new rows appear. I think this may be due to the tables that automatically upload being of differing lengths depending on production activity. I will try to solve this by moving the dash board up to the first rows and making sure any tables upload on lower rows. C A better solution would be to put the dashboard on another
Size of files to be uploaded
I'm keen to know the size limit of files to be uploaded integruscapital
Speed issue
I ran into absolutely unbearable speed problems when working on a moderately long spreadsheet. It is named "samples to china". I can share it with customer support. It has 141 rows and 3 columns. When I select ALL and then picked a different font size, the browser simply freezes for 10-20 minutes. The font change WAS accomplished afterwards, but 10-20 minutes to accomplish such a task is absolutely unacceptable! Similar things happen when I want to delete a number of columns together. This really
Formats, locale, regionale settings
Hello, As a future and much needed enhancement, would it be possible to set our own locale settings instead of using Country/Language in the account settings? For example, the locale for French Canada is different than for English Canada : Number/currency : en-ca : $123,456,789.00 fr-ca : 123 456 789,00 $ Time : en-ca : 23:45:12 or 11:45:12 PM fr-ca : 23:45:12 Short date : en-ca : 01/15/2008 fr-ca : 2008-01-15 or, sometimes, 15-01-2008 Long date : en-ca : January 15, 2008 fr-ca : 15 janvier 2008
General Feedback
Got to know abt the Zoho from Hindu news paper today and this is the first time i am using the Zoho apps. They look awesome. - Rakesh. rak826
Thank you so much
your website is actually amazing, I use it for keeping track of my work hours in excel, thanks very much stuart moffat stuartmoffat
MS Office Plug-in Help
Is there a way to change the default location for saving sheets locally on my machine?
Notify on spreadsheets not working
Tried notifying shared users - says "pick at least one user" tho it shows 2 users already in the shared details. - sameer sameer.shisodia
Expense Planner Quick Templates
Zoho Team, How about having quick templates like 'Expense Planners' etc? Wouldn't that bring in more utility value for Spreadsheet users?
Not able to access sheet in IE
Dear Sir, In internet explorer, i was not able to access the zoho sheet as it was giving error every time i tried to access. what might be the problem? Thanks & Regards, Guresh. aguresh
Its really too bad
I just spent 2 hours trying to get used to your "productivity tools", because I REALLY wanted to get away from Google docs. However, I am realizing that your solution is simply not there, which will cause me to abandon you as a client. Its a real shame. Some of the problems I have encountered over these 2 hours: - MS Office plug-in is giving me error messages - Files uploaded through the plug-in appear in Sheet but NOT in Start. There is no way to synch Sheet and Start. - I even tried saving the
charts
I like this. as a regular past user of exhell, I have noticed a really neat feature: For a two series chart [two sets of data] allow for one to be a bar/column and the other to be a line chart. Let's play this scenario out: I have a column of number of widgets and the market share gained that week. For 3 weeks I have 3 rows of data in two columns which I will comma delimit for ya: sales,share 425,5 210,24 635,35 Now if I wanted to juxtapose the two on top of each other in excel, I would pick the
autofilter
what posibility of use autofilter ?? bargatan
linking sheets to database
Is there any way to link multiple zoho spreadsheets to a zoho database? bishwa.oakes
Automatic Updating Broken?
Is the automatic webdata updating not working any longer? It hasn't been for me. It works when I manually click refresh but will not update every 15 minutes like it is set to. I'm pretty sure I'm not doing something wrong because it has been working fine on this particular sheet for many months now.
Can't paste into Zoho Sheet
I have built some pivot tables within Zoho which work fantastically. I need to regularly update part of the data file from an external source which I plan to do by copy pasting from Excel. Currently I am unable to paste into Zoho sheet. guymckenzie
Error 500, every 5 minutes!
There is a constant error that makes it impossible to work with Sheets (I've faced it in Write too) It is this "Error 500: Internal Server Error" that asks to reopen the sheet, but it does it 100 times a day, almost every 5 minutes!!! Please help because a job that should take 10 minutes, wastes an hour! Thanks, Ali
Publishing sheets/range
Hi, What is the logic behind publishing ranges? I have published a range to a website but it doesnt update until i log back into zoho. This range is based on 15 minute interval from another site, so i need this information updated. How do I ensure that it updates without logging into zoho every 15 minutes!?! logansan
Spreadsheet Sorting
I am trying to sort a spreadsheet and I do not see where it allows me to pick which column to sort by. Please advise. radiantimt
zoho sheet pivot tables
When I try to change the way a date field is being brought in, I click where it says "Year", but the drop down menu appears behind the active window. I therefore cannot change it from YEAR to "Full Date" b/c I can't move the window out of the way without the drop down list disappearing. remcentre
Eliminate Cellulite
Fish Oil supplements Report
Email sending macro
Hi all, Been searching like crazy (both here and google..) for a ZOHO compatible email sending macro. Basically, I want ZOHO to send me an email when a cell hits a certain number (ie: stock watch trigger) The cell is a linked external data reference. Thanks in advance for any suggestions or links to someone having done this... Regards, LO
XY scatter plot with dates in the X axis
Hello, I have two columns. The first columns are dates. The second column are values. The dates are not evenly spaced, eg. between two points there might pass one week, whereas between two other points there might pass two months. When I use a XY scatter plot in OpenOffice, the points are aligned according to the date, ie. not necessarily equally spaced. However, in Zoho Sheet, the points are aligned with equal separations even if the time differences are not equal. Is it possible that Zoho Sheet
sheet
terribly slow - good bye garehira
Integration with Zoho DB & Reports
I'd like to be able to import data into my sheet from a DB report I've created.
Sheet not opening with other applications on IE explorer
Hi, We have linked the Zoho sheet with one of our web applications. When we tried to access the information on the webpage (Windows Internet Explorer), the Zoho sheets does not appear on the screen. But its working fine on FireFox. Its happening since today. Pls address this issue. Thanks - naveen
Zoho sheets tough time
Generally, I used to enter the datas in Microsoft excel sheets then i will paste it in Zoho sheets. Suddenly, I encountered the error which says, "Stop script or continue" if i select any one of the option my data gets disappeared. It keeps frustrating me, would you please advice on this? sankarr
NA() function doesn't work
Hi again, I've tried the NA() function and returns "#Invalid Formula". I need this function because i use the "#N/A" type in a chart when cell is empty. Example: fx=IF(ISBLANK($F1.H8);NA();$F1.H8) Thanks in advance!
Create User Functions (User Formulas)
Hi! My question is: �Is now possible to implement our own functions? I need my own customize formula to count how many yellow cells are in a especified range. I opened the VBA Editor, and i wrote and saved this code below in section Macro_Modules->Macros. Public Function countYellowCells(ByVal Range_Data As Range) Dim c As Range Dim Suma As Integer countYellowCells = 0 For Each c In Range_Data If c.Interior.ColorIndex = 6 Then countYellowCells = countYellowCells + 1 End If Next c End Function I tried
Problem with printing embedded sheet
I have this worksheet embedded in an html page. You can view it at http://www.gconnect.in/pages/pay_calc_pb12.html The problem I face is that, if we try to print the web page, the first page is blank except for the website logo and ad. In the second page I get a portion of the sheet. The third page is again blank. The sheet does not get printed as displayed on the page. Is it a bug or is there any other way of doing it so that the complete sheet gets printed.
latest fixation
In the decisions yesterday it is given as Scientist E & F is put in PB4. I am in that grade My basic on 1.1.06 was 19100 . But your calculator is fixing me in PB3
Blackberry Mobile
Hello, I tried to launch Zoho mobile on my blackberry web browser and it takes me to the site but I cannot click on the login link. Also, is there a way to work around having Zoho sheet go offline when the spreadsheet is left idle for some time. When I come back to it it gives an error message. Thank you. George gpolzer@Zoho.com or gpolzer@mindspring.com gpolzer
unsaved changes in zoho sheet
Hi, When editing a a document using zoho writer remote API, and tries to close the writer with unsaved changes, the writer alerts the user reminding him of saving, but sheet does not behave so, and do close and leave the user suffers from data loss. I think this is a new feature in writer, should we expect zoho sheet to support that soon? Thanks, Mohammad
sheet unusable from asus eeepc
impossible (or at least not obvious) how to navigate through a list of sheets in "my sheets" make using the app impossible from an Asus EeePC. These devices and others like it are popular for mobile workers who use online only applications for mobile office etc. niallroche
importo problem
Good evening, I'm trying to import one sheet with vba code included, but when importation's complete, can't manage to make it work. I'll attach the file i want to import
Disable Editing on Embeded Sheets
I saw http://blogs.zoho.com/sheet/how-to-embed-your-spreadsheet-into-any-webpageblog/ and it works great! But is there a way to disable visitors from editing the cell's content? I really like the tabs and "Save to Excel" link. joemako
Help!! Password protected
Hi I've got a copy of the spreadsheet I want to open in zoho\zohosheet\users\username\spreadsheet.xls But I'm being asked for a password to open it - I never set a password. The local version is more up to date because I made a lot of changes without internet access. How do I open it? Whats the password? Do I need to do a sych or something? Thanks Russ
Next Page