Excel: GET.DOCUMENT() Incorrect with Type_of_Info 21-29

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 "Microsoft Excel Functions and Macros" version 2.2 manual, GET.DOCUMENT(21) should return "a horizontal array of the numbers of the fonts being used in the <active> document." 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 "styles" 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.