Microsoft KB Archive/59967

{| = Excel: GET.DOCUMENT Incorrect with Type_of_Info 21-29 =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q59967

SUMMARY
Using the Microsoft Excel GET.DOCUMENT command with the type_of_info argument equal to 21-29 may result in unexpected information being returned.

For example, according to page 237 of the &quot;Microsoft Excel Functions and Macros&quot; version 2.2 manual, GET.DOCUMENT(21) should return &quot;a horizontal array of the numbers of the fonts being used in the document.&quot; If a document was created with different fonts on a Macintosh, the result is a horizontal array in which each entry contains the same font name, instead of each array entry containing a different font number, as would be expected according to the documentation.

MORE INFORMATION
Argument numbers 20-29 of the GET.DOCUMENT command were included for compatibility with Excel for Windows version 2.10; these arguments don't apply to Excel version 2.20 for the Macintosh or to Excel version 2.20 for OS/2.

Excel for Windows 2.10 is limited to four combinations of font and font formatting on each worksheet; the GET.DOCUMENT command in Excel for Windows 2.10 returns the four different &quot;styles&quot; used in that document.

Since Excel for the Macintosh 2.20 handles fonts differently, allowing up to 256 combinations of font and font formatting, documents created in Excel for the Macintosh 2.20 return only the standard font of the document instead of a list of all the fonts being used in the document.

If the document is imported into Excel for the Macintosh 2.20 from Excel for Windows 2.10, the GET.DOCUMENT command returns the font information for the four font styles defined in the Excel for Windows 2.10 document.
 * }