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

241 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
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
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
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
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
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
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
1b5493e660 Test for dupliate images with hyperlinks. 2020-02-07 21:22:14 +00:00
John McNamara
139cd8cc41 Added support for object positioning. 
Added support for setting the image or chart object_position
property to specify if they should be moved or sized with cell.

Issue #263
 2020-01-19 11:23:58 +00:00
John McNamara
2849813f36 Updated copyright year. 2020-01-12 12:59:31 +00:00
John McNamara
db582a7ae4 Fix for default worksheet VBA codenames. 
Issue #256
 2020-01-11 16:38:43 +00:00
John McNamara
87df446d49 Added support for cell comments in constant_memory mode. 
Added support for cell comments in constant_memory mode
and also refactored the internal data structure for
handling comments.

Issue #38
 2020-01-11 09:02:07 +00:00
John McNamara
6ab739e9d2 Fix for issue with default comment font. 2020-01-08 23:16:56 +00:00
John McNamara
85dfccd734 Added support for cell comments and options. 
Issue #38
 2020-01-07 23:27:04 +00:00
John McNamara
1290420818 Working image duplicate removal. 2019-12-26 16:12:36 +00:00
John McNamara
a4f9e5bad0 Initial image duplicate removal. Same worksheet only. 2019-12-24 19:17:17 +00:00
John McNamara
373ff53382 Support newer Excel hyperlink length of 2079. 2019-12-15 13:05:52 +00:00