Commit graph

212 commits

Author SHA1 Message Date
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