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