並び替え後、フォントサイズが大きくなって
いつも役立たせていただいております。 本日並び替えを試してみたのですが、並び替えの度に、当初7ポイントだったものがサイズが大きくなってしまうようです。 サイズが変わらないようにしていただくと大変助かります。よろしくお願いいたします。 （元々エクセルで7ポイントでインポートしたシートでした。ポイントのコンボボックスを見ると、7は、選択肢の一番下に表示されていますので、本来、Zoho Sheetの仕様想定外のフォントサイズだったのでしょうか。。） lvjlvj
Technical Support
ok
Can't open Sheet, please help asap...
hello, just emailed support, posting here meanwhile. i can't open sheet from my account (friend's works fine). this is the error i get: var jsMsg=eval(({StackedBar: "Stacked Bar", NamethisCellRange: "Name this Cell/Range", FormatCells: "Format Cells", InvalidName: "Invalid Name", SaveAsNewDocument: "Save As New Document", Owner: "Owner", Column3DDesc: "Column with a 3-D visual effect.", StackCol1003DDesc: "100% Stacked Column with a 3-D visual effect.", hasClosedDocument: "has closed the document",
Remote APIs unusable in robust solution - check HTTP codes
Hi, I'm the technical lead at huddle.net, an online collaboration system, where we've just put the finishing touches on to our Zoho integration. Overall, my experience has been good, but it is clear that we can't build a robust solution on top of your API. We currently have two serious issues with the way that the Zoho APIs are implemented. Firstly, the remote API is broken. The documentation clearly states that you can return an HTML fragment with output=editor, and that this fragment can be embedded
コピー＆ペーストについて
IEのブラウザ上にてコピーした表のペーストが何故か出来ません。Excelだと何の問題もなく出来るのですが・・・ この作業がzoho sheetでも可能になると嬉しいです。 sumitono
budget speadsheet
Yes this looks great!
Must have feature
I didn't see anything in your FAQ section, but I would think that "find" would be a must have feature. Excel has a very ellaborate find feature with finds by column, full, prefix, suffix etc. webcrsn
Technical Support
can't send notification to shared users using SHARE > NOTIFY SHARED USERS ?? diggermel
eBay Final Value Fees Formula
Hi, Does anyone know if there is a way to produce this formula in Zoho? =ROUND(D2*1.5%+MIN(D2,1000)*(3.5%-1.5%)+MIN(D2,25)*(8.75%-3.5%),2) I'm using it to calculate my final value fees in eBay. I want to create a spreadsheet that can be used by multiple users. Thank you in advance for any help. eBay final value fees are based on these numbers. http://pages.ebay.com/help/sell/fees.html $0.01 - $25.00** 8.75% of the closing value $25.01- $1,000.00 8.75% of the initial $25.00 ($2.19), plus 3.50% of
Row alignment
I already read a topic on this but with no solution suggested. My spreadsheet shows the lines misaligned in the left section (the ones which numbers the rows) against the rest of the document. If I manually change the row height it's fixed, but if I move to a different sheet and then I switch back to the first one, the problem happens again. I tried with Camino, Safari, Firefox (both under PC and Mac Os X 10.5), any idea? I could also share the file with you if you tell me which user would you use
iPhone interation enhancements
First, thank you for the awesome online spreadsheet! It really is fantastic. Recently I got an iPhone and began using one of my online sheets with it. Since I need to edit the sheet so that it recalculates, I'm using the full interface to zoho, not mini.zoho. So, here's the "issue" and request for help. When editing a sheet from the Safari browser in an iPhone, simply selecting a cell to edit does not work as it does through a normal browser. From an iPhone here is what it takes to edit a cell: 1)
Viewing Text Across Empty Cells
In Excel, whenever you type in text inside of a cell, and the cells next to that cell are blank, you can see all of the text, as though the other cells did not exist. The only time that you cannot see an entire text sentence, for example, is when the cells next to that cell contain date, text or forumlas. In your online version, I cannot figure out how to display long text sentences in a cell, even when the cells next to that cell are blanki. I cannot find any way to clear or format the other cells
Zoho Sheet not loading
Can't access my Zoho sheets - they keep on "loading", but never show up. Maybe it's due to my location (Shanghai, China) - any ideas? axel.mosig
When I select a few columns and drag
this option does not work.. when I do the drag it pastes wrong dates and numeric fields. I need a certain columns to be moved below to create space for entries above. I am not able to do this. vkman72
Wow!! Wat a tool
Excellent work!! I sincerely appreciate the efforts behind it ashokmsis
why can't I merge some cells in a column?
why can't I merge some cells in a column? nanfang05
日本語入力について
日本語が タスクバーからしか入らないのはすべんです 至急、表のセルからストレートに入力できるようにしてください miraix2
copy and paste is not working in zoho spreadsheets under IE
when you do the following in Zoho sheet under IE: 1. double click on a cell which contains text or whatever 2. select all text in the cell or use (Ctrl+A) 3. copy the contents 4- go and paste the contents into another cell 5. the pasted text will appear only on the value bar above (for seconds) and not on the cell, so you lost the pasted text. could you help me on this issue?! Ahmad
File Size limit and default languages
Hello Zoho: (1) I appear to have successfully imported two larger (1.5-mb) Excel files with extensive sales data. However, when I double click to open, the spreadsheet shows nothing. What is the problem? Is there a limit on file size?? (2) When I pull down the "language" tab, it appears to default to Bulgarian -- I can't get it to stay with English? Is this a problem -- my screen is in English. Thank you, Rob Godfrey Carpinteria CA 93013 iMac w/OS X robgod
problem with imported spreadsheet
I have a spreadsheet with email addresses and a pivot table. Zoho sheet doesn't like it. Firefox locks up and shuts down. brentrjones
Slow loading on Zoho projects / user access
It is extremely slow sometimes to load functions on Zoho projects. As an example, if I want to load tasks and milestones, the page takes around 30-40 seconds sometimes or it just hangs up. Why is this so ? My company is thinking of signing up for a paid account but the lag time in loading pages is going to be a big deterring factor as we would need our team members in remote locations to be able to fire it up easily. Also, on another note, it is quite funny that I have two to three users seen online
where is the UNDO function
I don't see any icon or any menu item to UNDO changes in a sheet. brentrjones
new user
just logged in for first time! This ROCKS!! I LOVE IT drkucharski
Conditional formatting?
I rely on conditional formating. I'll need that before I can use zoho in a production environment. fedude
Zoho sheet filename is corrupted when arabic file name
when posting an arabic file name or generaly a utf8 filename except for English it appears corrubted, this is a sample reuest i made: ----------------------------------------------------------------- <html> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8"> </head> <body> <form id="mainForm" method="POST" action="http://sheet.zoho.com/remotedoc.im?apikey=[apikey]&output=editor&format=xls" target="_self" onload="this.submit()" > <input type="hidden" name="filename" value="حمد.xls">
Shared Sheet not updating for simultaneous users
Hello, When two of us edit a sheet simultaneously, we don't see many of each other's changes and can overwrite cell without knowing there was data in them. For example, Alice and Bob are editing the same sheet at the same time. 1) Alice types data in cell A5 2) Bob's view of A5 still shows it as empty, even several minutes later 3) Bob types data in A5, overwriting Alice's without knowing it. Updates seemed to be more frequent for one user than the other. We tested this several times. Both users
love your tools but with sheet how do I lock a row or colum
You know how int google docs or ms office you can lock a row or column... I dont see a way to do that with your tool. let me know. thanks. richagent
Alphabetical order
The alphabetical order only sort one column but do not sort the second. For example I have entered this. A C B B A A A B B C B A I highlight all and click the sort. It will give me this. A B A A A C B B B C B A The first column is sort, but the second column is not sort so I must sort again. But this waste so much time because I have so many rows.
deleting spreadsheet
How does one delete a spreadsheet? Thanks, Joel jcohen66
IMPORT problems
Just found ZOHO last night and now giving it a try. Can't seem to IMPORT any of my files in XLS. Is there a limit to size, rows or columns ? I have files of some 13,000 rows with approx 10 columns. These are newly re-constructed roster of YS Army Divisions. I have them on a website as HTML, but very cumbersome and not inter-active. www.IndianaMilitary.org, 106th Division, Roster Thanks
List of spreadsheets is now gone!
I seem to have found a bug. When I first log in I have a list of spreadsheets on the left side of my screen. If I minimize this window (using the [x] at the top right of this window) it will slide off screen to the left. I can open and close this window fine using the arrows at the edge of the window, or the double arrow at the top left of the ZOHO window. ...BUT... If the window is off-screen to the left and I click the ZOHO Sheet logo at the top left of the screen, the window will disappear completely
Hyperlinks in spreadsheets
Guys I have a spreadsheet (imported) that has links back to the main page (hyperlinks in other tabs) When I use this it just opens a blank spreadsheet. burry21
Zoho Sheet Remote API as DDE?
Hi, I am not geek, so maybe this question doesn't have a sense. Anyhow, could I use Zoho Sheet Remote API to write data to zoho sheet from the third party application, or write data to the third part application from zoho sheet? Something similar to DDE feature, Excel has. Thanks in advance.
Dropdown Lists?
Dropdown lists and conditional formatting are lost? fedude
Fixierung von Spalten / Zeilen
Ist es möglich, in Zoho Sheet Zeilen oder Spalten zu fixieren? Gruß MS binomsc
Linkages Zoho projects to Zoho sheets
I have a Zoho projects account and use Zoho sheets to link excel sheets to upload as a url on Zoho projects. The question I have is that, do I need to have a paid subscription seperately for Zoho sheets if I will want to go in for a paid Zoho projects account and will this be the same procedure for my various users ? (or is it only admin ?) How does this work ?
Zoho projects - notes function
When I add notes to a certain task (added as admin), who is able to edit or delete the task ? I have tried it as admin and as a user and the button for the edit/delete note frankly seems to have disappeared for some notes assigned by admin. Also, as the notes attached to a certain task can still be seen once completed tasks have been archived, can they also be deleted ? What is the threshold limit for the number of notes I can add to a task ? Also, is there a function where I can export notes to
cut paste does not seem to work
Trying to cut and paste from excel with no luck. Import external data - web query would also be a cool option. greatest_real_estate_agent_in_the_world
Jan summary
summary shows "invalid format"--Why??? irwinmomm
Persitant Error Message
With almost every entry I make I get a message box saying something like: the server has encountered a problem please reopen zoho. This slows me down a lot. how do I stop it? bruceterrell
Next Page