Tag Info

Hot answers tagged

10

Google Docs Upload your existing files. Google Docs accepts most popular file formats, including DOC, XLS, ODT, ODS, RTF, CSV, PPT, etc. So go ahead and upload your existing files. Familiar desktop feel makes editing a breeze. Just click the toolbar buttons to bold, underline, indent, change font or number format, change cell background color ...


9

I find the inability of Google spreadsheets to select noncontiguous rows or columns a serious limitation, particularly when formatting a spreadsheet. Keyboard shortcuts that will work on one platform but not another seriously hinders my use of Google docs in general. (That said, I use Google Documents a lot and wish I could use it for more.)


9

Google Spreadsheets doesn't have Pivot Tables built in. For any serious data analysis that could be a real deal breaker. However, it does appear that there are apps in the marketplace that add this functionality in, for example: http://www.google.com/enterprise/marketplace/viewListing?productListingId=3466+14613093613005114004


7

Blank cells count towards the limit if they are within the range of non blank cells. The calculation is done by multiplying the number of the last row with data by the number of the last column with data for example: +----+---+---+---+ | | A | B | C | +----+---+---+---+ | 1 | x | | | | 2 | | | | | 3 | | | | | 4 | | x | | | 5 | x ...


7

Besides what's already been said: Lack of text-to-column parsing. That is, if I have a raw string like Blah|2|4|5|www.google.com Foo|2|1|1.2|www.twitter.com It's trivial to have Excel quickly do a text-to-columns on that, using | as a delimiter. Making data formatting as simple as possible is crucial to people who need to create or interact with data ...


5

If you're just looking for rows/columns to insert data, then Google Spreadsheets are the way to go. Two really cool applications for Google Spreadsheets is using it to create a live Feedback form for any website (if you know how to edit HTML, then you can even take the attributes from the Google Form and use your own website's HTML and CSS to format the ...


5

In Google Docs spreadsheets it is only possible to select a single cell or ranges of adjacent cells. So in short NO, you cannot.


3

I am pretty sure that Google Docs does not quite do what you would like. One neat feature in Docs for a spreadsheet is that you could make a form onto your sheet, and give people the form, where they enter their information, and select their name from a list, so you could sort on their data.


3

There is a free application known as TrelloExcel out there. I've been using it for about a week or two now - https://github.com/dillenmeister/TrelloExcel It will very nicely export/import data, but it doesn't seem to handle updating existing items. For what you need it for, I think it will work to get you the task name, description, and due date (but no ...


3

This has been fixed in the Google Docs Spreadsheets. You may now use the F2 key to begin editing without clicking in the cell.


3

Per the official list of keyboard shortcuts, F2 is the only key responsible for editing a cell. I've just tried it in 3 browsers (Chrome 16, Firefox 9, and IE 9) and it doesn't function the same way as it does in Excel. Your solutions are 1) pressing F2 before entering any data, 2) pressing Backspace to remove the characters you've typed after the error, or ...


3

You can look at Wikicalc, an open source Wiki-Spreadsheet http://www.softwaregarden.com/products/wikicalc/ And if you are not so fixed on using a spreadsheet-like user interface, why not a "standard" html form, with javascript to do the calculation ?


2

I would say the two that I notice are: Lack of spell check Not as many chart types built in, in particular, basic charts for stocks.


2

You can find them using find and replace if you go to view -> all formulas (ctrl+') and then do you "round( " find this will at least cut down on the manual labor of it all I couldnt find a way (using find and replace to search for wild card value though EDIT: Try out the script below REF: ...


2

I bashed up a comparison sheet for the formula's between MS Excel 2010 and Google Spreadsheet. Comparison was based on the names only. See snapshot of the current situation: If you want to make sure that Google Spreadsheet files are properly converted and still work in MS Excel 2010, then don't use the following formula's: ADD ARRAYFORMULA CONCAT ...


2

Just publish the template with read-only privileges. Then they can go File->Make a copy to duplicate it for their own use. That's how templates work.


2

I think you can do what you describe with Forms & Spreadsheet in Google Docs. Step 1: In Google Docs, select Create New > Form Step 2: Create questions in "Edit Form" window. Each question will be represented as a column in the spreadsheet that is being created in the background. (I assume you'll want "Name" and "Latest Score", so I'll use that ...


2

Google will allow you to directly edit a spreadsheet in an iframe. I've got this on some of my sites. In my case, the sharing in the spreadsheet is set to "Anyone with the link" "Can edit". Not sure how it would work if you require authentication.


2

This is a bit off topic because it doesn't answer the question of Excel exporting, but it does address the side of good solutions for burndown charts. We use Trello Burndown from Blue Line Game Studios. It does a pretty good job and everyone can update their piece so it's not dependent on sharing an excel spreadsheet. You can find that at ...


1

This is what I came up with. Screenshot Explained Column F expresses the weight of the measurement in the series. Multiplying the height and the width by the fraction, will yield the corresponding fraction. A summation will yield a weighed height and width. Example I've created an example file for you: Average Resolution


1

I have a temporarily solution: Right-click the target excel cell Choose Paste special Choose Text


1

If you want to make sure that MS Excel 2010 files are properly converted and still work in Google Spreadsheets, then don't use the following formula's: AMORDEGRC AMORLINC AREAS ASC AVERAGEIF AVERAGEIFS BAHTTEXT BESSELI BESSELJ BESSELK BESSELY BETADIST BETAINV CALL CELL CHIDIST CHIINV CHITEST CLEAN COMPLEX CONVERT COUNTIFS CUBEKPIMEMBER CUBEMEMBER ...


1

There is no current functionality to do this (I'm not on the Beta, so I cannot test the Bulk Export functionality currently on offer, although it doesn't look like its what you need). However, there is a card on the Ideas stack (sort of a feature request list), entitled CSV or Other Export. This looks like more what you want - however it's not implemented ...


1

Adjacent As of 11-02-2014, it is possible to select multiple cells, even the ones that aren't adjacent and perform different actions like: Styling Delete values Undo/redo actions Paste values (into all cells) Apply a quick sum Work with formulas and charts Screenshot Note This is only possible with the new Google Spreadsheets. References ...


1

not tried it myself But been wanting to find time to install (& hopefully compile) feng office


1

As Gmail doesn't preserve formatting, your options may be to: Copy the file to Google Drive and reference that using the "Insert files using Drive" option Insert a screenshot of the relevant portion of the sheet within the email, if you're particular about formatting and the data isn't a lot


1

The way you've stated it, that this is not a FORMATTING problem: you need to use a FORMULA to combine the data you have into a new data-value, in a new cell. The nice thing about using a spreadsheet for this is that it's dynamic: if your source data changes, your derived data changes at the same time. However as others have stated, the gmail ...


1

You don't have to create in one go the whole string because some clients have limitations regarding the number of recipients. You can simply create the desired format for each row and then select the ones that you want and paste them in client's field for BCC. You don't have to worry about the fact that you're copying cells instead of the string, because ...


1

You might look at Docs.com, which is Microsoft's free online service. You won't have to do any kind of conversion with the existing spreadsheet documents.


1

Google spreadsheets formatting is limited compared to the newer versions of Excel (2007+). I have found it much easier to create usable spreadsheets with a decent UI using Excel than Google Spreadsheets - everything I do with the latter looks like Excel 2003! Google spreadsheets does web interaction much better than Excel (retrieving info from the web such ...



Only top voted, non community-wiki answers of a minimum length are eligible