------------------------------------------------------------------- Sat Dec 31 03:08:02 UTC 2022 - Tina Müller - updated to 1.10 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes ------------------------------------------------------------------- Sat May 15 03:07:28 UTC 2021 - Tina Müller - updated to 1.09 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 1.08 2021-03-31 + Added support for background images in worksheets. See set_background(). + Added support for GIF image files (and in Excel 365, animated GIF files). + Added support for pixel sizing in set_row() and set_column() via new functions called set_row_pixels() and set_column_pixels(). + Added initial support for dynamic arrays in formulas. ------------------------------------------------------------------- Thu Apr 1 03:06:44 UTC 2021 - Tina Müller - updated to 1.08 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 1.08 2021-03-31 + Added ability to add accessibility options "description" and "decorative" to images via insert_image(). + Added the workbook read_only_recommended() method to set the Excel "Read-only Recommended" option that is available when saving a file. + Added option to set a chart crossing to 'min' as well as the existing 'max' option. The 'min' option isn't available in the Excel interface but can be enabled via VBA. + Added option to unprotect ranges in protected worksheets. + Added check, and warning, for worksheet tables with no data row. Either with or without a header row. + Added ignore_errors() worksheet method to ignore Excel worksheet errors/warnings in user defined ranges. ! Fixed issue where pattern formats without colours where given a default black fill colour. ! Fix issue where custom chart data labels didn't inherit the position for the data labels in the series. ! Fixed issue with relative url links in images. ! Fixed issue where headers/footers were restricted to 254 characters instead of 255. ------------------------------------------------------------------- Fri Aug 7 03:08:46 UTC 2020 - Tina Müller - updated to 1.07 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 1.07 2020-08-06 + Added support for Border, Fill, Pattern and Gradient formatting to chart data labels and chart custom data labels. ------------------------------------------------------------------- Tue Aug 4 03:09:55 UTC 2020 - Tina Müller - updated to 1.06 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 1.06 2020-08-03 ! Fix for issue where array formulas weren't included in the output file for certain ranges/conditions. ------------------------------------------------------------------- Fri Jul 31 03:09:03 UTC 2020 - Tina Müller - updated to 1.05 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 1.05 2020-07-30 + Added support for custom data labels in charts. ------------------------------------------------------------------- Mon Jun 1 03:10:06 UTC 2020 - Tina Müller updated to 1.04 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 1.04 2020-05-31 + Added support for "stacked" and "percent_stacked" Line charts. ! Fix for worksheet objects (charts and images) that are inserted with an offset that starts in a hidden cell. ! Fix for issue with default worksheet VBA codenames. - Removed error in add_worksheet() for sheet name "History" which is a reserved name in English version of Excel. However, this is an allowed worksheet name in some Excel variants so the warning has been turned into a documentation note instead. ------------------------------------------------------------------- Fri Dec 27 03:09:39 UTC 2019 - - updated to 1.03 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 1.03 2019-12-26 + 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 behaviour. ------------------------------------------------------------------- Fri Nov 8 10:50:29 UTC 2019 - - updated to 1.02 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 1.02 2019-11-07 + Added support for hyperlinks in worksheet images. + Increased allowable url length from 255 to 2079 characters, as allowed in more recent versions of Excel. ------------------------------------------------------------------- Tue Oct 29 09:39:59 UTC 2019 - - updated to 1.01 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 1.01 2019-10-28 + 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 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. ------------------------------------------------------------------- Mon Apr 8 05:05:47 UTC 2019 - Stephan Kulow - updated to 1.00 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 1.00 2019-04-07 ! 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 XlsxWriter files since it expected the "[Content_types]" to be the first file in the zip container. ------------------------------------------------------------------- Mon Feb 11 06:08:33 UTC 2019 - Stephan Kulow - updated to 0.99 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 0.99 2019-02-10 + 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. ! Fix for issue with special characters in worksheet table functions. ! Fix handling of 'num_format': '0' in duplicate formats. ------------------------------------------------------------------- Sat Apr 21 05:18:40 UTC 2018 - coolo@suse.com - updated to 0.98 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 0.98 2018-04-14 + 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. 0.97 2018-04-10 + 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 colour after they are clicked. ! Fixed missing plotarea formatting in pie/doughnut charts. ------------------------------------------------------------------- Sun Sep 17 05:25:42 UTC 2017 - coolo@suse.com - updated to 0.96 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 0.96 2017-09-16 + Added icon sets to conditional formatting. Feature request #116. ------------------------------------------------------------------- Mon Jun 13 07:03:13 UTC 2016 - coolo@suse.com - updated to 0.95 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 0.95 2016-06-13 + Added workbook set_size() method. Feature request #59. ------------------------------------------------------------------- Sun Jun 12 13:00:39 UTC 2016 - coolo@suse.com - updated to 0.94 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 0.94 2016-06-07 + Added font support to chart tables. Feature request #96. 0.93 2016-06-07 + Added trendline properties: intercept, display_equation and display_r_squared. Feature request #153. 0.92 2016-06-01 ! Fix for insert_image issue when handling images with zero dpi. ------------------------------------------------------------------- Tue May 31 10:20:26 UTC 2016 - coolo@suse.com - updated to 0.91 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 0.91 2016-05-31 + Add set_custom_property() workbook method to set custom document properties. ------------------------------------------------------------------- Mon May 23 11:48:26 UTC 2016 - coolo@suse.com - updated to 0.90 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 0.90 2016-05-13 + Added get_worksheet_by_name() workbook method to retrieve a worksheet in a workbook by name. Feature request #124. ! Fixed issue where internal file creation and modification dates where in the local timezone instead of UTC. Issue #162. ! Fixed issue with "external:" urls with space in sheetname. ! Fixed issue where Unicode full-width number strings were treated as numbers in write(). Issue #160. ------------------------------------------------------------------- Thu May 5 09:14:33 UTC 2016 - coolo@suse.com - updated to 0.89 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 0.89 2016-04-16 + Added write_boolean() worksheet method to write Excel boolean values. ------------------------------------------------------------------- Tue Jan 19 09:51:43 UTC 2016 - coolo@suse.com - updated to 0.88 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 0.88 2016-01-14 + Added transparency option to solid fills in chart areas. + Added options to configure chart axis tick placement. Feature request #158. ------------------------------------------------------------------- Wed Jan 13 09:53:54 UTC 2016 - coolo@suse.com - updated to 0.87 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 0.87 2016-01-12 + Added chart pattern and gradient fills. + Added option to set chart tick interval. + Add checks for valid and non-duplicate worksheet table names. + Added support for table header formatting and a fix for wrapped lines in the header. ------------------------------------------------------------------- Wed Oct 21 08:54:16 UTC 2015 - coolo@suse.com - updated to 0.86 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 0.86 2015-10-19 ! Fix to allow chartsheets to support combined charts. ! Fix for images with negative offsets. + Allow hyperlinks longer than 255 characters when the link and anchor are each less than or equal to 255 characters. + Added hyperlink_base document property. + Added option to allow data validation input messages with the ‘any’ validate parameter. Issue #144. + Added "stop if true" feature to conditional formatting. Issue #138. + Added better support and documentation for html colours throughout the module. The use of the Excel97 colour palette is supported for backward compatibility but deprecated. Issue #97. ------------------------------------------------------------------- Tue Sep 15 08:44:15 UTC 2015 - coolo@suse.com - updated to 0.85 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 0.85 2015-08-05 ! Fixes for new redundant sprintf arguments warnings in perl 5.22. Issue #134. ! Fix url encoding of links to external files and dirs. ------------------------------------------------------------------- Wed Apr 22 06:12:12 UTC 2015 - coolo@suse.com - updated to 0.84 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes 0.84 2015-04-21 + Added support for chart axis display units (thousands, million, etc.). + Added option to set printing in black and white. Issue #125. + Added chart styles example. + Added gradient fill support. + Added support for clustered charts. + Added support for boolean error codes. ------------------------------------------------------------------- Tue Apr 14 20:25:35 UTC 2015 - coolo@suse.com - updated to 0.83 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes ------------------------------------------------------------------- Sat Dec 03 22:43:10 CET 2011 - pascal.bleser@opensuse.org - initial version (0.39)