Auto-fill
Description | : | Auto-fills selected table cells using data from the first few selected cells |
Download |
---|---|---|---|
Author(s) | : | Onetastic | |
Category | : | Table | |
Last Updated | : | June 20, 2016 | |
Requirements | : | OneNote 2010 or above | |
Screenshot | : | ||
![]() Auto-fill No screenshot available for this macro. |
|||
Changelog | : | June 20, 2016 (8FBECD) - Onetastic These versions are no longer supported: March 09, 2013 - Onetastic |
<i>What would useful to me is if auto-fill incremented the number or alpha character as it filled down. So if you put a 1 in the top cell in a column and then clicked auto fill the cell below would have a 2 in it and a 3 in the one below that etc.</i>
<i>What would useful to me is if auto-fill incremented the number or alpha character as it filled down. So if you put a 1 in the top cell in a column and then clicked auto fill the cell below would have a 2 in it and a 3 in the one below that etc.</i>
Hello Omer,
I made it work
<Macro name="TABLE - Font Size - Column 3 Only">
<Comment text="----------------------------------------------------------------------------------" />
<Comment text="Change the Font Size in Table Column " />
<Comment text="----------------------------------------------------------------------------------" />
<ForEach var="table">
<Array>QueryObjects("Table", GetCurrentPage())</Array>
</ForEach>
<ForEach var="cell">
<Array>QueryObjects("Cell", $table)</Array>
<If>
<Condition>$cell.colIndex == 2</Condition>
<Expression>$cell.paragraphs[0].alignment = "right"</Expression>
<Expression>$cell.paragraphs[0].fontSize = 8</Expression>
</If>
</ForEach>
</Macro>
:)
I am trying to target Column 4 Paragraph text - and make the font size to Size 12
<ForEach var="oTableCell">
<Array>QueryObjects("Cell", GetCurrentPage())</Array>
<If>
<Condition>!($oTableCell.colIndex == 3)</Condition>
<Continue>1</Continue>
</If>
<Expression>$oTableCell.paragraphs fontSize= 18</Expression>
</ForEach>
I tried to target the paragraphs - but I got stuck and couldn’t work it out