# wx.lib.agw.xlsgrid.XLSRichText¶

This is a class which holds information about the cell content, in terms of actual cell value, font, text colour, alignment and formatting. In addition to what XLSText does, this class attempts to handle cells with rich text content.

## Class Hierarchy¶

Inheritance diagram for class XLSRichText:

## Known Superclasses¶

wx.lib.agw.xlsgrid.XLSText

## Methods Summary¶

 __init__ Default class constructor. BuildChunks Splits the cell content accordingly to their rich text format index. Draw Actually draws all the chunks of text on a grid cell, one by one. Measure Convenience method to measure the maximum height and total width of all

## Class API¶

class XLSRichText(XLSText)

This is a class which holds information about the cell content, in terms of actual cell value, font, text colour, alignment and formatting. In addition to what XLSText does, this class attempts to handle cells with rich text content.

### Methods¶

__init__(self, book, cell, xf_index, display_text=None, hyperlink=None, rich_text=None, default_width=10)

Default class constructor.

Parameters
• book – an instance of the xlrd.Book class;

• cell – an instance of xlrd.sheet.Cell class;

• xf_index – an index into xlrd.Book.xf_list, which holds a reference to the xlrd.sheet.Cell class (the actual cell for xlrd);

• display_text – if Mark Hammonds’ pywin32 package is available, this is the WYSIWYG cell content;

• hyperlink – if this cell contains a hyperlink, it will be displayed accordingly;

• rich_text – if this cell contains text in rich text format, XLSGrid will do its best to render the text as rich text;

• default_width – this is the default width of the text in 1/256 of the width of the zero character, using default Excel font (first FONT record in the Excel file).

Note

If you are using version 0.7.1 or lower for xlrd, the hyperlink parameter will always be None as this feature is available only in xlrd 0.7.2 (SVN).

Note

If you are using version 0.7.1 or lower for xlrd, this class will note be used by XLSGrid.

Warning

This class currently supports only single-line non-rotated text, and it discards properties like shrink-to-fit and wrapping.

BuildChunks(self, book, xf_index, rich_text)

Splits the cell content accordingly to their rich text format index.

Parameters
• book – an instance of the xlrd.Book class;

• xf_index – an index into xlrd.Book.xf_list, which holds a reference to the xlrd.sheet.Cell class (the actual cell for xlrd);

• rich_text – if this cell contains text in rich text format, XLSGrid will do its best to render the text as rich text.

Draw(self, dc, rect)

Actually draws all the chunks of text on a grid cell, one by one.

Parameters

Measure(self, dc)

Convenience method to measure the maximum height and total width of all the chunks of text composing our rich text string.

Parameters

dc – an instance of wx.DC.