github-starred/libxlsxwriter
2
0
Fork 0
mirror of https://github.com/jmcnamara/libxlsxwriter.git synced 2026-05-15 22:02:06 -06:00
Code Issues 16 Projects Packages Wiki Activity Actions
853 commits 51 branches 124 tags 28 MiB
Commit graph

301 commits

Author SHA1 Message Date
John McNamara
3fcccedd06 Added support for adding a macro button to a worksheet. 
Feature request #39
 2021-08-26 23:44:22 +01:00
John McNamara
6d6d99eeaf Added support for worksheet tables. 
Feature request #33
 2021-08-19 22:54:59 +01:00
John McNamara
dd9b177235 Add test for C++ compilation and includes. 2021-08-10 22:55:14 +01:00
John McNamara
431f4839f9 Add filter rules for autofilters. 
Feature request #254
 2021-08-02 23:49:05 +01:00
John McNamara
ed47b1fbb8 Added addition accessibility options for worksheet charts. 
Added Description/Alt Text and Decorative accessibility options for charts.
These options were already available for images.
 2021-07-28 14:10:16 +01:00
John McNamara
9402191bc1 Fix for unixtime type size. 
The size of thetime_h type used with worksheet_write_unixtime()
wasn't sufficient to represent the full range of Excel's dates.
The parameter in question has been extended to int64_t.

Issue #347
 2021-07-27 17:28:10 +01:00
Sijmen J. Mulder
b2b7000c42 Respect LDFLAGS when linking tests 
Otherwise it's not possible to link e.g. system minizip if it's outside
the default search paths.
 2021-07-27 16:40:48 +01:00
John McNamara
bda599d033 Added optional third party dtoa library. 
Added the optional Milo Yip DTOA library (emyg_dtoa) to avoid
issues where the standard sprintf() dtoa function changes output
based on locale settings. It is also 40-50% faster than the
standard dtoa for raw numeric data.

If you wish to use this third party library you can compile
libxlsxwriter with it by passing `USE_DTOA_LIBRARY=1` to
make. The USE_DOUBLE_FUNCTION build variable is no longer used.

Imported source from https://github.com/miloyip/dtoa-benchmark

Feature request #272
 2021-07-12 23:09:52 +01:00
John McNamara
393ded9a2d Add option to turn off bold in chart title font. 
Added the LXW_EXPLICIT_FALSE variable to allow the default bold
property in chart title fonts to be turned off.

Closes #199
 2021-07-12 22:33:11 +01:00
John McNamara
d72da755f0 Add docs and examples for dynamic arrays. 
Feature request #327
 2021-07-07 23:33:26 +01:00
John McNamara
4fcdd7b26d Updated copyright year. 2021-07-01 23:57:09 +01:00
John McNamara
7f20142d47 Add extra unixtime test. 2021-07-01 23:25:54 +01:00
John McNamara
9b89841750 Add support for Unix datetimes. 2021-07-01 21:00:59 +01:00
John McNamara
412571bb92 Add build support for gcov coverage. 2021-06-06 20:09:21 +01:00
John McNamara
925a147fc1 Add support for using MD5 functions from OpenSSL. 
Feature request #335
 2021-05-27 23:35:59 +01:00
John McNamara
5f3647faa5 Test in-memory JPEG file. 2021-05-14 00:13:01 +01:00
John McNamara
af5115cbb5 Add support for worksheet background images. 2021-05-14 00:12:05 +01:00
John McNamara
e3fb0e2c32 Add support for GIF images. 2021-05-08 00:25:14 +01:00
John McNamara
019c8badc2 Added extra chart font axis test. 2021-04-25 13:47:25 +01:00
John McNamara
063f702593 Fix issue for y_axis font rotation of 0. 2021-04-23 20:54:09 +01:00
John McNamara
e478365508 Add initial support for dynamic arrays in formulas. 
Feature request #327
 2021-04-23 07:25:50 +01:00
John McNamara
e2795f601d Add support for pixel sizing of rows and columns. 
Added support for pixel sizing in worksheet_set_row() and
worksheet_set_column() via new functions called
worksheet_set_row_pixels() and worksheet_set_column_pixels().
 2021-04-15 19:53:01 +01:00
John McNamara
c718466194 Minor fix for ctest output. 2021-04-10 21:11:11 +01:00
John McNamara
3778da4d2d Add docs for new worksheet_insert_image_opt() fields. 
Add doc for new "description" and "decorative" fields for
worksheet_insert_image_opt().
 2021-03-28 21:02:40 +01:00
