Commit graph

340 commits

Author SHA1 Message Date
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
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
John McNamara
dcecc632d5 Added support for hyperlinks from images. 2019-12-15 00:11:44 +00:00
John McNamara
f26aeacb86 Add default hyperlink format as a style. 2019-12-11 00:39:11 +00:00