JeffOffice 0.10.2 (beta)

JeffCrunch keeps up with huge sheets and says plainly what a save will change, and JeffWrite breaks lines and pages more like the original. This release finishes the rebuild of how JeffCrunch tracks rows and columns, so even a sheet of a million rows stays quick to edit, undo, and redraw. It also adds the first beta work for JeffCrunch and JeffWrite.

JeffCrunch (preview)

• Column edits in very large sheets are faster. In a sheet of a million rows, deleting a column now takes 17 to 44 thousandths of a second instead of up to 70, and undoing it takes about 4 thousandths of a second instead of 70.
• The window redraws only what changed. After an insert or delete, JeffCrunch repaints just the rows or columns that moved, instead of the whole sheet.
• Undo and Redo give your selection back. After Undo or Redo of a row or column edit, the cells you had selected are selected again.
• Filling 100,000 new rows takes under a second. Before, it could keep JeffCrunch busy for minutes.
• A refused edit never costs you your Undo history. When JeffCrunch can't do an edit (for example, on a protected sheet), everything you could undo before is still there.
• Templates and add-ins are saved as what they are. A template (.xltx, .xltm) or add-in (.xlam) is saved back as a template or add-in. Save As can now turn a template into a workbook (.xlsx or .xlsm), and it asks first if the new kind can't hold the file's macros. The Open dialog lists templates and add-ins.
• Saving as CSV says what will be left out. CSV holds only one sheet of plain values. Before saving, JeffCrunch now names what the CSV file won't keep, including other sheets (hidden ones too), formulas, pictures, charts, and notes. It offers Save Values Only, Save as .xlsx, or Cancel.
• A file that won't open gets a plain explanation. JeffCrunch says whether the file is empty, is really a PDF, picture, text document, or presentation, is password-protected, was cut short, or is damaged. Other open workbooks are left alone.
• Saving keeps everything you didn't change. A new check opened, edited, and saved 8,328 workbooks and compared every part of each file. Nothing that wasn't edited changed.

JeffWrite (preview)

• Lines and pages break more like the original. On our practice documents, pages that match the original went from 76% to 82%, and page counts now match in 95% of documents. The changes include:
  • Footnotes split across pages as in the original.
  • Spaces at the end of a paragraph wrap when the document asks for it.
  • Numbered lists set with a space or nothing after the number are spaced as the document asks.
  • Empty header and footer lines take the right height.
  • Web addresses in links no longer break after a slash.
• Typewriter-style text looks as dark as in the original. Text in Courier New, drawn with a free stand-in font, is shown a little darker on screen to match. PDFs and printing are unchanged.

Windows installer

• The folder page no longer shows a stray backslash at the end of the install folder when you update.

Behind the scenes

• New stress tests feed JeffCrunch extreme sessions: millions of edits, sheets edited for hours, and every row and column number used up. Those tests found two of the fixes above.