Using importHTML in Google sheets is it possible to shape the following Sheet1:Rows 1-30 only Sheet2:Rows 31-61 only This would increase the data limit from 50 to 60 but with two sheets. I understand it is possible to use query Limit and offset Limit the number of rows Offset skips a number of rows &quot;Select* LIMIT 2 OFFSET 4&quot; This maybe a solution
123420
, upon which I'm trying to use importxml() but it just won't work properly.  Until moments ago, not a single one of the formulas on this sheet would load at all, they just hung on "Loading...", but just as I began this question, some of the cells began populating with data.  This is the follow-on  that turned out to be an issue with the XPath and how importxml() handles it.  But that led me to this issue.  Can anyone see what is wrong with  and why the function won't behave properly?
31810
Excel has the functionality to import fixed-width text files where it presents a dialog that lets you choose where the begins and ends of fields are which it puts into columns.  Does it also have functionality where, given an existing spreadsheet, you can export to a fixed-width text file?    If so, how do I access this? I have tried using Save As and choosing Text File but it seems to only save as Tab-delimited which doesn't help me.  This is Excel 2003 if it matters.
64889
I pressed return to make a new line in a cell of my Google Spreadsheet. That just moved the cursor to the next cell.   How does one add a new line in a cell?
54409
I had tried to increase the number from 2 to 4 where I need 4 lines  \multirow{4}{*}{\thead{Pair number \\ (Class 11 sample sample \&amp; \\ Class 22 sample sample \\ Reference X sample sample)}} &amp;      \documentclass[12pt,oneside]{book}  \usepackage[showframe]{geometry} \usepackage{amsmath} \usepackage{ragged2e} \usepackage{makecell, multirow, tabularx} \renewcommand\theadfont{\small\bfseries} % for bold in table using \small \renewcommand\theadgape{} \usepackage[svgnames, table]{xcolor} \usepackage{hhline, boldline} \usepackage{seqsplit, caption} %for table spacing to second row \usepackage{booktabs, ragged2e} % Use booktabs rules and get rid of vertical rules, ragged2e to ragged text \usepackage{siunitx} %for table spacing to second row \usepackage{threeparttable} %to add footnote below table \usepackage{tabulary} \usepackage{graphicx}  \usepackage[font=small,labelfont={bf,sf}, textfont={sf}, justification=centering]{caption}  \begin{document}   \begin{table}[h!] \centering \sisetup{table-format=3.0, table-number-alignment=center, table-column-width=2.0cm}  \begin{tabular}{lrr}     \toprule      \multirow{4}{*}{\thead{Pair number \\ (Class 11 sample sample \&amp; \\ Class 22 sample sample \\ Reference X sample sample)}} &amp;  \multicolumn{2}{c}{\thead{\makebox[0pt]{Accuracy Accu Accuracy (\%)}}}\\ \cmidrule{2-3}     &amp;{\textbf{Accuracy}}      &amp; {\textbf{Inaccuracy}} \\      \midrule     Pair 11 (A8 \&amp; B35) &amp; 0  &amp;   0 \\     Pair 12 (A10 \&amp; B42) &amp; 0   &amp;  0 \\     Pair 13 (A8 \&amp; B32) &amp; 0   &amp;  0 \\         \bottomrule     \end{tabular} \end{table}   \end{document}
4354
I have a monthly spreadsheet that relies on figures from the previous month. I'd like to import these values dynamically rather than cutting and pasting them. Is this possible? How do I do it?
43013
I have the following formula in a sheet:  =if(E1="HOLD",,query(Cust_Orders!B6:Z5000,"Select Y,G,I,H,K where H&gt;0  "))   With E1 being a drop down with values HOLD and FETCH  The recalculation when I go to FETCH takes about 13 seconds.  But when it is in HOLD, the query doesn't exceute, and everything goes blank. Not what I want.  I'm trying to avoid recalculating this query every time I make a change in the Cust_Orders range, but keep the old values, as two different pivot tables that are viewed by other people are dependent on it.  Google spreadsheet recalc settings all are 'on change and foo'  Is there a way to do this?
59444
I have a large dataset to show in tabular format. The problem is that it doesn't page  break into more pages. And the excess is not being displayed.  This is how i used the tabular tag   \begin{tabular}{ lllllllllllllllll }  00000000 &amp; 00 &amp; 01 &amp; 02 &amp; 03 &amp; 04 &amp; 05 &amp; 06 &amp; 07 &amp; 08 &amp; 09 &amp; 10 &amp; 11 &amp; 12 &amp; 13 &amp; 14 &amp; 15 \\  00000016 &amp; 16 &amp; 17 &amp; 18 &amp; 19 &amp; 20 &amp; 21 &amp; 22 &amp; 23 &amp; 24 &amp; 25 &amp; 26 &amp; 27 &amp; 28 &amp; 29 &amp; 30 &amp; 31 \\  00000032 &amp; 32 &amp; 33 &amp; 34 &amp; 35 &amp; 36 &amp; 37 &amp; 38 &amp; 39 &amp; 40 &amp; 41 &amp; 42 &amp; 43 &amp; 44 &amp; 45 &amp; 46 &amp; 47 \\  00000048 &amp; 48 &amp; 49 &amp; 50 &amp; 51 &amp; 52 &amp; 53 &amp; 54 &amp; 55 &amp; 56 &amp; 57 &amp; 58 &amp; 59 &amp; 60 &amp; 61 &amp; 62 &amp; 63 \\  00000064 &amp; 64 &amp; 65 &amp; 66 &amp; 67 &amp; 68 &amp; 69 &amp; 70 &amp; 71 &amp; 72 &amp; 73 &amp; 74 &amp; 75 &amp; 76 &amp; 77 &amp; 78 &amp; 79 \\  00000080 &amp; 80 &amp; 81 &amp; 82 &amp; 83 &amp; 84 &amp; 85 &amp; 86 &amp; 87 &amp; 88 &amp; 89 &amp; 90 &amp; 91 &amp; 92 &amp; 93 &amp; 94 &amp; 95 \\      \end{tabular}   I haven't included all the rows here.   How can i make it automatically page break into new pages and show the entire table.
65998
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.
58096
I'm trying to make a conditional formatting rule in Google Spreadsheet that would highlight a row green based on text in multiple cells.   If cells L2, M2, and N2 = APPROVED; and cell O2 = X; then row 2 = highlighted green.
9459
I'm using the multicol package for my columns. So far, I have \setlength\columnsep{10pt} in the preamble to set the default column separation. But for one particular page, I'd like to set the columnsep to 30pt.  I wasn't able to get it to work by inserting a new \setlength at the start of the page.  Here's an example:  \documentclass{article} \usepackage{blindtext} \usepackage{multicol} \setlength\columnsep{10pt} % This is the default columnsep for all pages \begin{document}  \begin{multicols*}{2} \blindtext  \newpage \setlength\columnsep{30pt} % I want the columnsep to be wider only on this page. Right now, nothing happens. The default 10pt is still being used. \blindtext \columnbreak \blindtext  \newpage \blindtext  \end{multicols*} \end{document}   Any help would be appreciated.
122624
I have created 50 spreadsheets for 50 students. Each spreadsheet contains 33 sheets, numbered 1 to 33, along with a couple of other sheets.  Within each of these 33 sheets, there are many protected ranges.  I accidentally protected a range that ought not to have been protected. So, with 50 students each having 33 sheets, I have over 1800 sheets to unprotected.  I want to loop through each sheet, 1 to 33, and remove protection from cell F15. Right now, I (the owner) am the only editor.  Since I'm not an actual programmer, I've clearly not done this properly.  Can someone offer a suggestion of how I can change my Google Script to make this work?  var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheets = ss.getSheets();  for (var i=2; i  &lt;sheets.length; i++) {   var sheet = ss.getSheets()[i];   sheet.activate();   SpreadsheetApp.flush();   var range = sheet.getRange('F15');        var protection = range.protect().setDescription('Protected range');        var me = Session.getEffectiveUser();        protection.addEditor(me);        protection.removeEditors(protection.getEditors());        if (protection.canDomainEdit()) {          protection.remove();          } //end of if statement  }
42967
One of the pages in our web app includes a table that typically has a few dozen rows for each user, and it takes most of the page's width (5-8 columns).   For each row, users can perform 3 possible actions.  What's the recommended way to let users perform these actions? We've considered a few options:   3 small action buttons on the left-hand side of each row  3 small action buttons on the right-hand side of each row Drop down with the three actions Other approaches?   I saw other questions with a great discussion on  , but in this case, I'm more interested in the right place to put them.   Thanks!  Option 1 Illustration
47087
In a Google Spreadsheet, I have a column with values like T1, T2, T13 (i.e. all values starting with the same text prefix). I would like to use a formula on the numerical part of the values of these cells (for conditional formatting). Can I somehow apply it only to the numeric part of the value, i.e. 1, 2, 13? I would like to change the background colour for the cell containing the maximum numeric part of the value?  I know how to extract the numeric part. E.g., if the T-values are in column A, cell B3 can contain this equation:  =if(len(A3)&gt;1,value(right(A3, len(A3)-1)),0)   However I fail to apply any further formula to this. E.g. this doesn't work:  =max(if(len(A2:A)&gt;1,value(right(A2:A, len(A2:A)-1)),0))
28042
I really tried hard to do this on my own, but I keep failing ... Using multi-column and multi-row commands confused me. I know some of you might frown upon such a request but I really need help getting this table implemented .. So I'm sorry if I upset anyone.  My preamble has :   \documentclass[12pt,a4paper]{report} \usepackage[lmargin=3.81cm,tmargin=2.54cm,rmargin=2.54cm,bmargin=2.52cm]{geometry} \linespread{1.5}     Is there a way I can convert this from excel to LaTeX form ? I tried an add-in before but it didn't work for me. Also online generators cannot combine cells the way I want them (unless I didn't find a better table generator ? )
58454
I’m trying to get IMPORTRANGE to work for me with no success. I made two simple spreadsheets:  and . In the destination sheet I’m using the import range function:  =importrange(“1-5F1_zz0ZpGj7SfeQhewsCe0CsrA0eyPbjfmUrLBsyk”,”Sheet1!a1:a1”)   I tried already:   Replacing the , with ; Referencing just the key as well as the full URL in the first argument Switching from “ to ‘ With the sheet name and without it   Not sure what else to do.  Any ideas?
26340
I am using the outlines package to write some outlines, and occasionally four levels are not enough to present my data. I understand that this is a limitation of LaTeX, as you cannot nest more than four levels of enumerate environments. Is there any way to increase this limit? If not, why is the limit exactly four?
60682
I have the following QUERY  =query(XX!A2:A;" select A where A&gt;'50' ")   and  =query(YY!A2:A;" select A where A&gt;'50' ")   how do I combine these two data sources so I don't have to have two separate columns they process data to?   best would be if the 1st row from XX is followed by the 1st row of YY, 2nd row followed by 2nd row... and so on If the above option is not easily possible, it is OK for one query to be followed by the second one (if I expect correctly that the start of the second will be moved with newly added data into the first one)