NRSI: Computers & Writing Systems
OS/2 table Range bit calculation workbook
Now contains Unicode range definitions from the draft version 1.5 of the OpenType standard.
This Excel workbook (with included macros) calculates the UnicodeRange and CodepageRange bit vectors for the OS/2 table in TrueType fonts. The resultant hex string is directly usable in the hackos2 and Reprise utilities.
As of this date the book includes definition of OS/2 table bits that have been announced in their draft version 1.5 of the OpenType specification.
You will need the macro security setting in Excel configured to Medium (recommended) or Low to use this workbook.
Download the workbook to your computer and open it up in Excel. The workbook does have macros so you may be prompted as to whether to permit them or not. The uploaded file was scanned with up-to-date AVG so should be virus free.
On the UnicodeRange or CodepageRange sheets, place a "1" in column A for any range bit you want set, clearing out the rest of column A.
Run the included macro DisplayRangeBits (this is available on the "OS/2 table Range bit calculation" toolbar if you want). The result will appear in a message box. Copy the result to the clipboard if you want.
To clear all the bits on the current worksheet, run the ClearBits macro (also available on the toolbar).
If the toolbar is not visible, click View / Toolbars and enable the toolbar "OS/2 table Range bit Calculations".
Screenshot of the Unicode range worksheet
NB: As of Feb 2008, this sheet contains all proposed assignments to the UnicodeRange and CodepageRange bits that I know of from Microsoft. To add others, simply modify the relevant worksheets. For ease of use I've "protected" the worksheet so only column A can be changed, so to add additional definitions you'll need to unprotect the workbook.