TreeSheets Release Candidate 2011-04-04

[Wouter]

This is a release candidate, meaning a build that I make available on this group only (it is not on the main page yet) for hardcore users to try out.

It is likely to contain more bugs than the eventual release. Feedback on bugs and usability of the new features welcome!

Get it from: http://treesheets.com/Treesheets_Setup_RC1.exe

Sorry, Windows only, Linux & Mac will follow once the full Windows release is out.

From the history:

- folding of grids: Edit -> Toggle Fold (F10) on cell(s) hides the grids they contain.
  Folded cells will be marked with a '+' symbol in front of them
  If you zoom into them, you will see the full grid, without having to fold/unfold.
  A nice alternative to shrinking text if your sheet gets too big.
- an image drop down menu provides a convenient set of images you can quickly add to selected cells
- there's now a strikethrough style (useful for todo/task lists!) using the CTRL+t shortcut (previously transpose)
- added alternative (black & white) toolbar icon set (see options menu)
- "Sort" now sorts on subsequent columns if data in the current column is equal
- "Sort" can now be either ascending or descending
- outputs statistics on file when loading
- added commands to reset text sizes, styles, colors and column widths within the current selection (see Edit menu)
- making a lot of edits to a single cell will now set multiple undo points rather than just a single one
- added shift+del, shift+insert and ctrl+insert as alternatives for ctrl+x, ctrl+v, ctrl+c
- double clicking grid boundaries now selects that entire grid, not the parent cell
- option: render document centered or not
- option: minimize on close
- option: single click maximize from tray
- images in front of text rendered centered
- improved toolbar dropdown rendering & size
- images don't resize anymore when changing the text size of a cell,
  instead there's now a function to change the size of an image (Edit -> Images -> Scale)
- cells shrunks to tiny size don't show images
- documents always show a small gutter, regardless of size
- fixed filtering making everything tiny if cell text of grid was filtered, now doesn't minimize cells with grids, just greys them out
- fixed text selection not showing correctly with image in front
- fixed failing autosave popping up endless dialog boxes
- fixed undo causing file to be marked as not modified
- fixed horizontal layout being reset by some operations
- fixed line style rendering sometimes having wrong background color
- fixed style settings on "Wrap in new parent"
- fixed statusbar items not showing fully on some systems

[JennyB]

I really like the new icons.

Big thumbs up for folding but... if you fold a cell, zoom in to a cell in the grid and then F6 to a matching cell outside the folded cell, the cursor appears on the folded cell, not the target.

[Bill]

Brilliant! Wouter, I'm back in the fold (folding, I should say -
ahahaha); what a great addition! This makes TreeSheets into a leading
multidimensional concept - and see? It works, doesn't it, even though
you thought it wasn't a great idea?! Ha! Splendid fellow, I shall go
and announce the news on Outlinersoftware.com immediately...

Cheers,
Bill

[Wouter van Oortmerssen]

Good catch! Fixed for the release.

Wouter

[Wouter van Oortmerssen]

Glad to hear!

I think shrinking is superior to folding, but I get so many requests
for folding that I gave in. You have to account for people having
different workflows, or at least being used to it from other apps :)

I wouldn't announce it yet, since this is an RC, not the final
release. That should follow in a few days once bug reports dry up.

Wouter

> --
> You received this message because you are subscribed to the Google Groups "TreeSheets" group.
> To post to this group, send email to trees...@googlegroups.com.
> To unsubscribe from this group, send email to treesheets+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/treesheets?hl=en.
>
>

[David Lynch]

Wouter, congrats on the bullet collapse and expand option, another big user interface improvement!

[David Lynch]

Wouter,

A small inconvenience, after PASTING a collapsed bullet or bullets, the PASTED bullets default back to expanded view.

David

[David Lynch]

Heh, it could rightly be a big problem, the more nested bullets you have! :)

[Wouter van Oortmerssen]

That is actually by design, my thinking is, that if a set of data ends
up at a new location, you folding requirements are probably different.
But I can see arguments for the reverse.

Wouter

[JennyB]

On Tuesday, April 5, 2011 3:49:27 PM UTC+1, Wouter wrote:

Glad to hear!

I think shrinking is superior to folding, but I get so many requests
for folding that I gave in. You have to account for people having
different workflows, or at least being used to it from other apps :)

With folding it's hard to get a good solution without carrying around a lot of state. Possibly your simple toggling is as good a way as any. I particularly like that its possible to fold/unfold a whole range of cells at once.   But that also makes me think that, when you select (click on) a particular zoomed-out cell, you should be able to zoom fully in on it in one move.

[Wouter van Oortmerssen]

> With folding it's hard to get a good solution without carrying around a lot
> of state. Possibly your simple toggling is as good a way as any. I
> particularly like that its possible to fold/unfold a whole range of cells at
> once.   But that also makes me think that, when you select (click on) a
> particular zoomed-out cell, you should be able to zoom fully in on it in one
> move.

Is rolling the mousewheel not quick enough? And what form would that
take, a key assigned to "zoom to selected cell" ?

Wouter

[JennyB]

No key, just skip the intermediate zoom levels when the zoom immediately follows a cell selection. Worth a test? 

[Wouter van Oortmerssen]

