Google Sheets split by " ," & add new rows
Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries)
How to use an existing database with an Android application What rules say that summoning undead is evil, and what rules say why? How should we handle downvote retaliation? I have a situation where I'm trying to figure out what the right thing to do is on SO.    I see a question.  I answer the question.  I see there are a couple other answers.  One answers the question well, though with less explanation than my answer.  The other answer seems both wrong and irrelevant to the question (doesn't answer the question at all).  I comment to that effect.  The "wrong" part is edited out, but the author of the answer doesn't respond to how their answer actually answers the question.  In fact, they seem offended that I don't "get" it.  After giving them several chances to explain how their answer is relevant to the question and seeing their attitude, I decide to downvote their answer as I don't see how it addresses the question at all and the author won't explain.  They retaliate and downvote my answer and admit in their comments that their downvote of my answer has nothing to do with the content of my answer and only because they don't like me disputing their answer.  Did I do the right thing by downvoting their answer?  Do I just have to live with their downvote retaliation?  Anything I should have done differently?  I also have no way of knowing this for sure, but the next question I answered was upvoted, then downvoted so perhaps this same person is stalking my answers and downvoting other answers of mine too with no comment.  As long as this doesn't continue, I'm not losing sleep over a couple downvotes, but I do wonder if I should have done anything differently.  Followup Later After I Posted This Question: After thinking about it for a little while, the person who disagreed with me decided to delete their post.  So, eventually the message did get through to them.  I don't know if they rescinded their downvote or not (or if they even could). GSC: How to move a site from a domain to sub domain, sub folder or new domain with a sub folder? Is it possible to tell Google's Webmaster Tools that our site hosted on www. has moved to a sub folder, sub domain or a new domain with sub folder? I recently upgraded from blender 2.81 to 2.82a, and I've immediately noticed a problem. Blender is not rendering HDRI images like it used to. You used to be able to plug an HDRI image into the background node, and into the world output. However when I do this now, in Eevee or Cycles, it renders what can be described as "as solid color" version of the HDRI instead of the actual HDRI image.   Here are some images to show as examples, each has a difernt HDRI, one is in Eevee, one is in Cycles. Is this a new "feature" of 2.82 or is this a bug? Thanks. Q: "Do you have any juice?"   A: "Yes, there's some in the fridge."   Sounds perfectly fine to me, but:     Q: "Do you have any towels?"   A: "Yes, there's some in the closet."   Does not.  I asked for towels - plural - so wouldn't "Yes, there're some in the closet," in which there are is turned into a contraction be the correct way to say it?  Spellcheck, however, doesn't like "there're", and I think I'm the only person I've ever heard use the word "there're".  Even folks who I know say "there are" shorten it to "there's" when possible.  Am I saying it wrong, or are both forms acceptable? Proof that Conditional of Poisson distribution is Binomial Clock displays incorrect time I've just installed 64-bit Ubuntu 11.04 and after I updated it, the clock stopped displaying the right time. It's now 8 hours behind my normal time. I've checked the Time and Date settings and the Location field is correct. What's even weirder is that the time displayed in Time and Date Settings adjusts itself after a few seconds and is correct. The time displayed in the task bar remains the same, however.  Any ideas? Paradox of General Comprehension in Set Theory, other than Russell's Paradox As is well known, the General Set Comprehension Principle (any class is a set) leads to the Russell Paradox (the class $x \notin x$ cannot be a set). As a result, set theories must restrict the Comprehension Principle to avoid self-reference. For example, in the case of ZFC, this is done by enumerating a small list of "safe" comprehension schema such as Separation.  Does General Comprehension lead to other types of paradox than Russell's? Or is this basically the only thing that can go wrong? To be honest I find it hard to keep up with all the changes, and very frequently I have to go look at the privileges list to see whether a user (that I'm looking at, so I have his reputation value) has a certain privilege or not.  However, I still don't know what that user will actually see or how the site actually behaves for that user.  There's quite a number of posts here on meta about "where did this go" and "why can't I" and I can't really tell either way how a site behaves for a user with a reputation level of 2500.  So, I propose the following functionality:   For all users, be able to view the site as though you had less reputation than you actually have Bonus-feature: For all users, be able to use the site at that reputation level, unless some features of low-level users conflict with your actual functionality For mods, be able to view the site as a specific users (be able to see all he sees, exactly the way he sees it), but of course not pose as that user (ie. things I do would still be me)   The UI could be merged into the mod menu and the privileges menu:    (Note, I chose a user randomly, Olivier Pons is in no way related to this question or flags, or whatever that I know of.) How to break a Quagmire 3 cipher? Cross Reference problem In Lieb and Loss's Analysis, I saw that they mentioned  $L^1(\mathbb{R}^n) \cap L^2(\mathbb{R}^n)$ dense in $ L^2(\mathbb{R}^n)$ (dense wrt the $L^2$ norm, I think). But I didn't find its proof in the book. So I wonder why it is?    Does this conclusion hold for $L^1(\Omega, \mathcal{F}, \mu) \cap L^2(\Omega, \mathcal{F}, \mu)$ for any measure space $(\Omega, \mathcal{F}, \mu)$?  Are there similar statements if replace $L^1$ with $L^p$, and  $ L^2$ with $L^q$ for $p \leq q \in (0, \infty ]$ or $\in [1, \infty]$?  Thanks and regards! Error handling in C code What do you consider "best practice" when it comes to error handling errors in a consistent way in a C library.  There are two ways I've been thinking of:  Always return error code. A typical function would look like this:  MYAPI_ERROR getObjectSize(MYAPIHandle h, int* returnedSize);   The always provide an error pointer approach:  int getObjectSize(MYAPIHandle h, MYAPI_ERROR* returnedError);   When using the first approach it's possible to write code like this where the error handling check is directly placed on the function call:  int size; if(getObjectSize(h, &amp;size) != MYAPI_SUCCESS) {   // Error handling }   Which looks better than the error handling code here.   MYAPIError error; int size; size = getObjectSize(h, &amp;error); if(error != MYAPI_SUCCESS) {     // Error handling }   However, I think using the return value for returning data makes the code more readable, It's obvious that something was written to the size variable in the second example.  Do you have any ideas on why I should prefer any of those approaches or perhaps mix them or use something else? I'm not a fan of global error states since it tends to make multi threaded use of the library way more painful.  EDIT: C++ specific ideas on this would also be interesting to hear about as long as they are not involving exceptions since it's not an option for me at the moment... SEO in Stack Overflow We've been out of private beta for only two days, and stackoverflow.com is already ranking high in .  Are there any specific techniques applied in the site? I've been researching the subject for some time and haven't found it to be so easy.   even returns site-links.  () Can a hotel kick you out if you let an unregistered guest share a room with you? Is there a safe way to determine how powerful an opponent is? Add markdown support for hidden-until-you-click text (aka spoilers) I am wondering if there exists any formula for the following power series :  $$S = r + r^2 + r^4 + r^8 + r^{16} + r^{32} + ...... + r^{2^k}$$  Is there any way to calculate the sum of above series (if $k$ is given) ? Some questions are getting closed as duplicates - good, the system is working. Unfortunately, some are getting closed as duplicates of other questions which are already deleted. This leaves all 1-9,999 reputation users left scratching their heads when they try to view the duplicate. Even worse, imagine being the author of the question and having your question closed as a duplicate when the original question isn't accessible.  I think something is wrong. Today I undeleted a question (left it closed) since it was referenced in the close-reason for another question. Comments indicated that people were clearly irritated that they could not access the duplicate     [Comment] Ok, who thought it was a good idea to close this as duplicate of a deleted question, which most people cannot even see? For the record, I'm reopening - clearly there's enough interest in this question. – Kobi 14 hours ago   ---   [Comment] The PosibleDuplicate link is broken. Voting to reopen. – Rahul G 7 hours ago   ---   [Flag] Closed as duplicate of a deleted question, fail. Thanks for moderating. – {username removed} 14 hours ago   My undelete-action was short-lived, as a few users returned to delete the post again.  It certainly cannot be desirable to reference posts that the vast majority of users cannot even see, especially when the author of the redundant question cannot see (at the time of writing this, the author has a reputation of 18).  I'm not sure what the solution is to this, but I'd like to hear some ideas.  Questions  Question:  Duplicate of: