Revisions of perl-Excel-Writer-XLSX
Tina Müller (tinita)
committed
(revision 29)
Fix disabling of __perllib_provides
Dirk Stoecker (dstoecker)
accepted
request 1153710
from
Tina Müller (tinita)
(revision 28)
- 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.
Dirk Stoecker (dstoecker)
accepted
request 1076934
from
Tina Müller (tinita)
(revision 27)
- 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.
Dirk Stoecker (dstoecker)
accepted
request 1046352
from
Tina Müller (tinita)
(revision 26)
- updated to 1.10 see /usr/share/doc/packages/perl-Excel-Writer-XLSX/Changes
Stephan Kulow (coolo)
accepted
request 893498
from
Tina Müller (tinita)
(revision 25)
- 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.
Tina Müller (tinita)
accepted
request 883236
from
Tina Müller (tinita)
(revision 24)
- 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.
Dirk Stoecker (dstoecker)
accepted
request 824831
from
Tina Müller (tinita)
(revision 23)
- 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.
Dirk Stoecker (dstoecker)
accepted
request 824471
from
Tina Müller (tinita)
(revision 22)
- 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.
Dirk Stoecker (dstoecker)
accepted
request 823711
from
Tina Müller (tinita)
(revision 21)
- 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.
Dirk Stoecker (dstoecker)
accepted
request 810782
from
Tina Müller (tinita)
(revision 20)
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.
Lars Vogdt (lrupp)
accepted
request 759720
from
Tina Müller (tinita)
(revision 19)
- 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.
Tina Müller (tinita)
accepted
request 746556
from
Tina Müller (tinita)
(revision 18)
- 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.
Lars Vogdt (lrupp)
accepted
request 743803
from
Tina Müller (tinita)
(revision 17)
- 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.
Stephan Kulow (coolo)
accepted
request 692163
from
Stephan Kulow (coolo)
(revision 16)
automatic update
Stephan Kulow (coolo)
accepted
request 673235
from
Stephan Kulow (coolo)
(revision 15)
automatic update
Stephan Kulow (coolo)
accepted
request 599531
from
Stephan Kulow (coolo)
(revision 14)
automatic update
Stephan Kulow (coolo)
accepted
request 526599
from
Stephan Kulow (coolo)
(revision 13)
automatic update
Stephan Kulow (coolo)
accepted
request 401560
from
Stephan Kulow (coolo)
(revision 12)
automatic update
Stephan Kulow (coolo)
accepted
request 401417
from
Stephan Kulow (coolo)
(revision 11)
automatic update
Stephan Kulow (coolo)
accepted
request 399094
from
Stephan Kulow (coolo)
(revision 10)
automatic update
Displaying revisions 1 - 20 of 29