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 ...


3

Google Sheets allows you to protect specific cell ranges so only certain users can edit them.


2

I've shared a sheet for you to play with here. There is a fourth sheet to help write the second solution The simple solution (with only numeric ids) is quite straightforward: =MAX(Sheet1!A2:A,Sheet2!A2:A, Sheet3!A2:A) (This assumes each column has a title) The situation with a prefix works like this: ="R" & MAX( ...


1

I have been building an online database application over Google App Engine for such use-cases. It is called iFreeTools Creator. Supports multiple data-types for fields including single-line text, multi-line text, numbers, images, geo-location and more. Forms and views are automatically generated for users based on their authorization profiles. Users ...


1

With the following formula you can accomplish that. Formula =QUERY(DATA!D2:F15, "SELECT D, SUM(F) GROUP BY D PIVOT E LABEL D 'Politicians'") Explained The QUERY function will group the summation of the costs per politician and pivot the outcome per type. Screenshot Example I've prepared an example for you: overview with query and pivot


1

The solution is to set the correct Local under the Spreadsheet's settings ("This affects formatting defaults, such as currency."). So if you want US.locale style (MM-DD-YYYY), then choose US.Locale. If you are in a different locale and want formatting


1

There is no default way to do it through UI of google docs. However, I have written a small script that you can use on your google docs spread sheet to add rows. function addRows(){ var sheet = SpreadsheetApp.getActiveSheet(); var rows = sheet.getDataRange(); var numRows = rows.getNumRows(); for (var i = 1; i <= numRows*2 - 1; i+=2) { ...


1

Perhaps you are requesting an array formula: =arrayformula(A1:A&", "&B1:B)


1

You can do it for first row and then drag the formula to next rows in the column. Just go to the corner of the cell where you have already applied, the arrow will become a cross hair. Drag it to next rows. The formula will be automatically updated till the final cell where you drag and values will be calculated.


1

So as I was saying... I couldn't find anything that would let me do this that didn't involve installing a full spreadsheet app so I created a simple CSV transposition tool on app engine: CSV Transposer Tool


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

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.



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