JeffOffice

Changelog

What changed in each version of JeffOffice, newest first. Each version's files are on its downloads page.

JeffOffice 0.26.0

· Downloads

Charts, equations, comments in JeffPub, spilling formulas in JeffCrunch, and a ribbon and keyboard you can set up yourself.

Every app

  • Set up the ribbon: right-click it to hide, add, and reorder tabs and groups, or to add a command to the quick toolbar.
  • Quick toolbar: Save, Undo, and Redo in all four apps, and a Quick Toolbar page in Options to choose its buttons.
  • Shortcut keys: choose your own in Options, Customize the keyboard.
  • Remove personal information on save: a box on the Info page takes names, company, and other personal details out of the file you save. The open file is never changed.
  • Print: Printer Properties, paper choices, grayscale, last page first, and printing on both sides in reverse. JeffPub and JeffDeck gain selection, collate, and zoom.
  • Selection Pane for showing, hiding, and naming objects (JeffPub, JeffDeck, and JeffWrite), and Full Screen (JeffPub and JeffDeck).
  • One About page and one "Check spelling as you type" setting for all four apps.

JeffPub

  • Comments on objects and on places of a page, with replies, a Comments pane, and Resolve.
  • Insert Chart with a Chart tab, and Insert Equation.
  • Passwords for .jpub files and for templates.
  • Check Accessibility, now with contrast and reading order, and tagged PDFs with bookmarks.
  • Go To (Ctrl+G).

JeffDeck

  • Insert Chart, kept in .pptx files, and a Chart tab.
  • Go To a slide, section, comment, or object.
  • Check Accessibility, tagged PDFs with bookmarks, and PDF/A in Export to PDF.
  • Compress Pictures, Paste Special and Keep Text Only, Share by email, New Window, and Switch Windows.

JeffWrite

  • Tracking options: how changes are marked, the change bars, and moves.
  • Keys for styles and symbols.
  • Online Pictures and Compress Pictures, and the Selection Pane for floating objects.

JeffCrunch

  • Spilling formulas: a formula that gives several values fills the cells beside it, with A1# to refer to the whole block, #SPILL! when something is in the way, and LET. Kept in .xlsx, .xls, and .ods files.
  • Insert Equation over the cells, and a Symbol dialog.
  • Charts and drawing objects are kept in .ods files.
  • Compress Pictures, Online Pictures, and Text Art.

Linux

  • The .deb sets up updates: installing the downloaded .deb now adds the JeffOffice apt repository, so later versions come with your system updates. It leaves an existing setup alone, and sudo apt purge jeffoffice takes it away again. To leave it out, see the Linux install guide.
  • The snap is on the beta channel as well as edge: sudo snap install jeffoffice --beta.

Security

  • The snap's sound and video: JeffDeck in the snap now plays sound and video with JeffOffice's own minimal FFmpeg 7.1.5, the same build and short list of decoders as the other downloads, instead of the KDE platform's own libraries. The decoders left out for security in 0.25.1 can't be reached there either.

Also

  • Translations for the new and changed text.

JeffOffice 0.25.1

· Downloads

A security update for all four apps, with a few fixes.

Security updates

  • Qt 6.8.3 → 6.11.3, the toolkit the apps use for windows, text, pictures, and printing. It fixes:
  • CVE-2026-6210 (Qt SVG, rated 8.7 of 10): a crafted SVG picture could make an app read memory it shouldn't and crash.
  • CVE-2026-4775 (libtiff 4.7.0 → 4.7.2, in the TIFF picture reader, rated 7.8): a crafted TIFF picture could write past the end of a buffer.
  • CVE-2025-5683 (ICNS icon reader, rated 5.1): a crafted icon file could crash an app.
  • FFmpeg, JeffDeck's sound and video: JeffDeck used the full FFmpeg 7.1 that comes with Qt, which reads hundreds of formats. It now uses its own build of FFmpeg 7.1.5 with only what a presentation needs: 111 decoders and file readers, such as AAC, MP3, AC-3, H.264, and MP4.
  • Left out entirely, so these can't affect JeffDeck: the TDSC, CFHD, DVB subtitle, MACE6, and AV1 decoders named in CVE-2026-65703, CVE-2026-70632, CVE-2026-70628, CVE-2026-66039, and CVE-2026-30997 (rated 7.5 to 8.7).
  • FFmpeg 7.1.5 itself fixes CVE-2025-22921, CVE-2026-8461, and CVE-2026-96611 (an overflow in the MP4 reader).
  • This applies to Windows, the Mac, the .deb, and the AppImages. In the snap, sound and video come from its KDE platform.

