Microsoft KB Archive/87719

= Zero-Width Columns Lost in Text & Commas/Text & Tabs Formats =

Article ID: 87719

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 3.0 for MS-DOS
 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a
 * Microsoft Money 2000 Business & Personal Edition

-



This article was previously published under Q87719



SUMMARY
When you are using a Works Spreadsheet module or Database module file that contains 0-width columns, and you save the file in a Text And Commas or Text And Tabs format, the data in the 0-width columns will be lost in the text version of the file.

NOTE: Other kinds of column formatting will not affect what is or is not saved when you save a file in text format.



Steps to Reproduce Behavior
 Open a new Spreadsheet module document.  In cells A1-D1, type the numbers 1, 2, 3, and 4 respectively (one number for each cell). Your spreadsheet should look like the following example:         |     A     |     B     |     C     |     D     | 1 |     1     |     2     |     3     |     4     |                     Set the width of column B to 0. From the File menu, click the Save File As command, and enter the filename SPIFF.TXT. Under Format, click Text And Commas. Close the file. Open SPIFF.TXT as a Word Processor file.</li></ol>

Note that Works saved only the numbers 1, 3, and 4; the 2 in column B is gone. The same results will occur when you save files in the Text And Tabs format. This behavior exists in both the MS-DOS and Windows versions of Microsoft Works.

Additional query words: 2.00 3.00 4.00 4.00a 4.50 4.50a

Keywords: kbinfo KB87719

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.