Repository navigation
Added
-
Added an XLSX API to read cell styles. A long requested feature.
The new
worksheet_style()method returns aStyleRangeofStylevalues
holding the font, fill, borders, alignment, number format and protection of
each cell, with theme and indexed colors resolved, including tints.For streaming,
XlsxCellReaderadds thenext_cell_with_style_id()method,
which returns each cell value together with its style id in a single pass, and
styles()to resolve the id to aStyle. Formats without style support
return an emptyStyleRange. See also thexlsx_style_stream.rsexample. PR
#653 and PR #682. -
Added
workbook_properties()methods toXlsandOdsin addition to the
xlsxandxlsbsupport in the previous release. The workbook document
properties can now be read from all the supported formats, including via
open_workbook_auto(). PR #756 and PR #757. -
Added
WorkbookProperties::custom_propertiesto read the custom, user
defined, document properties as a map of property name to text value.
PR #750.
Fixed
-
Fixed XLSX reading of packages whose main workbook part isn't named
xl/workbook.xml. The part name is now read from_rels/.rels. Issue #752
and PR #753. -
Fixed XLSX decoding of
_xHHHH_string escapes to handle all UTF-16 code
units, including surrogate pairs, instead of only_x00HH_. PR #751 and
PR #767. -
Fixed XLSB date and time formats not being applied to whole-number cell
values stored as integer RK records. These were returned asData::Int
instead ofData::DateTime. PR #758. -
Fixed an XLSB panic on malformed
BrtNamerecords, which now return an
error. Issue #760 and PR #761. -
Fixed a panic and an unbounded allocation in the CFB reader on malformed
compound files, which affected XLS files and VBA projects. PR #762. -
Fixed the XLS reader to ignore the case of the
WorkbookandBookstream
names, so that files with aWORKBOOKstream open as they do in LibreOffice.
Issue #618 and PR #755. -
Fixed XLS decoding of BIFF5 strings in multibyte code pages such as
Shift-JIS, GBK and Big5, which previously acquired NUL and replacement
characters. PR #765. -
Fixed an XLS panic on BIFF5 formulas with a
PtgStrstring literal, which
has no flags byte before BIFF8. PR #703. -
Fixed ODS error cells, such as
#DIV/0!, to return their displayed text
instead of an empty string. Issue #720 and PR #739. -
Fixed ODS cell text to include tabs (
text:tab) and soft line breaks
(text:line-break), which were previously dropped. PR #759. -
Fixed
ExcelDateTime::to_ymd_hms_milli()for times that round up to
midnight, which were returned as hour 24 of the same day instead of rolling
over to the next day. PR #763.
What's Changed
- xlsx: read the main workbook part name from _rels/.rels by @ozenyunus35 in #753
- feat(xlsx/xlsb): read custom document properties by @Alex-ley-scrub in #750
- fix(cfb, xls): ignore path casing by @sftse in #755
- ods: read text:tab and text:line-break in cell text by @wleeaf in #759
- feat(ods): read workbook document properties by @Alex-ley-scrub in #756
- Add Xlsx cell style reading support by @jmcnamara in #682
- ods: preserve displayed text for cached error cells by @sjh9714 in #739
- feat(xls): read workbook document properties by @Alex-ley-scrub in #757
- fix(xlsb): apply date formats to whole-number cell values by @Alex-ley-scrub in #758
- datetime: roll times that round up to midnight over to the next day by @ryanduguid in #763
- Fix BIFF5 multibyte string decoding by @awaken in #765
- xlsx: decode all xHHHH escapes as UTF-16 code units by @jmcnamara in #767
- ci: add contributing guide and PR template by @jmcnamara in #770
- tests: rename tests and fixtures to describe what they test by @jmcnamara in #771
New Contributors
- @ozenyunus35 made their first contribution in #753
- @wleeaf made their first contribution in #759
- @sjh9714 made their first contribution in #739
- @ryanduguid made their first contribution in #763
- @awaken made their first contribution in #765
Full Changelog: v0.37.0...v0.38.0