JeffDeck

  • The Insert dialogs offer only the sound and movie formats JeffDeck plays. A movie whose sound JeffDeck can't play now says so when you insert it.
  • Charts in OpenDocument presentations show their gridlines every time. Before, they could appear or disappear from one opening to the next.

JeffCrunch

  • When a workbook opens in a window of its own, the Open page closes.
  • Clear Print Area works right after you save.

Every app

  • Underlines are drawn where they were before the toolkit update, including under a tab at the end of a line.
  • Translations for the new and changed text.

JeffOffice 0.25.0

· Downloads

Every app can save a PDF with a password and print on both sides by hand. JeffCrunch gets automatic recovery, spelling as you type, and AutoCorrect in cells, and JeffDeck and JeffPub get the File > Info page.

Every app

  • PDFs with a password: when you save as PDF, choose Encrypt with a password. You can set a password to open the PDF and an optional second password that controls printing, copying, and changing it. PDFs with a password also open in each app, for example a picture inserted from one.
  • Print on both sides by hand: on a printer that prints only one side, the app prints every other page, then asks you to turn the stack over and put it back. A new Sides choice on the Print page sets one side, both sides, or both sides by hand, and the app remembers it.
  • AutoCorrect: one set of rules for all four apps, and web addresses you type become links.
  • Spanish: spelling for 19 more Spanish-speaking regions, such as Mexico and Argentina, and an interface in the Spanish of Spain.
  • Security updates: newer versions of the libraries that draw PDFs, compress files, and check spelling, each with known security problems fixed.

JeffCrunch

  • Automatic recovery: JeffCrunch saves a recovery copy as you work and offers it back after a crash, without pausing your typing.
  • Spelling as you type: misspelled words in cells are underlined. To turn it off, clear the "Check spelling as you type" option.
  • AutoCorrect in cells, with the same rules as the other apps.
  • Charts in .xls workbooks are read and are kept when you save as .xlsx.
  • A text file whose cells start with = keeps them as text, unless you ask for formulas.

JeffDeck and JeffPub

  • File > Info: document properties, Mark as Final, Inspect, and Version History on one page. In JeffDeck it also sets a password for the file, and the file's versions, copies, and backups keep that password.

Fixes

  • Firmer limits on damaged and hostile files in all four apps, so they open as far as they can instead of stalling or crashing.
  • Typed formulas nested deeper than 64 levels are refused, as other spreadsheet programs do.
  • Closing JeffWrite's window while it asks for a password stops opening the file.
  • Translations for the new commands, dialogs, and Help pages.

JeffOffice 0.24.0

· Downloads

Every app starts faster, JeffWrite and JeffCrunch draw the diagrams a file keeps, and JeffWrite gets linked text boxes and drawing groups. JeffCrunch adds split panes, threaded comments, Move Chart, and more pivot table tools.

Every app

  • Faster start: the window shows before the bundled fonts load and before the file you opened is read, and ribbon tabs are made when you first show them.
  • Diagrams: a file's diagrams are drawn from the drawing the file keeps, in JeffWrite and JeffCrunch as in JeffDeck.
  • Safer with damaged and hostile files: firmer limits on zip packages, saved files with very many parts, and formulas that do very much work, so such files open as far as they can instead of stalling.

JeffWrite

  • Linked text boxes: text flows from one box to the next, across pages, with Create Link and Break Link.
  • Drawing: grouped shapes that move with the line as one object, picture fills, Text Art, drawing canvases, and connectors.
  • Go Back returns to the places you edited, even after more edits.

