We’re rewarding the question askers & reputations are being recalculated! Read more.
7

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


6

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


5

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

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


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 http://...


2

Short answer The script should be wrote by and end-user/developer. Explanation Google Sheets doesn't include a way to automatically convert VBA code to Google Apps Scripts. By the other hand not all the VBA statements, classes, methods, etc. have an equivalent on Google Apps Script and not all the Excel features have an equivalent on Google Sheets, so ...


2

Seems your Excel is set to the 1904 date system (more likely for Mac users than PC users). This is an Excel option. Dates in Excel are index numbers that by convention start either in 1900 or 1904. The setting may be changed in Excel under Options > Advanced > When calculating this workbook.


2

This is a job for the INDIRECT function. For the sum in A8, use =SUM(INDIRECT("R2C" & B8 & ":R5C" & B8; FALSE)) Likewise, for the sum in A9, use =SUM(INDIRECT("R2C" & B9 & ":R5C" & B9; FALSE)) Explanation: INDIRECT lets you construct cell addresses from dynamic input, e.g. from other cells. It supports both A1 notation (as in A2),...


1

You need to use TEXT, instead of TO_TEXT: =TEXT('90diaspessoas'!A16,"dd-mm-yyyy" ) As long as underlying date number is correct, This will work. OR Set formatting in '90diaspessoas'!A16 correctly to DD-MM-YYYY. Then, TO_TEXT will work. FINAL CONCATENATED FORMULA: =TEXT('90diaspessoas'!A16,"dddd dd-mm-yyyy")


1

Short answer Apply "real" border lines. Explanation The "default borderlines" in Excel and other spreadsheets application are named grid lines. They are a visual aid, not real formatting.


1

As far as I am aware, this is not possible, given Excel's incompatibility with Google Apps Script. There is an alternate and only slightly less efficient solution, though: each time you want to analyse the results of your Form, simply download the connected Google Sheet as an Excel spreadsheet, open the downloaded spreadsheet in Excel, and do your analyses ...


1

I'm no Excel guru, but I think this page on the CommCare Help Site goes through the steps to do at least some of what you're talking about: https://confluence.dimagi.com/display/commcarepublic/Tutorial%3A+Create+an+Excel+Dashboard. The key might be starting at "Step 4: Name your raw data for easy reference later" where is shows you how to mark all rows in ...


1

What's the equivalent of the SEP metadata in Google Sheets? There isn't one. is there an all around metadata which could work both on MS Excel and Google Sheets No.


1

Please try: Find: (.+)\) Replace with: $1,0) Search: This sheet (or to suit) Search using regular expressions Also search within formulae Replace all.


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

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


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


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