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.
-
(Updated 3/11/09 to remove dead links and put images back).
Here's the link for the setup file:https://johnguin.members.winisp.net/Shared%20Documents/table_sums.zipAlternate location: https://elhombre.members.winisp.net/api/table_sums.zip
And the source code:https://johnguin.members.winisp.net/Shared%20Documents/table_sums_Source.zipAlternate location: https://elhombre.members.winisp.net/api/table_sums_Source.zip
Standard setup directions apply: ensure OneNote has exited, run setup.exe (as an admin on Vista) and install for all users.
Here it is in action. Before adding the columns:
And after:
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
Comments
Anonymous
December 10, 2007
PingBack from http://www.absolutely-people-search.info/?p=5515Anonymous
December 11, 2007
hee hee - the image links are broken! Let me try to fix that...Anonymous
December 12, 2007
John is posting some of the powertoys that have been in development, please see here: Table Sum PowertoyAnonymous
December 12, 2007
John is posting some of the powertoys that have been in development, please see here: Table Sum PowertoyAnonymous
December 13, 2007
Daniel Escapa is filling the pages of his blog with an amazing array of OneNote information , links toAnonymous
January 13, 2008
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
Anonymous
January 14, 2008
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! JohnAnonymous
January 24, 2008
One of the more easy to explain testing techniques we use at Microsoft to ensure our software meets theAnonymous
January 24, 2008
One of the more easy to explain testing techniques we use at Microsoft to ensure our software meets theAnonymous
February 13, 2008
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.Anonymous
February 13, 2008
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. JohnAnonymous
February 18, 2008
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?Anonymous
February 18, 2008
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. JohnAnonymous
March 15, 2008
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.Anonymous
March 17, 2008
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, JohnAnonymous
March 19, 2008
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!Anonymous
March 19, 2008
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.Anonymous
March 19, 2008
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. JohnAnonymous
September 22, 2008
Of the many different types of bugs testers find in products, "asserts" seem to be the most obvious.Anonymous
March 10, 2009
I've installed this, but I don't see a "Sum" button. What toolbar is it in or where do I right-click for it? This is with XP-sp3. If it matters, I've found that for most of the PowerToys I've added, I've had to install, then install again (repair option) before the extra buttons will come up. That hasn't helped this time. Thanks! KevinAnonymous
March 10, 2009
Never mind, I suppose. When I installed the SortPages PowerToy, the Sum button appeared. I don't know what the install of the next toy did, but it "cleared" the problem. Anyway, cool toy. I've just recently upgraded from ON 2003, and the "new tables" alone make the upgrade worth it, and this summing toy just makes them that much better. Thanks, KevinAnonymous
March 10, 2009
Glad it worked out. I just rebuilt it and it looks like it should have worked. I will be updating this page later today to put the images back. JohnAnonymous
July 09, 2009
The comment has been removedAnonymous
July 09, 2009
I don't think the auto update is something I could add. Events (like typing) are not exposed in the API, so my addin would never know you modified the contents of the cells... Maybe someone more creative than I could get something working?Anonymous
March 30, 2010
Hi John, I have OneNote 2010 beta and installed table sum powertoy. The "Sum" button appears in the Add Ons tab but doesnt appear to work. Can you help ?Anonymous
March 30, 2010
It will only work with 2007 format notebooks. All the 2007 addins will need to be updated to use the new namespace once Office 2010 is released.Anonymous
August 02, 2010
Is there any possibility you could update this for 64-bit OneNote 2010?Anonymous
August 09, 2010
I can try, but this will take some time. My copy of the source files is messed up on my end...Anonymous
June 05, 2011
Hi John, i am very new to OneNote. Can we use the table data and create charts in oneNote? it would be great if we have such features. thanks JishaAnonymous
June 05, 2011
No, there is no way to do this within OneNote. You could export the table to excel and create a chart there, then conceivably add that chart back to OneNote as an addin. Feel free to take this code and modify it to do that!Anonymous
September 05, 2011
Has the sum add in been updated for OneNote 2010?Anonymous
September 06, 2011
Not yet - let me know if you need it updated and I can try to do that for you.Anonymous
September 10, 2011
I am looking for this functionality as well. Would be nice to have an updated version for OneNote 2010!Anonymous
September 18, 2011
Arne and Dan: done! Get it here: blogs.msdn.com/.../table-sum-toy-updated-for-onenote-2010.aspxAnonymous
October 17, 2011
Thank you very much! Works perfectly for me :)Anonymous
March 28, 2014
Unfortunately doesn't work correctly on Italian version when float numbers are involved. The tool simply ignores any punctuation in any flavour. E.g.: 15.6 and 15,6 are both interpreted as 156