JeffCrunch

  • Split panes: View > Split, and split boxes at the ends of the scroll bars, each pane scrolling on its own.
  • Threaded comments: reply to a comment on the Review tab or in the Comments pane; files keep their threads and the people in them.
  • Pivot tables: Calculated Item, Solve Order, field buttons on pivot charts, and New Table Style.
  • Charts: Move Chart to a new chart sheet and back onto a worksheet, and error bars on area charts with custom amounts from cells.
  • Formulas: Next Error and Previous Error, Edit Links that update values and change a source, and Error Checking for formulas in unlocked cells.
  • Custom views, subtotal page breaks, and locked scenarios.
  • Calculation is faster on workbooks with many lookups, and a workbook with more to work out than one calculation allows keeps the values it had and finishes on the next change.

JeffPub

  • Linked text boxes that wrap around each other no longer slow the program down.
  • A publication with very many tab stops in one paragraph saves correctly.

JeffDeck

  • The slide sorter stops scrolling by itself, and rehearsal times start on a new slide.

Fixes

  • Grid lines are one screen pixel wide at 125% and 150% display scaling.
  • Undo and Redo wait while a large change is going in, and Save and Close wait during Goal Seek and Scenario Summary.
  • A recovery copy is written before the old one is removed.
  • Translations for the new commands, dialogs, and Help pages.

JeffOffice 0.23.0

· Downloads

JeffWrite gets drawing, charts, equations, and a much stronger Find; JeffCrunch gets shapes, pictures, scenarios, and more chart tools. Every app now also comes in American, British, Canadian, and Australian English.

JeffWrite

  • Drawing: shapes and text boxes, elbow and curved arrows, crop to a shape, rotate, align and distribute, gradient fills, and the Draw Table pen and Eraser on the pages.
  • Charts and equations: a file's charts are drawn with their colors and borders, with tabs to change them, and equations get accents, matrices, a gallery, and editing in place.
  • Find: match counts and highlights on the pages, Advanced Find, wildcards, special codes for breaks, fields, and notes, groups in Replace, and Find Next and Replace that reach headers, footers, notes, and table cells.
  • Navigation: results by heading and by page, and headings that collapse and expand on the page.
  • Styles: Manage Styles sets the recommended, hidden, and locked styles, their order, and imports or deletes them.
  • Views: Web Layout wraps the text to the window, a vertical ruler shows the page margins, and New Window, Arrange All, and Side by Side work for documents.
  • Web pages: open a web page with its pictures, links, and lists, and save as a web page, a filtered web page, or a single file.
  • Tables: text turned to read from the top down or bottom up, text wrapped around a table, and Delete Cells, Shift Left.
  • Editing: a mini toolbar over selected words, a Paste Options button after a paste, smart cut and paste that fixes the spaces, and the five fonts you chose last at the top of the font list.
  • Page setup and printing: settings that apply from a point forward, envelope paper sizes, several pages on one sheet of paper, odd or even pages only, and PDF/A-1b export.
  • More: a table of figures from a paragraph style, alignment tabs in headers and footers, Bring Forward and Send Backward for pictures, and hyphenation of words in capitals.
  • New documents use A4 paper outside the United States and Canada, matching the computer's region.

JeffCrunch

  • Shapes and pictures: Insert Picture, Shapes, Text Box, and Icons, with Picture Format and Shape Format tabs, Shape Styles, grouped shapes, gradient fills, and a Selection Pane that lists, picks, and reorders them.
  • Charts: error bars, drop lines, high-low lines, up/down bars, display units on an axis, data labels taken from cells, and a Chart Filters button that leaves series out and keeps that in the file.
  • Formulas: LET, CELL, INFO, and FILTERXML, Trace Error, Apply Names, Calculate Before Save, a sortable Names list, and scenarios that follow inserted and deleted cells.
  • Data: open a web page's tables as a workbook, fixed-width text import, Paste Link, Paste as Hyperlink, and a calculated field for pivot tables.
  • Borders and grid: Draw Border, Draw Border Grid, Erase Border, and a color for the gridlines.
  • Protection: ranges people may edit in a protected sheet, which move with inserted and deleted rows, columns, and cells.
  • Printing: scale to a paper size, a preview of the sheet, odd or even pages only, and several pages on one sheet of paper.
  • Check Accessibility now finds low-contrast text, merged cells, unclear link words, blank layout cells, and the reading order.
  • Options: AutoComplete, the fill handle, decimal places, and showing or hiding zeros on a sheet.

