Revision history for Perl module Excel::Writer::XLSX. + New feature. - Removed/deprecated feature. ! Bug fix. 0.44 January 5 2012 ! Fix for missing return value from Workbook::close() with filehandles. RT 73724. Reported and patched by Charles Bailey. ! Fixed support special filename/filehandle '-'. RT 73424. Reported by YuvalL and Charles Bailey. ! Fix for non-working reverse x_axis with Scatter charts. Reported by Viqar Abbasi. 0.43 December 18 2011 + Added chart axis label position option. + Added invert_if_negative option for chart series fills. 0.42 December 17 2011 ! Fix for set_optimization() where first row isn't 0. Reported by Giulio Orsero. ! Fix to preserve whitespace in inline strings. Reported by Giulio Orsero. 0.41 December 10 2011 ! Increased IO::File requirement to 1.14 to prevent taint issues on some 5.8.8/5.8.6 platforms. 0.40 December 7 2011 ! Fix for unreadable xlsx files when generator program has -l on the commandline or had redefined $/. Github issue #7. Reported by John Riksten. 0.39 December 3 2011 ! Fix for spurious Mac ._Makefile.PL in the distro which prevented automated testing and installation. Github issue #5. Reported by Tobias Oetiker. ! Fix for failing test sub_convert_date_time.t due to extra precision on longdouble perls. RT #71762 Reported by Douglas Wilson. 0.38 December 3 2011 + Backported from perl 5.10.0 to perl 5.8.2. You are killing me guys. Killing me. 0.37 December 2 2011 + Added additional axis options: minor and major units, log base and axis crossing. 0.36 November 29 2011 + Added "min" and "max" options to axis ranges via set_x_axis() and set_y_axis. 0.35 November 27 2011 + Added Scatter chart subtypes: markers_only (the default), straight_with_markers, straight, smooth_with_markers and smooth. 0.34 November 4 2011 + Added set_optimization() method to reduce memory usage for very large data sets. 0.33 October 28 2011 + Added addition conditional formatting types: cell, date, time_period, text, average, duplicate, unique, top, bottom, blanks, no_blanks, errors, no_errors, 2_color_scale, 3_color_scale, data_bar and formula. 0.32 October 20 2011 ! Fix for format alignment bug. Reported by Roderich Schupp. 0.31 October 18 2011 + Added basic conditional formatting via the conditional_format() Worksheet method. More conditional formatting types will follow. + Added conditional_format.pl example program. 0.30 October 6 2011 + Added stacked and percent_stacked chart subtypes to Bar and Column chart types. 0.29 October 5 2011 + Added the merge_range_type() method for finer control over the types writen using merge_range(). 0.28 October 4 2011 + Added default write_formula() value for compatibility with Google docs. + Updated Example.pm docs with Excel 2007 images. 0.27 October 2 2011 + 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 October 1 2011 + 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 June 16 2011 + Added option to add defined names to workbooks and worksheets. Added defined_name.pl example program. ! Fix for fit_to_pages() with zero values. Reported by Aki Huttunen. 0.24 June 11 2011 + Added data validation and data_validate.pl example. + Added the option to turn off data series in chart legends. 0.23 May 26 2011 ! Fix for charts ranges containing empty values. 0.22 May 22 2011 + Added 'reverse' option to set_x_axis() and set_y_axis() in charts. 0.21 May 11 2011 ! Fixed support for filehandles. + Added write_to_scalar.pl and filehandle.pl example programs. 0.20 May 10 2011 ! Fix for programs running under taint mode. + Added set_tempdir(). ! Fix for color formatting in chartsheets. 0.19 May 5 2011 + 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 missing formatting for array formulas. Reported by Cyrille Gourves. ! Fixed issue with chart scaling that caused "unreadable content" Excel error. 0.18 April 7 2011 + Added set_properties() method to add document properties. Added properties.pl and tests. 0.17 April 4 2011 + Added charting feature. See Chart.pm. ! Fix for file corruption issue when there are more than 10 custom colours. Reported by Brian R. Landy. 0.16 March 4 2011 ! Clarified support for deprecated methods in documentation and added backward compatible methods in some cases. ! Fix for center_horizontally() issue. Reported by Giulio Orsero. ! Fix for number like strings getting written as strings instead of numbers. Reported by Giulio Orsero. 0.15 March 1 2011 ! Fix for issues with set_row() not passing on format to cells in the row. Reported by Giulio Orsero. ! Fixes for related issue in set_column(). 0.14 February 26 2011 + Added write_rich_string() method to write a string with multiple formats. + Added rich_strings.pl example program. + Added set_1904() method for dates with a 1904 epoch. + Added date_time.pl example program. ! Fixed issue where leading and trailing whitespace in cell strings wasn't preserved. 0.13 February 22 2011 + Added additional page setup methods: set_zoom() right_to_left() hide_zero() set_custom_color() set_tab_color() protect() + Added Cell property methods: set_locked() set_hidden() + Added example programs: hide_sheet.pl protection.pl right_to_left.pl tab_colors.pl 0.12 February 19 2011 + Added set_selection() method for selecting cells. 0.11 February 17 2011 ! Fix for temp dirs not been removed after xlsx file creation. http://rt.cpan.org/Ticket/Display.html?id=65816 Reported by Andreas Koenig. 0.10 February 17 2011 + Added freeze_panes() and split_panes(). + Added panes.pl example program. 0.09 February 13 2011 + Added write_url() for internal and external hyperlinks. + Added hyperlink1+2.pl example programs. 0.08 February 3 2011 + Added autofilter(), column_filter() and column_filter_list() methods. + Added autofilter.pl example program. 0.07 January 28 2011 + Added additional Page Setup methods. set_page_view() repeat_rows() repeat_columns() hide_gridlines() print_row_col_headers() print_area() print_across() fit_to_pages() set_start_page() set_print_scale() set_h_pagebreaks() set_v_pagebreaks() + Added headers.pl example program. 0.06 January 19 2011 ! Added fix for XML characters in attributes. Reported by John Roll. + Added initial Page Setup methods. set_landscape() set_portrait() set_paper() center_horizontally() center_vertically() set_margins() set_header() set_footer() 0.05 January 4 2011 + Added support for array_formulas. See the docs for write_array_formula() and the example program. 0.04 January 3 2011 + Added merge_range() for merging cells. With tests and examples. 0.03 January 3 2011 + Optimisations. The module is now 100% faster. 0.02 October 12 2010 ! Fixed dependencies in Makefile. 0.01 October 11 2010 First CPAN release.