Forum Posts Feed
Tree-Outliner with internal EXCEL full-edit ribbon viewer?
< Next Topic | Back to topic list | Previous Topic >
Posted by donleone
Jul 16, 2013 at 10:05 AM
Slartibartfarst wrote:
By the way, thankyou - I just took a look at that link that
>you gave: http://www.youtube.com/watch?v=YuTBdonbYZo
>It’s a superb OneNote overview.
Yes, indeed, the best I’ve seen as-well.
First, i must admit that i totally under-estimated MS OneNote 2013 power-user capabilities, so here is a quick summary of my new findings so far, in trying to find the “ideal” outliner with the best possible Excel ingretation:
THE GOOD
_____________________
1. You can get OneNote 2013 at the Microsoft Store for just $69.90 as a direct download (so no need to buy the full office or any “365” subscription package.) so price is definitely “okay”. See here:
http://www.microsoftstore.com/store/msusa/en_US/pdp/productID.259322100
2. You can thankfully DISABLE the always “hovering-note-box-container” over every selected item in the Options/Display/Show Note containers on pages (by checking that one off! - so it feels now like a “real” outliner editor, very calm. )
3. there is a hidden tree-navigation view which gets enabled only in FULL-SCREEN that is far more organized seeming than the regular view, see here (and plus you get the full screen blank for added focus & concentration. See here:
http://blogs.msdn.com/cfs-filesystemfile.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-00-63-17/8686.normal_2D00_dropdown.png
4. and of course the Excel Intregration with One-click-editing and auto-sync-changes-Preview is great, and working even with Excel 2007 perfectly integrated
5. Everything (Attachments, pictures, videos etc.) is stored inside in a single-database, and all changes are auto-synced after edited/saved.
6. There is literally no official microsoft limit set on a OneNote Database size (unlike e.g. Outlook PST files with have a 20GB limit), so a 100GB or greater database is totally possible (e.g. with many attachments, videos etc.) needing only some decent RAM (for previews) to keep it smooth.
7. The possibility to extend the program via ADD-INS is a huge (!) possibility (that sadly not many programmers have taken up yet), by which one can “custom expand” OneNote’s interface & functionality tremendously!
Therefore, after searching google like crazy for OneNote Addin Suppliers, here are some quick best found power-user OneNote Add-ins so far:
- this one adds a Calendar Module, Auto-filling Table fields (!), and an easy do-it-yourself drag-&-drop Macro-Editor), and the add-is is FREE
http://www.omeratay.com/onetastic/
- then to show just how far one could go in Add-in programming, here is a full-blown Database Add-in, with entry-forms, contact management etc. which but is way over-priced, but nevertheless. See here:
http://www.abletfactory.com/EMRSuite.html
- And here also a useful add-in for better batch-import & Export of large files/attachments (as the native import/export implementation is fairly limited, as Microsoft likes you to stay inside OneNote forever)
http://www.onenotegem.com/onenote-batch.html
THE BAD OF ONENOTE
_____________________
-There is no way to password protect & encryt the WHOLE OneNote, only “section by section” at least you can. So then i thought to put everything under just 1 Section, and pass-word protect, but that limits my tree-view navigation quite a bit (albeit you still can have 2 sub-levels for organization, by making them sub-pages)
- no custom icons possible in tree (but alternatively i am thinking to make 1 page a full-fleged “index” navigation page, and use all other sub-pages as linked to that, then you could outline your perfect navigation yourself, without even needing any tree-anymore, i know its not perfect, but just to show you how far i am considering to sacrifice for great excel data-sheet integration.
cant think of anything else, but thats about as best as OneNote gets.
Posted by donleone
Jul 16, 2013 at 10:30 AM
oh wow just discovered !!
With this “favorites-to-ribbon” add-in you can even have “stored searches” saved to the ribbon bar, as a kind of replacement for my missing “saved searches” feature of Ultra Recall…
http://www.onenotegem.com/uploads/8/5/1/8/8518752/5926742_orig.jpg
features are starting to come together slowly ;-)
greetings
Posted by donleone
Mar 30, 2014 at 09:41 PM
Found this most amazing Old Goodie, called “Info Rapid Card File System” !
which has the best Excel-in-place-editing ability of any Outliner i have seen so far
see example:
https://dl.dropboxusercontent.com/u/12285943/Screenshot_Excel_Inplace_Editing.jpg
Thus you amazingly get
- Hierarchical Spreadsheets !! (this is soo rare)
+
- integrated Document management (of whatever format you can preview PDF, Word, whatever) = all internally stored + indexed + full preview-able + change updated internally saved.
+
- an super-fast search engine with in-results preview, of even all attachment-indexed documents/excels too (!)
see here: http://www.inforapid.de/assets/images/cfscreen1.gif
+
- MULTIPLE WINDOWS workspace
greetings!
link:
http://www.inforapid.de/html/cfscreenshots.htm
Posted by donleone
Mar 30, 2014 at 11:13 PM
ADDITION:
this software also has a most amazing integration !!
YOZO OFFICE 2012 = the only true integrated office suite in a single application = but cleverly usable, a power-outliner capable!!
be smarter,
don’t think “custom fields” = think cells
don’t think “search folders” = think table filters (and one click trigger-buttons)
+
likewise MULTIPLE WINDOWS simultanous working, so amazing !
see screenshot:
https://dl.dropboxusercontent.com/u/12285943/Sreenshot_Yozo_Office_Integrated_Editing.JPG
official site:
http://www.yozooffice.com
and PS: here another power screenshot showing the same concept, but using again the just previous mentioned software - InfoRapid Cardfile System:
https://dl.dropboxusercontent.com/u/12285943/InfoRapid_CardFile_System_Excel-multi-windows2.jpg
greetings!
Posted by MadaboutDana
Mar 31, 2014 at 01:36 PM
Yozo Office reminds me of good ole’ StarOffice 5, which had a similar totally integrated interface. Alas, it died (or rather, was transformed into OpenOffice). I’ve also thought it was a shame nobody else picked up that paradigm - and now, clearly, they have!