1Revision history for Perl module Spreadsheet::WriteExcelXML. 2 3This module is depreacated. Use Excel::Writer::XLSX instead. See the 4DEPRECATED NOTICE in the main documention. 5 6 70.15 2021-03-29 8 9 ! Fix for failing test with perls compiled with usequadmath. 10 Reported by H.Merijn Brand 11 12 130.14 2012-07-12 14 15 ! Fix for hash randomisation bug under perl 5.17.6. 16 Reported by Andreas Koenig RT#81766. 17 18 190.13 2011-26-02 20 21 ! This module is now deprecated in favour of Excel::Writer::XLSX. 22 23 240.12 2011-04-01 25 26 ! Minor fix for set_bold() without argument. 27 Reported by Lukasz I. 28 29 300.11 2010-21-03 31 32 + Increased row and column limits to Excel 2007's limits of 33 1,048,576 x 16,384. Older limits of 65536 x 256 can still 34 be imposed via the use_lower_cell_limits() method. 35 Added additional tests for new limits. 36 Thanks David Ashirov. 37 38 390.10 2005-29-04 40 41 + Added autofilter option via the autofilter() and filter_column() 42 worksheet methods. 43 44 + Added autofilter.pl example program and tests. 45 46 470.09 2005-23-04 48 49 + Added write_html_string() method to allow multiple formats to 50 be added to a cell via Html formatting. 51 Added html_string.pl example and test case. 52 53 + Added write_comment() method to allow cell comments. 54 Added comment.pl example and test case. 55 56 ! Fixed bug with contiguous merged ranges. Thanks Mike Trotman. 57 Updated test 32_merge.t. 58 59 ! Fixed bug where screen gridlines couldn't be turned off. 60 Thanks Mike Trotman. 61 Updated test 34_page_setup.t. 62 63 640.08 2004-01-12 65 66 + Enabled the Page Setup methods as per Spreadsheet::WriteExcel: 67 set_landscape() 68 set_portrait() 69 set_paper() 70 center_horizontally() 71 center_vertically() 72 set_margins() 73 set_header() 74 set_footer() 75 repeat_rows() 76 repeat_columns() 77 hide_gridlines() 78 print_row_col_headers() 79 print_area() 80 fit_to_pages() 81 set_print_scale() 82 set_h_pagebreaks() 83 set_v_pagebreaks() 84 85 + Added the print_gridlines() method since printed gridlines are 86 off by default in Excel XML. This option was also available via 87 the less obvious hide_gridlines() method. 88 89 + Added the headers.pl example. 90 91 + Added page_setup tests 34_page_setup.t, 35_print_area.t and 92 36_print_repeat.t. 93 94 950.07 2004-11-11 96 97 + Added automatic Unicode handling via utf8 in perl 5.8 and 98 later. 99 Added several unicode_*.pl examples in different encodings. 100 Thanks to Sean Burke for the sample encodings. 101 102 + Added add_write_handler() method to allow users to add 103 their own data handlers to write(). 104 105 + Added write_handler examples. 106 107 + Added write_to_scalar.pl example in order to answer frequently 108 asked question about writing an Excel file to a scalar. 109 110 + Added indent.pl, mod_perl1.pl, mod_perl2.pl and diag_border.pl 111 examples. 112 113 1140.06 2004-19-08 115 116 + Enabled merge_range() as per Spreadsheet::WriteExcel. 117 118 + Added merge.t test for the above behaviour. 119 120 + Added merge1.pl to merge5.pl examples. 121 122 ! Renamed the Excel 5 style merge() format to the more correct 123 center_across(). 124 125 + Added support for array formulas as suggested by 126 Masaaki Hirose. 127 128 + Added array_formula.t test for the above behaviour. 129 130 + Added array_formula.pl example. 131 132 1330.05 2004-02-07 134 135 ! Fixed bug with implicit <Cell> ss:Index attribute. 136 137 + Added index.t test for the above behaviour. 138 139 1400.04 2004-01-07 141 142 ! Added XML escape for "\n" and test. Used in set_text_wrap(). 143 Thanks to Masaaki Hirose and Marc Rosenthal for reports. 144 145 + Enabled set_row() as per Spreadsheet::WriteExcel. 146 147 + Enabled set_column() as per Spreadsheet::WriteExcel. 148 149 + Added tests for set_row() and set_column(). 150 151 1520.03 2004-13-05 153 154 + Added write_date_time() to write dates in Excel XML's 155 simplified ISO8601 format. 156 157 + Enabled write_url() as per Spreadsheet::WriteExcel. 158 159 + Added hyperlink.pl and date_time.pl examples. 160 161 + Added web_component.pl example. 162 163 + Added tests for write_date_time(). 164 165 1660.02 2004-25-04 167 168 ! Fixed a Windows case insensitive bug. 169 170 1710.01 2004-24-04 172 173 First CPAN release. 174 175 + Write strings. 176 177 + Write numbers. 178 179 + Write formulas. 180 181 + Formatting. 182