Skip to content

Fix Table Formulas (Breaking Change)

Compare
Choose a tag to compare
@stevencohn stevencohn released this 22 Sep 14:50
· 88 commits to main since this release
9bdcfb4

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