John McNamara
ae4e652e57 Added more tests for image descriptions. 2021-03-28 02:06:57 +01:00
John McNamara
29c5461610 Add option to set read-only mode when opening a file. 
Added the worksheet read_only_recommended() method to set the Excel
"Read-only Recommended" option that is available when saving a file.
 2021-03-27 20:36:13 +00:00
John McNamara
4090f66e79 Fix for format with pattern only. 
Fix issue where pattern formats without colours where given a
default black fill colour.
 2021-03-27 00:48:54 +00:00
John McNamara
83550882c6 Added 'min' crossing option to chart axes. 
Add 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.
 2021-03-26 17:01:00 +00:00
John McNamara
c06101fcad Updated copyright year. 2021-01-13 21:25:35 +00:00
John McNamara
110af3ff4d Fix for ignored position in chart custom data labels. 
Fix issue where custom chart data labels didn't inherit the position
for the data labels in the series.`
 2020-10-02 20:44:38 +01:00
John McNamara
38b8903228 Fix issue with relative url links in images. 2020-09-21 23:27:23 +01:00
John McNamara
c9f0fe6788 Fix for issue when UTF8 header/footer strings were truncated. 
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.

Closed #305
 2020-09-08 18:24:55 +01:00
John McNamara
13aebf962e Made lxw_datetime_to_excel_date() function public. 2020-09-07 23:35:30 +01:00
John McNamara
4b6c45982c Added implicit include paths to unit tests. 
Added implicit include paths to unit tests to avoid issues
when running paralled builds.
 2020-09-07 10:56:11 +01:00
John McNamara
e3d4bcaf7c Added docs for conditional formatting. 
Feature request #302
 2020-09-05 21:17:39 +01:00
John McNamara
5d4a571105 Added support for conditional formatting. 
Feature request #302
 2020-08-30 21:06:48 +01:00
John McNamara
f23d2e905e Added style/format handling for conditional formatting. 
Added style/format handling for conditional formatting. The
Actual conditional formatting hasn't been added yet to the
worksheet and those parts of the tests have been skipped, for now.
 2020-08-22 14:38:49 +01:00
John McNamara
017001fc14 Added support for images in headers/footers. 2020-08-17 21:01:36 +01:00
John McNamara
644d8630ed Added worksheet_ignore_errors() function. 
Added worksheet_ignore_errors() function to ignore Excel
worksheet errors/warnings in user defined ranges.
 2020-08-13 17:19:33 +01:00
John McNamara
7182ac3e47 Added formatting for custom chart data labels. 2020-08-10 19:11:51 +01:00
John McNamara
e5a6833382 Added formatting for chart data labels. 2020-08-07 00:50:09 +01:00
John McNamara
2e6f3d7cdf Change lxw_chart_data_label field from .delete to .hide. 
Change lxw_chart_data_label field from .delete to .hide in order
to avoid reserved word conflict with C++.

Issue #300
 2020-08-04 11:16:49 +01:00
John McNamara
f7dc5ba13b Added tests for worksheet range return values. 2020-08-03 23:39:18 +01:00
John McNamara
d4424a0e7b Fix issue with write_array_formula() cell range. 2020-08-03 23:38:47 +01:00
John McNamara
ca5c2b7cb9 Added support for custom chart data labels. 2020-08-01 17:50:06 +01:00
John McNamara
497eaaf389 Added worksheet_write_formula_str() function. 
Added worksheet_write_formula_str() function mainly to allow
a blank string result to be written for formulas and thus
force recalculation in OpenOffice.
 2020-07-31 00:07:36 +01:00
John McNamara
db556bf7e9 Fix for hyperlinks in image buffer images. 
Fix for issue where hyperlinks urls and tips were ignored for
worksheet_insert_image_buffer_opt() images.

Issue #292
 2020-05-31 13:39:02 +01:00
John McNamara
714d07dd39 Added stacked and percentr stacked line charts. 
Added LXW_CHART_LINE_STACKED and LXW_CHART_LINE_STACKED_PERCENT
line charts subtypes.
 2020-05-31 12:59:19 +01:00
John McNamara
a0e6a362ba Removed LXW_ERROR_SHEETNAME_RESERVED warning. 
Removed LXW_ERROR_SHEETNAME_RESERVED warning which was used with
the reserved worksheet name "History". However, this is an
allowed worksheet name in some Excel variants so the warning has
been turned into a documentation note instead.
 2020-03-21 17:40:08 +00:00
John McNamara
1b5493e660 Test for dupliate images with hyperlinks. 2020-02-07 21:22:14 +00:00