Commit graph

185 commits

Author SHA1 Message Date
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
Jean-Philippe Doyle
3d3bd12abe Add function to set axis labels alignment 2018-09-01 20:26:34 +01:00
John McNamara
03bb8d2eb0 Add docs for in-memory image handling.
Addd docs and additional tests for in-memory image handling.

Issue #125
2018-08-30 23:04:39 +01:00
John McNamara
1992f906c3 Initial in-memory image handling.
Issue #125
2018-08-30 00:16:03 +01:00
John McNamara
d4819bc3a3 Added top_left chart legend position. 2018-08-20 14:00:09 +01:00
John McNamara
14421b6629 Add user defined function for formatting doubles. 2018-04-24 23:34:38 +01:00
John McNamara
8fbe44461d Fix for jpeg images with unhandled SOFs. 2018-04-13 23:49:10 +01:00
John McNamara
0e0a04ce8c Fix for missing plotarea formatting in pie/doughnut charts.
Issue #147
2018-04-02 20:17:58 +01:00
John McNamara
88bf28d388 Fix for number format issue.
Fix for issue where some number formats were incorrectly treated
as duplicates and not stored/applied.

Issue #151
2018-03-16 15:34:02 +00:00
John McNamara
7d440b66a6 Updated copyright year. 2018-02-11 23:06:54 +00:00
John McNamara
d863c8e1fd Add functions to access axis and error bar pointers.
Add functions to return pointers to chart axis and error bar
pointers as syntactic sugar for wrapper languages that can't
access the pointers directly.

Issue #142
2018-02-11 13:24:46 +00:00
John McNamara
6d2befd587 Added outline settings function.
Issue #30
2018-02-05 23:33:32 +00:00
John McNamara
aeb6e0e9b9 Initial support for worksheet outlines.
Issue #30.
2018-02-04 21:15:14 +00:00
John McNamara
dc31b10bad Updated copyright year. 2018-02-03 17:15:35 +00:00
John McNamara
0865a040a4 Implementation of data validation.
Feature request: #31
2017-09-23 11:52:18 +01:00
John McNamara
b0a7c691ad Added option to use system minizip in make build.
Additional fixes for using system minizip in the Makefile make system.

Issue #119.
2017-08-20 11:33:02 +01:00
John McNamara
856a45a292 Added option to use system minizip in make build.
Added option to use system minizip in the Makefile make system.

Issue #119.
2017-08-14 20:08:57 +01:00
John McNamara
be77bac3ee Added docs for chart trendlines. 2017-01-29 18:13:43 +00:00
John McNamara
27ebef50eb Add chart trendlines. 2017-01-29 02:20:06 +00:00
John McNamara
9a6c4f815c Added more tests for error bars. 2017-01-27 00:56:02 +00:00
John McNamara
7b69c672bf Refactoring of error bar function structure. 2017-01-27 00:29:07 +00:00
John McNamara
6ef24a312c Refactoring of error bar function structure. 2017-01-27 00:05:48 +00:00
John McNamara
fbeeef7cc1 Initial chart error bars. 2017-01-26 00:07:38 +00:00
John McNamara
9f2108feb1 More features and tests for chart data labels. 2017-01-23 00:20:52 +00:00
John McNamara
673a0e0458 Initial working chart data labels. 2017-01-22 18:13:31 +00:00
John McNamara
6e82474759 Added chart up-down bar support. 2017-01-22 02:24:50 +00:00
John McNamara
bcc3945565 Added handling of blank data in charts. 2017-01-21 20:45:11 +00:00
John McNamara
154b63b0ee Added chart gap and overlap functions. 2017-01-21 13:58:49 +00:00