Every app

  • English variants: American, British, Canadian, and Australian English for the menus and Help, chosen from your computer's settings or in Options.
  • About lists the third-party software each app uses.
  • Options: remove personal information from a file's properties when saving.

Fixes

  • On Windows, JeffWrite's ruler now lines up with the page when the window opens or changes size.
  • A blue outline no longer appears above and below the pages in JeffWrite, or around the sheet in JeffCrunch, when the window changes size.
  • Chart axis unit names follow the interface language.
  • Translations for the new commands, dialogs, and Help pages.

JeffOffice 0.22.0

· Downloads

JeffWrite gets an outline, more views, and new ways to save and share; JeffCrunch gets version history, an email export, and more pivot table and chart tools. JeffPub is now optional in the Windows setup.

JeffWrite

  • Views: an Outline view (move and edit headings, with Enter, Tab, and Shift+Tab), Draft, Read Mode, Split (a second pane on the same document), and page movement side to side or top to bottom.
  • File: version history kept on this computer, a gallery of twelve built-in templates, reopening where you stopped editing, and a question before a save would lose parts of a file.
  • Save and share: save .rtf, save .docm and .dotm with their macros kept, open and save .txt in many encodings, make an email file with the document or a PDF of it, PDF export with bookmarks from your headings and a choice of pages, and printing both sides by hand.
  • Print preview with one, two, or four pages, and page ranges by section.
  • Headers and footers: designs, page number formats, document information, and a date.
  • Formatting: character shading and borders, watermarks, drop caps, paragraph spacing choices, and hyphenation settings.
  • Help tab with shortcuts and what's new, Edit Field on a field's right-click menu, the section number in the status bar, and line counts in Word Count.
  • Options: Save, Display, and Advanced pages, with your choice of measurement units.

JeffCrunch

  • File: version history kept on this computer, a gallery of built-in templates with a picture of each, an email file with the workbook or a PDF of it, the whole workbook as PDF/A, Check Compatibility before an .xls copy, Open and Repair for a damaged .xls, and printing several sheets, or only the selection, at once.
  • Pivot tables: Recommended Pivot Tables, Show Values As rank and percent of the parent row or column, and Show Report Filter Pages.
  • Charts: a logarithmic axis, Save as Picture, alt text and names for charts, pictures, and shapes, and chart templates (.crtx).
  • Formulas and Data: Error Checking, Evaluate Formula, Watch Window, Goal Seek, Subtotal, Advanced Filter, Circle Invalid Data, and Flash Fill (Ctrl+E), which fills a column from a few examples.
  • Home: a paste menu with every Paste Special choice, Copy as Picture, and Delete Cell Style.
  • Info: Protect Sheet and Protect Workbook Structure cards, and Inspect Workbook now finds hidden rows and columns, headers, and footers.
  • Options: the font, size, and number of sheets for new workbooks.

Windows setup

  • JeffPub is now a choice in setup, like the other apps, and starts ticked. Unticking an app in an update removes it, its shortcuts, and its file types, and keeps its settings.

Fixes

  • An .xlsx copy of an old workbook no longer holds names or page breaks the format refuses, so other spreadsheet programs open it.
  • A plain .txt file opens at once when its encoding is clear.
  • Translations for the new commands, dialogs, and Help pages.

JeffOffice 0.21.0

· Downloads

