Browse Prior Art Database

Method to Ignore Blank and Separator Rows When Converting Spreadsheet Files

IP.com Disclosure Number: IPCOM000060210D
Original Publication Date: 1986-Mar-01
Included in the Prior Art Database: 2005-Mar-08
Document File: 1 page(s) / 12K

Publishing Venue

IBM

Related People

Chang, PY: AUTHOR [+4]

Abstract

A method is described to convert blank and separator rows of a spreadsheet to deleted records when the spreadsheet data is to be used with the merge with file function of DisplayWrite 3. Normally, when an operator creates a spreadsheet, lines are left blank or lines of non-alphanumeric characters are used to separate the column headings from the real data or to separate the data up into sections. These lines make the spreadsheet easier to read and understand. However, the operator would not want these lines to be treated as records and included when the data is merged with a document. For instance, the operator might create a shell for producing a letter that will go to many different people. If a blank line was included as a record in a merge, a letter with blanks for the name would be created.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 71% of the total text.

Page 1 of 1

Method to Ignore Blank and Separator Rows When Converting Spreadsheet Files

A method is described to convert blank and separator rows of a spreadsheet to deleted records when the spreadsheet data is to be used with the merge with file function of DisplayWrite 3. Normally, when an operator creates a spreadsheet, lines are left blank or lines of non-alphanumeric characters are used to separate the column headings from the real data or to separate the data up into sections.

These lines make the spreadsheet easier to read and understand. However, the operator would not want these lines to be treated as records and included when the data is merged with a document. For instance, the operator might create a shell for producing a letter that will go to many different people. If a blank line was included as a record in a merge, a letter with blanks for the name would be created. In accordance with this method, the blank and separator records are included in the file, but are converted to a deleted record format. Therefore, these records are ignored and not output during the merge. This saves the operator paper and time they would have to spend sorting out the bad letters. When errors are detected by the file manager component, e.g., invalid data in math field, data too long, etc., an error message is posted by the system telling the operator the field and record of the error. If the file is converted from a spreadsheet file, then the information about record does not mean...