Table Sum Powertoy for OneNote

Untitled 1

Untitled 1 — Tue, 11 Dec 2007 06:23:44 GMT

PingBack from http://www.absolutely-people-search.info/?p=5515

re: Table Sum Powertoy for OneNote

JohnGuin — Tue, 11 Dec 2007 18:00:15 GMT

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

John's new powertoys!

Daniel Escapa's OneNote Blog — Thu, 13 Dec 2007 06:24:20 GMT

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

John's new powertoys!

Noticias externas — Thu, 13 Dec 2007 06:28:34 GMT

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

A Plethora Of OneNote 2007 Goodness

Pocket.Info - Mobile 2.0 — Thu, 13 Dec 2007 16:41:27 GMT

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

re: Table Sum Powertoy for OneNote

Kathy — Mon, 14 Jan 2008 08:29:26 GMT

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)

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

re: Table Sum Powertoy for OneNote

JohnGuin — Tue, 15 Jan 2008 08:24:29 GMT

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

Using OneNote's customers as a basis for designing tests

OneNote Testing — Fri, 25 Jan 2008 00:15:08 GMT

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

Using OneNote's customers as a basis for designing tests

Noticias externas — Fri, 25 Jan 2008 00:32:39 GMT

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

re: Table Sum Powertoy for OneNote

Dave J. (Scoop0901) — Thu, 14 Feb 2008 01:26:17 GMT

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.

re: Table Sum Powertoy for OneNote

JohnGuin — Thu, 14 Feb 2008 01:33:06 GMT

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

re: Table Sum Powertoy for OneNote

KevinAndrew — Tue, 19 Feb 2008 04:49:47 GMT

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?

re: Table Sum Powertoy for OneNote

JohnGuin — Tue, 19 Feb 2008 06:50:41 GMT

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

re: Table Sum Powertoy for OneNote

Brent — Sun, 16 Mar 2008 12:09:00 GMT

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.

re: Table Sum Powertoy for OneNote

JohnGuin — Mon, 17 Mar 2008 15:37:56 GMT

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

re: Table Sum Powertoy for OneNote

Brent — Wed, 19 Mar 2008 15:39:29 GMT

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!

re: Table Sum Powertoy for OneNote

Brent — Wed, 19 Mar 2008 15:46:02 GMT

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.

re: Table Sum Powertoy for OneNote

JohnGuin — Wed, 19 Mar 2008 17:50:31 GMT

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

Using asserts to help find bugs in OneNote

OneNote Testing — Mon, 22 Sep 2008 18:10:05 GMT

Of the many different types of bugs testers find in products, "asserts" seem to be the most obvious.

re: Table Sum Powertoy for OneNote

Kevin — Wed, 11 Mar 2009 00:38:28 GMT

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!

Kevin

re: Table Sum Powertoy for OneNote

Kevin — Wed, 11 Mar 2009 00:57:01 GMT

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,

Kevin

re: Table Sum Powertoy for OneNote

John — Wed, 11 Mar 2009 01:21:28 GMT

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.

John

re: Table Sum Powertoy for OneNote

ibam — Thu, 09 Jul 2009 17:18:33 GMT

this tool is amazing... atleast i know how to use sum function in one note.

But john, could you make further improvement by make this add-in as realtime function just like sum function in excel.

because i really need one software that can handle anything in my head :P

i've tried onenote 2010 (technical preview) but still i can't find this sum function

thanks a lot

ibam

re: Table Sum Powertoy for OneNote

JohnGuin — Thu, 09 Jul 2009 17:50:33 GMT

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?