JeffWrite and JeffCrunch take a big step toward 1.0: tables, references, mail merge, pivot tables, conditional formatting, about 250 new functions, and Undo that reaches past a save.

JeffWrite

  • Tables: table styles with our own names, column widths as a percent, Convert Text to Table, Sort inside a table, and a mouse that grabs a border only when you mean it.
  • References: tables of contents, footnotes and endnotes, captions, citations and a bibliography, an index, and a table of authorities.
  • Mailings: mail merge from a list, with preview, merge fields, and highlighting.
  • Home and Review: Change Case, Sort, paste choices, a Tabs box, spacing and paragraph options, Word Count, proofing language, Thesaurus, Translate, Compare (tracked changes between two versions), Restrict Editing, and Lock Tracking.
  • Insert, Design, Layout, and View: symbols, a blank page, links, Text from File, cover pages (three original designs), Date & Time, a horizontal line, columns with column lines, page borders and page color, line numbers, the Navigation pane, and Reveal Formatting.
  • Check Accessibility lists what a screen reader would miss.

JeffCrunch

  • Pivot tables: make them from a range or table, Drill Down and Drill Up, move a pivot table, slicers and timelines that filter it, and pivot charts.
  • Charts: Format Axis (bounds, units, order, crossing, number format, ticks, and labels), data labels, Move Chart to another sheet, and sparklines with their own tab.
  • Conditional formatting from the Home tab: highlight cells greater than, less than, between, or equal to a value, text that contains a word, duplicates, top and bottom items, and above or below average. Rules already in a file, including data bars, color scales, and icon sets, are kept exactly as they were.
  • About 250 new functions in math, statistics, finance, engineering, and arrays.
  • Data tab: Text to Columns and Remove Duplicates, with formulas that point at the moved cells following them.
  • Undo reaches past a save: a deleted or moved chart or picture, and a cleared or added rule, can still be undone after you save.
  • Home, View, and Page Layout: fill lists, moving cells by their border, Go To Special, cell styles, Full Screen, and more.

All four apps

  • File > Info for JeffWrite and JeffCrunch: document properties, Mark as Final, password protection, and Inspect Document.
  • Read-only files really are read-only, Save a Copy keeps a file's properties, and a backup copy is offered before saving over a file.
  • Open and Repair for damaged files, with bounded memory.

Fixes

  • Many limits keep a damaged or hostile file from freezing an app or using unbounded memory.
  • JeffCrunch messages and labels that showed in English when another language was chosen are now translated.
  • Formulas that could run for minutes (some finance and statistics functions with huge arguments) now stop quickly with an error, and several wrong results are corrected.

JeffOffice 0.20.1

· Downloads

A new Windows installer, and JeffOffice's legal and privacy documents.

Windows installer

  • A new, sharper installer. Its pictures and text are drawn for every display scale, from 100% to 250%, so nothing looks blurry on a high-resolution screen. The license reads as flowing paragraphs instead of broken lines.
  • Updating from an earlier version keeps your settings and your choice about usage statistics.
  • .ott templates now open in JeffWrite and .ots templates in JeffCrunch from Open with.
  • No administrator rights are needed, as before.

Privacy and legal

  • File > Options shows your install number, the random number your usage statistics are sent with, with a Copy button. To have our copy of your statistics deleted, send it to info at jeffoffice dot com before you turn statistics off.
  • The statistics server now deletes everything after 24 months.
  • Options and the first-run question link to the privacy notice. The About page of each app links to the privacy notice, the Additional Terms that come with the GNU GPL, and the trademark policy.
  • Every package now includes the license texts of the parts JeffOffice is built with (Qt, the Lucide icons, and the libraries that read .pub files), along with the GPL and the Additional Terms.
  • Setting the environment variable JP_NO_TELEMETRY turns usage statistics off; Help now says so.
  • Each release now lists a SHA-256 checksum for every download (SHA256SUMS), so you can check your copy.
  • Help for JeffWrite and JeffCrunch has an Options page.

JeffOffice 0.20.0

· Downloads

