Bringing RTL to Zoho Sheet
Taking into account the request from various Arabic and Hebrew users we have now introduced RTL in Zoho Sheet where you can work from right to left on your spreadsheets. Not sure what RTL is all about? Read on to know more. Work Right to Left If you are a user of the Arabic/Hebrew locale settings, this update is sure to make your day. Working with Zoho Sheet is now a lot easier for you as the grid, column and row headers, menu tab, sheet tabs, and even the cursor will function from right to left
ZohO Download.
kinldy sort ,i cant download excel from spreed sheet.
Create a top and double bottom cell border
Is it possible to create a premade top and double bottom cell border like in this screenshot?
Upgrade to TLS 1.2 for a secured Zoho Sheet usage.
Hello everyone! Keeping your data secure has always been our top priority, and with this update Zoho Sheet takes securing your data even further. Complying with updated PCI standards, we're terminating support for TLS versions 1.0 and 1.1 starting on October 31, 2018. After this date, users must update their processing solutions to TLS 1.2 to continue using Zoho Sheet without any interruption. What is TLS? Transport Layer Security (TLS) is a security protocol that ensures a safe transfer of
Cell references change when sorting
Let's say I have a range of data A1:K20, and the formula for cell D5 is "=10+B30". If I sort that data so that row 5 becomes row 3, the formula for D3 should remain "=10+B30". It should remain this way because B30 is outside of the sorted range. This is how Excel and Google Sheets behave. In Zoho sheets, the formula for D3 changes to "=10+B28". It's acting as if I deleted two rows. This breaks the entire spreadsheet unless absolute references (such as "=10+$B$30") are used.
Data Validation for a column goes away after inserting or deleting a row
If I have a data validation applied from C1 to C100, and if I insert/ delete a row at C50. The data validation is only till C1 to C49. Inserting and deleting a row removes the data validation
How do I hide lines and columns?
How do I hide lines and columns? I cannot find instructions. Thanks for your help. Pierre
sheet gone
Hello, nearly 10 years ago I used to have a simple sheet on zoho. Now I'm looking for it and it's gone. What happened? Are there any 'backups'? BR Michael
Disable people from downloading or duplicate even they can ready only on the sheet
Is it possible? This is to prevent people from circulating the sheet around?
Sheets: Conditional formatting not working in Firefox + console log filled with errors
Where: New Zoho Sheets in Firefox 64 When opening the "Conditional Formatting" dialog in Zoho Sheets and clicking on "ok", nothing happens. Instead, two errors appear in the console: error { target: Window, isTrusted: true, message: "Script error.", filename: "https://js.zohostatic.com/sheet/Dec_28_2018_3_1979055/appsheet/Views/OWNER/initmin.js", lineno: 0, colno: 0, srcElement: Window, currentTarget: Window, eventPhase: 2, bubbles: true, … } initmin.js:15:995 TypeError: t is undefined initmin.js:6:2933
How do I speed up Zoho in China?
Speed is such a problem that we will have to leave your great product because of it. The speed isn't bad in the USA! We have huge issues in China. I tried using a product to get around the china censors which only helped a little bit. What else can I try? thanks Ken
New Zoho Sheet: Publish This Range not working and an error-filled console
When clicking on "Publish This Range" in the latest Firefox, nothing happens after pressing "Continue". THis only happens in the new Zoho Sheet version. Additionally, my developer tools console is filled with errors, primarily TypeErrors and internal errors (I assume there's some connection). Full error log (high-level): https://pastebin.com/yn0zfBa9 Relevant error (pops up when clicking on "publish this range"): https://pastebin.com/Khi09MTE (Not the full error, only expanded one level as copy()
Embed a range
Can you please tell me how I embed a range of cells rather than they whole sheet. If you cant then the service doesnt make sense Thanks Steve
How to highlight duplicate values in a list of columns?
I'm looking for a way to highlight duplicate entries in a list of columns. As an example, A1 to A20 cells - each cell gets values entered manually. If let's say a value entered at A3 is same as a value entered in A17 (as the values are entered over time, not all at one time) I'd like to highlight the cell in red. I've tried with conditional formatting but haven't found a workaround for this problem. Thanks in advance for all help in this issue.
Block users the possibility of going to a version
How can I get my spreadsheet users back to an earlier version of my spreadsheet? I mean: I do not want the users of my spreadsheet to have the option to view the version history, let alone go to an earlier version of the spreadsheet. An unsuspecting user could go to an earlier version of the spreadsheet and cause a loss of valuable information. note: I use google translate.
Search Box Macro Script To Search Using Filters In Sheet
Hi there, There are ways to create a search box in excel using a VBA. The main macro code is pasted below. I was wondering if this could be doable with Zoho sheet. Would this code work? Or, do you guys have a solution to search the sheet and filter the results? Thanks, Chad Sub SearchBox() 'PURPOSE: Filter Data on User-Determined Column & Text/Numerical value 'SOURCE: www.TheSpreadsheetGuru.com Dim myButton As OptionButton Dim SearchString As String Dim ButtonName As String Dim sht As Worksheet Dim
zoho sheet, hide column function added in new version. But what about hide column function in VBA?
Hi guys, I really like the hide column function in the new version, but can i use it also in VBA? Because that would be great, so hopefully you can give me some code to work with or create it :-). Already thanks. Wilco,
Zoho Sheet, button with macro don't work anymore in the new version?
Hi guys, I switched over to the new version of zoho sheet, but now my button with macro don't work anymore. When i switch back to the old version it works again? This is an example of what for code i am using. Sub Docenten() ' ' Docenten Macro ' Gemaakt door wilco02 op maandag 22 oktober 2018 14:18:08 ' Range("F1:K65536").Select Selection.EntireColumn.ColumnWidth = 0 Range("X1:BE65536").Select Selection.EntireColumn.ColumnWidth = 0 Range("A1").Select End Sub The code
Zoho sheet, data validation limited in new version zoho sheet?
Hi guys, I made a search box with data validation for about 600 customers. It works perfectly in the old version, when i switch to the new version it seems to be limited and shows only about 100 people? Do you guys also have this problem? And how can i fix it? Already thanks./
Zoho Sheet - Split cell diagonally fill half color
is it possible to split a cell diagonally, fill different text in each half and ideally color them differently as well?
Document is weak
Hi. I want to work only sheet api my problem; I can't get TOKEN... Step 1: req https://accounts.zoho.com/oauth/v2/auth ?response_type=code &client_id=1000.P4Z0WWOLFDGRT23126TYD3B4JWQ5TE &scope=ZohoSheet.dataAPI.UPDATE,ZohoSheet.dataAPI.READ &redirect_uri=http://mydomain.com/zoho_result.php &state=-5466400890088961855 res http://mydomain.com/zoho_return.php?state=-5466400890088961855&code=1000.041b7b5928bbab9f0af9fdce95126e73.1fac756c41995bd37728b2ec5c1f2d1d&location=us&accounts-server=https%3A%2F%2Faccounts.zoho.com&
Bypass the url by a local url
Hey everyone, i'm using the Excel preview api and i wanna know if is it possible to change the url who is the excel file stored in a server by a local file who is stored on my computer ?? This is the Api link : https://sheet.zoho.com/sheet/view.do?url=http://link.to/file.xls&name=newName And i want something like this : https://sheet.zoho.com/sheet/view.do?url=file:///C:/Users/PC/Downloads/myfile.xls&name=newName Thanks you for the help ;)
editing sheet cells in the edit bar
if I overwrite & hit return, the cell remains *un*edited :(
Macro Disappeared.
I have had a sheet with a Demo VBA-Macro since may 2011 that I occasionally start. It is a demo for an interview that I still sometimes use as an example. After this my macro has disappeared from the file and its history. So even if I go back to versions from 2011 the Macros/view reports the sheet as not having any macros. I am wondering if the location where the macros are stored may have become unavailable. I then opened another sheet with a macro, it had disappeared too. Am I the only one?
Can't Create A Piechart in Zoho Sheets
Hi there I'm having problems creating a simple piecharts in sheets. I have a column that tracks 4 different values. I want to create a piechart to show what's the percentage of each value based on the total number of entries in that column. In MS excel, I just have to highlight that column and insert a pie chart. When trying to do the same with zoho, I get 'No chart recommendations for the selected data range'. And when I select piechart, the preview on the right show's nothing. Would appreciate
Zoho Sheets - Sorting cells by Color & Sorting Text By Color. (Not
Filter)
Hi, Is there a way to sort cells by color and by text color, similar to Excel? Cell and Text can be filtered by color. However, this is not helpful because it isolates ("filters") the cells or texts of the selected color/text and hides all others. I'm looking to sort by color, for example, sorting by cells with red text on top etc. Is this possible?
Timesheet with Balance Due / Formula
I'd like to create a timesheet for an employee, to keep track of their hours, total pay, and current balance due. Below is a screenshot with more detail. I'd like total hours to display all of the results B6:Bxxx. Total Pay will sum all of the values from C6 and onward. I'd like the "Pay Due" (C3) to show all of the balance due for those cells that don't have a pay date listed. With the example above, I'd like it to display "5" but then when a date is entered into the "pay date" column for that
Zoho Sheets 503 Error
Zoho sheets have been unavailable since this morning. I can't open any sheet but docs and presentations are working. Any ideas? Thanks.
Issue with a Sheet after yesterday Connectivity Issue
Hello there guys, As of today we're not being able to manipulate an specific Sheet with Pivot Tables (and filters on it) I've attached a .mp4 showing the problem itself Briefly the problem is that when we try to change the filter itself it's not doing anything or randomly showing an Error Message that implies that we cannot modify a Part of a Pivot Table. Please let us know how to fix this as remaking this whole Sheet is not viable for us currently. Thanks in advance for your support Kind Regards
Alt Keyboard Shortcuts
This is key for me as a financial analyst, and would make things much faster.
Can't able to scroll down to excel
I've created/uploaded excel sheet, but now not able to scroll down, is there any setting where its lock.
zoom?
how do you change the zoom on the sheet?
Temporary glitch in STOCK() function.
Dear users, Due to the unexpected termination of stock data API service from Yahoo! Finance, we are sorry to inform you that the STOCK() function in Zoho Sheet will be temporarily disabled. The STOCK() function will return #ERROR! from our next update. We're working on bringing back the function and will update you once we're done. Please bear with us until then. Thanks, The Zoho Sheet Team
Meet the latest feature of Zoho Sheet: Lock Cells
We are happy to announce the release of one of the most awaited features in Zoho Sheet. You can now lock the cells that you wish to keep secure. Once you are done with editing cells, you can lock them so that they won't be modified anymore. We believe that this feature will be a great addition to our existing set of collaboration features and is intended to improve your collaboration experience. You can access this new feature Lock from Data tab. Apart from being able to lock individual cell ranges,
New forum, closer community, better experience—Zoho Sheet
Hi Everyone! We've been making a lot of changes to Zoho Sheet behind the scenes, and all these enhancements will be out in a few more days. As a first step in moving to a closer community where our team and users stay connected, here's the new Community forum exclusively for Zoho Sheet. Follow the page to see all the announcements, get answers for all your questions, post ideas, and learn some tricks that can help you create powerful spreadsheets quickly, and become a spreadsheet expert! Not
Grey background appearing for Charts when a Zoho sheet is exported to xlsx
When a Zoho sheet having charts is exported to xlsx or xls, a grey background is seen for the charts in the exported spread sheet. Please refer the attached screenshot. Could you please let us know if this could be fixed ?
Freeze panes disappearing/lost in the exported xlsx
When a Zoho sheet having a Freez panes is exported to xlsx or xls, the exported sheet does not hold the freeze panes intact & is lost. Please refer the attached screenshot. Could you please check.
No Zoom Button
Hi, I wouldlike to zoom in and zoom out my zoho spreadsheet file but unable to find that button. Can you help?
Conditional formatting: before/after "today" not available
When setting conditional formatting, it only allows me to set a specific calendar date when choosing "Before" or "After" conditions. Typing "today" returns the error "Value must be of type date". Is there a workaround? Thanks for any help!
Scroll time within the sheet and general delay is extreme
Hello, I've been using Zoho in China for the last one year. The experience with Zoho sheets has just only gotten worse. Every scroll takes 5-10 secs. Every cell entry takes 4-5 secs. Earlier i had gotten replies that it is due to "The great firewall of china". But thats is incorrect because: 1) I have tried using VPN servers from various countries which the same result. Even with different internet service providers. Basically all permutations and combinations. 2) I travel back to India and the experience
Next Page