I have copied some data into Excel 2010. I have found that some of the cells need to be widened to allow the data to fit. How do I automatically adjust the height of the cells to fit the content?
For every generation of Excel I can remember (including 2010, which I'm using now), Excel's "Auto Size Row" features sometimes fails to actually auto size a row when the cell contains wrapped text. When it works properly, all the text is revealed and there is no additional space below the last line of text. When it fails, it adds extra space below the text. To make matters worse, what you see is not always what you get, i.e., text that appeared okay on screen gets cut off when it's printed. You also get different sizing depending on whether you are zoomed in/out or at actual size.  Simple test case:  Why is there a one-line gap after the text in cell A1 but not in A2?  (To reproduce: set width of column A to 17.14 (125 pixels), text wrap on, and cell alignment top.)  (I double-checked that I applied Auto Fit Row Height to both rows. Zoom level is 100%.)    Is there any known remedy for this without resorting to manually adjusting the row heights (which is not practical for more than a handful of rows)?
Update pgfmath macro in foreach loop I need to update a variable defined in a pgfmathsetmacro command inside a foreach loop. Apparently, the var is only updated when it is used after the update command. Here is a MWE:  \begin{tikzpicture} \draw [help lines] (0,0) grid (3,3); \pgfmathsetmacro{\a}{1} \foreach \b in {2,3} {     \node [blue] at (\a,0) {\a};     \pgfmathsetmacro{\a}{\b}     \node [red] at (0,\a) {\a}; } \end{tikzpicture}   The red nodes are printed at updated positions and the value printed is also updated; the blue nodes are not: they keep their initial value (1) and are located at the initial position (0,1).  Why is this? Thanks José Is a bool read/write atomic in C# Is accessing a bool field atomic in C#? In particular, do I need to put a lock around:  class Foo {    private bool _bar;     //... in some function on any thread (or many threads)    _bar = true;     //... same for a read    if (_bar) { ... } } This seems to be a basic issue, but I just realized that I actually don't know how to test equality of coefficients from two different regressions. Can anyone shed some light on this?   More formally, suppose I ran the following two regressions:  $$ y_1 = X_1\beta_1 + \epsilon_1 $$ and  $$ y_2 = X_2\beta_2 + \epsilon_2 $$ where $X_i$ refers to the design matrix of regression $i$, and $\beta_i$ to the vector of coefficients in regression $i$. Note that $X_1$ and $X_2$ are potentially very different, with different dimensions etc. I am interested in for instance whether or not $\hat\beta_{11} \neq \hat\beta_{21}$.   If these came from the same regression, this would be trivial. But since they come from different ones, I am not quite sure how to do it. Does anyone have an idea or can give me some pointers?   My problem in detail: My first intuition was to look at the confidence intervals, and if they overlap, then I would say they are essentially the same. This procedure does not come with the correct size of the test, though (i.e. each individual confidence interval has $\alpha=0.05$, say, but looking at them jointly will not have the same probability). My "second" intuition was to conduct a normal t-test. That is, take   $$ \frac{\beta_{11}-\beta_{21}}{sd(\beta_{11})} $$  where $\beta_{21}$ is taken as the value of my null hypothesis. This does not take into account the estimation uncertainty of $\beta_{21}$, though, and the answer may depend on the order of the regressions (which one I call 1 and 2).   My third idea was to do it as in a standard test for equality of two coefficients from the same regression, that is take  $$ \frac{\beta_{11}-\beta_{21}}{sd(\beta_{11}-\beta_{21})} $$   The complication arises due to the fact that both come from different regressions. Note that   $$ Var(\beta_{11}-\beta_{21}) = Var(\beta_{11}) + Var(\beta_{21}) -2 Cov(\beta_{11},\beta_{21}) $$ but since they are from different regressions, how would I get $Cov(\beta_{11},\beta_{21})$?  This led me to ask this question here. This must be a standard procedure / standard test, but I cound not find anything that was sufficiently similar to this problem. So, if anyone can point me to the correct procedure, I would be very grateful! What is the right ffmpeg output format for a v4l2-loopback device? Following the guide in  I did:  $ sudo modprobe v4l2loopback $ ffmpeg -f x11grab -r 15 -s 1280x720 -i :0.0+0,0 -vcodec rawvideo -pix_fmt yuv420p -threads 0 -f v4l2 /dev/video0   The device /dev/video0 shows up as expected but the ffmpeg command fails with following output:  $ ffmpeg -f x11grab -r 15 -s 1280x720 -i :0.0+0,0 -vcodec rawvideo -pix_fmt yuv420p -threads 0 -f v4l2 /dev/video0 ffmpeg version 4.0 Copyright (c) 2000-2018 the FFmpeg developers ... [x11grab @ 0x559767794cc0] Stream #0: not enough frames to estimate rate; consider increasing probesize .... [v4l2 @ 0x55976779e6c0] ioctl(VIDIOC_G_FMT): Invalid argument Could not write header for output file #0 (incorrect codec parameters ?): Invalid argument Error initializing output stream 0:0 --  Conversion failed!   I already tried to follow the suggestions below the answer to no avail. I noticed that v4l2 is listed as demux only in ffmpeg -formats. Does that mean I can't use it for output to /dev/video0? If so, what should I use instead? I tried h264 but that crashes after ~1000 frames with following error message:  $ ffmpeg -f x11grab -r 15 -s 1280x720 -i :0.0+0,0 -vcodec rawvideo -pix_fmt yuv420p -threads 0 -f h264 /dev/video0 ffmpeg version 4.0 Copyright (c) 2000-2018 the FFmpeg developers ... [x11grab @ 0x55da61e29cc0] Stream #0: not enough frames to estimate rate; consider increasing probesize ... File '/dev/video0' already exists. Overwrite ? [y/N] y .... Error writing trailer of /dev/video0: Invalid argument .... Conversion failed! Python: list items are not changed in for loop What happened to the Yin half of Kurama? Did Naruto get both halves of Kurama after fighting Sasuke, or did the other half of Kurama die when Minato was killed? How does Cypher exit/enter the Matrix without an operator? I've just upgraded to Ubuntu 17.10 and am missing the Ubuntu Dock settings, i.e. in gnome-control-center the dock settings are blank:    I think I might be missing the "ubuntu-dock" package, but can't find this anywhere in the software centre.  Also the gnome-control-center was completely missing after the update, and I had to install this separately - not sure if this is related.  I think this is different from  because changing the type of GNOME session doesn't fix the problem. If I go for GNOME* I get no Dock settings section at all, and if I got for Ubuntu* I get the blank Dock settings section described above.  Output of apt-cache policy gnome-shell-extension-ubuntu-dock:  rob@rob-pc:~$ apt-cache policy gnome-shell-extension-ubuntu-dock gnome-shell-extension-ubuntu-dock:   Installed: (none)   Candidate: 0.7   Version table:      0.7 500         500 http://gb.archive.ubuntu.com/ubuntu artful/main amd64 Packages         500 http://gb.archive.ubuntu.com/ubuntu artful/main i386 Packages What does “pull sb. out of the hat” mean? Some days I'm working with extremely large Excel files.  They have too many sheets that can't be shown in one sheet tab. (see image)      So, I'm wondering whether or not we can show Excel sheet on more than 1 row. Many tries with Google don't help much.    Many tries but I still can't make Excel show the sheet bar the way I want (≥ 2 rows), so I'm working with some VBA Scripts kopischke suggested.    FYI, right click on |&lt; &lt;&lt; &gt;&gt; &gt;| button on the bottom-right corner show you a list of up to 15 sheets.  For more, click on View more in the list appeared. How do they decide Blu-ray/DVD release date? I think my question is different from .  Some movies' productions release Blu-ray/DVD so early after theatrical release, others will take time. How do they decide for the Blu-ray/DVD release date? How to execute several commands after each other with one request to the terminal (without using a file)? What is the best place for storing binary files that are related to data in your database? Should you:   Store in the database with a blob Store on the filesystem with a link in the database Store in the filesystem but rename to a hash of the contents and store the hash on the database Something I've not thought of   The advantages of (1) are (among others) that atomicity of transactions is preserved. The cost is that you might dramatically increase storage (and associated streaming/backup) requirements  The goal of (3) is to preserve atomicity to some degree - if you can enforce that the filesystem you are writing to does not allow files to be changed or deleted, and always has the correct hash as filename. The idea would be to write the file to the filesystem before permitting the insert/update referencing the hash - if this transaction fails after the filesystem write but before the database DML, that is fine because the filesystem is 'faking' being the repository of all possible files and hashes - it doesn't matter if there are some files in there that are not being pointed to (and you could clean them up periodically if you are careful)  EDIT:  It looks like some RDBMSs have this covered in their individual ways - I'd be interested to know how others do it - and particularly in a solution for postgres What's the difference between Wubi and a regular "alongside Windows" installation? I can not see how mathematically one can divide the numerator and denominator by theta. Can some one explain this in a different way. When you divide two fractions you multiply the first fraction by the reciprocal of the second. This is not the case here.     Divide numerator and denominator by $\theta$. ($\sin\theta$ also works.) $$\eqalign{\lim_{\theta\to0}\dfrac{\sin\theta}{8\theta+\tan\theta}&amp;= \lim_{\theta\to0}\dfrac{\dfrac{\sin\theta}\theta}{8+\dfrac{\sin\theta}\theta\cdot\dfrac1{\cos\theta}}\\&amp;=\dfrac{\lim\limits_{\theta\to0}\dfrac{\sin\theta}\theta}{8+\lim\limits_{\theta\to0}\dfrac{\sin\theta}\theta\lim\limits_{\theta\to0}\dfrac1{\cos\theta}}\\&amp;=\dfrac1{8+1\cdot1}\\&amp;=\dfrac19.}$$ Sharepoint 2010 - Deploy webpart as Feature scope = web is it possible to redefine { and } in C? I am very new to being able to use LaTeX to type up mathematical papers, and I just got my "system" set up. Currently I have installed TexWorks, and MikTex, and I have put together a 'hello world' article which seems to run well.   I have also used the syntax "\usepackage{amsmath}" and "\usepackage{amssymb}" in the beginning of my .tex file to write math symbols, only because some online tutorial said so.   My question is, firstly, are those the only packages I need to use for writing math, and secondly, I remember reading about some shortcuts(?) that can be used for writing math symbols, and/or user defined shortcuts that can be 'set' in the beginning so as to reduce the amount of LaTeX code needed to write mathematical symbols. However, I do not know if this is true, and if it is, how to go about 'installing' such a thing.   Does such a thing exist? Am I able to make my own shortcuts?  Thanks! How can I search for one label but not another? What search query will return conversations that have the label Reading but not the label Ignore?  I've tried using label:reading -label:ignore but Gmail still returns conversations that have the label Ignore:    The query label:(reading -ignore) gives me the same results. Proof of when is $A=X^TX$ invertible?