./textproc/libxlsxwriter, C library for creating Microsoft Excel files

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: CURRENT, Version: 1.1.4, Package name: libxlsxwriter-1.1.4, Maintainer: sjmulder

C library that can be used to write text, numbers, formulas and hyperlinks to
multiple worksheets in a Microsoft Excel 2007+ XLSX file.

It supports features such as full formatting support, merged cells, defined
names, autofilters and charts.


Required to build:
[pkgtools/cwrappers]

Master sites:

Filesize: 19963.086 KB

Version history: (Expand)


CVS history: (Expand)


   2021-11-19 23:13:32 by Sijmen J. Mulder | Files touched by this commit (5)
Log message:
textproc/libxlsxwriter: Update to 1.1.4

Changes:
 - 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. See working_with_tables and tables.c.
 - Added support for adding a macro button to a worksheet. See macro.c.

Package changes:
 - Fixed test target (missing py.test version suffix).
   2021-10-26 13:23:42 by Nia Alarie | Files touched by this commit (1161)
Log message:
textproc: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes

Unfetchable distfiles (fetched conditionally?):
./textproc/convertlit/distinfo clit18src.zip
   2021-10-07 17:02:49 by Nia Alarie | Files touched by this commit (1162)
Log message:
textproc: Remove SHA1 hashes for distfiles
   2021-08-10 14:05:40 by Sijmen J. Mulder | Files touched by this commit (2)
Log message:
textproc/libxlsxwriter: Update to 1.1.3

Fixes use of reserved C++ 'operator' keyword.
   2021-08-09 09:05:23 by Sijmen J. Mulder | Files touched by this commit (4)
Log message:
textproc/libxlsxwriter: Update to 1.1.2

- Added support for autofilter rules.
- Added Description/Alt Text and Decorative accessibility options for
  charts. These options were already available for images
- Fix incorrect use of LDFLAGS when building object files.
- Fix for not using LDFLAGS when linking tests.
- Fix time type, Excel always needs 64-bit values so time_t is not
  always sufficient.
- Fix minor const issue.
   2021-07-26 03:02:12 by Sijmen J. Mulder | Files touched by this commit (4)
Log message:
libxlsxwriter: Update to 1.1.1

Packaging changes:
 - Now uses pkgsrc or system libraries instead of bundled (minizip, md5).

Upstream changes:

1.1.1
- Added optional third party library to handle sprintf handling of
  doubles. This is to avoid issues with number formatting in some locales. The
  optional library is the Milo Yip DTOA implementation.
- Added the LXW_EXPLICIT_FALSE variable to allow the default bold property in
  chart title fonts to be turned off.

1.1.0
- Fix for Cocoapod issue where local md5 files conflicted with BoringSSL headers.

1.0.9
- Added support for Excel 365 dynamic arrays. See
  worksheet_write_dynamic_array_formula() worksheet_write_dynamic_formula()
  and ww_formulas_dynamic_arrays.

1.0.8
- Fix for dynamic library soname on Linux.

1.0.7
- Added support for writing Unix date/times via the
  worksheet_write_unixtime() function.
- Added support for dynamic library soname version to help packagers and build
  systems differentiate ABI versions.

1.0.6
- Added support for using OpenSSL MD5 functions instead of built in third
  party library. See gsg_md5.

1.0.5
- Added support for worksheet background images via
  worksheet_set_background().

1.0.4
- Added support for GIF image files (and in Excel 365, animated GIF files).

1.0.3
- Added some fixes to make the library compile more cleanly as an R library.

1.0.2
- Added option to set row heights and column widths in pixels via the
  worksheet_set_row_pixels() and worksheet_set_column_pixels() functions.

1.0.1 March 30 2021
- Added support for pkg-config to Make/Cmake installs. See the
  gsg_using section of the Getting Started guide.
- Added ability to add accessibility options "description" and \ 
"decorative" to
  images via worksheet_insert_image_opt() and lxw_image_options.
- Added the workbook_read_only_recommended() function to set the Excel
  "Read-only Recommended" option that is available when saving a file.
- Fixed issue where pattern formats without colors were given a default black
  fill color.
- Added option to set a chart crossing to 'min' via
  chart_axis_set_crossing_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 some additional information on using constant_memory mode with memory
  mounted /tmp directories. See ww_mem_temp.
- Added build option to compile libxlsxwriter as a "universal binary" \ 
for both
  Apple silicon and Intel-based Macs, i.e., arm64 and x86_64. See
  gsg_universal.
- Fixed issue where the limit for header/footer strings was
  255 bytes instead of 255 characters and as a result UTF8
  strings were being truncated.
   2020-10-01 23:10:42 by Sijmen J. Mulder | Files touched by this commit (3)
Log message:
textproc/libxlsxwriter: Update to 1.0.0

Changes:
 - Added support for worksheet conditional formatting.
 - Added performance optimization for search for control characters in
   strings in worksheet_write_string().
 - Made lxw_datetime_to_excel_datetime() a function public.
 - There are now over 1000 test cases, including 650 tests that compare
   the output from libxlsxwriter, byte for byte, against test files
   created in Excel. This is also the 100th release of libxlsxwriter.

Package changes:
 - Disable hardcoded -O3
   2020-08-24 00:27:52 by Sijmen J. Mulder | Files touched by this commit (3)
Log message:
textproc/libxlsxwriter: Update to 0.9.9

Changes in 0.9.6:
 - Added support for chart custom data labels.
 - Fix for issue where array formulas weren't included in the output
   file for certain ranges/conditions. Issue #735.

Changes in 0.9.7:
 - Changed #lxw_chart_data_label field from .delete to .hide in order to
   avoid reserved word conflict with C++. Issue #300

Changes in 0.9.8:
 - Added formatting for chart data labels and chart custom data labels.

Changes in 0.9.9:
 - Added support for images in headers and footers. See
   worksheet_set_header_opt().
 - Added worksheet_ignore_errors() function to ignore Excel worksheet
   errors/warnings in user defined ranges.