Repository navigation
JeffOffice 0.20.0 (beta)
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
.rtffiles. 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
.odtfiles. Save As now offers OpenDocument Text. Comments and tracked changes are saved. After a save, JeffWrite says what the format has no place for..otttemplates and flat.fodtfiles open too; a.fodtis 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
.rtfand.odtfiles and kept when you save to.docxor.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.odsfiles that need a password, including the newer kind LibreOffice 25 makes. File > Protect with Password protects an.xlsxwhen you save it. An.xlsor.odscopy 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
GETPIVOTDATAformula. - 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
.docxfiles 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
.odtare left out, and JeffWrite then asks for a new name when you save. - A saved
.odthas 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
.odsfile'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.