Commit graph

236 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
34290c1cab Add case insensitive worksheet name check.
Add case insensitive worksheet name check, in add_worksheet() and
in workbook_validate_sheet_name(). Ignores UTF-8 chars which may
contain upper/lowercase duplicates.

Closes #230
2019-06-07 21:28:08 +01:00
John McNamara
267a09a242 Added check for reserved worksheet name.
The worksheet name "History" is reserved by Excel.
2019-06-07 20:09:54 +01:00
John McNamara
ee18f0c4c0 Add error code for worksheet name with apostrophe.
Issue #223
2019-06-07 16:58:19 +01:00
John McNamara
f34673a92f Fix for sheet names that start or end with an apostrophe.
Excel doesn't allow worksheet names to start or end with
and apostrophe.

Closes #223.
2019-06-07 00:01:15 +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
Evan Miller
ebba115435 Fix compile-time warnings with strict prototypes enabled.
The C standard and -Wstrict-prototypes requires that functions which
take no arguments be declared as foobar(void) instead of foobar().

Fixes #208
2019-01-30 14:00:00 +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
970120a063 Initial skeleton for chartsheet class.
Issue #90
2018-09-07 10:37: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
3137b60647 Add docs for data validation 2017-09-25 00:27:24 +01: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
3333909632 Changed file creation time to utc.
Issue #110
2017-07-24 20:34:14 +01:00
Alexhuszagh
0278e18042 Updated CTest to work with MSVC 2017-07-10 17:52:19 -07: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