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