Table Sum Powertoy for OneNote

John Guin has post one of many new powertoys to come over the next week…

Table Sum Powertoy for OneNote

•  

• As promised, here is the first of a week’s worth of addins/powertoys for OneNote 2007. This addin will sum the columns of a table for you and add the new row to the bottom. It ignores non-numeric values in the column. It’s only requirement is that you need to click in a table to select it before hitting the Sum button (although it will prompt you for clicking the table if you need to).

   

  It does have some limitations. Inking (writing numbers in tables w/o converting them to text) is not supported, and tables within tables will cause problems.

  Here’s the link for the setup file: http://johnguin.members.winisp.net/Shared%20Documents/table_sums.zip

   

  Alternate location: http://elhombre.members.winisp.net/api/table_sums.zip

   

  And the source code: http://johnguin.members.winisp.net/Shared%20Documents/table_sums_Source.zip

   

  Alternate location: http://elhombre.members.winisp.net/api/table_sums_Source.zip

   

  Standard setup directions apply: ensure OneNote has exitied, run setup.exe (as an admin on Vista) and install for all users.

   

  Here it is in action. Before adding the columns:

  

   

   

  And after:

  

   

   

  (And there is a hidden preview for another addin to be released later this week in the images above. Can you find it?)

   

  There is a lot to do with this from here. Adding support to sum rows (relatively easy, but requires some new UI), performing other simple math routines, completely ignoring columns which have no numbers at all, perhaps applying boldface to the answers and similar tasks would all be appreciated. Moving this code over to the Object Model at www.codeplex.com/onom and extending it there is also a task on my radar.

   

  As always, let me know what you think.

   

  Questions, comments, concerns and criticisms always welcome,

  John

Posted: December 11th, 2007 under Taskbar & Utilities.

Comments