Commit graph

115 commits

Author SHA1 Message Date
John McNamara
6d6d99eeaf Added support for worksheet tables.
Feature request #33
2021-08-19 22:54:59 +01:00
John McNamara
431f4839f9 Add filter rules for autofilters.
Feature request #254
2021-08-02 23:49:05 +01:00
John McNamara
9402191bc1 Fix for unixtime type size.
The size of thetime_h type used with worksheet_write_unixtime()
wasn't sufficient to represent the full range of Excel's dates.
The parameter in question has been extended to int64_t.

Issue #347
2021-07-27 17:28:10 +01:00
Sijmen J. Mulder
b2b7000c42 Respect LDFLAGS when linking tests
Otherwise it's not possible to link e.g. system minizip if it's outside
the default search paths.
2021-07-27 16:40:48 +01:00
John McNamara
bda599d033 Added optional third party dtoa library.
Added the optional Milo Yip DTOA library (emyg_dtoa) to avoid
issues where the standard sprintf() dtoa function changes output
based on locale settings. It is also 40-50% faster than the
standard dtoa for raw numeric data.

If you wish to use this third party library you can compile
libxlsxwriter with it by passing `USE_DTOA_LIBRARY=1` to
make. The USE_DOUBLE_FUNCTION build variable is no longer used.

Imported source from https://github.com/miloyip/dtoa-benchmark

Feature request #272
2021-07-12 23:09:52 +01:00
John McNamara
4fcdd7b26d Updated copyright year. 2021-07-01 23:57:09 +01:00
John McNamara
7f20142d47 Add extra unixtime test. 2021-07-01 23:25:54 +01:00
John McNamara
9b89841750 Add support for Unix datetimes. 2021-07-01 21:00:59 +01:00
John McNamara
412571bb92 Add build support for gcov coverage. 2021-06-06 20:09:21 +01:00
John McNamara
925a147fc1 Add support for using MD5 functions from OpenSSL.
Feature request #335
2021-05-27 23:35:59 +01:00
John McNamara
e478365508 Add initial support for dynamic arrays in formulas.
Feature request #327
2021-04-23 07:25:50 +01:00
John McNamara
e2795f601d Add support for pixel sizing of rows and columns.
Added support for pixel sizing in worksheet_set_row() and
worksheet_set_column() via new functions called
worksheet_set_row_pixels() and worksheet_set_column_pixels().
2021-04-15 19:53:01 +01:00
John McNamara
c718466194 Minor fix for ctest output. 2021-04-10 21:11:11 +01:00
John McNamara
c06101fcad Updated copyright year. 2021-01-13 21:25:35 +00: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
f7dc5ba13b Added tests for worksheet range return values. 2020-08-03 23:39:18 +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
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
85dfccd734 Added support for cell comments and options.
Issue #38
2020-01-07 23:27:04 +00:00
John McNamara
dcecc632d5 Added support for hyperlinks from images. 2019-12-15 00:11:44 +00:00
John McNamara
44bb2056e4 Initial working hyperlink style. 2019-12-10 00:10:13 +00: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
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
72c9b219cb Updated copyright year. 2019-02-10 21:11:46 +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
e85ad362ec Initial working rich strings.
Issue #37
2018-09-28 16:55:29 +01:00
John McNamara
4a67554236 Added chartsheet protect() function. 2018-09-15 14:36:47 +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
14421b6629 Add user defined function for formatting doubles. 2018-04-24 23:34:38 +01:00
John McNamara
7d440b66a6 Updated copyright year. 2018-02-11 23:06:54 +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
062ddc5ee6 Fix scan-build warnings. 2017-01-09 00:25:14 +00:00
John McNamara
038cece4ad Update copyright year. 2016-12-31 00:48:27 +00:00
John McNamara
813ca50be0 Update copyright year. 2016-12-31 00:33:00 +00:00