Commit graph

251 commits

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