Zoho Sheet and Freeze Panes
I am opening an Excel workbook in Zoho sheet. The workbook has images in the top rows of cells. When I freeze panes, the images disappear. The images reappear when Unfreeze is selected. Is there a way to make this behave as it does in Excel, where the images remain visible regardless of Freeze?
Can someone help me with Zoho spreadsheets?
I requested an appontment call back which I never received early this morning. I've just rebooked and the time that I've been booked for is appearing as 3:30pm CST time, when I specified my time zone as Beijing, China time. 3:30pm CST time is early in the morning in China. Can somone please cancel this appointment and just either call me any time during the day, China time or respond to my previous thread?？ This query about macros has now been going on for 2 weeks!! If converting the macros from
Allow Anonymous Collaborators
Hi, I would like anyone to be able to edit a sheet but without logging in or added as a collaborators. Is there such a thing as world read/writable?
Split Function
Hi, Is the a split or equivalent function available? Here is what I'm trying to accomplish. If a cell has 5 names (John, Bob, Larry, James, David) I want a count of the names. In Google docs, I accomplished this by doing =counta(split(A1,",")) It's hacky but it works.
Problem with macros
This code return error Wrong number of arguments or invalid property assignment: _Default Public Sub ReCalculate_acepted_contacts() i=10 j=2 'это шаблон заполнения Sheets("Сводная").Cells(i, j).Value = get_acepted_contacts(Sheets("Сводная").Cells(i,i)) End Sub But this code is work correct Public Sub ReCalculate_acepted_contacts() i=10 j=2 'это шаблон заполнения Sheets("Сводная").Cells(i, j).Value = get_acepted_contacts(Sheets("Сводная").Cells(10,2)) End Sub In first example
Link to table on a web page
A table is updated daily on this page: http://www.tsp.gov/investmentfunds/shareprice/sharePriceHistory.shtml ...and I wish to update it daily on a spreadsheet. When I used google sheets, the function is successful when using this formula: =IMPORTHTML("http://www.tsp.gov/investmentfunds/shareprice/sharePriceHistory.shtml","table",2) ...but when using Zoho Docs, selecting "link external data," and using this URL: http://www.tsp.gov/investmentfunds/shareprice/sharePriceHistory.shtml ...the message returned
How can I store an old value as comment using VBA?
Hi, I am trying to make an excel spreadsheet which will retain the value of the cell as comment when new values are inputted. I know on excel this is possible and I found the following off the internet. Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'copy previous value to another sheet Sheet2.Range(Target.Address) = Target End Sub Private Sub Worksheet_Change(ByVal Target As Range) '//clearing more than one cell causes an error On Error Resume
Spreadsheet disappeared after marked as favorite.
Hello Zoho, I just recently starting using a Zoho spreadsheet to keep track of some information. As I uploaded different files I wanted to make sure I could always find this spreadsheet so I marked it as a favorite. After that the spreadsheet dissapeared. I can't find it in any of my folders or the trash. Do you know what happened to it and how I can get it back? Thank you.
Formulas don't import properly from excel .xlsx
I imported my Excel file and when I try to use it many of the formulas aren't working. Is there an ideal format that I should first save my Excel file in so it imports formulas properly? Please help.
Sorting numbers and letters in columns
When I try to sort combination letter/numbers, like S1, S2,S3,S4,S5,S6,S7,S8,S9,S10,S11,S12, anything above S9 will be sorted following S1,, like this: S1,S10,S11,S12,S2,S3,S4,S5,S6,S7,S8,S9, I have tried everything I can think of like using "S01" instead of "S1", etc. How do I fix this? Thanks.
Sluggish performance when sorting large column
Hi, I have an embedded spreadsheet on my website and one sheet has quite a long column of data - about 700 rows and counting daily. When trying to sort or filter this data on the embedded version, it simply refuses to respond. The column or selection stays in green but no matter how long it is left to do it's working, nothing happens. As the data contained on the spreadsheet is intended for visitors to do exactly this and is a main reason why they come to my website, this is very frustrating. Especially
How do I read multiple Zoho Spreadsheets, which are different files in Zoho Docs?
I have 3 spreadsheets where I need to read the data into one spreadsheet. How do I do this?
Can I set a spreadsheet so that only some users can view/edit certain worksheets within that spreadsheet?
EOM
Excel containing 1,00,000 rows with 200 columns is not opening in ZOHO Spreadsheet.
I have tried to open local excel file with 1,00,000 rows and 200 columns in ZOHO Sheets, which is not opening. Is there any possible way to open this in ZOHO Sheets?
??? where the cell is empty in the formula
Hi, I have been using Zoho spreadsheet for a while.In most of the cell I found sign of "????" in which the cell are empty but the formula is there whose results is zero. Why this so ??
Why can't i select a single cell? is this a bug?
Hi, When i type a formula, like in any spreadsheet editor, i can select another cell with mouse pointer. At this point, i expect the select cell (only) to be added to my formula, but instead of that, i get a bloc of 4 cells, that need to be manually adjusted to 1 cell. 1) why..? Why would you do that? 2) is this a bug? if no, then please answer question number 1. :) 3) Is there a way to disable this ? Please tell me it's a bug or it can be disabled...
Conditional formatting not gets ported when downloading zoho sheet to PC
Hi Team, While downloading a zoho sheet as Xlsx file the conditional formatting in the sheet is not getting downloaded in the file. It will be a good ad if it could be fixed. Thanks! Raaj
Problem with: "Your edit is not applied to the document. Please try again later."
Whenever I try to edit my spreadsheet called "brojila", Zoho spreadsheets says "Your edit is not applied to the document. Please try again later." It has been saying that for couple of days. Any help is appreciated. Thanks, Davor
Get set for Icon Sets.
Conditional Formatting in Zoho Sheet has become more exciting with the addition of Icon Sets. Represent a series of data with certain intervals using colorful icons. They are available in sets of two to five icons making them flexible with your data. How to use it. Icon Sets is placed under the Conditional Formatting menu tab. You can use a set containing two icons for data with TRUE/FALSE or similar conditions, three or more icons to see the change in data with many
Unable merge cell
I fisrt time ZOHO office speadsheet. i have problem on merge cell at my pc. i unable to use merge cell icon. The merge cell icon is not active... is my pc need to update? PC Specification Windwos 10 pro Intel Core 2 Dou CPU E7500 @2.93Ghz Installed Memory = 2 GB System type = 32 - bit Operating system
2 Spreadsheets Disappeared from Shared Folder
2 weeks ago one spreadsheet disappeared from my shared table Yesterday this happen again with another shared spreadsheet Each time this happen after Server Error which was something like "We are sorry but there is current problem with the server" And after refresh the spreadsheet was gone. Already checked Trash but isn't there. Can you help me, please? These spreadsheets are very important and i don't know how they just disappeared from my files. Thank you in advance.
Write in a cell of a locked spreadsheet Using VBA code
Hi. How can I write in a cell of a spreadsheet that is blocked? I mean: I need to collect information in a spreadsheet of an user and through a macro (button) this information is sent to the spreadsheet that is blocked for that user. The user can not write directly to the blocked spreadsheet, but he can enter in another spreadsheet where he enters information. Can this be possible? for example: There are three spreadsheets: Sheet 1, Sheet 2 and Sheet 3. Sheet 1 is a spreadsheet locked and no one
How tot color a block of cells with a condtional format
I would like te automatical color en block of cells (for instance B5 to D8) when in one of the cells a name apears. I have tried tot celect the block an formulate the conditi0on but a best one cells colors. What is the right formula or is in not possible in Zoho spreadsheet? I have tried text contains end trhe formula´s =$B$5="dave" and =$B$5=dave
Indirect() function not working
H, I had the following function in Excel INDIRECT("'" & $A4 & "'!" & C$2) when imported to zoho, I get an error, event though, apparently - indirect() exists - what is Inside the parenthesis works and gives " Act 1_1!C26" (tab & reference I want to get the content of..) Can you help me? Thanks Loïc
Finding a value in a worksheet via VBA
Hi, I'm trying to find a string (ex. "Smith, Joe") in a column ("A") in a sheet. First, it appears that Match is the function I should use, is this correct? If so, I cannot get it to work. Here is the code dim x as long msgbox (x) x = worksheetfunction.MATCH("Rabbit", WorkSheet("KeithQuoteData").Range("A1:A50"), 0) I'd appreciate any help with the Match function or a better way to search for a string and return its location. Thanks, Dennis
Dialog Box
Hi there, I'm trying to add a dialog box with vba to confirm that a certain action is about to happen and it just produce me a regular message box. The code: If MsgBox("Delete this Row?", vbYesNo, "Confirm") = vbYes Then Thoughts? Thanks, O-Ren
Adding more color and category to Charts.
Charts are the most effective way to represent data inside a spreadsheet. Zoho Sheet is constantly working on improving this marvelous tool of data visualization. Let's see what the current Chart update has in store for you. 1. Colors to make charts with elegance. Color Schemes Default colors can make your charts look monotonous. Hand-picking colors for each segment of a pie or funnel can also be tiring. Choose from the four sets of color schemes, or from the various other monochromatic shades. Already
Workbook_SheetChange is not working
Is there a reason for that? Thanks O-Ren
How to connect or link one workbook to data that is stored in another workbook?
How? Thanks, Oren
IMAGE(URL) Function on Spreadsheets
Hello ZOHO Team, I see that the IMAGE / IMAGE(Url) function is available now on Spreadsheets, I searched on Zoho's forums/topics with no results about this new feature from other users. How can I make it work? I already tried the following ways with no luck: =IMAGE(http://mysite.com/image.gif) =IMAGE('http://mysite.com/image.gif') =IMAGE("http://mysite.com/image.gif") All of the above functions just returns a !NAME# This IMAGE function requires most of all my imported spreadsheets To make World
Hours Calculation
Hi, I'm trying to sum some hours on my spreadsheet, but every 24 hours I get back to zero. How can I solve this or at least go around of it?
Zoho Spreadsheet not opening
All of my spreadsheets keep on loading but doesn't show any data
File is lost after being online 9 years
Hello, I uploadd XLSX file about 9 years ago and it was working fine untill recently. Now it's completely empty and I can not download it in original format either.
Unable to export spreadsheet
I have several spreadsheets that will not export or download. I have tried restarting the browser, clearing the cache, even rebooting the computer. I also tried copying the spreadsheet nothing is working.
How to insert combo box in Worksheet ??????
How to insert combo box in Worksheet ?????? Anyone have idea about it Please, tell me it's argent
Can't find a function
Could I ask some assistance in figuring out some formulas to perform a couple of calculations I am attempting to perform? I cannot find anything in the help files. Scenario 1: Let's say that, for any given row, columns E through X all contain numeric values, except that one and only one contains text. How would I perform a calculation that finds that occurrence of text, or even the "first" (of one) occurrence of text in columns E through X, and set that cell's value equal to the text? Secondarily,
Working at the same time in shared spreadsheet
When sharing a spreadsheet, we cannot work on it at the same time. If we use filters and i have it opened with a filter selected whoever is working on it at the same time will see his screen the way I see it, with the filters I selected so he has to stop whatever he is doing until I finish using the filter... Any suggestions? am I doing something wrong?
CMD + Select in Sheets?
Hello, Is there any way to use the traditional CMD select function? Normally its like the Shift + select, but it does not include everythign in between - only what you are clicking on while holding command. (might be control for PC users) Thanks
zoho sheet stuck
I Need help. ZOHO sheets stuck on the loading screen. I've already deleted the system cache and cookies of my browser (google chrome) but it's still not opening.
[Zoho Docs] Charts are changed after exporting from Zoho Sheets
This is what my excel sheet charts look like in Zoho Docs, After exporting, it looks like this. Is there any way to fix this? Please help.
Next Page