My question is similar to this one, for which no answer has yet been posted.   I am filling one Google Spreadsheet with Zapier which creates new rows of data. I then use ImportRange to take that some data from that sheet into another, where it is processed and generates text that I use to send out emails or SMS.  This 2nd sheet is read by Zapier in order to send the email or SMS.  The problem is that the 2nd sheet does not automatically update when I am not logged in an making changes.  i.e. importrange() is not updating 'when I am not looking'.  I have both sheets set to refresh every minute and Zapier 'reads them' once every 5 mins (writing to the first sheet, only reading from the second").  I have tried any scripts, although I have tried using the Now() function and concatenate() functions in order to amend the data pulled in by importrange() - which did not fix the problem.  The second sheet is a bit complex and takes time to load.
I am using an external application to enter data into a Google Spreadsheet.  This workbook is then referenced by a separate workbook (with the IMPORTRANGE(spreadsheet_key, range_string) function) that manipulates and interprets the data.  My problem is that whenever I personally modify the referenced workbook, the referencing workbook updates just fine, but whenever the external application modifies it, it does not get updated.  I have tried editing the "Spreadsheet settings" so that recalculation is done every minute and on every change.  Furthermore, I have also installed an extension in Google Chrome that auto-refreshes the page every hour.  However, the data does not get re-imported from the referenced workbook.  Even if I copy the formula into a new cell, the data is still not re-imported.  Is there anything that I can do to the referencing workbook to trigger Google Sheets to re-import the data?  Edit: Just to be clear, I currently have one workbook with data entered by an external application in it (call it the "source sheet"), and another workbook with an IMPORTRANGE function in it (call it the "referencing sheet").  The data shown by the IMPORTRANGE function in the "referencing sheet" does not include any data entered by the external application since I last personally edited the "source sheet".  Also, both workbooks are using the new Google Sheets.  Edit: Also, this question is not the same as  because I am using the function given as the solution to that question to import data from a spreadsheet.  The problem is not how to import the data, but rather how to update the source for the data.  My assumption would be that Google would have taken care of this for me, but the data in the "referencing sheet" does not get updated, and the only way I can find to get it to update is to physically go into the "source sheet" and edit it myself.
How to replace ${} placeholders in a text file? Help with multirow table I am trying to wrap text in the multirow column (1st one) and only have the vertical lines inside the table if that makes sense.   Can anyone help me? `  \begin{table*}[!htbp] \centering \renewcommand{\arraystretch}{1.4} \begin{tabular}{|c| p{2cm}|c|c|c|c|} \cline{3-6} &amp;&amp;\multicolumn{2}{c|}{\textbf{Gravité du Dommage G1}} &amp; \multicolumn{2}{c|}{\textbf{Gravité du Dommage G2}}\\  \cline{3-6} &amp;&amp;\textbf{Fréquence F1} &amp; \textbf{Fréquence F2} &amp; \textbf{Fréquence F1} &amp; \textbf{Fréquence F2}\\ \hline \multirow{ 2}{*}{\textbf{Probabilité Occurence O1}}&amp;\textbf{Possibilité Evitement P1}&amp;&amp;&amp;&amp;\\ \cline{2-6} &amp;\textbf{Possibilité Evitement P2}&amp;&amp;&amp;&amp;\\ \hline \multirow{ 2}{*}{\textbf{Probabilité Occurence O2}}&amp;\textbf{Possibilité Evitement P1}&amp;&amp;&amp;&amp;\\ \cline{2-6} &amp;\textbf{Possibilité Evitement P2}&amp;&amp;&amp;&amp;\\ \hline \multirow{ 2}{*}{\textbf{Probabilité Occurence O3}}&amp;\textbf{Possibilité Evitement P1}&amp;&amp;&amp;&amp;\\ \cline{2-6} &amp;\textbf{Possibilité Evitement P2}&amp;&amp;&amp;&amp;\\ \hline \end{tabular} \end{table*} Proving $\frac{\sin x}{x} =\left(1-\frac{x^2}{\pi^2}\right)\left(1-\frac{x^2}{2^2\pi^2}\right) \left(1-\frac{x^2}{3^2\pi^2}\right)\cdots$ How to prove the following product? $$\frac{\sin(x)}{x}= \left(1+\frac{x}{\pi}\right) \left(1-\frac{x}{\pi}\right) \left(1+\frac{x}{2\pi}\right) \left(1-\frac{x}{2\pi}\right) \left(1+\frac{x}{3\pi}\right) \left(1-\frac{x}{3\pi}\right)\cdots$$ showing that a group of order 45 is abelian Which of these are acceptable? Is one preferable over the other?   "Chemically-deposited tourmaline is never periwinkle." "Chemically deposited tourmaline is never periwinkle."   Also, is the title to the this question asking what I'm trying to ask?  (I realize that there are other questions about hyphenation in similar contexts; I'm asking specifically about -ly adverbs.) Is there a way to convert an image to grayscale? I want to have a page-filling and -breaking longtable, so I decided to try xltabular. Unfortunately xltabular seems to screw up the booktabs rules in the normal tabular environments, see:  \documentclass{article} \usepackage{booktabs, xltabular} \usepackage[active,tightpage]{preview} \PreviewEnvironment{tabular} \begin{document} \begin{tabular}{ccc}     \toprule     col1 &amp; col2 &amp; col3 \\     \midrule     row 2: &amp; more and moooooooooooore &amp; test \\     \bottomrule \end{tabular} \end{document}     Not loading xltabular resolves the issue.  Did I miss some package option or some incompatibilities? Is there a better package than xltabular which doesn't break booktabs?  (I am using TeXLive 2019 and compile with lualatex)    EDIT (by Skillmon)  I reduced the bug to the following MWE (which doesn't make much sense on its own), it looks like booktabs tries to be smart detecting something, but fails badly.  \documentclass{article} \usepackage{longtable} \let\xltabular\relax \usepackage{booktabs}  \begin{document} \begin{tabular}{ccc}     \toprule     col1 &amp; col2 &amp; col3 \\     \midrule     row 2: &amp; more and moooooooooooore &amp; test \\     \bottomrule \end{tabular} \end{document}   It seems to suffice that longtable is loaded and \xltabular is defined (even if it's just \relax). Convergence of $A_nT$ to $AT$ in operator norm for compact $T$ $A_n:Y\rightarrow Z$ are operators that strongly converge to $A$. Also, $\|A_n\|_\text {op}\le c$ for $c&gt;0$. Given a compact operator $T:X\rightarrow Y$, I need to show that $A_nT$ converges to $AT$ in operator norm (all spaces in this question are Banach spaces).     I was unable to prove this and I also do not understand why we need to assume that $T$ is compact. Any ideas? Why does "touch -a" also set the ctime? Is it touch(1) from coreutils-8.4-37.el6.x86_64 or my brain which is broken?  $ touch abc $ LANG=C stat abc   File: `abc'   Size: 0               Blocks: 0          IO Block: 4096   regular empty file Device: fd04h/64772d    Inode: 10485773    Links: 1 Access: (0664/-rw-rw-r--)  Uid: (3060399/ nodakai)   Gid: (  418/   quant) Access: 2016-10-14 18:42:06.189751847 +0800 Modify: 2016-10-14 18:42:06.189751847 +0800 Change: 2016-10-14 18:42:06.189751847 +0800 $ touch -a abc $ LANG=C stat abc   File: `abc'   Size: 0               Blocks: 0          IO Block: 4096   regular empty file Device: fd04h/64772d    Inode: 10485773    Links: 1 Access: (0664/-rw-rw-r--)  Uid: (3060399/ nodakai)   Gid: (  418/   quant) Access: 2016-10-14 18:42:17.374235446 +0800 Modify: 2016-10-14 18:42:06.189751847 +0800 Change: 2016-10-14 18:42:17.374235446 +0800 $ touch --help | grep 'access time'   -a                     change only the access time   As you see, it was not only atime but also ctime which was updated by touch -a !?!?  The filesystem is ext4 over LVM if that makes any differences. What is the reason behind the multiple Spider-Man reboots? Spider-Man is the one franchise that is on course to a third reboot in a span of 15 years.   My question is what was the reason for these numerous reboots of Spider-Man which pretty much follow the same origin story for the Marvel superhero.  Has the comic creator or studio ever spoken out about the reasoning behind the same? HTML form readonly SELECT tag/input We had in our lecture on numerical analysis the following: Let $\mathrm{Lin}(X,Y)$ be the set of all linear maps $X\rightarrow Y$. Let $A\in\mathrm{Lin}(\mathbb R^l,\mathbb R^n)$ and $B\in\mathrm{Lin}(\mathbb R^n,\mathbb R^m)$ and $\|C\|_{op}:=\max_{\|x\|\leq1}\|C(x)\|$. Then our lecturer followed $\|A\circ B\|_{op}\leq\|A\|_{op}\cdot\|B\|_{op}$. So he didn't prove it and so I've tried it by my own. My attempt: $$\begin{aligned} \|A\circ B\|_{\mathrm{op}} &amp;= \max_{\|x\| &lt; 1}\|(A \circ B)(x)\| \\ &amp; \leq \max_{\|x\| &lt; 1} \|A\|_{\mathrm{op}} \|B(x)\| \\ &amp;= \|A\|_{\mathrm{op}} \max_{\|x\|\leq1}\|B(x)\|\\ &amp;= \|A\|_{\mathrm{op}}\|B\|_{\mathrm{op}} \end{aligned}$$ But this seems too easy. I am really interested in a nice proof so anybody could help? Thanks a lot! Splicing a Javascript array from within the callback passed to forEach ModelBuilder not adding output feature class to Table of Contents? I'm trying to create a tool in ModelBuilder that will take a new point from a user, create a feature class for this point and display it on a map.  What I've done is:   I've created a feature class for a point-like feature in ArcCatalog. I've prepared a really simple model in ModelBuilder, that starts with a feature set variable (which takes the feature class as a schema and symbology file). The variable is marked as a parameter. Next I'm using the Copy Features tool that takes the variable as input and saves it as a feature class in my scratch workspace. The output feature class is marked as a parameter with the 'add to display' option.   After the module is run I get a shapefile in my scratch workspace. I can add it manually to TOC and it contains the selected point. However no matter what I do, I can't display it in TOC automatically after the model completes.  There is a known issue described in several places that doesn't allow to display newly created layers in TOC when model finishes with the 'add to display' option. However there's a quick workaround, which is to mark the output layer as parameter. In my case it doesn't work.  I'm using ArcGIS for Desktop 10.1 on Windows 7 x86_64. How to handle WndProc messages in WPF? In Windows Forms, I'd just override WndProc, and start handling messages as they came in.  Can someone show me an example of how to achieve the same thing in WPF? Does a photon in vacuum have a rest frame? Quite a few of the questions given on this site mention a photon in vacuum having a rest frame such as it having a zero mass in its rest frame. I find this contradictory since photons must travel at the speed of light in all frames according to special relativity.  Does a photon in vacuum have a rest frame? What is a good data plan for Internet surfing in northern Italy? I've checked the webpages of some their providers, but franly, just like in the case of those in my own language, I literally cannot find my way around them. So if you wouldn't mind sharing a word of two or advice.  I'm looking for a good solution for mobile internet surfing in northern Italy, that can be connected to a laptop (you know, that usb stick with a SIM card inside kind of thing). 15 Gb or so at some decent speed. Can you perhaps give a recommendation or two of what to get?    Edit: Just to define what I'm looking for exactly. A data plan of 15 Gb with an internet key (usb stick into which a SMS card goes) that you plug into a laptop. Preferably non-contractual, so I can cancel when I leave. I am not interested in surfing on my mobile phone since due to size I still prefer the smaller Nokia-like models for calls (smaller to carry) - no internet on them. Clear item with custom name? Earlier I asked a question about  and got the answer that while it is only necessary for anonymous types, that it is used nonetheless to make writing code 'quicker'/easier and 'just because'.  Following  I saw that var gets compiled down to the correct type in the IL (you will see it about midway down article).  My question is how much more, if any, IL code does using the var keyword take, and would it be even close to having a measurable level on the performance of the code if it was used everywhere? I'm trying to load data from different tables using left outer joins into a QgsVectorLayer. The approach I'm following so far is the one from the developers cookbook . The underlying database is postgres. The query returns correct data, including a geometry column, however I can't figure out how to get the join inside the query to work with . As the table the data come from needs to be specified, is it even possible to do so?  Would approaching the problem using psycopg2 be more suited, and if so, is there a way to create a layer from the result set? The only way I can think of is creating an empty layer and adding each feature individually by looping over the result set. But possibly there is an easier way?  Sadly, using the builtin DB Manager is not an option. The layer has to be added programmatically.