Updated the app icon and sidebar icons for the new Big Sur style.
Updated for Big Sur (macOS 11) compatibility, but still supports back to High Sierra (macOS 10.13).
SheetPlanner is now a universal app for Intel and Apple M1 silicon.
The Outline view can now be used free of charge, including all outlining features, and saving documents.
When in free outliner mode, the toolbar and menus are simplified to omit paid features, including the Sidebar, Timeline, Month, and Year views, smart filters, and multiple tabs.
In free mode, if opening a document that contains multiple sheets, they appear as multiple unclosable tabs.
The purchase bar at the top of the window now only appears during a trial of the paid features.
When first running SheetPlanner, a window will appear with a slideshow introducing the features of the app. This can be re-displayed later via the Help ▸ Welcome to SheetPlanner menu command.
When updating to a new build of the app, a window will appear with "What's New in SheetPlanner". This can be re-displayed later via the Help ▸ What's New in SheetPlanner menu command.
When the app hasn't been purchased, a window will be displayed with options to use the free outliner, start a trial, unlock the full features, restore a purchase, or learn more.
Even if the trial has been completed in version 1, it will be available to try again in version 2.
After the unlock page, a newsletter signup page will be displayed. This can be re-displayed via Help ▸ Sign Up for the SheetPlanner Newsletter.
Help & Tutorials window
Added a new Help & Tutorials window.
This is displayed via the Help ▸ SheetPlanner Help menu command.
Includes a sidebar that lists the help topics and video tutorials.
Clicking a help section displays the help for that topic.
Clicking a video displays the corresponding video tutorial.
Multiple sheets in a document
Added a sidebar to the left of the Outline view in the document window, including built-in and custom folders and sheets.
A document can now include multiple sheets, each with their own columns, rows, styles, filters, etc.
Built-in folders include all sheets, recently accessed sheets, favorite sheets, and deleted sheets.
Each tab or window of a document can have a different sheet selected, and each with their own shown views and selections.
Added items to the Add toolbar menu to add new folders and sheets.
Added a new Sheet menu to the menubar, with commands to add new folders and sheets, duplicate, rename, delete, and navigate between sheets.
Can click on a selected folder or sheet to rename it.
Can click the star icon on a selected sheet to mark it as a favorite.
Folders and sheets can be dragged to rearrange them.
The view state is stored for each sheet of each tab of each computer.
The selected sheet name is displayed in the window/tab title.
This is only available in the trial and purchased modes.
Document changes for multiple sheets and future sync features
Major changes to the document format to support the big new feature of multiple sheets in a document.
Support for organizing sheets into nestable folders.
Support for multiple people and/or Macs editing a document via cloud syncing (coming in a future version), each with their own tabs, sheet and cell selection, etc.
Numerous changes to improve the performance of document access.
Plus other changes for the latest version of Swift.
🚧 NOTE: the document format has changed, so documents opened by this version onwards can't be opened in version 1.2 and earlier.
Added a File ▸ Save as Template… command to save the current document as a custom template, that you can use as a basis when making new documents.
Custom templates are listed in a new "My Templates" section of the Template Chooser (which is only included if some have been saved).
Right-click on a custom template in the chooser for menu commands to rename or delete it.
Improved the Template Chooser to work better from the keyboard: you can now just arrow around to select a template, then press the Return key to open it.
Updated the appearance of the Template Chooser window.
Added support for importing documents from Caboodle, maintaining the hierarchy and content of the entries.
Custom fields are added as columns, and entry text are added as notes.
Supports both version 1 (from Dejal) and version 2 (from Before Dawn) of Caboodle.
If any encrypted entries are encountered, you will be asked for a password, or can skip them, or stop the import.
If the same password is used for multiple entries, you only need to enter it once; it'll only ask again for unique passwords.
Changed the style scope popup menu to rename "All at This Level" to "Level n Rows", where "n" is the selected row number.
Removed the Parent/Child option, since that caused confusion.
When the scope is changed to "Level n Rows", the level style is applied to the selected row.
Existing documents are updated accordingly.
If only one cell is selected when pasting text with multiple lines and/or columns, it will now overwrite (and select) adjacent rows and/or columns.
If more columns than are available are needed, new ones are added at the end.
If more rows than are available within the parent of the selected cell, more are added at the end of that parent.
If the selected cell is the last within its parent, added rows can reflect the hierarchy of the pasted text. The hierarchy is ignored if overwriting adjacent cells, to avoid changing existing hierarchy.
If multiple cells are selected, pasting only populates those cells, as before.
Copying and pasting now uses the displayed column order; previously the order could be different if columns have been moved.
Choosing the Print… command now transforms the window into a print preview.
When in the print preview, a Print… button in the Inspector and the Print… menu command displays the standard print sheet to actually print.
When in the print preview, a Done button in the Inspector and a File ▸ Done Printing menu command enable exiting the print preview.
The print preview always uses the light appearance, even when the Mac is using the dark appearance, to match the paper. Defaults to Plain theme, but that can be changed.
The Outline and/or Timeline views are displayed so that all of their columns are visible. The Month and Year views can not be printed yet (coming in a later version).
Outline and Timeline views are fully editable in print preview mode. Cells can be edited, rows can be collapsed or expanded, filters and focus can be used, etc.
The preview can be zoomed in or out via a pinch gesture on a trackpad.
The Inspector includes a Print pane with pop-up menus to choose the printer and paper size.
The Print Inspector also includes graphical representations of the page to toggle between portrait and landscape, plus top, bottom, left, and right margins.
The Inspector includes checkboxes to include the row numbers and/or column headings when printing.
The views can be scaled via a slider or percentage field in the Inspector, so they fit a desired number of pages, with a Fit button to fit their width to one page.
Page breaks are indicated with dotted lines; they are aligned to the gaps between cells.
The Preferences window has been split into two pages, with the usual page-switching toolbar buttons.
The General page includes behavior options like whether to use a template, the Return and Tab key options, etc.
The Appearance page includes cosmetic options to apply as defaults in new sheets, like the theme and font, plus new options for the completion and topic style, finish date options, timeline options, and calendar options.
The default text color now uses an enhanced color well, with the pop-up swatches.
Tweaks and fixes
The focus path and dismiss button are now displayed in the Topic column header instead of a separate bar.
Changed the Show Completed Rows option to support three options: Show Completed, Show Completed Today, and Hide Completed. The new today option leaves just completed rows visible until the following day, so recently completed rows can be referred to if needed.
Added a pop-up menu to the Import open panel to choose the destination of the import: a new document, or a new sheet on the topmost open document.
If holding Option when clicking a view in the toolbar, that view replaces the current view(s) instead of adding another one.
Can now sort (via the Organize ▸ Sort Once submenu) by the Added Date to get back to the order rows were added, or by the Changed Date to see the recently edited rows.
Changed the Filter menu to have the filters at the end, instead of the start, to match the Sheet menu (and other apps).
Disabled the limit of making the Topic column narrower than the total custom columns, so blank space can be left to the right of the last column if desired (I can easily re-enable it if we want to go back to the old behavior).
Re-sampled each of the color palette colors to match those in Apple Numbers.
Changing between light and dark modes now refreshes the Inspector, so it shows the correct color.
The label for links now uses a color with more contrast. Also increased the text length before truncation, and fixed a layout issue with multiple long links.
When showing or hiding the filter bar, other tabs are now updated to match that state.
When hiding the note or links, now exits editing mode.
The tooltip for the Connect toolbar button changes between Connect Dependency and Disconnect Dependency as appropriate.
Fixed updating the dates when loading the Expense Tracker template.
Replaced the icon for the Completed options in the toolbar with a tri-state one.
Fixed parent rows with some completed children not appearing when showing Completed Today.
Fixed changing the completed options displaying rows as collapsed when they shouldn't be.
Fixed updating the Timeline and calendar views when changing the focus.
Clicking a cell next to a link now selects the cell.
Fixed showing notes and links in a new tab.
Adjusted the dark variation of the Yellow Notepad theme.
Fixed row menu items with submenus not applying their items to the clicked row.
When opening a new document or sheet from a template, the Added and Changed dates are set to the current date and time, with a 1-second offset for each row, so sorting by Added Date will restore the templated order.
If the dates for the Timeline are more than ten years ago, only those dates are displayed, rather than including today in the range.
Added support for a minimum Timeline scale of years.
The Timeline tooltip now only includes dates that have their "show in timeline" Column Inspector option checked.
Fixed the undo for a Clear Value command saying Undo Delete instead of Undo Clear Cell.
No longer beeps when reaching the beginning or end while arrowing between cells.
Changed the name picker (e.g. for saving a smart filter) to include buttons to cancel and save the change, as alternatives to pressing the Escape or Return keys.
Changed the date picker to not automatically dismiss when clicking on a part that doesn't change the date (e.g. the month name, or dates in previous or next months).
When multiple rows are selected, the Edit ▸ Duplicate Row menu command becomes Duplicate Selected Rows, and similar for the row menu.
If the preference for new documents is set to a fixed template, but one hasn't been explicitly chosen, now defaults to Blank (which is the first in the menu anyway).
Adding rows, indenting, and outdenting are now disabled when using a filter, since they don't make sense in that context.
Fixed the filter criterion value popup not always appearing for Symbol columns.
Improved filter criteria on Symbol columns to work properly with unchecked symbols.
The Show Note in New Tab menu command is now always visible in the row menu. (It appears in the View menu when you hold the Shift key.)
Fixed a template opening in a new tab of an existing document.
Fixed a crash when dragging a row into its own children; that shouldn't be and no longer is allowed.
When editing a date cell via the date picker, other cells are now immediately updated. (Editing by typing in the cell updates when leaving the cell, to avoid unnecessary updates for incomplete dates.)
Fixed using the date picker in the Inspector vs the Timeline or calendar info popover.
Now shows the Show/Hide Completed toolbar button menu when clicking instead of clicking and releasing, for quicker access.
The Connect toolbar button now shows the connected/disconnected state in its icon (with an arrow when connected, none when not). It also shows it immediately on click, rather than after completion the operation, to appear more responsive.
Fixed a crash on High Sierra and Mojave when accessing the Window menu.
Reimplemented the Shift-selection behavior to create rectangular selections, anchored from the initial click point (so can be reshaped with each Shift-click or Shift-arrow), in the same way as Numbers etc.
Updated the row selection functions (clicking the row number to select the row, the Select row commands, etc) to select the whole row and support rectangular selection adjustments.
Fixed undoing the Timeline Shade Weekends option in the Inspector.
Fixed undoing dragging the Timeline bars.
Improved linking to a website when the URL has spaces around it, by trimming off those spaces.
When dragging files to a document to link to them, now only highlights the row under the drag.
Fixed an issue where dragging parents and children could lose their hierarchy.
When copying selected cells, the text lines for child rows are now prepended with spaces to preserve the hierarchy.
When pasting text with a single cell selected, or while editing, when adding rows it now looks for space prefixes to preserve the hierarchy.
Fixed the Show All Notes and Show All Links not toggling to their Hide variations.
Fixed inability to change the Style Inspector from All at This Level to Parent/Children at Level.
Fixed the text color defaulting to black on dark mode for some new users.
The Preferences window now updates the text color when changing between light and dark modes.
Added a new Picture column type, that can include pictures within the document.
Pictures can be dragged or pasted, shown as thumbnails, and have a larger Quick Look view.
Can now optionally choose multiple items in List cells.
Each cell can now have its own style, including font, face, size, text style, justification, and color.
Replaced the Style Inspector font button with separate pop-up menus, and added an alignment control.
Can now add a notification for Date cells, a specified interval before the date.
The Timeline view now supports an editable info popover when double-clicking on a bar.
Added a Date Stamp function.
Plus numerous other improvements; see the website for details.
Changing a Date column color, or toggling the show checkboxes, is now immediately reflected in the Timeline view.
Fixed the Outline Columns submenu showing incorrect column names after adding or removing columns.
The Progress column is now shown in the Project Plan template.
If you open a template then close it without making any changes, it now doesn't ask if you want to keep it.
Added the ability to connect rows to establish a dependency.
Dependencies are displayed via arrows in the Timeline, and new optional columns in the Outline.
A red vertical line now marks the current date & time in the Timeline.
Any Date column can now be included in the Timeline.
New Symbol column type, including checkbox, flag, star, color icons, bullet journaling, Eisenhower quadrants, 5 stars, etc.
New Progress column type, displayed as a progress bar, mini pie chart, or percentage.
Auto-enter cell values with a default value, from the row above, today, formatted serial number, and more.
Outline view menu improvements.
Filter improvements, including better search for dates, time intervals, note text, and more.
Printing the Timeline is now supported, and printing the Outline is improved.
Plus numerous other improvements; see the website for details.
Fixed a layout issue with the calendar views when always showing scrollbars is enabled in the System Preferences.
Fixed issues with editing Number column values in some Euro countries.
Fixed a crash that could occur when changing Preferences after closing a document.
Fixed an issue where a document could not be opened.