NA() Function �?
Dear ZS team, Does exists any possibility to reference a null value? Why NA() function does'nt work? Is there any workaround about it? Example: =IF(ISBLANK($Tabla.T9);NA();$Tabla.T9) Greetings!
Can't we insert image objects in Zoho Sheet?
Doesn't Zoho Sheet support inserting of images in worksheets?
Every two minutes, I get internal error in Zoho Show
Every two minutes I get a JavaScript MessageBox stating that an internal error occured. Close your sheet and reopen again. The save button very often hangs. This happens very much high in MSIE 7.0. Can some one look into this showstopper bug?
シートが正しく表示されない
複数のシートがあるデータを編集する場合、シートを移動する際に正しく表示されません。 どのように表示されないか、ですが その1 シートを選択した後読み込み中のまま変わらない。 その2 選んだシートと違うシートが選ばれる。 以上のような症状です。 tsujita
Edit Series Option
Can Zoho Show bring an automatic Edit -> Fill Series like in Microsoft Excel?
cut and paste
It seems that I am unable to cut text from a web page and paste into a writer doc anymore? Why not? guns4liberty
Scheduled Maintenance of Zoho Sheet
There is a scheduled maintenance of Zoho Sheet on September 27, 2008 starting from 10:00 PM PST to September 28, 2008 1:00 AM PST. Zoho Sheet will not be accessible during these 3 hours. Sorry for the inconvenience caused due to this.
web order form to zoho sheet?
I have just signed up to zoho and will probably start using it, we have a ski resort, and provide ski lessons to our customers, we use an excel sheet for managing lesson orders, we will use zoho sheet for our own use, so that our personel can fill in new orders via zoho sheet. But what i was wondering now before getting started is that would it be possible to have a form on our website, where our customers can fill in a form and then this form after being approve by a personel would then be sent
zoho sheet
how do i delete a sheet from a book? now there is delete only rows and columns. also, not sure how to rename a sheet in a book. stedawa
color tabs
color tabs, please penas
Stock Function cannot reference another cell
This works =STOCK("GOOG","PRICE") But this doesn't (reference symbol from other column) =STOCK(B3,"PRICE") (B3 is the cell which has the string "GOOG") So its very hard to use the function generically (where symbol is in one column) ramganesh
Importing Excel 2007 files.
I can't seem to import Excel 2007 files because they have an extension .xlsx. I must go into excel and save it as and "Excel 97-2003" file. Is this just me or by design?
utf-8 in the name of a sheet - bug
Hi again, If the name of a sheet contains utf-8 characters you can not edit the macro for the sheet, because it is not listed in the left side of the macro editor. cheers, Peter pvojnisek
Stock Function in Sheets
When I use =STOCK("IBM")the function correctly gives me the last sale price. But if I substitute UUP for IBM I get an error reply. UUP is the symbol for Power Shares DB US $, which is a recently created Exchange Traded Fund. However your function works O.K. when I use the symbol for older, well established Exchange Traded Funds.Thanks. refr
No log-in editing
One feature that both Zoho and Google lack is a no log-in editing option. Sometimes, I want to make a spreadsheet that ANYONE can edit, even without a log on. That doesn't really serve your purposes -- as you want to add more "users", but sometimes I want that more wiki-like functionality without forcing everyone to join Zoho (or Google or whomever). I noticed that Zoho does have a no logon option on its Wiki service. Any chance that would be added to spreadsheets? Thanks. Jimbo (SpinCycle) spincycle
Mat
Cloud you please show me how to quickly add, subtract, multiply,and divide to excel colums? joseph49
Publishing individual pivot table
Hi, I am new to Zoho and have a problem. If I publish my document, I always get a code that publishes the whole document including the Datasheet and all pivots I created. Is it possible to link only to a certain pivot table? If thus how? If this is not possible, is there a way how I can open a specific sheet when linking to my document? Thus far it always seems to open with the last sheet I created... Thx Fox
Formulas
I may be missing something, but I cannot seem to enter a formula with a cell reference using the Excel method. Must the cell reference be manually typed every time? If so, please change. If not, please explain how. esaeo1
Zoho sheet slow and crashes too often
Every now and then I get an internal server error and it tells me to shut down the sheet and reopen and check again.. Once is okay, twice... well, can live with it.. but, 5 times in the course of a 20 line spreadsheet????
"Untitled" for Portuguese BR
in file name box, top, "Sem nome" penas
translate
bravo! now do it for you entire line, please, please. best penas penas
errorcode 12029
I shared a sheet with several people, and gave them full access. One person has no problems at all, an other person's data are not retained (i.e. not saved), and a third keeps getting the abovementioned errorcode when trying to insert rows. What can be the cause of the errorcode, and why does the sheet behave so differently for different people from the same group, sharing the same authorisations? Kind regards, Anton Langeler alangeler
How do you default Australian date format into the Zoho shee
Hi, I would like the default date format to dd/mm/yyyy when creating new spreadsheets and to also be used in any spreadsheet I upload. It seems that my account preferences and locale information does not come across when I create a new spreadsheet or upload a spreadsheet. Could someone please advise as to how this can be done. Thanks in advance sam
excel macros
I had help with the macros for this spreadsheet and I'm not sure if that's what not working but none of the drop down list are populated. Can someone help me? james_chapman
Linked formulas keep getting messed up
I have a sheet with multiple sub-sheets that periodically polls tables in creator. The results are used to develop a table showing progress against budget. However, I have the following problems. 1. All the sub sheets are supposed to load into A3 but I have now found that the update in several sheets now loads into A2. This seems to occur when the creator table is empty (table is set to pick up data from a single day and if no data is available the creator table is empty. 2. Where the table is empty
inline charting with 2 Y axis would be very useful -
Suggestions : 1) I found such chart with 2 Y axis useful (line charts ), especially now that automatic scaling takes place on the Y axis. 2) For inline charts, customizing the X values to include the actual X values is needed. Right now, the only values found on the X scale are 1,2, 3,4, etc. Thanks for considering these suggestions. Michel
Sheet name !!!
Hi When a sheet is open for viewing or editing, the sheet name is clearly visible. The sheet name must be displayed bold and big, and also the it must be highlighted on the left pane. Regards Vivek Ragunathan vivekragunathan
the code of recorded macros does not show up
I am trying Zoho sheets macro recording, and it does not work: recorded macros can be run, but their code will not display! I am using Chrome, I'll try with Firefox next laurent.alsina
how can i run this macros....very important!!
Hey All, I'm no macro expert so i need a litle hand on this one.... I have 2 macros that i'm desperate to make work.....The first one (in the workbook) is macro email sending e the second is a conditional formating...i don't now how to make this macros to work Can you guys help me..? Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = false On Error Goto ENEV If(Target.Address="$F$5" And IsNumeric(Target.Value) And Target.Value>=1000) Then ThisWorkbook.HasRoutingSlip =
sheet.zoho.com is kick BUTT
hey I do not agree with what you wrote really.... please explain in detail a bit more for me ;d thank you
Merge Cells Down
Is there a way to merge cells down? I can merge cells across but am unable to do it down (vertically). It will be a nice feature to have in future releases. cstlhtdf
SendMail Macro (2)
Hi guys, i'm trying to put (inside the code below the date of the task (collum "I" - Finish date) inside my email macro , the macro already send the name of witch task has my the especific condition (collum "E", now i need to add the finish date (collum "I") of the same task .......somebody know how to do it? .Message = "Verificar Cronograma. Tarefa:" & Range("E" & status.Row).Value i've shared me sheet with support Thank's
mapping data (heat maps, etc) ....
I have some data that I'd love to map. Ideally I'd like to be able to create world maps (gdp/capita colored by country) and US state maps (gdp/capita colored by state). Ideally I'd like to break it down even further and map out data by MSA (metro area) and county. I'm curious if this is on the radar. Visualization is so important and maps are one of the best visualization tools. Data that has a spatial component benefits massively from a good map. If there are 3rd party visualization tools that I
When are you going to get the row numbers aligned with wrap
Hi, This problem has been around for quite a while and its really annoying. When are you going to fix the problem with the row number not lining up with the rows when you use 'wrap text'. Thanks
Chrome, break line fails
Hi there, I installed Google Chrome 0.2.149.30 today, everything was fine but the shortcut ALT + Enter to go to next line inside a cell, doesn't work. Thanks a lot. ommmmid
using EOF in VBA
how do i use EOF in VBA instead of using IsEmpty ? (:
permalinks from creator 3 NOT working
Dear Sheet I have 2 problems with permalinks, 1. When I set the cell to update from creator to A3, I find that if the creator table is empty then the cell changes to A2 to update. This should not happen. 2. The permalinks from creator no longer seem to be working correctly. As they now load the following scrip instead of the data. Please fix soonest Peter <!-- $Id: viewperma.jsp <head> <title>Zoho Creator - </title> <!-- $Id: includejs.jsp <!-- $Id: --> <script> var i18n = { }; </script> <script>
Can you out .png images on zoho sheet?
Can you out .png images on zoho sheet? Thanks
Zoho Sheet is dead slow
Hello, This is the zoho sheet 'ProgressWeeklyReport-OSTeam' I'm referring to. We are an HR outsourcing company thus we have a lot of records and database. If you can rectify why the Zoho sheet is so 'SLOW' at the earliest, we would like to have our 'Project Management', CRM and all our activities on ZOHO itself. I tried through Firefox and Google chrome. Through Firefox, Zoho Sheet is still slow. Google chrome really does well when it comes to speedy browsing. Its in our best interest to stay away
Problem fetching new mail
I have setup POP access to my Yahoo Mail account and have successfully downloaded most of my messages. However, Zoho mail hasn't collected any of my messages from the last month - instead it just displays 'No new mail messages' whenever I click on 'Fetch'. Any ideas? Thanks
Next Page