Welcome to MSDN Blogs Sign in | Join | Help

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.

Published Monday, December 10, 2007 6:42 PM by JohnGuin

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# Untitled 1

Monday, December 10, 2007 10:23 PM by Untitled 1

# re: Table Sum Powertoy for OneNote

hee hee - the image links are broken!  Let me try to fix that...

Tuesday, December 11, 2007 10:00 AM by JohnGuin

# John's new powertoys!

John is posting some of the powertoys that have been in development, please see here: Table Sum Powertoy

Wednesday, December 12, 2007 10:24 PM by Daniel Escapa's OneNote Blog

# John's new powertoys!

John is posting some of the powertoys that have been in development, please see here: Table Sum Powertoy

Wednesday, December 12, 2007 10:28 PM by Noticias externas

# A Plethora Of OneNote 2007 Goodness

Daniel Escapa is filling the pages of his blog with an amazing array of OneNote information , links to

Thursday, December 13, 2007 8:41 AM by Pocket.Info - Mobile 2.0

# re: Table Sum Powertoy for OneNote

John you left me a note in the discussion group about my crash in ON after installing and attempting to use the table sum powertoy. Here is the error message I recieved. You'll be glad to know that I used ON to capture the error. (LOVE IT)

Error getting paxconç?

,Q,S ystem..untime.InteropServices.CtMException? (OaOO7O6BE): The

- remote procedure call failed. (Exception from HRESuLT: OsOO7O6BE)

at

Microsoft.Office.Interop.OneNote.Applicationclass.GetPagecontent(Str

ing bstrPageJD, String& pbstrPagexmlOut, Pagelnfo pagelnfoToExport)

at TableSums.Maynard.OnClick(String strActivePagelD)

I clicked on the link for the set up file and once it was downloaded I clicked on the link for the source code. (Didn't know for sure if I was supposed to do that or not) Please give better downloading instructions for those of us who are semi computer illiterates.

Once I downloaded both, I ran set up but nothing came up about allowing all users. I then opened onenotes to see if the icon was there and it was. I didn't realize it would add up every column in the table so I thought I was clicking on the column I wanted it to add up. Within seconds it said onenotes was not responding. I closed the program and when I reopened it I had the blue screen that says the last time I viewed that screen onenotes crashed so I refreshed. This happened a couple of times then I saw the error message above.

I then ran set up again only this time it ask me if I wanted to repair onenote table sum or remove onenote table sum. I selected repair.

The problem continued after that So I left the message on the board.

I went in later and tried again and then it worked. (Go Figure) Now it is working but when I click on the table sum icon it takes 30 + seconds for the action to take place. I have also noticed that some times during that 30 + seconds the top of the screen will show the (not responding message)

I'm running recently purchased onenotes 2007 on a new computer running Vista.

Not sure how to answer the question of the type of table I am using. Other than the information I put into it the tables all look the same. I am using text though.

You are welcome to email me if you need me to do anything else. Thanks for the addins I really love what I've seen of Onenotes so far and can't wait to see it grow.

Kathy

Monday, January 14, 2008 12:29 AM by Kathy

# re: Table Sum Powertoy for OneNote

Just curious - how many columns are in your table, and how much data do they have?

Also, the first time you use the addin, it takes a few seconds to load the .net framework and then initialize the addin.  Second and subsequent times you add columns it should be much faster.

I'm glad it started working for you.  I'll also give better setup directions in the future - I appreciate your honest feedback!

John

Tuesday, January 15, 2008 12:24 AM by JohnGuin

# Using OneNote's customers as a basis for designing tests

One of the more easy to explain testing techniques we use at Microsoft to ensure our software meets the

Thursday, January 24, 2008 4:15 PM by OneNote Testing

# Using OneNote's customers as a basis for designing tests

One of the more easy to explain testing techniques we use at Microsoft to ensure our software meets the

Thursday, January 24, 2008 4:32 PM by Noticias externas

# re: Table Sum Powertoy for OneNote

Very cool powertoy, John.  I can't wait for the final release.

As to the "other" hidden powertoy that is to be released (I haven't seen any other annoucements), but it is the other icon at the top right of the screenshots? It looks like a square with an arrow pointing from bottom left to top right.

Wednesday, February 13, 2008 5:26 PM by Dave J. (Scoop0901)

# re: Table Sum Powertoy for OneNote

It was the Task Request addin (http://blogs.msdn.com/johnguin/archive/2007/12/11/task-requests-from-onenote-meeting-notes-powertoy.aspx).  You can see the hand with the task item in it.

The icon you mention is the "full screen" mode.  It works the same as hitting F11 and is useful when you want to maximize the note taking area for your screen.  

John

Wednesday, February 13, 2008 5:33 PM by JohnGuin

# re: Table Sum Powertoy for OneNote

Cool powertoy.  However, the holy grail here has got to be excel embedded into notebook pages like it can be into a word doc.  Even better would be some native editing capabilities without opening the full blown excel application in the background.  Is this on the team's radar?

Monday, February 18, 2008 8:49 PM by KevinAndrew

# re: Table Sum Powertoy for OneNote

The most frequent feedback we get is "keep OneNote simple and lightweight."  Adding OLE/embedded apps and features like that could easily spiral into something very complicated very quickly.  Simply getting Word integrated as Outlook's default email editor in OL 2007 was extremely tough - how do we combine the Word ribbon with the Outlook email ribbon?  Just how much Word functionality can we integrate?  How much should we?  

Thanks for the nice words about this toy.  I hope to expand it somewhat if I can get some free time.

John

Monday, February 18, 2008 10:50 PM by JohnGuin

# re: Table Sum Powertoy for OneNote

Could you please provide a step-by-step usage of this addin? I am having problems getting it to do anything. The icon is always "greyed-out" in the toolbar. Maybe I missed something.

Sunday, March 16, 2008 5:09 AM by Brent

# re: Table Sum Powertoy for OneNote

Hello Brent,

Can you try the steps at http://blogs.msdn.com/johnguin/archive/2008/03/17/the-3-biggest-pain-points-we-are-investigating.aspx ?  The parts about running as administrator and ensuring the .NET support is installed are both important.

Sorry for the problems,

John

Monday, March 17, 2008 8:37 AM by JohnGuin

# re: Table Sum Powertoy for OneNote

John,

Thank you! I guess I missed that .net "support" didnt get installed with onenote.

everything is fine and dandy now!

Thank you for your excellent work! I find onenote really exciting and have become very attached to it... always looking for new ways to use it. I hope some great new features get added in the next release, I look forward to it with great anticipation! I wish they gave the dev team more resources, because onenote is in a class all its own!

Wednesday, March 19, 2008 8:39 AM by Brent

# re: Table Sum Powertoy for OneNote

This powertoy is great!!! It fills a gap I was experiencing. But I too would like to see some lightweight spreadsheet style manipulation on tables in the next version of onenote. Nothing super fancy.. but something flexible enough to make (self-calculating) hour logs/time-cards and simple invoices.

Wednesday, March 19, 2008 8:46 AM by Brent

# re: Table Sum Powertoy for OneNote

Hello Brent,

Thanks for the kind words!  And for extra "excel like" functionality, I'm trying to find some college students (see http://blogs.msdn.com/johnguin/archive/2008/03/10/looking-for-students-worldwide-to-help-with-the-onenote-object-model.aspx for details) to help with the OneNote object model.  A better set of table functionality is one of the projects - we'll see how this new program works out.

John

Wednesday, March 19, 2008 10:50 AM by JohnGuin

Leave a Comment

(required) 
required 
(required) 
 
Page view tracker