How Do I Combine Columns In Google Spreadsheets?
Concatenate several columns into one in Google Sheets
Using \@-ified punctuation while using \frenchspacing After reading  about spacing and punctuation, I was left wondering about an issue that didn't seem to be addressed: using \frenchspacing together with the modified punctuation \@., \@?, etc.  As far as I can tell visually, using \frenchspacing together with these commands works correctly (i.e., it seems like nothing breaks, and the extra space is suppressed as normal), but are there problems that can arise from doing so?   Moreover, when using \frenchspacing, "should" I still use \@. and its friends where it would ordinarily be necessary, in case someone wants to remove \frenchspacing later? Would accommodating (hypothetical) future editors in this way be "standard", "above and beyond the call of duty", or "crazy"? I am generating one report where I need to use background image. But I found that image always starts leaving some margin space to left side.    \documentclass{article} \usepackage{wallpaper} \usepackage{mdframed} \usepackage[top=2cm, bottom=2cm, outer=0cm, inner=0cm]{geometry} \begin{document}  Some content \ThisLRCornerWallPaper{1.0}{image.jpg} \end{document}    How can I use background image covering whole page? Monotonicity of the sequences $\left(1+\frac1n\right)^n$, $\left(1-\frac1n\right)^n$ and $\left(1+\frac1n\right)^{n+1}$ How to add a Login / Logout link in Main navigation menu? How can I add a Login link to the "Main navigation" menu?  When a user clicks on the link, it should take them to the /user/login page. Once they login, the link should change to say "Logout" instead of "Login".  Is there any way to add such a link? Execute sudo without Password? Inspired by this ....  I am the sole person using my system with 12.04. Every time I issue a sudo command; the system asks for the user password (which is good in its own way).  However I was thinking; without activating the root account; how can I execute the sudo commands which will not ask for user password to authenticate.  NOTE: I want to execute sudo command without authenticating via password; only when they are executed via terminal. I don't want to remove this extra layer of security from other functions such a while using 'Ubuntu software center' or executing a bash script by drag-drop something.sh file to the terminal. "Can’t help but" vs. "can help but" Is "can’t help but" considered to be a confused mix of the expressions "can but" and "can’t help"? If not, what is the difference between "can help but" and "can’t help but"? Setting the pivot point of an object I have a sword that currently rotates around a pivot point thats off of the actual object. Im new to blender and im not sure how i would go about changing it so that the sword rotates around the handle. Any help would be appreciated! Marking plural of code words In my blog (which is about programming) I often use reserved words from different programming languages.  Like this:     When column is nullable in both tables, this query won't return a match of two NULLs for the reasons described above: no NULLs are equal.   Here, NULL is a programming language keyword.  For numerous reasons, I mark them with &lt;code&gt; tag so they are rendered with a fixed width font, not translated into the foreign languages by Google Translate, can easily be seen on the page etc.  In the example above, which would be the best way to mark the plural?   NULLs NULL s NULL's NULLs NULLS   Option 1 looks ugly on the page (the word and the plural marker are rendered in different colors and fonts)  Option 2 adds a space between the word and the plural marker  Option 3 looks nicest but is not correct  Options 4 and 5 may leave the reader under impression that NULLS is a reserved word (which is not true) and this may be confusing. Also, Google Translate would leave the word as is which would be definitely wrong in other languages.  What would be the least of 5 evils? I am trying to prove that any conjugate of $a$ has the same order as $a$.  Let $G$ be a group and let $a \in G$.  An element $b \in G$ is called a conjugate of $a$ if $b=xax^{-1}$.  My professor gave us a hint.  Prove $a^k=e$ iff $b^k=e$ for all $k \in \mathbb{Z}$ implies $o(a) = o(b)$.  My first move is to $b^k = (xax^{-1})^k = (x^{-1})^ka^kx^k = (x^{-1})^kex^k = (x^{-1})^kx^k=x^{-k+k}=x^0$  I am not sure that I am doing this correctly?  I am trying to get $b^k=e$.  However when I raise $(xax^{-1})^k$, I am not sure if I what I have done is correct?  I am kind of confused here. Show that the congruence $x^{p-1} \equiv 1 \pmod {p^2}$ has precisely $p-1$ solutions modulo $p^2$ Let $p$ be a prime number. Show that the congruence $x^{p-1} \equiv 1 \pmod {p^2}$ has precisely $p-1$ solutions modulo $p^2$  I know the statment above is true for modulo $p$, but how is this imply to modulo $p^2$ I'm trying to create an item that can break certain blocks, but also has a colored name in 1.13.2   Here's the command I'm using.  /give iAugust minecraft:shears{display:{Name:"[{\"text\":\"Arcane Shears\",\"color\":\"aqua\",\"italic\":false,\"bold\":false}]CanDestroy:[minecraft:iron_bars]"}}   But it only has a colored name, and it can't break specific blocks. Inaccurate reputation graphs - bug or as designed? I have notice two issues with the reputation graph: 1: This user has a higher score on the graph than in reality I happened to notice  where the user's graph reputation does not match their actual reputation.  The person in question was hit by a -100 penalty for an offensive answer a while back, but the graph doesn't reflect that.  I thought it just didn't update when I noticed this at the time, but the person has since gained and lost reputation and at all times the graph was +100 of their actual reputation.  It seems, based on Shadow Wizard's comment that this is because the reputation change is non-public. OK, fair enough... , which was marked as , noticed a similar phenomenon for placed DVs.  This prompted me to examine graphs more carefully.  It seems that this hidden -1 has been updated, as I checked several users and did not find any others that had lower actual reputation than graph reputation, so .  (Since the number of DVs placed is public, I can be reasonable sure that these users have placed -1 rep DVs, although strictly speaking they could be 100% question DVs.) 2: Some users have a lower score on the graph than in reality I did, however, find many users where the graph says their reputation is much lower than it actually is.  Perhaps that is from deleted downvotes turning into hidden +1s, but those should be balanced by hidden -1s, so its not clear what happened.  Seems there is some error in the logic - maybe the -1s do affect the graph now as per the , but the corresponding +1s don't?  Whatever the case, I can't imagine it is intentional. Edit: I went back to find some examples today &amp; didn't find any.  I think the issue has been resolved - either it was a caching issue or a change was made to the code after this post. I have my Git repository which, at the root, has two sub directories:  /finisht /static   When this was in , /finisht was checked out in one place, while /static was checked out elsewhere, like so:  svn co svn+ssh://admin@domain.com/home/admin/repos/finisht/static static   Is there a way to do this with Git? @class vs. #import There is a problem with my logic and I cannot seem to point out where. There's a rocket ship travelling at close-to-c speed v without any acceleration (hypothetically), and there is an observer AA with a clock A on Earth, and there's another observer on the rocket BB with a clock B and these two clocks were initially in sync when the rocket was at rest with a FoR (frame of reference) attached to Earth. Now, this rocket's moving and AA tells us that B is running slower than A by a factor of$$ \gamma = 1 /(1-v^2/c^2)^{1/2} $$ $$ t_A/t_B = \gamma $$ where v is the relative 1d- velocity between the two i.e the earth and the rocket! That would mean the time elapsed on A is greater than that on B but this will happen only in the FoR of AA? So $t_B$ in this equation must be the time on B as observed by AA? Is this correct? What do the terms mean in the equations? If the symmetry holds and BB doesn't accelerate, then BB could say that $$ t_B/t_A = \gamma $$ right? where $t_B$ and $t_A$ are the times on B and A with respect to FoR of BB? But I was solving this problem and I took the earth FoR of A, but the prof took the rocket FoR of B? Like how will I know which FoR to solve the problem from? It'd greatly help if the terms in all the above equations were laid down neatly! DO we even need these FoRs?? Because in all the solved problems the prof is't specifying any and is using random ones! Please help!!!! This is the question where I messed up. The first rocket bound for Alpha Centauri leaves Earth at a velocity (3/5)c. To commemorate the ten year anniversary of the launch, the nations of Earth hold a grand celebration in which they shoot a powerful laser, shaped like a peace sign, toward the ship.  According to Earth clocks, how long after the launch (of the rocket) does the rocket crew first see the celebratory laser light?  This must be 25 years. My reasoning is: If v = 3c/5 10v + vt = ct where t is time taken by the light to reach the rocket from Earth as calculated from Earth.. and I solved that for t. and added 10 years to that because the time starts at the launch of the rocket!  According to clocks on the rocket, how long after the launch does the rocket crew first see the celebratory laser light?  This is 20 years. Here, I say: If it takes 25 years as observed by clocks on earth for the laser to reach the rocket, what should be the corresponding time as seen on a clock on the rocket? Using the formula: 25 = $\gamma$t where $\gamma$= 5/4 solved for t!  According to the rocket crew, how many years had elapsed on the rocket's clocks when the nations of Earth held the celebration? That is, based on the rocket crews' post-processing to determine when the events responsible for their observations took place, how many years have passed on the rocket's clocks when the nations of Earth hold the celebration?  For this, I did the following: 10 years on earth = T years on rocket ship where T must be lesser than 10 as observed from Earth FoR! Therefore, T= 4(10)/5 years = 8 years! But, prof says, 10 years on Earth = T years in rocket ship where T must be GREATER than 10 as observed from the rocket FoR??? Therefore, T = 10(5/4) years = 12.5 years!! What does this question actually want? Ckeditor toolbar not entirely showing up nameref (hyperref) evaluating counter instead of section name What's the proper way to reference a section with a counter in the title? The TOC generates correctly, but the cross references aren't so lucky.  MWE:  \documentclass[letterpaper, 12pt, twoside]{exam}  \usepackage{hyperref}  \newcounter{KSRLessonNumberCounter} \setcounter{KSRLessonNumberCounter}{1} \newcommand{\KSRSection}[2][\value{KSRLessonNumberCounter}]{         \setcounter{KSRLessonNumberCounter}{#1}         \section*{Lesson \arabic{KSRLessonNumberCounter}: #2}         \addcontentsline{toc}{section}{Lesson \arabic{KSRLessonNumberCounter}: {#2}}         \stepcounter{KSRLessonNumberCounter} } \newcommand{\KSRSubsection}[1]{         \subsection*{#1}         \addcontentsline{toc}{subsection}{#1} } \newcommand{\KSRLessonNumber}{ }  \begin{document}  \KSRSection{Sample}  This is the first lesson. The second lesson is \nameref{sec:blah}.  \KSRSection{Blah} \label{sec:blah}  This is the second section  \KSRSection{Lorem Ipsum}  Dollars are Set in \nameref{sec:blah}.  \end{document} When I check for updates, I get a "Failed To Download Repository Information" error.   This is what comes up under details:   W: Failed to fetch gzip:/var/lib/apt/lists/partial/us.archive.ubuntu.com_ubuntu_dists_natty_main_source_Sources  Hash Sum mismatch,  E: Some index files failed to download. They have been ignored, or old ones used instead. How do I add "citations" at the end of the document as done here? WP List Table custom quick edit box - post meta data missing and columns change on submit I have extended class WP_List_Table to create a custom sortable table of posts along with a quick edit box with custom meta boxes.  The meta boxes populate and save but when I click submit the field values disappear and the defaults ( cb, title, tags, cats, etc) which are not even included in my class get added back to the column saved. This throws off the other columns on the page.  The saved custom field values return when the page is refreshed.  It seams like on submit the $post_object is missing.  I'm using a hacked get_inline_data function that includes the meta_values in my quick edit form instead of calling get_inline_data in my class.  My save function for the meta boxes:  add_action( 'save_post', 'save_inline_edit_meta' ); function save_inline_edit_meta( $post_id  ) {     global $pagenow;      if ( $pagenow == 'admin.php' ) {      if ( isset( $_POST[ 'is_quickedit' ] )  &amp;&amp; isset( $_POST[ 'standinghead' ] ) )         update_post_meta( $post_id, '_wnd_standing_head', $_POST[ 'standinghead' ] );      if ( isset( $_POST[ 'is_quickedit' ] )  &amp;&amp; isset( $_POST[ 'headline' ] ) )         update_post_meta( $post_id, '_wnd_alt_title', $_POST[ 'headline' ] );      if ( isset( $_POST[ 'is_quickedit' ] )  &amp;&amp; isset( $_POST[ 'deck' ] ) )         update_post_meta( $post_id, '_wnd_deck', $_POST[ 'deck' ] );     }   return $post_id;  }   My Javascript save function:  save : function(id) {         var params, fields, page = $('.post_status_page').val() || '';          if ( typeof(id) == 'object' )             id = this.getId(id);         $('table.widefat .inline-edit-save .waiting').show();         params = {             action: 'inline-save',             post_ID: id,             post_type: 'post',             edit_date: 'true',             post_status: page         };         fields = $('#edit-'+id+' :input').serialize();         params = fields + '&amp;' + $.param(params);          $.post('admin-ajax.php', params,             function(r) {                 $('table.widefat .inline-edit-save .waiting').hide();                  if (r) {                     if ( -1 != r.indexOf('&lt;tr') ) {                         $(inlineEditPost.what+id).remove();                         $('#edit-'+id).before(r).remove();                         $(inlineEditPost.what+id).hide().fadeIn();                     } else {                         r = r.replace( /&lt;.[^&lt;&gt;]*?&gt;/g, '' );                         $('#edit-'+id+' .inline-edit-save .error').html(r).show();                     }                 } else {                     $('#edit-'+id+' .inline-edit-save .error').html(inlineEditL10n.error).show();                 }             }         , 'html');         return false;     },