Fix Table Formulas (Breaking Change)

What's Changed

The previous release broke simple subtraction in table formulas when using cell references, such as A1-A2. This release fixes that but also introduces new breaking changes that should provide better functionality. See #1551

Table Formula Change Details
Relative cell references are replaced by a new function, cell(), and two variables, tablerows and tablecols. While the release will break the relative cell reference feature, the new functions will be much more powerful, allowing both column offset and row offset, as well as forward looking relative references. The full syntax of the cell function will be:

cell(colOffset, rowOffset)

Offsets are always relative to the current cell, i.e., 0,0 refers to the current cell. Both positive and negative offsets are allowed.

Examples
To add a reverse-looking summary cell to the bottom of a table, something like sum(A1:cell(0,-1)) will total all cells in the column from the first row (A1), down to the row just prior to the formula cell.

To add a forward-looking summary cell to the top of a table in cell A1, something like sum(A2:cell(0, tablerows-1)) will total all cells in the column from the second row (A2), down to the cell in the last row of the table; note that rowOffset parameter still needs to be expressed as an offset from the current cell, hence tablerows-1.

Internal Updates

• N/A

Known Issues and Proposed Updates

• 🐜Reduced an issue where Command/Quick Palette dialogs would cause the OneNote window to flicker; this changes the opening behavior of the Palette dialogs, hiding the command list until you start typing, #1422. However, the flicker still randomly occurs.
• 🐜 SearchAndReplace doesn't replace the currently highlighted or selected word/phrase; sometimes it doesn't replace other candidates either
• 🐜Replaying a command using Ctrl+Shift+R is done in a single thread, breaking progress.RunModeless; see CreatePagesCommand
• 🐜Simple substraction formula (A1-B2) will fail unless there are spaces around the minus (A1 - B2), #1551
• 🐜Select Similar Styles will find differences in colors Auto vs #000000 - make it more fuzzy?
• 🐜PasteText should convert CRLF to hard-breaks, currently creates soft-breaks
• 💡Command to convert friendly URLs to raw URLs; References menu
• 💡Paginate Hashtag search results
• 💡Move Navigator to DB, paginate history panel, provide import/export
• 💡Move Reminders to DB, option in dialog and on-page link to delete completed reminders
• 💡Github PR action to pull ticket# prefix from branch name, e.g. 1234-do-something-cool

Full Changelog: 6.5.1...6.5.2

Preview Release WITH CRITICAL BUG

Subtraction in Formulas is BROKEN

DO NOT INSTALL THIS VERSION IF YOUR NOTEBOOKS HAVE MANY TABLE FORMULAS

• 🐜Simple subtraction formulas are broken. See #1551. Workaround: Add spaces before and after the minus sign. For example, change A1-A2 to A1 - A2. This is the next top priority item and will be fixed as soon as possible.

What's Changed

• Added Japanese language translations thanks to @forestail's PR
• Added a Bash language definition for the Colorize command, #1516
• Added source page environment variables for Plugins to consume, #1519
• Added the ability to change the text color when applying strikethrough styling to completed To Do tag, #1528.
  • This introduces a Colors sheet to the Settings dialog, combing this setting with Horizontal Lines color
