Commit Graph

1043 Commits (master)

Author SHA1 Message Date
snippet c21014c0fd Added the ability to set the active sheet
Closes #653
2022-08-29 18:30:48 +10:00
Thomas Fussell 4c79627553 ignore merge cell count 2022-08-21 20:42:45 -05:00
Thomas Fussell d45e831f47 fix copy-and-paste bug 2022-08-21 11:18:20 -05:00
Thomas Fussell a52bcd5fef implement defined names 2022-08-21 10:57:02 -05:00
Thomas Fussell bf92dd7640 implement shared and array formulas 2022-08-13 13:20:25 -05:00
Thomas Fussell 5c2fdff70f fix unhandled enumeration values in switch statement 2022-08-13 08:52:32 -05:00
Thomas Fussell 538f80794c
Merge pull request #635 from Blakjak88/master
fix writing of missing showGridLines attribute to xlsx file
2022-08-07 14:12:15 -05:00
Blakjak88 6b5755af30
Update xlsx_producer.cpp
show_grid_lines() is default enabled in Excel so attribute should only be written when it is set to false. 

Added 'if-statement' to check for 'false' before writing attribute.
2022-08-07 11:11:15 +08:00
Thomas Fussell f3bbaa3eeb
Merge pull request #628 from softvise/softvise/patches
Fix format::number_format
2022-08-06 13:53:08 -05:00
Blakjak88 dbfed051c8
Update xlsx_producer.cpp 2022-07-05 12:53:47 +08:00
Markus Färber cef67bdc45 Fix format::number_format
In case number_format() is called on a format that does not have
format ID set, number_format() dereferences
d_->parent->number_formats.end() causing a crash.
This might happen when calling cell::is_date() on a cell that has type
'number' without a number format but some other styling set.
This might never occur in spreadsheet files created by commercial
applications but xlnt certainly allows to create such a file.
We therefore fix number_format here by returning the general number
format as a fallback.
2022-05-10 14:50:20 +02:00
Darrell Wright 4da810eaef
Missing include in number_formatter.cpp
Limits isn't being transitively included on gcc 11.2.0/ubuntu.  Added as it produces an error
2022-03-18 18:46:27 -04:00
Thomas Fussell d88c901faa
Merge pull request #608 from imgspc/iter_has_value
Add has_value to cell_iterator
2022-01-09 17:42:00 -05:00
Thomas Fussell 0246c7bece
Merge pull request #607 from doomlaur/bugfix/windows_utf16_paths
Paths on Windows are now correctly converted from UTF-8 to UTF-16
2022-01-09 17:41:18 -05:00
Thomas Fussell 69f651e3a1
Merge pull request #601 from doomlaur/bugfix/system_default_date_time
Added support for the System Default locale for the Time and Long Date types
2022-01-09 17:39:04 -05:00
Thomas Fussell 09dd4797b4
Merge pull request #600 from doomlaur/bugfix/streaming_reader_clean_cell_state
The streaming cell now always begins with a clean state when using the xlnt::streaming_workbook_reader
2022-01-09 17:37:18 -05:00
Félix Bourbonnais 5ff980854a
Merge branch 'master' into iter_has_value 2021-12-09 14:13:21 -05:00
Laurențiu Leahu-Vlăducu 8c584321a5
Paths on Windows are now correctly converted from UTF-8 to UTF-16 instead of UCS-2. This fixes issues with file paths that use 2 wchar_t characters / 4 bytes, also called surrogate pairs. Modified the unit tests to test this case. 2021-12-09 16:42:18 +01:00
Félix Bourbonnais 28f7e6fa69 Add has_value to cell_iterator
When iterating over a range that doesn't ignore null rows/columns,
the operator*() throws when dereferencing an iterator to a null cell.
Add has_value() to cell_iterator to be able to make a check without
relying on exceptions.
And add a test case.
2021-12-08 15:49:14 -05:00
Laurențiu Leahu-Vlăducu 2f2e0a37a4
Adapted the format_locale enum to include the System Default locale for the Date and Time types. 2021-12-01 23:34:20 +01:00
Laurențiu Leahu-Vlăducu 147307c90b
Added support for the System Default locale for the Time and Long Date types in Excel, as explained here: https://bz.apache.org/ooo/show_bug.cgi?id=70003
This fixes issues with some locales where "system default" is the default setting for times and dates. This happens, for example, when using German (Austria) as a locale in Windows, or when setting it manually in Excel.
2021-12-01 19:58:25 +01:00
Laurențiu Leahu-Vlăducu f6f4adca7d
Fixed a bug when using the xlnt::streaming_workbook_reader where a streaming cell could still contain information from the previously streamed cell. This could happen if the new cell did not contain information that could override the information of the previous cell, e.g. when the cell in XML only contained something like <c r="H4"/>, so the streamed cell still contained the type and the string/value of the previously streamed cell. 2021-12-01 14:09:37 +01:00
Wu, Ganhao b81d76a223 Fix test case - page size now optional. 2021-09-04 02:15:19 +08:00
Wu, Ganhao 5946eec32e Fix - Print Settings (Page Size, margins, etc) not saved when loading a file and save it. 2021-08-29 02:56:57 +08:00
Thomas Fussell 3a279fcaab
Merge pull request #580 from pomer/master
LibreOffice color names support
2021-08-22 09:04:11 -04:00
Thomas Fussell 50a792a01a Merge branch 'Issue484/fix-calculate-dimension-when-not-skipping-nulls' of https://github.com/imgspc/xlnt into imgspc-Issue484/fix-calculate-dimension-when-not-skipping-nulls 2021-08-22 08:59:05 -04:00
Thomas Fussell 04b6b97577
Merge branch 'master' into master 2021-08-22 08:41:01 -04:00
Thomas Fussell 04ebd7ef9d fix warnings, bump copyright, fix typo, update npm libs 2021-08-22 08:23:18 -04:00
Vladimir S. Yakovlev 99372e3f11 LibreOffice color names support 2021-08-17 00:46:39 +03:00
Sewon Park c160db4ef6
Merge branch 'master' into master 2021-06-24 15:45:51 +09:00
vkovec 4294e31253 include first empty rows and columns in range if skip_null false 2021-04-16 11:44:13 -04:00
Thomas Fussell 74fc642676 work on strikethrough for #530 2021-02-21 16:52:03 -04:00
Thomas Fussell 7f51eed107 os-independent weekday calculation 2021-02-21 08:18:26 -04:00
Thomas Fussell 60b2d9cfd1 ignore nullptr warning in libstudxml, update to latest beta 9, and switch to submodule 2021-02-20 22:29:59 -04:00
Sewon Park 7f44dc2274 minimum support for xlsm 2021-01-21 21:45:24 +09:00
Thomas Fussell f0da7f61bb
Merge branch 'master' into memory_leaks_fix 2021-01-03 19:31:11 -05:00
Thomas Fussell 6987c1f233 add constructor 2021-01-03 19:04:41 -05:00
Thomas Fussell a8b631bcbb replace enable_if_t 2021-01-03 18:42:56 -05:00
Thomas Fussell c007dafe33 add include 2021-01-03 18:26:48 -05:00
Thomas Fussell 1868128dda
Merge branch 'master' into memory_leaks_fix 2021-01-03 12:22:12 -05:00
Thomas Fussell e53ef68469 fix compiler warnings and some valgrind problems 2021-01-03 12:20:46 -05:00
Thomas Fussell 23244120fb
Merge branch 'master' into time-struct-warning 2021-01-03 10:15:46 -05:00
Thomas Fussell 0039eab40d fix gcc 4.8.2 build problems 2021-01-03 09:33:43 -05:00
Thomas Fussell b9a1b48811
Merge branch 'master' into time-struct-warning 2021-01-02 16:09:15 -05:00
Thomas Fussell c5d449915f fix shared string handling 2021-01-02 15:28:14 -05:00
Thomas Fussell 18e82f35d3 Revert "Shared strings"
This reverts commit d6262df555.
2021-01-02 15:20:56 -05:00
Thomas Fussell e9ec6a3dd1
Merge branch 'master' into time-struct-warning 2021-01-02 15:08:21 -05:00
Thomas Fussell ca2abc9ddc
Merge branch 'master' into worksheet_empty 2021-01-02 15:07:08 -05:00
Thomas Fussell c448d9788a
Merge branch 'master' into workbook_check_out_of_range_in_sheet_by_index 2021-01-02 15:06:21 -05:00
Thomas Fussell 4b91281280
Merge branch 'master' into issue-504-select-multiple-cells 2021-01-02 15:05:02 -05:00