I have been working on a shared Google Spreadsheet for months. All of a sudden, the comments have disappeared from the cells and now only appear in the discussion thread.   How can I get them back to their individual cells that they pertain to?
I'm running into this weird problem with Google spreadsheets: if the cells have comments on them and I sort the spreadsheet, the rows sort but the comments stay in the same position, and don't move with the cells they're attached to.  In other words, the cells look like this:  A C  &lt;-- comment on this cell B   and then I sort by this column:  A B  &lt;-- comment remains on this cell (stays in position) C  &lt;-- comment should have remained attached to this cell   This means that sorting is completely broken and I can't use it at all, because I clearly need the cell comments to stay with the cell they're attached to.  Is this a bad bug in Google Spreadsheets, or am I missing something here?
How to create a color of the same brightness and saturation? Let's consider three colors: Red, Green and Blue. For blue I created a specific shade, something like #F2F5F7. If you see this color, it has a certain level of shade, brightness and saturation value of blue.  I want to create the same equivalent color but for Green and Red, how to get that? Access is denied because the NTFS volume is already exclusively opened "Think of" versus "think about" Could someone help me to understand when I should use think of and when think about in sentences?  What is the difference between using one or the other? Slope layer with false results in QGIS? After the DEM creation, I wanted to create slope layer.   However, the result has not satisfied me. I don't think the slope map is correct. Have you ever encountered false calculated terrain map?  This is the DEM:    And this is the slope layer. Use grep --exclude/--include syntax to not grep through certain files I'm looking for the string foo= in text files in a directory tree. It's on a common Linux machine, I have bash shell: grep -ircl &quot;foo=&quot; *  In the directories are also many binary files which match &quot;foo=&quot;. As these results are not relevant and slow down the search, I want grep to skip searching these files (mostly JPEG and PNG images). How would I do that? I know there are the --exclude=PATTERN and --include=PATTERN options, but what is the pattern format? The man page of grep says: --include=PATTERN     Recurse in directories only searching file matching PATTERN. --exclude=PATTERN     Recurse in directories skip file matching PATTERN.  Searching on grep include, grep include exclude, grep exclude and variants did not find anything relevant If there's a better way of grepping only in certain files, I'm all for it; moving the offending files is not an option. I can't search only certain directories (the directory structure is a big mess, with everything everywhere). Also, I can't install anything, so I have to do with common tools (like grep or the suggested find). How do I add Python to the Windows PATH? I want to be able to run Python commands from the Windows CMD. However, if I don't specify Python's full path for each command, I get an error saying "Python is not recognized as an internal or external command, operable program or batch file."  How do I add Python to the Windows PATH permanently? How do you integrate $e^{x^2}$? I know that $\int{\frac{1}{x}}dx$ is simply $\ln{(x)}+c$ (-which is clearly unrelated to the problem but I just thought I would share anyway) but I am not sure how to approach $e^{x{^2}}$. Perhaps a substitution? Sharing Open Source Python/ArcPy Code and Models for ArcGIS Desktop? I will be writing scripts for ArcGIS Desktop in Python with ArcPy.   Is there a community or open source project where code and models can be shared? Convert date to another timezone in JavaScript While executing a C program, a.out, using the Ubuntu terminal, why do I always need to type ./ before a.out, instead of just writing a.out? Is there solution for this? override at runtime __setattr__ Lie algebra and tangent space at the identity are isomorphic Define the Lie algebra $\mathfrak{g}$ of a Lie group G to be the set of all left-invariant vector fields of $G$. I want to prove that   $$          f: \mathfrak{g} \rightarrow T_eG \\              X \mapsto X(e) $$ is a linear isomorphism.  The only thing that I have left to prove is surjectivity.Letting $v\in T_eG$, we set $X\in \mathcal{X}(G)$ such that $\forall x\in G,\,X(x)=L_{x_{*,e}}(v)$ (I still have to show that such an $X$ is indeed a vector field on $G$). We get that  $$ f(X)=X(e)=L_{e_{*,e}}(v)=v $$  where the last equality holds because  $$       L_{e_{*,e}}(v)f = v(f \circ L_e) = v(f \circ id_G) = v(f) $$ for any $f\in C^\infty(G)$. (I am thinking of the tangent vectors as derivations).  Now all we have left to do is prove that such an $X$ is left-invariant, and it is therefore an element of $\mathfrak{g}$, but I do not know how. I tried to prove that  $$            \forall f\in C^\infty(G),\, L_{{x}_*,y}(X(y))f=X(L_x(y))f $$ but with no success. When the loop is the figure shown below will be rotated in clockwise direction the the slip ring connected to the red segment of the loop will give us the positive voltage and the slip ring connected to the black segment of the loop will give us negative voltage according to the Flemings right hand rule.  What if the loop is rotated in counter clockwise direction ? Will the slip rings provide us the same polarities which they were giving when the loop was moving clockwise ?  Plus  The voltage from the loop is given by the equation.  V(t) = Vmaximum * sin (theta)  Where theta is the positive angle the red segment makes in the clockwise direction or in counter clockwise direction from this position ? Let $X$ ~ $Bin(n,p)$ and $Y$ ~ $Bin(m,p)$ be two independent random variables. Find the distribution of $Z=X-Y$.   see also   I figured this out:  $$ P(Z=z)=\cases{\sum_{i=o}^{min(m,n)} Bin(k+i,n,p)*Bin(i,m,p), &amp;if $z\ge0$;\cr \sum_{i=0}^{min(m,n)} Bin(i,n,p) * Bin(i-z, m, p),&amp;otherwise. \cr}$$  I also validated it by Monte Carlo simulation. For $n=30$, $m=20$ and $p=0.5$, I get the following distribution, where the circles are the analytical probabilities and the line connects the MC estimates.    Because that looked to me pretty much like a binomial distribution, I gave it a try and figured out that its actually a binomial, just shifted by m to the left. This can be simply written as $P(Y=y) = Bin(y+m, m+n, p)$. Hence, given equal success probabilities, the sum of two independent binomially distributed random variables is binomial, but also their difference, just shifted to the left.  This question here  is actually the same as mine, but received no answer and only the comment that there would be no simple formula. But the above formula looks pretty simple to me.   Is it correct that for the case of equal success probabilities, the above equations actually describes the distribution of $Z=X-Y$? I read in a book that $Z$ could not be binomial distributed because it had negative support. Is it right to call it a shifted binomial? How do I parse an ISO 8601-formatted date? I need to parse  strings like "2008-09-03T20:56:35.450686Z" into Python's datetime type.  I have found  in the Python standard library, but it is not very convenient.  What is the best way to do this? The LOTR wiki  Eru Ilúvatar intervened in the history of Arda:   creating Elves and Men removing Aman from the spherical Earth resurrecting Gandalf making Gollum trip      In a letter written by Tolkien, he stated that Eru again intervened, this time in the Third Age, causing Gollum to trip and fall into the fires of Mount Doom while still holding the One Ring, thus destroying it.   Is this correct? If so, what letter is this, and exactly what did Tolkien say? How do I access a field value for an entity (e.g. node) object? node_load((int) $nid) loads a fully-populated node entity. $node-&gt;title-&gt;value gets the title, but how do I access field values in Drupal 8? Can we divide two vector quantities? For eg., Pressure( a scalar) equals force (a vector) divided by area (a vector). I found there are so much excellent answer to questions about how to product high quality typesetting output. But I wonder how to save ink with LaTeX. What we need to think about to manage cost. page layout or something else? "We plan" versus "we are planning" Is there a semantic difference between the following two sentences?     In the future, we are planning to migrate our tool to the Z3 solver.         In the future, we plan to migrate our tool to the Z3 solver.