Works: Formatting in Spreadsheet or Database List Creates Thousands of Rows/Records

Selecting a field in list view of a Works database, and choosing Record Height from the Format menu adjusts the record height for all possible 32,000 records, increasing the size of the database to 32,000 records. Similarly, selecting a column in a Works spreadsheet and choosing Row Height from the Format menu adjusts the row height for all possible 16,384 rows, increasing the size of the spreadsheet to 16,384 rows.

Workaround

Select the records or rows for which you want to change the height, rather than selecting the entire field or column when changing row or record height.

To remove the extraneous rows or records, do the following:

1. Highlight the first blank row at the bottom of your spreadsheet or list view in the database.
2. Press SHIFT+CTRL+END together on the keyboard to select the extraneous rows or records.
3. From the Insert menu, click Delete Record/Field (in the Database module) or Delete Row/Column (in the Spreadsheet module).
4. If the Delete dialog box appears, click Record (database) or Row (spreadsheet). Click OK.
   
   NOTE: If Field (database) or Column (spreadsheet) is selected, all of the data will be deleted.
5. If the error message
   Not enough memory to Undo: Continue?
   appears, click OK.
6. From the File menu, click Save.

The extraneous rows or records will now be deleted.