Computers & Writing Systems

You are here: Type Design > Resources
Short URL: https://scripts.sil.org/OS2RangeBitWorksheet

OS/2 table Range bit calculation workbook

Bob Hallissy, 2008-02-06

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.

Instructions:

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.

Download

Excel workbook to calculate OS/2 table range bit fields (v1.2) Bob Hallissy, 2008-02-06 Download "OS2 table Range bit calculation.xls", MS Excel spreadsheet, 67KB [3854 downloads]

Older versions

Excel workbook to calculate OS/2 table range bit fields (v1.1) Bob Hallissy, 2006-04-04 Download "OS2 table Range bit calculation.xls", MS Excel spreadsheet, 50KB [3680 downloads]

Excel workbook to calculate OS/2 table range bit fields Bob Hallissy, 2006-02-14 Download "OS2 table Range bit calculation.xls", MS Excel spreadsheet, 54KB [2773 downloads]

Author

Bob Hallissy

Change history

© 2003-2024 SIL International, all rights reserved, unless otherwise noted elsewhere on this page.
Provided by SIL's Writing Systems Technology team (formerly known as NRSI). Read our Privacy Policy. Contact us here.