55832decb6
Numeric Array Formula and Matrix Function [from Bob95132] This closes #69
3 weeks ago
1088c04c79
Fixes bug #61468 , caused by a confusing OOXML spec design as noted in JavaDocs added in r1795648.
3 weeks ago
e4d58dc7ed
Fix 60384 and 60709: When shifting with merged regions we should correctly check if the region is moved along or needs to be removed because it is not fully kept via the shifting. This was broken by the fix for bug 59740, now additional unit tests ensure that it works better.
3 weeks ago
2490a1e124
Bug 61431 - Conditional formatting evaluation ignores undefined cells
3 weeks ago
bba404ec54
Fix data validation value list evaluation
4 weeks ago
278db84451
[github-25] support excel number trailing comma format - Thabks to Luca Martini for proving the patch
1 month ago
ae7e4f9049
[Bug 58975] do not cast numberOfOperands to byte in AbstractFunctionPtg
1 month ago
5742abfd75
[Bug 60422] fix data formatter issue with specific format in German locale
1 month ago
5687de67c7
Remove some deprecated *SSF APIs
2 months ago
adb26ccd86
Remove more deprecated code (especially from Spreadsheet Cell classes)
2 months ago
8a4de17338
Ensure SpreadsheetVersion is set for AreaReferences
2 months ago
14f52860a2
Bug 61203 - XSSFDrawing.getAnchorFromParent handles CTOneCellAnchor incorrectly, ignores CTAbsoluteAnchor
2 months ago
4673ee6764
[bug-65915] add test for 'OR' function
2 months ago
e874fa6ca9
bug 52063: support 2-argument LOOKUP(lookup_value, array) function in Excel
2 months ago
3b66c38600
Implement ICellStyle.ReadingOrder
2 months ago
7b25d9778c
Standardize some more common chart axis properties.
2 months ago
3bbb1c4ed1
Fix code style
3 months ago
dd074bb25e
#61085 support table styles
3 months ago
d2bbe0d05e
Bug 60898 - XSSFColor's getARGB() method returns a wrong color value when a workbook has a custom indexed color
3 months ago
07466a802c
#61085 support table styles
3 months ago
94234b1b5a
bug 61059: fix NamePtg to read unsigned shorts instead of signed shorts, avoiding a AIOOBE when a workbook contains more than 32k Names. Thanks to Travis Burtrum for the patch.
3 months ago
06b228cec4
Bug 61063: enable test case Bug61063
3 months ago
c193c8fafd
github-55: document that CellReference#isRowWithinRange(String rowNum, SpreadsheetVersion ss) expects rowNum to be parseable as an integer
3 months ago
a11818c1e5
bug 61110: remove deprecated, misspelled CellReference#isRowWithnRange and #isColumnWithnRange methods
3 months ago
a1c339b4fd
Fix analysis errors related to non-concrete type usage
3 months ago
1278918598
Use NET 9 SDK to compile solution
4 months ago
31c899c60e
Fix analyzer reported issues
* Use 'string.Contains(char)' instead of 'string.Contains(string)' when searching for a single character
* Type 'XXX' can be sealed because it has no subtypes in its containing assembly and is not externally visible
* To avoid double lookup, call 'TryAdd' instead of calling 'Add' with a 'ContainsKey'
* Prefix generic type parameter name with 'T'
4 months ago
e690063d92
Copilot review fixes
4 months ago
36992e4d39
github-32: speed up Irr() Excel formula computation by replacing Math.pow() with multiplication. Thanks to Daniel Kuan! This closes #32 .
4 months ago
9643881d4f
Add table style test cases
4 months ago
a470216af2
60184 - invalid OOXML produced when XSSFFont.getFamily() called with no families defined
4 months ago
832f7be3e4
61060 - teach DataFormatter about conditional formatting rules with number formats
4 months ago
d096dcc8f4
Change stringbuilder to zstring(this time changing only what needs to be changed)
4 months ago
5f73594729
Remove zero-length array allocations and use collection expression
4 months ago
945be131cb
Add grouping to ColumnChartData
4 months ago
54926ae467
Add grouping to bar charts
4 months ago
aa87073ddf
Make non-public API methods static where applicable
4 months ago
122d6cb5e3
Fix analyzer reported issues related to string usage
* add polyfills for older targets
4 months ago
ee59c41351
Remove prefixes from cref tags
4 months ago
2dd0fa7c92
Added "using SixLabors.ImageSharp.Metadata"
4 months ago
114120f46b
Account for image resolution units other than pixels per inch
Added logic to convert the resolution to "pixels per inch" for images which have it specified as "pixels per meter" or "pixels per centimeter".
4 months ago
89e8ab7aa7
bug 61049 fix ordering of builtin formulas
4 months ago
394f76f94f
POI 61007, use CellFormat for all format strings containing multiple parts (";" delimited) and update unit test to expect the same values as Excel. Also added tests for the failing formats.
4 months ago
4c23bca0f6
Replace casts with pattern variable
5 months ago
1e5f612188
fix merge issue
5 months ago
646c6a8b8d
Seal private and internal types
5 months ago
6d0c60ea62
Add support for DVar、DVarp、DStdev、DStdevp function
5 months ago
278748f49f
Add support for DAverage and DProduct function
5 months ago
7a5a20b058
Add support for DMax and DSUM function
5 months ago
3a87c3ae0c
Add more test cases of DGet function.
Bug 63700: Make D* functions work with numeric result column
bug-66087: make D* functions case insensitive
github-692: D* functions are incompatible with the diamond operator.
5 months ago
Antony Liu