This morning I got a notification that for an answer of mine a  was made.   As you see in the link above the question title states "Excel VBA - There isn't enough memory to complete this action" and the proposed edit had been the change from CreateObject("Outlook.Application") to Set oApp = CreateObject("Excel.Application").  I just thought what a big mistake I had made and wanted to click on "Approve" but then thought to first check the question. The OP edited the question changing form Outlook stuff to Excel and removing the whole code as well.    Is it allowed to change a question this drastically after receiving answers althought not upvoted (mine) but clearly refering to the OP's code? ?  What is the correct procedure here?
What should I do if a question has changed since I answered it? The other members vote my answer down because it actually doesn't answer the current question.  This kind of editing sometimes happens with  where the OP keeps adding new questions, making my pre-existing answer now incomplete.  But another pattern is when the OP asks an "XY problem" question, an answer points it out, and he changes the question to react to that.  Those answers now not only aren't answers but can look very tangential to people who don't review the edit history.
If a blocking creature leaves the battlefield, is the attacker still blocked, or will it damage the opponent? Suppose Player 1 has a Dragon on the table and  in hand, while Player 2 has two Spiders on the table.  Player 1 chooses to attack with the Dragon and Player 2 chooses to block with one of the Spiders.  Before combat damage is to be dealt, Player 1 uses Unsummon on the blocking Spider.    Does Player 2 take any life damage from the attacking Dragon? Why does do-release-upgrade on Xubuntu running version 18.04 not offer to update to 20.04.1? I've understood that when I run the Software Updater GUI program, or when I execute do-release-upgrade on the command line, it should offer to upgrade to the latest LTS release if (1) I've got the release update behaviour set to lts, and (2) if the first point release of a newer LTS release is available. I have a couple of machines running the Xubuntu LTS release 18.04. The contents of file etc/update-manager/release-upgrades on all these machines is [DEFAULT] Prompt=lts  That satisfies condition (1). Also, it seems that Xubuntu 20.04.1 is already released, satisfying condition (2). However, neither do-release-upgrade nor the Software Updater offers to upgrade to that release. Why? Edited to add: It seems this question is a duplicate of . Is Duck/Duct tape safe to use to insulate mains wires? Question says it all really. Based in the UK so mains is 240v and 20 amps. It's a lighting circuit. Windows 10 - disable reopening programs after restart/startup Occasionally, a forced restart is happening on my Windows 10 computer. When the OS is restarted every program that I've had prior to the restart is reopened at startup. The programs are reopened like I would just double-click them.  I usually hold 5-6 windows of Visual Studio and few more programs all together. When the above happens, I have to wait several minutes until I can start working, as everything takes ages to load.  Is there a setting to disable these programs from automatically opening at startup? Every natural number can be written as the sum of distinct Fibonacci numbers? Citation colour with Beamer + Hyperref + Natbib I'm using natbib for citation with a custom bibstyle. I'm working on a presentation using LaTeX beamer and for some reason the citation marker doesn't have the colour that is specified to hyperref. The citation marker is black instead of green. I'll give you a MWE:    \documentclass{beamer} \hypersetup{   colorlinks,   citecolor=green,   linkcolor=red }  \usepackage{filecontents} \begin{filecontents}{mybib.bib} @ARTICLE{Bar2011,   author = {F. Foo and F. Bar},   title = {Foo and Bar},   journal = {Journal of Foo},   year = {2011},   volume = {1},   pages = {1--3} } \end{filecontents}  \usepackage[comma,numbers,sort&amp;compress]{natbib} \bibliographystyle{plain}  \begin{document} Dummy referefence to~\cite{Bar2011} \bibliography{mybib} \end{document}   For the purpose of the MWE I have selected the plain bibstyle, however, changing that to something else (including the custom style I want to use) doesn't affect the label colour.    Is there any patch for this problem? Did the verb “fire a weapon” exist before the actual introduction of firearms on battlefields?  More specifically, does it make sense for a creative work to have archers (or whatever ranged weaponry) be told to “fire!”, when the world they live in has not yet seen firearms?  It seems some kind of an anachronism to me, since before firearms, “fire” would never propel any projectile...  I've seen several movies do it; I can't remember them all, but for instance I verified it in The Lord of the Rings trilogy (left), Kingdom of Heaven (top right), and more recently Frozen (bottom right):    The first two do it several times (with Kingdom of Heaven also using it on ballistae, and The Return of the King even having Aragorn ask Legolas to ), whereas firearms never appear on the battlefields they feature (Kingdom of Heaven is set in the 12th century; as for The Lord of the Rings, apart from one occurrence of a witchcraft-ish bomb, it's archery and medieval siege engines all the way).  Frozen may be debatable, happening probably somewhere in the 18th or 19th century, but since we only see swords, spears and the like, it made me flinch to hear crossbowmen use “fire!”.  I've also noticed other movies avoiding this, using “loose!” instead, such as Troy (left) and Gladiator (right):    This makes me think it would be the right thing to say instead... although I'm still wondering why not use “shoot”, which seems simpler to me. I want to show for $x\in\mathbb{R}$, the following inequality holds. $$ \left|\sin x\right|+\left|\sin (x+1)\right|+\left|\sin (x+2)\right|&gt;8/5. $$ This trigonometric inequality has been verified by Mathematica using the Plot commend. However, using the sum formula for the sine function seems doesn't work, and I cannot give a rigorous proof of it. Any suggestion, idea, or comment is welcome, thanks! Alternative proof that $(a^2+b^2)/(ab+1)$ is a square when it's an integer Let $a,b$ be positive integers.  When $$k = \frac{a^2 + b^2}{ab+1}$$ is an integer, it is a square.    Proof 1: (Ngô Bảo Châu): Rearrange to get $a^2-akb+b^2-k=0$, as a quadratic in $a$ this has two values: $a$ and $kb - a = (b^2-k)/a$. (The second root is determined in two different ways from the expansion $(x-r_1)(x-r_2) = x^2 - (r_1 + r_2)x + r_1 r_2$.)  Now suppose we have $a,b$ such that $k$ is an integer but not a square, by the investigation about roots we have that the second root is a nonzero integer since $k,b,a$ are integers and $k \not = b^2$, futhermore it is positive which is easily seen from its defining equation.  WLOG assume $a \ge b$ so that the second root is strictly smaller than $a$. This leads to a decent, replacing $a$ with the second root.    Proof 2 (Don Zagier): Apply reduction theory (specifically, Sätze 1 and 2 of Section 13 of my book on quadratic fields) to the quadratic form $x^2 + kxy + y^2$, which is the unique reduced quadratic form in its equivalence class.    Note that Proof 2 is pretty much the same as Proof 1 when written out in explicit detail, but I could not read Zagier's book because I cannot read German.  I would like to know more approaches to this and other alternative proofs of this result if possible! Thanks in advance.  I would also be interested in related problems (especially easier ones of a similar nature) and texts which cover the reduction theory in English. Multiple SSL domains on the same IP address and same port? This is a  about Hosting multiple SSL websites on the same IP.   I was under the impression that each SSL Certificate required it's own unique IP Address/Port combination. But the  is at odds with this claim.  Using information from that Question, I was able to get multiple SSL certificates to work on the same IP address and on port 443. I am very confused as to why this works given the assumption above and reinforced by others that each SSL domain website on the same server requires its own IP/Port.  I am suspicious that I did something wrong.  Can multiple SSL Certificates be used this way? What is the correct way to create a single-instance WPF application? How did Montague Apparate into the Hogwarts bathroom? This is a follow up question to . My reference database contains some DOI codes, but mainly normal URLs and some ISBN/ISSN codes. What I would like to achieve is extending the code from Herbert and hyperlink the title of the entry with the following priority: 1. DOI, 2. URL, 3. ISBN/ISSN. What I mean is, if both DOI and URL is available, use DOI. If URL and ISBN is available use URL. If only ISBN is available use that.  There are two further isses:    The URL field might contain several URLs, which are just seperated by a white space. In that case just the first URL should be used.  Herbert's code just extends to articles. I would like to extend this to all entry types.   The code from Herbert to Hyperlink the Title with DOIs is:   \newbibmacro{string+doi}[1]{%   \iffieldundef{doi}{#1}{\href{http://dx.doi.org/\thefield{doi}}{#1}}} \DeclareFieldFormat{title}{\usebibmacro{string+doi}{\mkbibemph{#1}}} \DeclareFieldFormat[article]{title}{\usebibmacro{string+doi}{\mkbibquote{#1}}}   This far surpasses my skill, so it would be great if someone could give me some guidance how to achieve that. Why did the quality of terminators increase from movies 1 to 3? I have seen only the first three movies, so I don't know whether the other movies/TV series deal with this question or not. My main point is that in the movies, the terminator that travels back furthest in time is of the worst quality, and the quality increases with the time travel (meaning they travelled from a later time). What is a good explanation for this?  Note: I am not interested in the obvious not-in-universe explanation that they wanted something better and bigger for each new movie. Is there such a thing as a Ubuntu Certified Engineer? A 64-bit double can represent integer +/- 253 exactly. Given this fact, I choose to use a double type as a single type for all my types, since my largest integer is an unsigned 32-bit number. But now I have to print these pseudo integers, but the problem is they are also mixed in with actual doubles. So how do I print these doubles nicely in Java? I have tried String.format(&quot;%f&quot;, value), which is close, except I get a lot of trailing zeros for small values. Here's an example output of of %f  232.00000000 0.18000000000 1237875192.0 4.5800000000 0.00000000 1.23450000  What I want is:  232 0.18 1237875192 4.58 0 1.2345  Sure I can write a function to trim those zeros, but that's lot of performance loss due to string manipulation. Can I do better with other format code?  The answers by Tom E. and Jeremy S. are unacceptable as they both arbitrarily rounds to two decimal places. Please understand the problem before answering.  Please note that String.format(format, args...) is locale-dependent (see answers below). On average, how many times must I roll a dice until I get a $6$?  I got this question from a book called Fifty Challenging Problems in Probability.   The answer is $6$, and I understand the solution the book has given me. However, I want to know why the following logic does not work: The chance that we do not get a $6$ is $5/6$. In order to find the number of dice rolls needed, I want the probability of there being a $6$ in $n$ rolls being $1/2$ in order to find the average. So I solve the equation $(5/6)^n=1/2$, which gives me $n=3.8$-ish. That number makes sense to me intuitively, where the number $6$ does not make sense intuitively. I feel like on average, I would need to roll about $3$-$4$ times to get a $6$. Sometimes, I will have to roll less than $3$-$4$ times, and sometimes I will have to roll more than $3$-$4$ times.  Please note that I am not asking how to solve this question, but what is wrong with my logic above.  Thank you! Did you know that :  Map&lt;Object,Object&gt; m1 = new HashMap&lt;Object, Object&gt;(); Map&lt;Object,Object&gt; m2 = new HashMap&lt;Object, Object&gt;(); System.out.println("m1.equals(m2) = "+m1.equals(m2)); System.out.println("m1.keySet().equals(m2.keySet()) = "             +m1.keySet().equals(m2.keySet())); System.out.println("m1.entrySet().equals(m2.entrySet()) = "             +m1.entrySet().equals(m2.entrySet())); System.out.println("m1.values().equals(m2.values()) = "             +m1.values().equals(m2.values()));   would output :  m1.equals(m2) = true m1.keySet().equals(m2.keySet()) = true m1.entrySet().equals(m2.entrySet()) = true m1.values().equals(m2.values()) = false   This is caused by the fact that AbstractCollection (which HashMap$Values inherits from) does not overrides #equals().  Do you have an idea why this is so ? Recommended books for advanced undergraduate electrodynamics I have hundreds of figures with filenames containing "#" to include using \includegraphics, I've tried packages like grffile or currfile, but none of them work. Can anyone suggest a real solution so that I don't need to change hundreds of file names? Thanks.  Update: 1. I'm using Windows. 2. When I compile it, it shows "Illegal parameter number in definition"