Repository navigation
JeffOffice 0.10.3 (beta)
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
.xlsor.ods. Save As now writes the older.xlsformat 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
.xlsfile JeffCrunch writes, record by record, and compare its formulas byte for byte with formulas taken from about 97,000 real files.