Xlrd

-------------------

- Tolerant handling of files with extra zero bytes at end of NUMBER record.
Sample provided by Jan Kraus.
- Added access to cell notes/comments. Many cross-references added to Sheet
class docs.
- Added code to extract hyperlink (HLINK) records. Based on a patch supplied by
John Morrisey.
- Extraction of rich text formatting info based on code supplied by
Nathan van Gheem.
- added handling of BIFF2 WINDOW2 record.
- Included modified version of page breaks patch from Sam Listopad.
- Added reading of the PANE record.
- Reading SCL record. New attribute ``Sheet.scl_mag_factor``.
- Lots of bug fixes.
- Added ``ragged_rows`` functionality.

-------------------

- Backed out "slash'n'burn" of sheet resources in unload_sheet().
Fixed problem with STYLE records on some Mac Excel files.
- quieten warnings
- Integrated on_demand patch by Armando Serrano Lombillo

---------------------

+ colname utility function now supports more than 256 columns.
+ Fix bug where BIFF record type 0x806 was being regarded as a formula
opcode.
+ Ignore PALETTE record when formatting_info is false.
+ Tolerate up to 4 bytes trailing junk on PALETTE record.
+ Fixed bug in unused utility function xldate_from_date_tuple which
affected some years after 2099.
+ Added code for inspecting as-yet-unused record types: FILEPASS, TXO,
NOTE.
+ Added inspection code for add_in function calls.
+ Added support for unnumbered biff_dump (better for doing diffs).
+ ignore distutils cruft
+ Avoid assertion error in compdoc when -1 used instead of -2 for
first_SID of empty SCSS
+ Make version numbers match up.
+ Enhanced recovery from out-of-order/missing/wrong CODEPAGE record.
+ Added Name.area2d convenience method.
+ Avoided some checking of XF info when formatting_info is false.
+ Minor changes in preparation for XLSX support.
+ remove duplicate files that were out of date.

+ Documented runxlrd.py commands in its usage message. Changed
commands: dump to biff_dump, count_records to biff_count.

-------

+ Bug fixed: Missing "<" in a struct.unpack call means can't open
files on bigendian platforms. Discovered by "Mihalis".
+ Removed antique undocumented Book.get_name_dict method and
experimental "trimming" facility.
+ Meaningful exception instead of IndexError if a SAT (sector
allocation table) is corrupted.
+ If no CODEPAGE record in pre-8.0 file, assume ascii and keep going
(instead of raising exception).

-------

+ At least one source of XLS files writes parent style XF records
*after* the child cell XF records that refer to them, triggering
IndexError in 0.5.2 and AssertionError in later versions. Reported
with sample file by Todd O'Bryan. Fixed by changing to two-pass
processing of XF records.
+ Formatting info in pre-BIFF8 files: Ensured appropriate defaults and
lossless conversions to make the info BIFF8-compatible. Fixed bug in
extracting the "used" flags.
+ Fixed problems discovered with opening test files from Planmaker
2006 (http://www.softmaker.com/english/ofwcomp_en.htm): (1) Four files
have reduced size of PALETTE record (51 and 32 colours; Excel writes
56 always). xlrd now emits a NOTE to the logfile and continues. (2)
FORMULA records use the Excel 2.x record code 0x0021 instead of
0x0221. xlrd now continues silently. (3) In two files, at the OLE2
compound document level, the internal directory says that the length
of the Short-Stream Container Stream is 16384 bytes, but the actual
contents are 11264 and 9728 bytes respectively. xlrd now emits a
WARNING to the logfile and continues.
+ After discussion with Daniel Rentz, the concept of two lists of XF
(eXtended Format) objects (raw_xf_list and computed_xf_list) has been
abandoned. There is now a single list, called xf_list