JeffWrite and JeffCrunch are now betas. JeffWrite opens .rtf and .odt files, saves .odt, and works with fields. JeffCrunch has pivot tables, opens password-protected workbooks, and lets you click cells while you type a formula.

How close are JeffWrite's pages?

We measure JeffWrite by laying out documents and comparing each page with the same page from the original program. A page scores under 2 when the two pictures are almost the same.

  • On 95 documents we never tuned JeffWrite on, 74.9% of pages score under 2, and the page count is right on 90 of the 95. In plain words, about 3 of every 4 pages lay out within a small difference of the original program. The rest differ by a line or a page break, most often where table rows are a hair taller or a font is a hair off.
  • On the 95 documents we did tune on, 91.8% of pages score under 2. On two other sets we tuned on less, 200 documents score 83.3% and 150 documents score 76.7%. Expect results like the last three numbers on your own documents.
  • Fidelity work continues after this release, starting with table row heights.

JeffWrite (beta)

  • Opens .rtf files. Text, looks, styles, lists, tables, page setup, headers and footers, notes, fields, bookmarks, pictures, tracked changes, and simple shapes come across. JeffWrite does not write .rtf: saving asks for a new name and writes a .docx.
  • Opens and saves .odt files. Save As now offers OpenDocument Text. Comments and tracked changes are saved. After a save, JeffWrite says what the format has no place for. .ott templates and flat .fodt files open too; a .fodt is saved as a new .odt, and JeffWrite tells you so.
  • Fields. Insert > Field puts in a page number, a date, a reference, or a number that counts figures. F9 works a field out again, Alt+F9 shows the codes, and fields can be locked or turned into plain text. Tables of contents update, and Cross-reference and Bookmark are on the Insert tab.
  • Track changes are read from .rtf and .odt files and kept when you save to .docx or .odt.
  • Unequal columns lay out as the file says.
  • Long documents lay out and edit faster.

JeffCrunch (beta)

  • Point mode. While you type a formula, click a cell, drag over cells, or press the arrow keys, and its address is written for you. Each address is colored in the formula and outlined on the sheet. Press F4 to fix part of an address with a dollar sign. Drag the outline to move an address, or its corner to stretch it.
  • Function Arguments. Press Shift+F3 or click fx to fill in a function one argument at a time, with the result shown as you go.
  • Password-protected workbooks. Open .xlsx, .xls, and .ods files that need a password, including the newer kind that recent OpenDocument programs make. File > Protect with Password protects an .xlsx when you save it. An .xls or .ods copy can't be protected.
  • Pivot tables. Make one from a range or a table, drag fields between Filters, Columns, Rows, and Values, change how totals and labels are laid out, refresh, change the data, and set options. Click a pivot table cell while you type a formula and JeffCrunch writes a GETPIVOTDATA formula.
  • MOD now gives the same answers as the original program, including the rounding of results.
  • Fixes to function hints, the default of SWITCH, and the Pick a Function list.
  • The ribbon fits larger fonts, and has a menu for tabs that don't fit.

Installer

  • The last page of the Windows installer now says where to find the apps: in the Start menu. The installer no longer starts an app for you.

Fixed

  • In JeffWrite and JeffCrunch, a blue line no longer shows at the top and bottom of the page after you press a key.
  • In JeffCrunch, "Calculating…" no longer stays in the status bar after you make a pivot table.
  • Very large or damaged files open faster or are turned away with a clear message, instead of stalling.
  • Footer text after a tab that runs past the right edge stays on its line.
  • Lines in Courier New break where the original program breaks them.
  • Text no longer runs through a placed group of shapes.
  • Saved .docx files keep a tracked list number's mark.
  • Help in German, Spanish, French, Italian, Dutch, and Portuguese matches the English again: 199 pages that had fallen behind were translated afresh.

Not working yet

