Microsoft KB Archive/21570

Incorrect Cell References in Audit Report PSS ID Number: Q21570 Article last modified on 01-10-1989 PSS database name: D_MPlan

3.00 3.01 3.02

MS-DOS

Summary: In Multiplan Versions 3.x there is a problem that can occur when printing out a report under Run Report Print Summary Full. An extra digit is connected to the cell references appearing directly above.

More Information: The following is an example of the problem:

  Beginning with a blank worksheet, format cells R1C1:R2C14 for the $ format.   Execute Run Report Print Summary Full. The following is an example of the printout: 28 cells with formats but no value R1C1 R1C2 R1C3 R1C4 R1C5 R1C6 R1C7 R1C8 R1C9 R1C10 R1C11 R1C12 R1C13 R1C14 R2C1 R2C2 R2C30 R2C41 R2C52 R2C63 R2C74 R2C8 R2C9 R2C10 R2C11 R2C12 R2C13 R2C14 

The erroneous references are to the following cells

R2C30 R2C41 R2C52 R2C63 R2C74

These cells should be be as follows:

R2C3 R2C4 R2C5 R2C6 R2C7

All of these references have an incorrect digit at the end. Microsoft has confirmed this to be a problem in Versions 3.00. 3.01, and 3.02. This problem was corrected in Version 3.04.

Copyright Microsoft Corporation 1989.