Releases: jmcnamara/libxlsxwriter
1.2.1 February 26 2025
-
Added the
workbook_set_size()
function to set the size of the window when
the file is opened. This is generally only useful on macOS since Microsoft
Windows uses the window size from the last time an Excel file was
opened/saved. Feature request #472. -
Improved the cmake build support for using the
minizip
library.
Pull request #471.
1.2.0 January 11 2025
- Added
format_set_font_family()
andformat_set_font_charset()
format functions to support Middle Eastern and Asian fonts.
1.1.9 October 24 2024
- Fix minor pointer/value error in
lxw_name_to_row()
andlxw_name_to_col()
utility functions.
1.1.8 July 31 2024
-
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. -
Fixed various issues:
- Failure on 32bit architectures #441
- workbook_validate_sheet_name buffer-overflow #442
- workbook_add_worksheet does not return a reasonable worksheet #443
- workbook_define_name stack-buffer-underflow #444
- workbook_close stack-buffer-overflow #445
- _store_array_formula heap-buffer-overflow #446
- worksheet_set_selection stack-buffer-overflow #447
1.1.7 April 5 2024
- Bump
.so
version to 6. This was missed in the previous release.
1.1.6 April 4 2024
-
Updated vendored version of minizip to v 1.3.0 to include upstream fixes.
Feature request #419.
-
Added
quote_prefix
format property.Feature request #385.
-
Added support for signed VBA projects.
-
Fix worksheet password hashing algorithm for long passwords. Replace/fix
the worksheet protection password algorithm so that is works correctly
for strings over 24 chars. -
Fix cmake minizip version check.
Feature request #405.
-
Fix for buffer overflow with utf-8 strings in data validation.
Feature request #394.
-
Fix for range in text type conditional format.
Feature request #395.
-
Fix 32bit multiply with overflow issue for images.
Fix multiply with overflow issue when image locations in the worksheet
were greater than the u32 max value. -
Added Swift package manager support.
-
Added support for building Zig library.
1.1.5 December 30 2022
-
Added support for writing a workbook to a memory buffer instead of to a file
via theoutput_buffer
parameter ofworkbook_new_opt()
. -
Add support for using in-memory data instead of temporary files on systems where
fmemopen()
andopen_memstream()
are supported. This requires theUSE_MEM_FILE
compilation option.
1.1.4 October 9 2021
-
Added support for Worksheet tables. Tables in Excel are a way of grouping a
range of cells into a single entity that has common formatting or that can
be referenced from formulas. Tables can have column headers, autofilters,
total rows, column formulas and default formatting. -
Added support for adding a macro button to a worksheet.
1.1.3 August 9 2021
- Changed worksheet_filter_column2() parameter name "operator" to "and_or" to
avoid a conflict with the C++ reserved keyword.
1.1.2 August 8 2021
-
Added support for autofilter rules.
-
Added Description/Alt Text and Decorative accessibility options for
charts. These options were already available for images.