Comments disappeared from Google Spreadsheet cell 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?
Google spreadsheet sorting messes up cell comments 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?
change folder icons in ubuntu-mono-dark theme QGLWidget appears black in Windows 7 Is there a term for someone who "can see multiple perspectives"? A colleague of mine is trying to describe herself as "capable of seeing a situation from multiple perspectives" or "able to look at the big picture from various viewpoints". I feel like there must be a better way to get this point across.  Is there a more concise way to describe this characteristic? Recolor Artwork: single swatch to multiple swatches I have an Illustrator document with a lot of objects. All the objects are black, same swatch.  I have a swatch group with a few dozen coloured swatches. I wish to apply these swatches to all the many black objects. It doesn’t have to be in any particular order, but each object should be coloured individually—I don’t just want to change black into some other colour, but to dozens of other colours. What I really want to avoid is having to select each object individually and then applying a different swatch to each.  I’ve never quite managed to get my head properly around the Recolor Artwork feature in Illustrator, and I cannot for the life of me get it to do anything like this. The “New” box in the Recolor Artwork dialogue box appears to accept only one colour.  Is there some way to do this using the Recolor Artwork feature? Or using some other feature that I’m not aware of? Bonus points if there’s a way to control the order in which the colours are applied; e.g., specifying an order and then click on each object in turn to apply each swatch being ‘iterated’ through in that order.  (I would prefer to avoid having to script it, but I will if there’s no other way.) Mathematica envelope for the bottom of a plot, a generic function How can I search the bash history and rerun a command? Can I search history in bash and run the result? Both  (if you take a list of values, the distribution of the most significant digit is rougly proportional to the logarithm of the digit) and  (given a corpus of natural language utterances, the frequency of any word is roughly inversely proportional to its rank in the frequency table) are not theorems in a mathematical sense, but they work quite good in the real life.   Does anyone have an idea why this happens?  (see also ) I recently learned that I have developed a consistent, but entirely wrong approach to punctuating direct speech in fiction. I am in the unenviable position of trying to relearn.  Previously I wrote such things as:     "I'm done." She said.   when the quoted speech was definitely, absolutely the end of a sentence. So now I know I need.     "I'm done," she said.   This follows the rule that a period is only allowed when the end of the spoken sentence is also the end of the sentence in the narrative. For example:     "I'm done." She slammed the door on the way out.   So, it now looks odd to me when there are multiple sentences in the speech:     "I can't take her. I'm done," she said.   Can you reassure me that is correct, or give the correct form? Please don't suggest rewriting the sentence to put 'she said' in the middle - I'm aware of that: I'm specifically asking about the punctuation rules.  The other odd case is speech ending with an ellipsis. Do sentence terminating ellipses (four periods normally) become:     "I can't take her. You know, ...," she said, nodding towards Jane.   If so, are non-terminating ellipses dealt with the same way?     "I can't take ...," she nodded towards Jane, "any more!"   or can non-terminating ellipses be used unadorned?     "I can't take ..." she nodded towards Jane, "any more!"   I'd be very grateful if you could point me at references as well as answers. For the record I am a British writer writing for both British and US publication, so any variation is also interesting to me! Quick question to anyone who has used this LaTeX template:    Any ideas on how to change the left margin to get more words onto one page? When using the ssh or ftp commands from the Bash shell, does the server that I am connecting to learn of the domain name used? I understand that the domain name is locally translated into an IP address via DNS. In HTTP, after that happens, the server is told the original domain name as well in order to serve the correct page, or to present the correct TLS cert (SNI).  host serverfault.com GET /   Does a similar phenomenon happen when connecting to ssh or ftp?  I ask because I am  trying to ssh into a server (GoDaddy webhosting) which expects a domain name, but is not letting me in when I try to connect via user@IPaddress as the DNS is not yet moved to the GoDaddy IP address. "Welcome to emergency mode!" Think it is a fsck problem My computer booted to a black screen with this error message.  Welcome to emergency mode! After logging in,type "journalctl -xb" to view    system logs, "systemctl reboot" to reboot, "systemctl default" or ^D to    try again to boot into default mode.   journalctl -xb snippet (what I think is wrong):  -- Unit systemd-fsckd.service has begun starting up. juli 09 15:40:16 kim-SSD-Sationary systemd-fsck[414]: /dev/sdb1 contains a file system with errors, check forced. juli 09 15:40:16 kim-SSD-Sationary systemd-fsck[414]: /dev/sdb1: Inodes that were part of a corrupted orphan linked list found. juli 09 15:40:16 kim-SSD-Sationary systemd-fsck[414]: /dev/sdb1: UNEXPECTED INCONSISTENCY; RUN fsck MANUALLY. juli 09 15:40:16 kim-SSD-Sationary systemd-fsck[414]: (i.e., without -a or -p options) juli 09 15:40:16 kim-SSD-Sationary systemd-fsck[414]: fsck failed with error code 4. juli 09 15:40:16 kim-SSD-Sationary systemd-fsck[414]: Running request emergency.target/start/replace juli 09 15:40:16 kim-SSD-Sationary systemd[1]: systemd-fsck-root.service: main process exited, code=exited, status=1/FAILURE juli 09 15:40:16 kim-SSD-Sationary systemd[1]: Failed to start File System Check on Root Device. -- Subject: Unit systemd-fsck-root.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel --  -- Unit systemd-fsck-root.service has failed. --  -- The result is failed. juli 09 15:40:16 kim-SSD-Sationary systemd[1]: Unit systemd-fsck-root.service entered failed state. juli 09 15:40:16 kim-SSD-Sationary systemd[1]: systemd-fsck-root.service failed. juli 09 15:40:16 kim-SSD-Sationary systemd[1]: Starting Remount Root and Kernel File Systems... -- Subject: Unit systemd-remount-fs.service has begun start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel   I ignored other errors like: ACPI PCC probe failed, nvidia not proprietary, etc.  I can access my PC by pressing Ctrl+D , but it is annoying. No Dialect mapping for JDBC type: -9 "Missing return statement" within if / for / while MySQL 5.5.16 allows anonymous connections Apparently, I can connect to MySQL (at least from my localhost) without having to provide any username or password. I can even put anything as username, as long as the password is empty. I have access to the information_schema and test databases. I can create tables. If I run SELECT USER() it returns the proper value randomstring@localhost, where the random string is whatever I used for username when I connected.  The mysql.user table contains root@localhost, root@127.0.0.1, @localhost and pma@localhost. I manually set encrypted passwords to all the records (UPDATE user SET password=...) and only root has any privileges, the other two records have "N" for all privileges. That record with the empty username looks suspicious, but I don't think it has anything to do with this and I think it was there from the beginning.  To make matters worse, if I add a user with a password, I can only connect using empty string as password (just like if I put anything as username). If I try to connect using the username I created and password I supplied when creating it (CREATE USER .. IDENTIFIED BY ..) it doesn't work.  Does anyone know what is wrong and how I can fix this?  Note: I am using MySQL 5.5.16 for Windows, provided by the XAMPP package. When running umount /path I get:  umount: /path: device is busy.   The filesystem is huge, so lsof +D /path is not a realistic option.  lsof /path, lsof +f -- /path, and fuser /path all return nothing. fuser -v /path gives:                    USER        PID ACCESS COMMAND /path:            root     kernel mount /path   which is normal for all unused mounted file systems.  umount -l and umount -f is not good enough for my situation.  How do I figure out why the kernel thinks this filesystem is busy? How is the system call in Linux implemented? When I invoke a system call in user mode,how did the call get processed in OS?  Does it invoke some some executable binary or some standard library?  If yes,what kind of thing it needs to complete the call? Does $\int_{0}^{\infty}\frac{dx}{1+(x\sin5x)^2}$ converge? In $\mathbb{R}$ with standard topology the closure of the above set $M$ is $M \cup 0$. I fail showing this by purely topological means. I.e. not using the fact that this holds in the reals as a metric space and deduce it for the induced topology.  I assumed that there exist a closed subset $A$ containing $M$ but not 0. Hence, the complement of $A$ is an open subset containing 0. Does this already yield a contradiction or do I need a different approach?  Could you help me on this? Why do statisticians say a non-significant result means "you can't reject the null" as opposed to accepting the null hypothesis? Traditional statistical tests, like the two sample t-test, focus on trying to eliminate the hypothesis that there is no difference between a function of two independent samples. Then, we choose a confidence level and say that if the difference of means is beyond the 95% level, we can reject the null hypothesis. If not, we "can't reject the null hypothesis". This seems to imply that we can't accept it either. Does it mean we're not sure if the null hypothesis is true?   Now, I want to design a test where my hypothesis is that a function of two samples is the same (which is the opposite of traditional statistics tests where the hypothesis is that the two samples are different). So, my null hypothesis becomes that the two samples are different. How should I design such a test? Will it be as simple as saying that if the p-value is lesser than 5% we can accept the hypothesis that there is no significant difference? Proving the sum of two independent Cauchy Random Variables is Cauchy Is there any method to show that the sum of two independent Cauchy random variables is Cauchy? I know that it can be derived using Characteristic Functions, but the point is, I have not yet learnt Characteristic Functions. I do not know anything about Complex Analysis, Residue Theorem, etc.   I would want to prove the statement only using Real Calculus. Feel free to use Double Integrals if you please.   On searching, I found . However, I was wondering if I could get some help directly on the convolution formula:  $$f_Z(z)=\int_{-\infty}^\infty f_X(x)f_Y(z-x)\,dx=\int_{-\infty}^\infty\frac{1}{\pi^2}.\frac{1}{1+x^2}.\frac{1}{1+(z-x)^2}dx\tag{1}$$  Here I have supposed that $X,Y$ are Independent Standard Cauchy. But I think the general formula can be derived easily after some substitutions. I need some help on how to proceed from $(1)$.  EDIT: Just as what the hint in the hyperlink said, I got the answer using that hint. However, I am not quite sure that the hint is algebraically correct. Maybe there has been some typing mistake in the book.