hyperlink changes format
Why when I create a hyperlink in a spreadsheet is Zoho changing the formating of the link I am pasting? Example: I want to link to this page http://thetvdb.com/?tab=season&seriesid=175001&seasonid=659461&lid=7 I paste that into the hyperlink, and Zoho changes the formatting of the ampersands to http://thetvdb.com/?tab=season&seriesid=175001&seasonid=659461&lid=7 which results in a error message because the database being called does not recognize the request in that format. I have been
Fast track to perfect charting.
Charts need the right set of data to look perfect. Wait, what?! If that's your mantra for ideal charts, you're doing your charting wrong. Perfect charts are those that interpret your data, however it might be, in the best possible way. Plenty of time goes into creating them. Well, not anymore, as Zoho Sheet has solutions to bring down the time you spend on charting. Cherry-pick charts, nimbly. Cherry-picking charts at the cost of your time? It's fun to try out different chart types, but not when
[Pydio] Impossible to save csv
Hi, Since Wenesday (probably) I can't save my .xls and .csv on my pydio server. Even if I upgrade my installation to the lastest version of pydio I can't save my spreedsheet. The .doc file can be save without problem. Have you made some change in the api for .xls and .csv recently ? Regards.
Cannot update any Docs or send emails
I am getting the Unable to connect to messaging server and all it has in Loading which stops me from typing anything in Documents i have all my spreadsheets in there and cannot update them. Kind regards Robert
Button disapperas when fixing window
I placed a button somewhere on the top left corner of a spreadsheet and connected a macro to it. Works. Good. But as soon I fix the window to cell F6, the button disappears. When I cancel fixation, the button is back again. But I need to use window fixation. Can you help me?
How do i make formula for date?
I need to make a sheet, For particular column if i add date 17/11/2016 and other column add formula like D6+30 So the result should be 17/12/2016 => current date plus 30 days addition. what should i do whenever i add formula the result is cames #VALUE 17/10/201 =D6+30(Enter) Need result 16/11/2016
Preview Not Available when printing xlsx files from PDF
Hi, I have an xlsx file that I can open just fine, but when I try to print from PDF when some specific options, it shows a Preview Not Available popup. The options I'm choosing manually are... Paper size: Letter Orientation: Landscape Options: Fit to width Every other option is default. When I remove these options it shows a print preview just fine. The file is 69 KB.
Fast Way To Search Spreadsheet - CNTRL + F Is Too Slow - Search Box In Middle of Data
Hey Zoho Docs Team, The Cntrl+F for search really slows us down when working on spreadsheets. Also, it always shows up right in the middle of all your data. Is there any way, to search our spreadsheets quickly? Using A Macro Search Box I have tried creating a macro, but that didn't work: https://help.zoho.com/portal/en/community/topic/search-box-macro-script-to-search-using-filters-in-sheet Here are the other options I was thinking about: Add Search box in Zoho Sheet toolbar In excel, there is a
How to link to external data in a .CSV file also stored on Zoho Docs
I go through all the steps using the "Link to External data" link and when I hit Finish it says "There was a problem with your last edit. Please check and try again".
Reference to another spreadsheet
Hi, Can you please help on below queries: is there any way to refer to a cell or link cells between two ZOHO spreadsheets. using VBA , can we push entries to another ZOHO spreadsheet. Thanks
Double Click To Edit Copy/Paste Cell, Open Links - But Only From One Account?
Hi there, I have a spreadsheet. On my account, it opens links fine and copy/past fine. However, on my team member's account, she has to double click to open links or even paste. I think, in excel, this is called double click to edit. How can I turn on single click? Thanks, Chad
total mess-up of spreadsheet
Hello, I have been evaluating Zoho Spreadsheet now for some time but have to say, that it lacks reliability. Just today, our spreadsheets were totally messed up with cell contents missing on a large scale, wrong cell formatting, formulas gone and macros corrupted. Even the older versions (accessed via Version History) now exhibit the same kind of corruption. What went wrong and how can I restore the spreadsheets to a workable state? Thomas
Suddenly embedded sheet missing data
Suddenly all my sheets embedded in iframes are missing data. It seems like anything in a merged cell (with the odd exception) is not showing at all Is making my pricing tables look rubbish as the column headings have disappeared. Is this something new or temporary? Has been fine until today
Using tags in spreadsheets cells
I would like to add this line in a cell: a2cestmieux.com <info@a2cestmieux.com>, But it automatically change to a2cestmieux.com <info @a2cestmieux.com="">, How can I disable this kind of autocorrect?
Zoho Docs corrupting XLXS file
We have an Excel .xlxs file that we share on Zoho Docs for capturing data.. We have 1 computer that syncs the file to a local drive so it can be used in conjunction with a larger Excel spreadsheet. Have had this setup working well for over a year. Two days ago we started having a problem with the xlxs file sync'd down through the Desktop app being corrupt. When trying to open the file with Excel we get 'Excel cannot open the file because the file format or extension is not valid'. I've confirmed
Maximum Number of Simultaneous Collaborators?
Hello! I am currently researching a viable replacement for Google Sheets for my department at work. We typically have about 20-40 people editing one spreadsheet at the same time. What is the maximum number of simultaneous collaborators in one spreadsheet at one time with ZOHO? I need this answer as soon as possible so that I may begin preparations to migrate from Google Sheets. Thank you! Adam S.
Worksheet Open Event
I'd like to execute a macro when a user opens a worksheet. I tried to do this with this code in sheet "ThisWorkbook", but it doesn't do anything. Private Sub Workbook_Open() Sheets("FirstSheetToDisplay").Select End Sub Any idea?
How can I generate a wide message or report with a macro?
I've a spreadsheet with a lot of data on multiple sheets. I would like to generate, based on that content, a kind of report which I would like to copy & paste into an e-mail program or on a formular in another website. The only way to do this was using the "msgbox" statement. But this is very inflexible, the number of lines are limited, it is not possible to insert CRLF, so it works only for short messages. Isn't there any possibility to extract data from the spreadsheet and generate a report? Perhaps
Does Zoho Sheet support bullets (dots or numbers)?
Dear Zoho sheet? Can I use bullets (dots or numbers) in Zoho Sheets? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Conditional Formatting Bug
I'd like to highlight cells in an area based on a formula. The area is J6:AU44. The formula is =ISEMPTY(J6)*($G6>0)*(J$1<>"") It works. But after a while, I don't know what exactly is the trigger, the formula changes on a magical way to =ISEMPTY(A1)*($G1>0)*(A$1<>"")
Buttons are not displayed on Handy Browser
I recently added some buttons with underlaying macros on an entry page of my workbook. Looks great, work great. But after a while I discovered that my iPhone 6 is not able to display that page correctly, all buttons disappeared, only some pictures and texts are visible. I tried Safari, Opera Coast and Mercury, all same result.
Bug in Sheets: If statement with "<" operator
Hello, last weekend I was fighting against a very ugly bug. It happens in a procedure like this private sub ChangeColor() dim x as variant dim iLimit as integer iLimit = range("Player").value for each x in range("User") x.Select (1) if iLimit > x.value and not isempty(x) then (2) if x.value < iLimit and not isempty(x) then Selection.Interior.Color = 49407 else Selection.Interior.Color = RGB(255,255,255) end if next x end sub When I use (1) it works correctly,
One more reason to move to Zoho Sheet.
Parting with data while moving to a new product is not the case with Zoho Sheet, as the improved 'File Import' lets you bring your files into Zoho Sheet effortlessly. Replace current spreadsheet. Constant updates to your spreadsheet from different sources don't require duplication anymore. Replace your current spreadsheet, while retaining share permissions. Insert as new sheet(s). Use 'Insert as new sheet(s)' to import sheets(worksheets) from various sources into a single spreadsheet. This helps
vlookup not update when requests data from another tab
I modify the source tab, but the destinations using, vlookup not update. I need click cell by cell and press enter (f9 not works). Have any global command to refresh all page? It is my cell: =IF(ISNA(VLOOKUP($B43;QS_AUGUST_2016_AIR.$C$4:$S374;8;FALSE));"";VLOOKUP($B43;QS_AUGUST_2016_AIR.$C$4:$S374;8;FALSE))
ThisWorkbook
Hi, In zoho spreadsheet the thisworkbook should be called everytime a sheet is opened. For my sheet this is not the case anymore. Is there a problem with this function? Thanks and kind regards Ernst
VBA: How dan I insert CRLF into strings?
I'd like to insert new lines into strings which should be displayed with msgbox function. I haven't found anything, the constants vbcrlf or vbNewLine don't work. My goal is, to generate a message based on the sheet content which can be copy&pasted into an e-mail or something else outside Zoho. It works great but I need CRLFs. Example: dim message as string message = "Line 1" & vbCrLf & "Line 2" & vbCrLf & "Line 3" msgbox message range("TextForCopyAndPaste").Value=message
countif returning #NULL! -- formula worked fine yesterday
On my 'Hosts' tab in my spreadsheet, this formula: =COUNTIF(Sites.$N$3:$N$185;$A2) worked fine up until now, where it's only returning #NULL!. The range in question on the 'Sites' tab is correct; I've quadruple checked that N3 is where my data starts and N185 is where it ends. I have a strong feeling that this is a problem on Zoho's side but would love any tips.
Feature Data Validation doesn't work on Handy App
I'm using data validation with area on my spreadsheet. Works great when I'm in the browser, but if I'm in the app, there's no dropdown box showing the valid entries. Even more, it doesn't accept correct entries.
COUNTIF function returning #NULL!
all of the COUNTIF functions that I have in my sheets are returning #NULL! when they worked just fine yesterday. =COUNTIF(P3.H$1:H$5036;"In") is there something wrong with that function now?
What about the error #NULL in excel?
How can i fix about #NULL error?
countif function with compare
In a spreadsheet I would like to count the numbers of occurences that values in an area are greater or equal than a compare value. Both the area and the compare value are referenced. Example: The area is B3:K3 The compare value is in cell A2 In Cell A1 I would like to display the number of occurences, so I'd expect to use a formula like this in cell A1: =countif(B3:K3;??>=A2) Doesn't work as countif compares only values or expressions. Is there any workaround?
Publish only one sheet, not the others
A calculation table can have multiple sheets, I'm using this extensively with cross references to each other. Great! Now the problem: I'd like to publish only one of a few sheets of a calculation. Up to now I can either publish ALL sheets or none. It there any way to make this possible, may be by referencing from another table?
How can I determine the person who is currently working in the spreadsheet
I'd like to generate a "Last Change when/who" entry in a spreadsheet. I was successful with time/date but I have no clues how to find out who is the person who was doing the change. Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = false On Error Goto ENEV range("LastChangeDateTime").Value=Now ' <- this works perfect range("LastChangePerson").Value=???? ' <- what should I enter here? ENEV: Application.EnableEvents = true End Sub
lock cell/sheets for shared access
Hi Is there a way to lock a cell or cell range or sheet so it can not be edited by others. Currently the lock also locks me (the owner of the sheet) out as well.
Why can't I addin Visual Basic? I'm sure its simple...
My code: c_size = application.counta(Worksheets("Sheet1").range("a1:a999")) c_size = c_size+1 My error: Encountered "1" at line 49, column 21.Was expecting one of: <NL>, ":", "&", <DOT>, "^", "(", "-", "+", "=", ">", "<", ">=", "<=", "<>", "\\", "/", "*", "IS", "LIKE", "MOD", "AND", "OR", "XOR", "EQV", "IMP", What am I missing?
Request: Option to Export to Google docs
Hello, I see there is an option to import a sheet from Google docs. I see the Export option has quite a few formats where a sheet in Zoho can be exported to however, it does not have the option to export to Google docs. Would it be possible to put this request into your roadmap? -- Thank you, TXTNLRN Dan text or call: 512-850-4898 Web site: http://www.TXTNLRN.com Teaching and learning through text messages. TXTNLRN Introduction Demo presentation - http://goo.gl/z1MJO or Get to know TXTNLRN http://screenr.com/7yS8
Opening Multiple URLs or Hyperlinks In Zoho Sheet
Hi there, I have a long list of urls in a spreadsheet: http://facebook.com http://perfectclicks.com http://twitter.com Problem: When I click on each one, it opens in a new tab and automatically takes me to that tab. This makes it very slow to open a long list of urls. Potential Fix #1: Can I stay on the current tab when clicking a hyperlink? There should be an option to uncheck "When I open a link in a new tab, switch to it immediately" just like Firefox has. Or, a short cut for this would be great.
display sheets by crm user
Is it possible to authenticate a crm user so that they can see either certain columns and rows or tabs? Thanks
Customizable Charts in Zoho Sheet
Now, create charts the way you want. Show your analysis effectively by picking colors of your choice for various elements of the chart. Visually appealing charts Set colorful backgrounds for your charts. Choose from a wide range of colors for plots, series, titles and subtitles. Choose 'Edit' mode to edit charts with just a click. With the new chart enhancements you can change the color, size, format and font of texts in charts by clicking them. Note: Avoid unintended changes to charts, using the
Impossible to use basic http auth in external data link.
If for example I set https://user:password@example.com/api/data.csv in external data link, a warning says that URL is invalid. Why ?
Next Page