JeffWrite:

  • No Draft or Outline view, and no vertical ruler.
  • Pictures, shapes, and tables in a header, a footer, or a note are kept but can't be edited. Shapes and text boxes can't be inserted.
  • Changes to tables, numbering, sections, headers, footers, and notes are not tracked as you make them.
  • No document properties box, no Compare, no Restrict Editing, no mail merge.
  • Equations show as one line of text.
  • Drawn shapes with no text, formulas, and charts in an .odt are left out, and JeffWrite then asks for a new name when you save.
  • A saved .odt has been tested on fewer files than a saved .docx.

JeffCrunch:

  • You can't make or change conditional format rules or data validation rules, or make a what-if data table. The ones a file has are shown and kept.
  • You can't enter an array formula with Ctrl+Shift+Enter yet.
  • An .ods file's charts, pictures, comments, pivot tables, conditional formats, and data validation are not read, and JeffCrunch says which when you open it.
  • Macros are kept but never run.
  • Some functions are missing; a formula that uses one keeps the value the file stored.

JeffOffice 0.10.3

· Downloads

JeffWrite gets the tools for working on a document with other people, and JeffCrunch can save copies for older programs. JeffWrite now tracks changes, takes comments, edits tables, places pictures, and manages styles. JeffCrunch can save a copy as .xls or .ods and works out what-if data tables.

JeffWrite (preview)

  • Track Changes. Turn it on with Ctrl+Shift+E (on the Review tab). JeffWrite then marks everything you type, delete, or reformat with your name and the date, in your own color. Each change also gets a bar in the margin.
  • Accept or Reject one change, every change, or every change shown, and step through them with Next and Previous.
  • Four views: Simple Markup, All Markup, No Markup (as if every change were accepted), and Original (as if every change were rejected).
  • Accept All and Reject All reach headers, footers, footnotes, endnotes, and text boxes, and one Undo takes either back.
  • On 27 documents with tracked changes, Accept All and Reject All gave exactly the same text as the original program.
  • Comments. Add a comment with Ctrl+Alt+M, then reply to it, mark it done, edit it, or delete it. Comments show in the margin and in a Reviewing pane.
  • Tables. Insert a table, add or delete rows and columns, merge and split cells, and apply table styles. You can also select a cell, row, column, or whole table, from the new Table tabs or the right-click menu.
  • Pictures. Insert pictures, then size, move, and wrap text around them with the mouse.
  • Page Setup and the ruler. A Page Setup dialog sets margins, paper, and orientation, and the ruler sets indents and tab stops.
  • Styles. A Styles pane lists the document's styles, and you can make new styles and change existing ones. Update to Match Selection and automatic updating also work.
  • Copy Formatting. Copy the look of text to other text. Double-click the button to paint more than once.
  • Drag and drop. Drag selected text to move it, or hold Ctrl (Option on a Mac) to copy it.
  • Go To (Ctrl+G). Jump to a page, section, line, bookmark, footnote, or heading.

JeffCrunch (preview)

  • Save a copy as .xls or .ods. Save As now writes the older .xls format and OpenDocument .ods.
  • Before saving, JeffCrunch names anything the format can't hold, such as rows past 65,536 or newer functions.
  • A formula the format can't express is saved as its value.
  • We saved copies of 8,371 workbooks and read every one back. Every value came back the same.
  • What-if data tables work. A data table reruns a formula for a list of inputs. JeffCrunch now works these out, instead of only showing the results stored in the file.
  • IRR matches the original. IRR works out a rate of return by repeated guesses, and it now takes the same steps as the original program, so it gives the same answers.
  • Grouping and outlines. Group and ungroup rows and columns, and show outline levels from the margin.
  • Fill has more options, works across sheets, and won't fill over merged cells that don't line up.
  • Show Formulas widens columns so the formulas fit, including columns you scroll to later.
  • Frozen panes are saved with the workbook.
  • Insert > Header and Footer opens the header so you can type in it.
  • Text files are saved the way you choose and otherwise kept as they came, including UTF-16 and Chinese, Japanese, and Korean text.

Behind the scenes

  • New checks read every .xls file JeffCrunch writes, record by record, and compare its formulas byte for byte with formulas taken from about 97,000 real files.