github-starred/libxlsxwriter
2
0
Fork 0
mirror of https://github.com/jmcnamara/libxlsxwriter.git synced 2026-05-16 06:06:11 -06:00
Code Issues 16 Projects Packages Wiki Activity Actions
748 commits 51 branches 124 tags 28 MiB
Commit graph

271 commits

Author SHA1 Message Date
John McNamara
38b8903228 Fix issue with relative url links in images. 2020-09-21 23:27:23 +01:00
John McNamara
c9f0fe6788 Fix for issue when UTF8 header/footer strings were truncated. 
Fixed issue where the limit for header/footer strings was
255 bytes instead of 255 characters and as a result UTF8
strings were being truncated.

Closed #305
 2020-09-08 18:24:55 +01:00
John McNamara
13aebf962e Made lxw_datetime_to_excel_date() function public. 2020-09-07 23:35:30 +01:00
John McNamara
4b6c45982c Added implicit include paths to unit tests. 
Added implicit include paths to unit tests to avoid issues
when running paralled builds.
 2020-09-07 10:56:11 +01:00
John McNamara
e3d4bcaf7c Added docs for conditional formatting. 
Feature request #302
 2020-09-05 21:17:39 +01:00
John McNamara
5d4a571105 Added support for conditional formatting. 
Feature request #302
 2020-08-30 21:06:48 +01:00
John McNamara
f23d2e905e Added style/format handling for conditional formatting. 
Added style/format handling for conditional formatting. The
Actual conditional formatting hasn't been added yet to the
worksheet and those parts of the tests have been skipped, for now.
 2020-08-22 14:38:49 +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
f7dc5ba13b Added tests for worksheet range return values. 2020-08-03 23:39:18 +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
a0e6a362ba Removed LXW_ERROR_SHEETNAME_RESERVED warning. 
Removed LXW_ERROR_SHEETNAME_RESERVED warning which was used with
the reserved worksheet name "History". However, this is an
allowed worksheet name in some Excel variants so the warning has
been turned into a documentation note instead.
 2020-03-21 17:40:08 +00: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
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