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

Include formatted code by wrapping it in three backticks (```) at the beginning and end of the block, or by starting a line with four spaces. Important note — the triple backticks have to be on a separate line and ensure you have a blank line before and after the code block.


11

I will assume you're not using Chrome, which is why my answer is relevant. Check out this article on copy/pasting in Google Drive documents: When working in Chrome, you can use the right-click menu to copy and paste content (or select "Copy" or "Paste" from the Edit menu in the toolbar). When using the right-click-context menu in Drive, the stuff you ...


5

Either surround the code by backticks (`) for smaller segments of code, or make sure that each line begins with a tab or at least four spaces.


5

I took some test CSV data and pasted it into a Google Sheet. When I opened the clipboard and chose "split text to columns", my data was immediately split. There shouldn't be anything else you need to do. Try with a smaller sub-set of the data.


4

Use $ sign to lock range. $H$1


3

If the other calendar is shared with you and available in the "Other Calendars" section in Google Calendar, you can save the ICS version of the calendar and import that into your own. To do this: Go to Google Calendar Click the ellipsis to the right of the "other calendar" that has all the events. Select Settings. In the Integrate Calendar section, find ...


3

We don't have inter-tab clipboard, but it would be possible. Please add it to the feature request list if you'd like to see it. They've added an option for cut and paste (which you can see at the link). We've added experimental support for this using local storage. It can be enabled with the clipboard=storage URL parameter as follows: https://www.draw.io/...


2

Finally found the answer here: http://daringfireball.net/projects/markdown/syntax#code using markdown is outdated, its not as easy as just using Gist haha, think I'll keep that route... they should really work on their tools.


2

I know that the subject is a bit old, but I found myself faced with this problem. I wrote an userscript if anyone is interested in it. It works with triple backslash with line feed and allows syntax highlighting, according to the indicated language. (edit: here) Eg: # Title Text line ```javascript import Vue from 'vue'; import App from './App....


2

Ctrl+A - Select All Ctrl+C - Copy To Clipboard If you just want to copy part of what's on screen: Mouse click at the beginning of the paragraph. Click Shift key and hold. Move your mouse to the last paragraph to copy. Mouse click again. Your text will be highlighted. You can let go of Shift now. Ctrl+C will copy the highlighted text to the clipboard ...


2

Actually the answer is trivial: Google webapps has MarkdownTableMaker https://chrome.google.com/webstore/detail/markdowntablemaker/cofkbgfmijanlcdooemafafokhhaeold?hl=en Works reasonably well.


2

Without a sample from Visual Studio 2013 (in Microsoft Windows 8) to hand, I can't be sure but believe enhancements to Docs since OP was posted have changed the circumstances upon which the question was based. Certainly now Ctrl+v does not lose "all the formatting and text", necessarily. For example the clip on the left is from Word and on the right from ...


2

You can copy paste the data in a tab free of data in column A. Then in column B1 you can use this : =REGEXREPLACE(formulatext(A1),"=",) Copy the cell for every data you have in column A Copy Column B then paste with the option values only Explanation : FORMULATEXT() is self-explanatory : it returns a formula based on a cell I.E. the string =+/- x here....


1

You would use the text function. If you have =today() in A1, you would use =text(A1,"mm/dd/yyyy"). (There are multiple formats for 'mm/dd/yyyy' if that's not the format you want.) Alternatively you can pre-format the cell as a date, so pasting the value would automatically be displayed as a date.


1

There does not seem to be one from the Sheets UI. The script editor has the ability to get a cell or cells color irrespective of whether it is conditional formatting or manual, with getBackground() or getBackgrounds() https://developers.google.com/apps-script/reference/spreadsheet/range#getBackground() There isn't an elegant way to copy to and from ...


1

Photopin.com, which indexes photos from flickr.com, supports partially this feature. It is still not entirely compliant with the CC attribution requirements mentioned in the question. On Photopin, once you find an image, you hover over it and click "get photo" which brings up a dialog as such: The last part "Grab HTML for Attribution" is a step in the ...


1

After spending every waking moment working on this and now much more since I have answered this question and I m sorry it took a while to update. here's where I have left off. it's clunky but functional: var ss = SpreadsheetApp.getActiveSpreadsheet(); var s = ss.getActiveSheet(); var r = s.getActiveRange(); var c = s.getActiveCell(); var aRow = r.getRow(); ...


1

Copy of a Comment by Alexander Taylor Oct 27 '15 at 22:34 : i notice that it only happens when cells contain newlines and possibly other special characters. adding the quotes might be done by the program you paste into -- each program may have the ability to convert tabular data into non tabular data as it wishes. if i paste into Google Keep, i see no ...


1

One solution I found is to use TextMate's Unwrap paragraph function. Copy text from Gmail, paste into TextMate, then go Text->Unwrap paragraph.


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