Why do people just downvote without giving reason?
How to deal with downvotes without any explanation
Reading Excel files from C# Is there a free or open source library to read Excel files (.xls) directly from a C# program?   It does not need to be too fancy, just to select a worksheet and read the data as strings. So far, I've been using Export to Unicode text function of Excel, and parsing the resulting (tab-delimited) file, but I'd like to eliminate the manual step. If you provide 0 as the dayValue in Date.setFullYear you get the last day of the previous month:  d = new Date(); d.setFullYear(2008, 11, 0); //  Sun Nov 30 2008   There is reference to this behaviour at . Is this a reliable cross-browser feature or should I look at alternative methods? A term for words that change pronunciation with part of speech My website's google cache copy looks broken.   Below is link to cache.  http://webcache.googleusercontent.com/search?q=cache:http://paintcollar.com  Can this affect the SERPs and crawling by google?  What can I do to rectify it?  PS. Few pages are being cached properly though.Below is URL to one such page. http://webcache.googleusercontent.com/search?q=cache:http://paintcollar.com/aneel Number Theory: $p!+p=n^2$, $p$ = prime How to calculate bounce angle? I played around with it for a while, but I simply can't figure it out.  I made a tank that fires missiles, and when the missiles hit the walls, I want them to bounce off, but I want them to bounce off to the right angle.  Right now I haven't got any obstacles, the missiles just bounce off when they get outside the viewportRectangle I made.  Is the solution I'm looking for quite advanced?  Is there a relativly simple way to do it? Find the limit of $\log\Big(\frac{(n^2+n)!}{n^2!n^{2n}}\Big)$ I have to prove that      $$\Big[\log\Big(1+\frac 1{n^2}\Big)+ \log\Big(1+\frac 2{n^2}\Big)+...+ \log\Big(1+\frac n{n^2}\Big)\Big] \to \frac 12$$   I know that $$\log\Big(1+\frac 1{n^2}\Big)+ \log\Big(1+\frac 2{n^2}\Big)+...+ \log\Big(1+\frac n{n^2}\Big)= \\ =\log\Big(\frac {n^2+1}{n^2}\Big)+ \log\Big(\frac {n^2+2}{n^2}\Big)+...+ \log\Big(\frac {n^2+n}{n^2}\Big)=\\ =\log\Big(n^2+1\Big)+ \log\Big(n^2+2\Big)+...+ \log\Big(n^2+n\Big)-2n\log n$$  Doing some manipulation we get:           $$\lim_{n \to +\infty}\log\Big(\frac{(n^2+n)!}{n^2!n^{2n}}\Big)=\frac 12$$      How can I prove this limit? How to create immutable objects in Java? What's the origin of referring to female superior officers as "sir"? It is well established in Star Trek: The Next Generation that female superior officers are normally referred to as sir.  This is applied to Dr. Crusher, Counselor Troi, Cmdr. Shelby, Maj. Kira, Lt. Dax, and numerous admirals.   This obviously fits in well with the egalitarian ideals of Star Trek. This convention is made explicit in &quot;Thine Own Self&quot;:  DATA: Counsellor, have you been promoted in my absence? TROI: That's right. Which means from now on you can call me sir. DATA: Yes, sir.  In Addition, the first episode of Star Trek: Voyager, &quot;Caretaker&quot; contains this dialog:  KIM: Thank you, sir. JANEWAY: Mister Kim, at ease before you sprain something. Ensign, despite Starfleet protocol, I don't like being addressed as sir. KIM: I'm sorry, ma'am. JANEWAY: Ma'am is acceptable in a crunch, but I prefer Captain. We're getting ready to leave. Let me show you to the bridge.  which again establishes that sir is the norm, although Capt. Janeway doesn't prefer it. Did this usage of the honorific sir start with ST: TNG or does it predate TNG in either sci-fi or the real world?  Related: Solving a Linear Diophantine Equation A Linear Diophantine Equation is of the following form:                                                                                        $Ax+By+C=0$, where $x_1 \leq x \leq x_2$ and $y_1 \leq y \leq y_2$.  If the value of $A,B,C,x_1,x_2,y_1,y_2$ are given and $x_1 \leq x_2$ and $y_1 \leq y_2$, then how many solutions can be found? How can I find out the total number of solutions according to the above condition. U.K visitor visa with very old criminal conviction - do I disclose it? I have been travelling to the U.K for 25 years at least 8-10 times a year,  receiving 5 year visas, never breaking the stay period, with no problem. I've gone through immigration with no problem till my last time in London. I was stopped for eight hours and questioned about a run with the law while I was in college. This was in the US, I was around 20, it was for a credit card use. I received a conditional discharge / probation conviction which was discharged one year later. It was stupid, I was young and in college, more than 28 years ago.  After being questioned about the issue in the US, I was allowed in. They were very polite and professional.  I was also asked if I ever changed my name: I did not change it, but one letter was added in the middle of my first and last names around 20 years ago as our names are translated from Arabic to English and before the digital biometric passports, hand written passports some times varied. It was a common thing at the time.  Now I am applying for my new 5 year visas and I intend to answer truthfully  about previous conviction (previously I answered no because my conviction was spent and I expunged my record.) I want to answer yes and explain it. Is that the right thing to do?  Should I answer yes to the question about having a different name even though it was something as simple as spelling Bryan instead of Brian or Teresa and Theresa -- not really changing it and never thought of it as a change.  I have an impeccable credit rating in the Uk and the last 28 years have never received a moving violation or ever had a run in with the law.  I made one mistake when I was very young but I am  very worried about how to go ahead. I believe honesty is the best approach, is it? How to Fix Broken Packages? I have asked this question on SO but perhaps that was the wrong location. Apologies for double posting but the question may have a better audience here.  The original question is:   And the text is below. Thanks.    When running the postgresql [9.3] "COPY TO" functionality, the postgres user creates a file. I have told it to put the file in the tmp directory (although this can be changed if needed).  This is run as part of a cron job, the user is an "export" user set up especially for this task. The end goal is for the exported file to end up in /home/export/created_file.csv.  1) postgres can't stash the exported file straight into the home directory of another user without setting up the folder to be overly permissive.  2) the export user can copy the file from /tmp to it's home directory, but then can not clean up (delete) the postgres owned file in /tmp.  This is a daily process and so old files will need to be deleted in some way. I can add a cron job to clean up the files afterwards but I was hoping for a cleaner solution - either a way to change the permissions on the file that postgres creates, or some way to give the export user the additional permission of being able to delete that file in advance of it's creation.  Giving the export user the same permissions as postgres in general however isn't an option, as it would then have free reign over the database.  Any advice, be it unix based or postgres based would be very welcome, thanks. I'm curious of how illusions would affect spells or abilities that require a target to be looking at something. A good example of this would be Medusa's Petrifying Gaze which has the following effect:  Petrifying Gaze: When a creature that can see the medusa's eyes starts its turn within 30 feet of the medusa, the medusa can force it to make a DC 14 Constitution saving throw if the medusa isn't incapacitated and can see the creature. If the saving throw fails by 5 or more, the creature is instantly petrified. [...]  So if someone were to cast Minor Illusion to put a bag over Medusa's head, would other player/creatures who do not realize that the bag is an illusion be affected by the gaze if they were looking in the direction of it? Does the illusion block the effect? I'm colorizing the header of a table formatted with column -ts $'\t'  Works well without color codes, but when I add color codes to the first line column doesn't properly align the output.  Without colored output it works as expected: printf "1\t2\t3\nasdasdasdasdasdasdasd\tqwe\tqweqwe\n" | column -ts $'\t'  But when adding color on the first line column doesn't align the text of the colored row: printf "\e[7m1\t2\t3\e[0m\nasdasdasdasdasdasdasd\tqwe\tqweqwe\n" | column -ts $'\t'  Observed this behaviour both on Ubuntu Linux and Mac OS X. I get this error whenever I try to install programs using the terminal:  home@ubuntu:~$ apt-get install myunity E: Could not open lock file /var/lib/dpkg/lock - open (13: Permission denied) E: Unable to lock the administration directory (/var/lib/dpkg/), are you root?   Also I'm unable to install updates using the terminal. What happens when identical overlapping effects have their end-condition met? I have an array in Perl:  my @my_array = ("one","two","three","two","three");   How do I remove the duplicates from the array? How can I change Win 10 protected registry entries? Why is a Hyperplane called a "Hyper"plane? I just had this curious question. In other fields, the word "hyper" is actually used to refer to something which is "over; beyond; above" as defined by Google. An example of such terms would be Hyperglycaemia, defined by Wikipedia as:     a condition in which an excessive amount of glucose circulates in the blood plasma.   Or Hypersonic, defined by Google as:     relating to speeds of more than five times the speed of sound.   So, my question is, what would be the motive to give a Hyperplane such a name when it is defined as :     a subspace of one dimension less than its ambient space