>> Is rolling the mousewheel not quick enough? And what form would that
>> take, a key assigned to "zoom to selected cell" ?
>
> No key, just skip the intermediate zoom levels when the zoom immediately
> follows a cell selection. Worth a test?

That is problematic, since it is so much quicker to just randomly
click anywhere inside a big hierarchy to start zooming into it than
exactly at the cell level you want to arrive at. With your change that
would often zoom you in way too far. It would have to be a separate
key for that reason.

Wouter

[albertde]

Even though I am principally a Linux user, tried the windows release
candidate on a 64bit Linux set-up using a 32bit wine. The only problem
I saw was a conflict with the f10 key, which in that Ubuntu derivative
(pinguy) is reserved for the menu. So, would prefer that you designate
an alternate key or allow the user the possibility of customizing that
aspect of TreeSheets.

On another note, if you would allow hyperlinks to URLs and file://
that would help me as I could use TreeSheets to launch externally
linked data.

In het algemeen, vind ik uw programma voortreffelijk. Het heeft mijn
leven vereenvoudigd.

Albert.

[Wouter]

So here is RC2, quite a few small improvements based on your feedback, but one bigger feature crept in: Redo! It is unlimited, but does not restore the selection you had when you made the undo it is redoing, sorry. Should be really useful regardless.

Since Undo/Redo is notoriously error prone, please try this feature out! If there's no further bugs, this RC2 will become the release soon.

http://treesheets.com/Treesheets_Setup_RC2.exe

- folding of grids: Edit -> Toggle Fold (F10) on cell(s) hides the grids they contain.
  Folded cells will be marked with a '+' symbol in front of them
  If you zoom into them, you will see the full grid, without having to fold/unfold.
  A nice alternative to shrinking text if your sheet gets too big.

- Redo (CTRL+y) now works. Doesn't keep selection, sorry.

- an image drop down menu provides a convenient set of images you can quickly add to selected cells
- there's now a strikethrough style (useful for todo/task lists!) using the CTRL+t shortcut (previously transpose)
- added alternative (black & white) toolbar icon set (see options menu)
- "Sort" now sorts on subsequent columns if data in the current column is equal
- "Sort" can now be either ascending or descending
- outputs statistics on file when loading
- added commands to reset text sizes, styles, colors and column widths within the current selection (see Edit menu)
- making a lot of edits to a single cell will now set multiple undo points rather than just a single one
- added shift+del, shift+insert and ctrl+insert as alternatives for ctrl+x, ctrl+v, ctrl+c
- double clicking grid boundaries now selects that entire grid, not the parent cell
- option: render document centered or not
- option: minimize on close
- option: single click maximize from tray
- images in front of text rendered centered
- improved toolbar dropdown rendering & size
- images don't resize anymore when changing the text size of a cell,
  instead there's now a function to change the size of an image (Edit -> Images -> Scale)
- cells shrunks to tiny size don't show images
- documents always show a small gutter, regardless of size

- CTRL+f now selects any previous text in the search box, CTRL+a selects all, and HOME/END work too
- made the interactive tutorial the default help (F1), both it and the old html tutorial available from the menu
- selects the parent if you cut or delete all children & doesn't allow deleting of all children of the root of the current view

- fixed filtering making everything tiny if cell text of grid was filtered, now doesn't minimize cells with grids, just greys them out
- fixed text selection not showing correctly with image in front
- fixed failing autosave popping up endless dialog boxes
- fixed undo causing file to be marked as not modified
- fixed horizontal layout being reset by some operations
- fixed line style rendering sometimes having wrong background color
- fixed style settings on "Wrap in new parent"
- fixed statusbar items not showing fully on some systems

- fixed bug with badly formatted indented text not being pasted/imported properly

[Wouter]

On Saturday, April 9, 2011 9:28:55 AM UTC-5, albertde wrote:

Even though I am principally a Linux user, tried the windows release
candidate on a 64bit Linux set-up using a 32bit wine. The only problem
I saw was a conflict with the f10 key, which in that Ubuntu derivative
(pinguy) is reserved for the menu. So, would prefer that you designate
an alternate key or allow the user the possibility of customizing that
aspect of TreeSheets.

It's possible to stop ubuntu from doing that: http://www.h4ck3r.net/2010/04/07/debugging-step-over-f10-eclipse-ubuntu/
Keyboard configuration is a possible future treesheets feature, too.
 

On another note, if you would allow hyperlinks to URLs and file://
that would help me as I could use TreeSheets to launch externally
linked data.

That is already possible, see Edit -> Browsing...
 

In het algemeen, vind ik uw programma voortreffelijk. Het heeft mijn
leven vereenvoudigd.

Dat is goed om te horen!

Wouter
 

[albertde]

Thanks for the tip re f10. It worked.

I really like the revisions. I will "play" further with TreeSheets but
so far, I haven't noticed any problems

And i should have noticed the Edit browsing and files. [I do a lot of
mind mapping and sometimes "hang" external websites and files on the
maps. It is a way to link items that are stored separately. Thanks to
alt-6, I have been able to mindmap compactly.]

On another note, I guess you will revise the tutorial to reflect the
changed role of ctl-t from transpose to strike-through.

Albert