• Updated Plugin dialog to include a Trial Run option to prevent inadvertent updates, #1062
• Update the Find Hashtags dialog, adding options for case-sensitive searches and to hide results from offline notebooks, #1492, #1495
• Updated calculator to ignore empty cells for countif, #1504
• Updated the box commands to move active cursor inside the box, #1539
• Renamed formula dynamic cells to relative cells across the UI and Wiki, #1504
• Fixed an issue where Preview Markdown did not properly add line breaks, #1335
• Fixed an issue where the Favorites dialog doesn't grab input focus, #1489
• Fixed an issue where Insert Toc would cause the Outline container to grow too large, #1498
• Fixed an issue where running a Plugin scoped to "all notebooks" would fail, [#1499]*#1499)
• Fixed an issue where relative formula range was missing the last row, #1504
• Fixed an issue where OneNote performance was affected by bug in Hashtag catalog build, #1506
• Fixed an issue where OneNote would crash if rebuilding the Hashtag catalog, #1507
• Fixed an issue where Calendar Copy Page did not copy links for all pages on day, #1513
• Fixed an issue where the Plugin dialog did not persist page-scope sub-fields, #1518
• Fixed an issue where the Navigator would affect performance when load a page with many headings, #1533
• Fixed an issue where the Insert QR Code command would fail, #1534
• Fixed an issue where Convert Markdown would fail due to wrong assembly version, #1538
• Fixed an issue where Convert Markdown would not correctly convert HTML, #1540
• Fixed an issue where Archive would fail when including an untitle Quick Note, #1548

Internal Updates

• N/A

Known Issues and Proposed Updates

• 🐜Reduced an issue where Command/Quick Palette dialogs would cause the OneNote window to flicker; this changes the opening behavior of the Palette dialogs, hiding the command list until you start typing, #1422. However, the flicker still randomly occurs.
• 🐜 SearchAndReplace doesn't replace the currently highlighted or selected word/phrase; sometimes it doesn't replace other candidates either
• 🐜Replaying a command using Ctrl+Shift+R is done in a single thread, breaking progress.RunModeless; see CreatePagesCommand
• 🐜Simple substraction formula (A1-B2) will fail unless there are spaces around the minus (A1 - B2), #1551
• 🐜Select Similar Styles will find differences in colors Auto vs #000000 - make it more fuzzy?
• 🐜PasteText should convert CRLF to hard-breaks, currently creates soft-breaks
• 💡Command to convert friendly URLs to raw URLs; References menu
• 💡Paginate Hashtag search results
• 💡Move Navigator to DB, paginate history panel, provide import/export
• 💡Move Reminders to DB, option in dialog and on-page link to delete completed reminders
• 💡Github PR action to pull ticket# prefix from branch name, e.g. 1234-do-something-cool

Full Changelog: 6.5.0...6.5.1

Hashtag picker, relative table formulas, next/prev unread, and bug fixes

What's Changed

• Added a hashtag picker dialog, bound to Alt+T, #1435
• Added dynamic cell row reference in table formulas, #1462
• Added two Copy/Move Selected Content commands to copy or move selected content to a new page, #1465
• Added the Select All Ink command, #1472
• Added the Export-PageInfo.ps1 plugin (for download) and enhanced Plugins with additional scopes, #1448
• Added the Next/Prev Unread Page commands to find and navigate to the next/previous unread page, Search menu, #1487
• Added the Arrange Containers command to the context menu when right-clicking an Outline border
• Added ability to add hashtag quick commands to the OneMore ribbon bar group from Settings
• Enhanced Hashtag search results to present snippets in document-order, #1405
• Enhanced Embed Page command to pull in first page item if no Outline container, #1085
• Fixed an issue where the Archive cleanup step caused exceptions leading to OneMore crash, #1056
• Fixed an issue where reminders updated on remote machines are not hyperlinked, #1189
• Fixed an issue where Preview Markdown was not retaining proper indentations, #1410, #1438
• Fixed an issue where Preview Markdown added a line break at the text cursor, #1416
• Fixed an issue where Convert to Markdown would fail with multiple Outline containers on a page, #1414
• Fixed an issue where Convert to Markdown failed with code block, #1429
• Fixed an issue where Edit Styles failed when default properties were not discovered properly, #1420
• Fixed an issue where the OneNote window would flicker when opening Command Palette, #1422
• Fixed an issue where FIPS enabled machines fail when using MD5, switched to SHA1, #1426, #1428
• Fixed an issue where page numbering improperly converted roman numeral "i" to local "ı", #1437
• Fixed an issue where refresh ToC in a secondary container would corrupt the Toc, #1444
• Fixed an issue where Duplicate Page would fail if the source page title is hidden, #1445
• Fixed an issue where Manage Favorites would fail early when encountering a broken link, #1446
• Fixed an issue where hashtags were not discovered in newly shared notebooks, #1449
• Fixed typos on the Find Hashtags dialog and the OneMore Wiki website, #1458
• Fixed an issue where Increase/Decrease Font Size did not affect all containers on a page, #1478

Internal Updates

• Added a temporary Clean Reminders command to dispose of orphaned reminders. This is only available on the Command Palette for now.

Regarding Page Tag to Hashtag Upgrade

• Some people have reported an issue where the upgrade from Page Tags to Hashtags is stuck and doesn't complete. This can be caused when a corporate policy prevents OneMoreTray.exe from running. As a temporary work-around, the upgrade state can be reset from the Hashtag settings sheet. Open Settings, navigate to the Hashtags sheet, and click the Reset link. Note that the Reset link is only visible when the "Upgrade…" link is shown as disabled.

Full Changelog: 6.4.0...6.5.0

Quick Palette, Convert/Preview Markdown

What's Changed

• Added the Quick Palette, accessible from the menu or by pressing Ctrl+Comma for keyboard warriors, #1398
• Added the Convert to Markdown command to converted selected markdown text to formatted OneNote content, #1028
• Added the Preview Markdown command to show converted markdown in a separate window, #1341
• Added the key binding Ctrl+Shift+B to add the current page to the Navigator My Reading List, #1072
• Accepted some enhancements to the PHP language definition by @d-faure, PR #1407
• Moved the Duplicate Paragraph command from the Edit menu to the Page menu
• Moved the Select All Images command from the Edit menu to the Images menu
• Moved the Sort List command from the Edit menu to the Numbering menu
• Updated the Copy as Text command to avoid adding an extra newline at the end of text, #1392
• Updated the way My Styles are saved, allowing the user to reset to predefined themes, #1038
  • Predefined themes are stored in read-only files; when the user modifies one of these themes, it is copied to a custom directory to preserve the original and allow a reset.
• Fixed an issue where reminders would be deleted after their hyperlinks are broken by moving pages between sections. Note there is still no way to purge them but at least the information is retained.
• Fixed an issue where installer would warn about elevation for shutdown action; updating to this release may still show the warning

New Contributors

• @d-faure made their first contribution in #1407

Full Changelog: 6.3.1...6.4.0

Critical fixes to Timer, Navigator and other modeless windows

What's Changed

• Fixed a critical issue where modeless dialogs would block, #1388
• Fixed a critical issue where Navigation provider would fail writing to invalid path, #1309
• Fixed an issue were Copy as Text would insert an extra line before first paragraph, #1392
• Fixed an issue where image resize would fail for images without Size, #1390
• Fixed an issue where Insert Box would fail for cultures using non-invariant number formats, #1386
• Fixed an issue where the Analyze command would fail for sections without backups
• Fixed an issue where the Trusted Protocol install action failed to find the correct SID
• Fixed an issue where report reminders missed reminders on non-indexed pages

Full Changelog: 6.3.0...6.3.1

Critical fixes and some enhancements

What's Changed

This is mostly a patch to address a couple of critical issues. But there are also a couple of nifty new features and enhancements. As always, that you to everyone for your helpful feedback. Enjoy!

• Added an option in setting to hide the My Reading List panel in the Navigator window, #1331
• Added colorizing support for PHP (look for suggestions for enhancement), #1325
• Added a warning message when attempting to caption a background image, #1352
• Added context menu commands to move selected pages to the top or bottom of the section's page list
• Added option to exclude completed tasks from Reminder Summary Report, #1371
• Added ability to copy links of pages from the OneMore Calendar month view, #1045
• Updated the install to abort if running without elevated privileges
• Fixed an issue where Split Page would fail when a heading had no content before the next heading, #1379
• Fixed an issue where Fit Grid to Text would fail if given an invalid width, #1360
• Fixed an issue where Calendar could not find a required dependency DLL, #1361
• Fixed an issue where Table of Contents were not added due to invalid width, #1354
• Fixed an issue where Copy as Text did not work from the page title, #1359
• Fixed an issue where Insert Date snippet caused a null exception, #1344
• Fixed an issue where the keyboard was not redirected to the Favorites dialog, #1332
• Fixed an issue where Unicode characters were lost when import Word docs, #1321
• Fixed an issue where Copy as Markdown was only copying ANSI characters, #1305
• Fixed an issue where Box commands would fail when first line is selected in secondary outlines

Full Changelog: 6.2.1...6.3.0

Dark theme, Improved Hashtag scanning

Feature Updates

Note that this turned out to be a bigger release than expected. While we try to test thoroughly, if you observe any questionable behaviors, please open a support ticket here.

• Updated the way the Hashtag scanner works
  • When scanning previously unscanned notebooks, OneMore will suggest to schedule the scan off-hours, such as midnight
  • Deprecated Page Tags. You will be given the option to upgrade Page Tags to #hashtags. Note that Page Tags will be removed in a later release of OneMore
• Added the ability to select a theme for OneMore windows and dialogs, (Settings/General) #1285
• Added the ability to change the location of the OneMore group within the Home ribbon, (Settings/Ribbon Bar)
• Added an option to allow the Navigator window to move beyond the screen, (Settings) #1286
• Updated the Navigator with the ability to jump to the top of the current page
• Updated the Navigator to ignore Quick Notes by default since they do not have titles. (Settings/Navigator)
• Fixed an issue where hashtags on a duplicate page causes an exception, #1283
• Fixed an issue where Split Page fails when the first child of a heading is a list item, #1289
• Fixed an issue where a hashtag on a Quick Notes page causes OneMore to crash, #1296
• Fixed an issue where the resize constraint is not applied in the Resize and Adjust Image dialog, #1297
• Fixed an issue where the Formula command took the Floor of negative values, losing precision
• Fixed an issue where the Copy as Text command failed, #1290
• Fixed an issue where the add-in would crash when opening Manage Favorites, #1304
• Fixed an issue where Box commands did not preserve indents, #1306
• Fixed an issue where Index Selected Pages action from Hashtags dialog would crash, #1320
• Fixed an issue where new custom snippets would not appear on the ribbon menu, #1333
• Fixed an issue where Arrange Containers did not recognize a container with only an image and no text
• Fixed an issue where Copy as Text/Markdown did not copy to clipboard, #1356

Internal Updates

• Converted all async disposables from IDisposable to IAsyncDisposable
• Now using await using var rather than just using var

Full Changelog: 6.1.0...6.2.1

Dark theme, Improved Hashtag scanning

Feature Updates

Note that this turned out to be a bigger release than expected. While we try to test thoroughly, if you observe any questionable behaviors, please open a support ticket here.

• Updated the way the Hashtag scanner works
  • When scanning previously unscanned notebooks, OneMore will suggest to schedule the scan off-hours, such as midnight
  • Deprecated Page Tags. You will be given the option to upgrade Page Tags to #hashtags. Note that Page Tags will be removed in a later release of OneMore
• Added the ability to select a theme for OneMore windows and dialogs, (Settings/General) #1285
• Added the ability to change the location of the OneMore group within the Home ribbon, (Settings/Ribbon Bar)
• Added an option to allow the Navigator window to move beyond the screen, (Settings) #1286
• Updated the Navigator with the ability to jump to the top of the current page
• Updated the Navigator to ignore Quick Notes by default since they do not have titles. (Settings/Navigator)
• Fixed an issue where hashtags on a duplicate page causes an exception, #1283
• Fixed an issue where Split Page fails when the first child of a heading is a list item, #1289
• Fixed an issue where a hashtag on a Quick Notes page causes OneMore to crash, #1296
• Fixed an issue where the resize constraint is not applied in the Resize and Adjust Image dialog, #1297
• Fixed an issue where the Formula command took the Floor of negative values, losing precision
• Fixed an issue where the Copy as Text command failed, #1290
• Fixed an issue where the add-in would crash when opening Manage Favorites, #1304
• Fixed an issue where Box commands did not preserve indents, #1306
• Fixed an issue where Index Selected Pages action from Hashtags dialog would crash, #1320
• Fixed an issue where new custom snippets would not appear on the ribbon menu, #1333
• Fixed an issue where Arrange Containers did not recognize a container with only an image and no text

Internal Updates

• Converted all async disposables from IDisposable to IAsyncDisposable
• Now using await using var rather than just using var

Full Changelog: 6.1.0...6.2.0

#Hashtag Queries, Stylize Images

Feature Updates

• Added a pre-install verification step to confirm the configuration of OneNote Interop, #1153 and #1242
• Added the Stylize Images command including an Invert style, #1258
• Updated the Find Hahstag dialog to be more user friendly, intuitive and powerful, #1230
  • Use single hash hashtags such as #example, with some constraints, see the wiki
  • Enter multiple tags or substrings, combine with AND and OR and parentheses
  • Added option to highlight hashtags using a selected character style, #1236, #1241
  • Ignore regions of a page using the new #SkipHashtags and #KeepHashtags special keywords
  • Now ignores Hex color codes and C# and C++ pragmas by default, can include them in Settings
• Slowed down the hashtag scanner to mitigate making OneNote sluggish; there is a longer term solution in the works
• Updated the Export Markdown command to store images and attachments for each page in a separate subfolder, #1004
• Updated the Analyze Storage report to include number of pages per section and notebook, #1239, #1240
• Updated the Navigator window to refresh the current page view by pressing F5, #1249
• Updated the Info and Code box snippets to use the standard font for titles, #1250
• Updated the Arrange Containers command adding an option to indent all containers, #1269
• Updated the way Favorites are checked, now attempting to auto-correct pages with changed IDs
• Moved status snippet commands under a new Status submenu on the Snippets main menu
• Moved Insert Emoji command from Page menu to Snippets menu, renamed to Emoji, and added more emojis, #1238
• Fixed an issue where images were not selected correctly in Resize and Adjust or Select All Images, #1273
• Fixed an issue where Hashtag scanner could not load a page ID and return null, #1268
• Fixed an issue where Arrange Containers would fail on a new page with no containers, #1266
• Fixed an issue where headings were not numbered correctly, #1245
• Fixed an issue where the Favorites dialog did not constrain its size during a user-initiated resize, #1238
• Fixed an issue where the Find Hashtag dialog would display deleted pages, #1233
• Fixed an issue where the Find Hashtag dialog was not constrained to a single instance, #1228
• Fixed an issue where the Find Hashtag text entry field was not resizing correctly, #1227
• Fixed an issue where logging a nested exception caused an exception, yep. #1255
• Fixed an issue where the OneMore Calendar did not properly display pages on their creation date, #1259
• Fixed an issue where some commands could not be replayed using Alt+Shift+R

Internal Updates

• Redesigned the Images Resize and Adjust command introducing a new ImageEditor class that can be shared with other commands.

##Hashtags

This adds the new ##Hashtags feature. This new features scans your notebooks and catalogs all ##hashtags in the text.

Note an initial catalog is generated the first time you run OneNote with OneMore 6.0.1. Depending on the size of your notebooks and number of pages, this can take some time and may make OneNote appear slow. Once the catalog is built, responsiveness should go back to normal.

Feature Updates

• Added a new command Search Hashtags, #1120
  • This includes the ability to search and index ##hashtags embedded in content of your pages
• Added a new command Copy as Text, available on the OneMore Edit menu, #1143
  • Copies the selected content as plain Unicode text without images, colors, or other formatting
• Added a new command, Stack Background Images, #1214
  • Repositions background images vertically down the page with no overlap and minimal whitespace between them
• Added Rust to the list of languages that can be colorized by the Colorize command
• Added an Add Current Page option to the Favorites dialog, available from the three-dots menu
• Added an Sort By Name option to the Favorites dialog, available from the three-dots menu, #1157
• Replaced the Add Title Emoji command with Insert Emoji that always inserts at the current cursor, #1185
• Updated the Adjust and Resize Images command, #1214
  • Added an option to allow images to auto-size (shrink or grow) with their container
  • Optionally stack background images when adjusting multiple foreground images
• Updated the Table of Contents snippet, #1208
  • Optionally apply a style to the title line "Table of Contents"
  • Insert the Table of Contents anywhere on the page, not just at the top
  • Existing top links are removed from the page if the option is not selected in the dialog, #1163
• Updated the Colorize command to add diff colorization, #1170
  • Recognizes a plug + or minus - character in column 0 of the selected code and treats that as a diff line
• Updated the Set Page Color command to optionally color all pages in the section or notebook, #1196
• Updated the OneNote Storage Analysis command to apply heatmap colorization to quickly identify large files, #1206
• Updated the Custom Styles dialog to add a "Disable Spellcheck" option to each style, #1191
• Updated the Favorites dialog to jump to a page when the favorite is double-clicked, #1157
• Updated Colorizer settings to hide unused languages to make the Colorize menu shorter, #1186
• Updated Images settings to choose an alternative PlantUML render server, #1155
• Updated the OneMore Calendar options with the ability to select all/none notebooks, #1146
• Fixed an issue where the installer would fail due to not finding the Active Setup key in the system registry
• Fixed an issue where the install was missing the PlantUML and Registry language files
• Fixed an issue where applying a custom style a large amount of time, #1122
  • Should improve performance with any OneMore command on a page with hand-writing, commit 3e57425
• Fixed an issue where images were not imported in Word documents, #1217
• Fixed an issue where Outline Formatting would append an space after each heading, #1204
• Fixed an issue where the paragraph spacing of custom styles was ignore when applying style to a page, #1197
• Fixed an issue where the Command Palette inserted an extra space in highlighted commands, #1172
• Fixed an issue where Remove Empty Lines inadvertently removed formulas on the page, #1150
• Fixed an issue where PlantUML colorizer files were missing from the installation, #1147
• Fixed an issue where Link References to this Page removed the space before an applied hyperlink, #1126
• Fixed an issue where Link Reference to This Page - refresh did not update modified page titles, #1089
• Fixed an issue where footnotes were not renumbered correctly when adding new ones, #1118
• Fixed an issue where recommended Chinese translations from PR #1080 where not applied, #1174

Internal Updates

• Updated the build.ps1 -fast command to build all OneMore projects
• Fixed an issue in the update-sdk.ps1 script to make it work in both PowerShell 5 and 7+

Full Changelog: 5.9.0...6.0.1