Excel-Writer-XLSX
view release on metacpan or search on metacpan
Changelog.md view on Meta::CPAN
- Fix for duplicate images being copied to an Excel::Writer::XLSX
file. Excel uses an optimization where it only stores one copy of a
repeated/duplicate image in a workbook. Excel::Writer::XLSX didn't do
this which meant that the file size would increase when then was a large
number of repeated images. This release fixes that issue and replicates
Excel's behavior.
## [1.02] - 2019-11-07
### Added
- Added support for hyperlinks in worksheet images.
- Increased allowable url length from 255 to 2079 characters, as allowed in
more recent versions of Excel.
## [1.01] - 2019-10-28
### Added
- Added support for stacked and East Asian vertical chart fonts.
- Added option to control positioning of charts or images when cells are
resized.
- Added support for combining Pie/Doughnut charts.
### Fixed
- Fixed sizing of cell comment boxes when they cross columns/rows that have
size changes that occur after the comment is written. Comments should
now behave like other worksheet objects such as images and charts.
- Fix for structured reference in chart ranges.
## [1.00] - 2019-04-07
### Fixed
- Fixed issue where images that started in hidden rows/columns weren't placed
correctly in the worksheet.
- Fixed the mime-type reported by system "file(1)". The mime-type reported
by "file --mime-type"/magic was incorrect for Excel::Writer::XLSX files
since it expected the "[Content_types]" to be the first file in the zip
container.
## [0.99] - 2019-02-10
### Added
- Added font and font_size parameters to write_comment().
- Allow formulas in date field of data_validation().
- Added top_left chart legend position.
- Added legend formatting options.
- Added set_tab_ratio() method to set the ratio between the worksheet tabs
and the horizontal slider.
- Added worksheet hide_row_col_headers() method to turn off worksheet row
and column headings.
- Add functionality to align chart category axis labels.
### Fixed
- Fix for issue with special characters in worksheet table functions.
- Fix handling of 'num_format': '0' in duplicate formats.
## [0.98] - 2018-04-14
### Added
- Set the xlsx internal file member datetimes to 1980-01-01 00:00:00 like
Excel so that apps can produce a consistent binary file once the
workbook set_properties() created date is set. Feature request [#168](https://github.com/jmcnamara/excel-writer-xlsx/issues/168).
## [0.97] - 2018-04-10
### Added
- Added Excel 2010 data bar features such as solid fills and control over
the display of negative values.
- Added default formatting for hyperlinks if none is specified. The format
is the Excel hyperlink style so links change color after they are
clicked.
### Fixed
- Fixed missing plotarea formatting in pie/doughnut charts.
## [0.96] - 2017-09-16
### Added
- Added icon sets to conditional formatting. Feature request [#116](https://github.com/jmcnamara/excel-writer-xlsx/issues/116).
## [0.95] - 2016-06-13
### Added
- Added workbook set_size() method. Feature request [#59](https://github.com/jmcnamara/excel-writer-xlsx/issues/59).
## [0.94] - 2016-06-07
### Added
Changelog.md view on Meta::CPAN
- Fix url encoding of links to external files and dirs.
## [0.84] - 2015-04-21
### Added
- Added support for chart axis display units (thousands, million, etc.).
- Added option to set printing in black and white. Issue [#125](https://github.com/jmcnamara/excel-writer-xlsx/issues/125).
- Added chart styles example.
- Added gradient fill support.
- Added support for clustered charts.
- Added support for boolean error codes.
0.83 2015-3-17
- Added option to combine two different chart types. For example to
create a Pareto chart.
0.82 2015-3-14
- Added extra documentation on how to handle VBA macros and added
automatic and manual setting of workbook and worksheet VBA codenames.
Issue [#60](https://github.com/jmcnamara/excel-writer-xlsx/issues/60).
- Fix for set_start_page() for values > 1.
- Fix to copy user defined chart properties, such as trendlines,
so that they aren't overwritten.
Issue [#121](https://github.com/jmcnamara/excel-writer-xlsx/issues/121).
- Added column function_value option to add_table to allow
function value to be set.
- Allow explicit text categories in charts.
Issue [#102](https://github.com/jmcnamara/excel-writer-xlsx/issues/102)
- Fix for column/bar gap/overlap on y2 axis.
Issue [#113](https://github.com/jmcnamara/excel-writer-xlsx/issues/113).
## [0.81] - 2014-11-01
### Added
- Added chart axis line and fill properties.
## [0.80] - 2014-10-29
### Added
- Chart Data Label enhancements. Added number formatting, font handling
(issue #106), separator (issue #107) and legend key.
- Added chart specific handling of data label positions since not all
positions are available for all chart types. Issue [#110](https://github.com/jmcnamara/excel-writer-xlsx/issues/110).
## [0.79] - 2014-10-16
### Added
- Added option to add images to headers and footers.
- Added option to not scale header/footer with page.
### Fixed
- Fixed issue where non 96dpi images were not scaled properly in Excel.
- Fix for issue where X axis title formula was overwritten by the
Y axis title.
## [0.78] - 2014-09-28
### Added
- Added Doughnut chart with set_rotation() and set_hole_size()
methods.
- Added set_rotation() method to Pie charts.
- Added set_calc_mode() method to control automatic calculation of
formulas when worksheet is opened.
## [0.77] - 2014-05-06
### Fixed
- Fix for incorrect chart offsets in insert_chart() and set_size().
Reported by Kevin Gilpin.
## [0.76] - 2013-12-31
### Added
- Added date axis handling to charts.
- Added support for non-contiguous chart ranges.
### Fixed
- Fix to remove duplicate set_column() entries.
## [0.75] - 2013-12-02
### Added
- Added interval unit option for category axes.
### Fixed
- Fix for axis name font rotation. Issue [#83](https://github.com/jmcnamara/excel-writer-xlsx/issues/83).
- Fix for several minor issues with Pie chart legends.
## [0.74] - 2013-11-17
### Fixed
- Improved defined name validation.
Issue [#82](https://github.com/jmcnamara/excel-writer-xlsx/issues/82).
### Added
- Added set_title() option to turn off automatic title.
Issue [#81](https://github.com/jmcnamara/excel-writer-xlsx/issues/81).
- Allow positioning of plotarea, legend, title and axis names.
Issue [#80](https://github.com/jmcnamara/excel-writer-xlsx/issues/80).
### Fixed
- Fix for modification of user params in conditional_formatting().
Issue [#79](https://github.com/jmcnamara/excel-writer-xlsx/issues/79).
- Fix for star style markers.
## [0.73] - 2013-11-08
### Added
- Added custom error bar option to charts.
### Fixed
- Fix for tables added in non-sequential order.
- Fix for scatter charts with markers on non-marker series.
## [0.72] - 2013-08-28
### Fixed
- Fix for charts and images that cross rows and columns that are
hidden or formatted but which don’t have size changes.
## [0.71] - 2013-08-24
### Fixed
- Fixed issue in image handling.
- Added fix to ensure formula calculation on load regardless of
Excel version.
## [0.70] - 2013-07-30
### Fixed
- Fix for rendering images that are the same size as cell boundaries.
GitHub issue #70.
- Added fix for inaccurate column width calculation.
### Added
- Added Chart line smoothing option.
Changelog.md view on Meta::CPAN
## [0.29] - 2011-10-05
### Added
- Added the merge_range_type() method for finer control over the types
written using merge_range().
## [0.28] - 2011-10-04
### Added
- Added default write_formula() value for compatibility with Google docs.
- Updated Example.pm docs with Excel 2007 images.
## [0.27] - 2011-10-02
### Added
- Excel::Writer::XLSX is now 100% functionally and API compatible
with Spreadsheet::WriteExcel.
- Added outlines and grouping functionality.
- Added outline.pl and outline_collapsed.pl example programs.
## [0.26] - 2011-10-01
### Added
- Added cell comment methods and options.
Thanks to Barry Downes for providing the interim functionality
- Added comments1.pl and comments2.pl example programs.
## [0.25] - 2011-06-16
### Added
- Added option to add defined names to workbooks and worksheets.
Added defined_name.pl example program.
### Fixed
- Fix for fit_to_pages() with zero values.
Reported by Aki Huttunen.
## [0.24] - 2011-06-11
### Added
- Added data validation and data_validate.pl example.
- Added the option to turn off data series in chart legends.
## [0.23] - 2011-05-26
### Fixed
- Fix for charts ranges containing empty values.
## [0.22] - 2011-05-22
### Added
- Added 'reverse' option to set_x_axis() and set_y_axis() in
charts.
## [0.21] - 2011-05-11
### Fixed
- Fixed support for filehandles.
### Added
- Added write_to_scalar.pl and filehandle.pl example programs.
## [0.20] - 2011-05-10
### Fixed
- Fix for programs running under taint mode.
### Added
- Added set_tempdir().
### Fixed
- Fix for color formatting in chartsheets.
## [0.19] - 2011-05-05
### Added
- Added new chart formatting options for line properties,
markers, trendlines and data labels. See Chart.pm.
- Added partial support for insert_image().
- Improved backward compatibility for deprecated methods
store_formula() and repeat_formula().
### Fixed
( run in 1.175 second using v1.01-cache-2.11-cpan-364913b4093 )