- updated to 1.12
see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes
1.12 2024-02-26
+ Added support for embedding images into worksheets with
worksheet `embed_image()`.
This can be useful if you are building up a spreadsheet of products with
a column of images for each product. Embedded images move with the cell
so they can be used in worksheet tables or data ranges that will be
sorted or filtered.
This functionality is the equivalent of Excel's menu option to insert an
image using the option to "Place in Cell" which is available in Excel
365 versions from 2023 onwards.
+ Added support for Excel 365 `IMAGE()` future.
+ Added trendline equation formatting for Charts.
+ Added support for leader lines to all chart types.
+ Added chart option to display `N/A` as empty cells.
+ Add support for `invert_if_negative` color option in Charts.
+ Added worksheet `very_hidden()` method to hide a worksheet in a way that
it can only be unhidden by VBA. Feature Request #228.
! Fixed identation and alignment property mismatch.
Fix issue where a horizontal alignment format was ignored if the
indentation was also set.
OBS-URL: https://build.opensuse.org/request/show/1153710
OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-Excel-Writer-XLSX?expand=0&rev=28
- updated to 1.11
see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes
1.11 2023-03-19
+ Added support for simulated worksheet `autofit()`.
+ Refactored internal column property handling to allow column ranges
to be overridden (a common UX expectation).
+ Add `quote_prefix` format property.
! Add fix for forward/backward slash issue on Windows perl builds.
Possibly introduced by a change in File::Find. Issue #284
! Fix for duplicate number formats. Issue #283
! Add fix for worksheets with tables and background images.
! Replace/fix the worksheet protection password algorithm
so that is works correctly for strings over 24 chars.
OBS-URL: https://build.opensuse.org/request/show/1076934
OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-Excel-Writer-XLSX?expand=0&rev=27
- 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.
OBS-URL: https://build.opensuse.org/request/show/893498
OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-Excel-Writer-XLSX?expand=0&rev=25
- 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.
OBS-URL: https://build.opensuse.org/request/show/883236
OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-Excel-Writer-XLSX?expand=0&rev=24
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.
OBS-URL: https://build.opensuse.org/request/show/810782
OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-Excel-Writer-XLSX?expand=0&rev=20
- 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.
OBS-URL: https://build.opensuse.org/request/show/759720
OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-Excel-Writer-XLSX?expand=0&rev=19
- 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.
OBS-URL: https://build.opensuse.org/request/show/743803
OBS-URL: https://build.opensuse.org/package/show/devel:languages:perl/perl-Excel-Writer-XLSX?expand=0&rev=17
