OpenOffice.org Writer Mail Merge Fields Insert Formula
I use OpenOffice.org , LibreOffice.org to merge from the Calc spreadsheet to the Writer word processor module. I was merging raw scores and wanted to reflect the percentage correct after the raw score. I could have added a column to my grade book that would have calculated the percentage correct, but to do this for every assignment would double the column count of an already expansive spreadsheet. Fumbling about with the Insert fields dialog box, I could not hit on the right combination. I even tried copying and pasting fields into the Insert formula dialog box, but to no avail. When copied and pasted, the field pastes as the field names only in angle brackets, such as and generates an invalid formula Rumbling around inside the help files answered many simpler questions, but not how to set up a formula using a Calc spread sheet field name. Stumbling about the web for an hour was also of no avail. Searches of the pertinent forums that are out there ( oooforum , OpenOffice.org c...