John McNamara
5c160dd4e8
Added worksheet_write_rich_string_html() function.
...
Added workaround/optimized worksheet_write_rich_string_html()
function to write raw rich string html. This avoid an expensive
file open()/close() in each call to worksheet_write_rich_string().
2020-08-21 21:20:23 +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
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
John McNamara
44bb2056e4
Initial working hyperlink style.
2019-12-10 00:10:13 +00:00
John McNamara
9880423443
Fix several hyperlink corner cases.
2019-12-08 23:12:44 +00:00
John McNamara
54a05386cd
Break hyperlinks into links and anchors.
2019-12-08 21:07:29 +00:00
John McNamara
0cfd73b9f6
Fix url encoding of links to external files and dirs.
2019-12-07 01:19:43 +00:00
John McNamara
3e3ce69aab
Made deprection of new_workbook() function explicit.
...
Made the deprecation of new_workbook() funtion more explicit
and removed instances from the examples and test code. The
workbook_new() function should be used instead.
See #252
2019-11-16 20:32:37 +00:00
John McNamara
035a3c6fdf
Refactored the insert image and chart APIs.
...
See #252
2019-11-11 20:56:00 +00:00
John McNamara
239f5afbd4
Allow user defined image descriptions
...
Allow user defined/override of the image description used by
worksheet_insert_image(), which defaults to the filename.
Issue #238
2019-10-12 05:14:48 +01:00
John McNamara
4e1ee88760
Add support for East Asian vertical chart fonts.
2019-08-31 17:32:54 +01:00
John McNamara
8ff6465f51
Add option to set chart font rotation as stacked.
...
Added the option to allow chart fonts to be rotation to 270 deg
to give a stacked orientation.
2019-08-24 09:55:47 +01:00
John McNamara
cb87c73a95
Initial support for adding macros to workbooks.
...
Initial support for adding macros extracted from existing xlsm
files to new xlsm files.
Issue #29 add_vba_project()
2019-06-16 15:46:09 +01:00
John McNamara
ebab9831b3
Refactor use_zip64 into the constructor.
...
Issue #228
2019-06-08 16:40:17 +01:00
John McNamara
e51eadae87
Fix issue with images in hidden cells.
...
Fix issue where images that started in hidden rows/cols weren't
placed correctly in the worksheet.
2019-04-07 14:25:35 +01:00
John McNamara
72c9b219cb
Updated copyright year.
2019-02-10 21:11:46 +00:00
John McNamara
ee941133ea
Additional formatting tests.
2019-02-10 21:06:49 +00:00
John McNamara
84dd312e79
Fix for issue when hashing number formats.
...
Issue #203
2018-10-30 23:16:32 +00:00
John McNamara
8df3ce882c
Add validation checks to worksheet_write_rich_string().
...
Issue #37
2018-10-01 21:30:32 +01:00
John McNamara
eb4e8d37af
Added support for constant_memory rich strings.
...
Issue #37
2018-09-29 02:46:46 +01:00
John McNamara
49cbf09ec2
Added tests for rich strings.
...
Issue #37
2018-09-29 01:43:38 +01:00
John McNamara
e85ad362ec
Initial working rich strings.
...
Issue #37
2018-09-28 16:55:29 +01:00
John McNamara
1d46ebee79
More chartsheet tests.
2018-09-20 23:57:54 +01:00
John McNamara
8d50d03b65
Added additional chartsheet features.
2018-09-20 21:06:19 +01:00
John McNamara
f44437aaf5
Added chartsheet_set_tab_color() function.
2018-09-16 12:16:22 +01:00
John McNamara
228d3c91d7
Added chartsheet_set_zoom() function.
2018-09-16 11:42:24 +01:00
John McNamara
4a67554236
Added chartsheet protect() function.
2018-09-15 14:36:47 +01:00
John McNamara
5933f440e9
Add chartsheet hide() function.
2018-09-12 22:47:36 +01:00
John McNamara
2ea3ba2a71
First fully functional chartsheet implementation.
...
Issue #90
2018-09-09 01:09:44 +01:00
John McNamara
f7f32def45
Refactor chart axis label alignment.
...
Issue #186
2018-09-01 20:58:31 +01:00