Auto-fill

Description : Auto-fills selected table cells using data from the first few selected cells

Download
Author(s) : Omer Atay
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) - Omer Atay
Re-written with the new Macro Language to take advantage of cleaner syntax and performance improvements

These versions are no longer supported:

March 09, 2013 - Omer Atay
Initial version

Related Macros

Macros by This Author

Comments

Name
Comment
dennis_uk - 2017-05-12
I'm with @Neil H:
<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>
dennis_uk - 2017-05-12
I'm with @Neil H:
<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>
Dan - 2017-02-27


Hello Omer,

I made it work

<?xml version="1.0" encoding="utf-16"?>
<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>



:)