source.dussan.org Git

Andreas Beeker [Sat, 28 Aug 2021 23:48:48 +0000 (23:48 +0000)]

sonar fixes
close resources in tests
fix gradle warnings

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892683 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 28 Aug 2021 13:27:36 +0000 (13:27 +0000)]

extend xslf test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892680 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 28 Aug 2021 13:18:08 +0000 (13:18 +0000)]

disable broken ant build

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892679 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 28 Aug 2021 13:05:17 +0000 (13:05 +0000)]

try to fix java 11 compile issue about org.w3c.dom.css classes

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892677 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 28 Aug 2021 09:13:34 +0000 (09:13 +0000)]

more use of commons-io

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892670 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 28 Aug 2021 09:13:21 +0000 (09:13 +0000)]

more use of commons-io

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892669 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 27 Aug 2021 18:54:01 +0000 (18:54 +0000)]

more use of commons-io

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892658 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 27 Aug 2021 17:33:39 +0000 (17:33 +0000)]

add basic support for hdphoto/wdp images in slideshows

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892653 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Wed, 25 Aug 2021 23:13:27 +0000 (23:13 +0000)]

try to fix spotbugs publisher entry

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892608 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Wed, 25 Aug 2021 23:07:06 +0000 (23:07 +0000)]

add spotbugs to gradle build
update dist path for jenkins archives

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892607 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Mon, 23 Aug 2021 20:48:30 +0000 (20:48 +0000)]

rat check - ignore svn conflict artifacts for module-info.class files

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892553 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Mon, 23 Aug 2021 19:50:51 +0000 (19:50 +0000)]

Increase general max heap size to cover also integration tests demands

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892551 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Sun, 22 Aug 2021 17:48:41 +0000 (17:48 +0000)]

Redirecting System.out/err is bad in concurrent test environment

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892530 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Fri, 20 Aug 2021 20:53:13 +0000 (20:53 +0000)]

use gradle for windows builds

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892481 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Fri, 20 Aug 2021 20:35:13 +0000 (20:35 +0000)]

use gradle for windows builds

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892480 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Fri, 20 Aug 2021 19:46:26 +0000 (19:46 +0000)]

try to fix path issues in Windows build

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892479 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Fri, 20 Aug 2021 17:07:36 +0000 (17:07 +0000)]

try to fix concurrent issues in excelant

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892478 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Fri, 20 Aug 2021 16:53:09 +0000 (16:53 +0000)]

Bug 65501 - Use viewbox when rendering SVG images

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892477 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Mon, 16 Aug 2021 23:09:54 +0000 (23:09 +0000)]

also invoke Java 11 build on gradle

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892391 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Mon, 16 Aug 2021 22:49:01 +0000 (22:49 +0000)]

fix Windows gradle build - task allJavaDoc

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892390 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Mon, 16 Aug 2021 22:17:05 +0000 (22:17 +0000)]

try to get openjdk working again ... also with gradle

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892389 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Mon, 16 Aug 2021 11:29:33 +0000 (11:29 +0000)]

[github-242] add support for MAXIFS, MINIFS, AVERAGEIFS functions. Thanks to jniewerth. This closes #242

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892366 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 14 Aug 2021 09:54:11 +0000 (09:54 +0000)]

increase intermediate significance

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892333 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 14 Aug 2021 09:53:38 +0000 (09:53 +0000)]

increase intermediate significance

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892332 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 14 Aug 2021 00:28:37 +0000 (00:28 +0000)]

tidy up eval

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892322 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 13 Aug 2021 23:46:54 +0000 (23:46 +0000)]

try to fix test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892321 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 13 Aug 2021 23:34:33 +0000 (23:34 +0000)]

try to fix test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892320 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 13 Aug 2021 21:40:26 +0000 (21:40 +0000)]

slightly more impl in XSSFDataBarFormatting

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892319 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Thu, 12 Aug 2021 14:46:41 +0000 (14:46 +0000)]

remove XLookup

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892285 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Wed, 11 Aug 2021 21:25:00 +0000 (21:25 +0000)]

support removing hyperlink from one cell when hyperlink is shared by many cells

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892249 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Wed, 11 Aug 2021 21:23:13 +0000 (21:23 +0000)]

compile module info only in Java 9+ builds

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892248 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Wed, 11 Aug 2021 21:16:49 +0000 (21:16 +0000)]

support removing hyperlink from one cell when hyperlink is shared by many cells

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892247 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Wed, 11 Aug 2021 21:13:45 +0000 (21:13 +0000)]

support removing hyperlink from one cell when hyperlink is shared by many cells

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892246 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Tue, 10 Aug 2021 19:40:03 +0000 (19:40 +0000)]

[bug-65490] add support for removing hyperlink directly from sheet

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892189 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Tue, 10 Aug 2021 14:22:25 +0000 (14:22 +0000)]

add test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892179 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Tue, 10 Aug 2021 14:10:59 +0000 (14:10 +0000)]

add support for reading hyperlinks that have cell refs that are area references (very limited update or write support as yet)

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892178 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Tue, 10 Aug 2021 00:20:25 +0000 (00:20 +0000)]

use "gradle clean jenkins" instead of only "gradle jenkins" otherwise the build/dist dir is filling up

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892148 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Mon, 9 Aug 2021 23:50:22 +0000 (23:50 +0000)]

convert link to internal jdk api to preformatted code

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892147 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Mon, 9 Aug 2021 23:37:13 +0000 (23:37 +0000)]

[bug-65492] XSSFExportToXml does not handle formula type cells with boolean values

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892146 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Mon, 9 Aug 2021 23:30:04 +0000 (23:30 +0000)]

disable "ant init" in gradle build

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892145 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Mon, 9 Aug 2021 22:39:27 +0000 (22:39 +0000)]

fix broken test case

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892144 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Mon, 9 Aug 2021 22:34:23 +0000 (22:34 +0000)]

use gradle as default build tool

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892143 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

Andreas Beeker [Mon, 9 Aug 2021 22:32:33 +0000 (22:32 +0000)]

move dist files from gradles default dist directory to pois dist dir

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892142 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Mon, 9 Aug 2021 21:57:40 +0000 (21:57 +0000)]

commit | commitdiff | tree

PJ Fanning [Sun, 8 Aug 2021 15:40:23 +0000 (15:40 +0000)]

init support for XLOOKUP

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892116 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sun, 8 Aug 2021 14:53:41 +0000 (14:53 +0000)]

init support for XLOOKUP

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892115 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sun, 8 Aug 2021 09:44:38 +0000 (09:44 +0000)]

init support for XLOOKUP

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892107 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 23:56:22 +0000 (23:56 +0000)]

tidy up

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892097 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 23:23:39 +0000 (23:23 +0000)]

init support for XLOOKUP

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892096 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 19:52:00 +0000 (19:52 +0000)]

add test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892092 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 19:40:35 +0000 (19:40 +0000)]

add test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892091 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 19:28:33 +0000 (19:28 +0000)]

[bug-49202] add PERCENTRANK.EXC function

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892090 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 18:36:12 +0000 (18:36 +0000)]

[bug-49202] add PERCENTRANK.EXC function

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892088 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 15:33:35 +0000 (15:33 +0000)]

[bug-49202] add PERCENTRANK.EXC function

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892084 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 15:09:40 +0000 (15:09 +0000)]

test issue

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892083 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 15:02:49 +0000 (15:02 +0000)]

[bug-49202] add PERCENTRANK.INC function

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892082 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 14:42:47 +0000 (14:42 +0000)]

[bug-49202] add PERCENTRANK.INC function

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892081 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 14:34:38 +0000 (14:34 +0000)]

tidy up javadoc

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892080 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 14:32:29 +0000 (14:32 +0000)]

tidy up javadoc

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892079 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 14:27:41 +0000 (14:27 +0000)]

[bug-49202] add PERCENTRANK function

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892078 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 14:23:10 +0000 (14:23 +0000)]

[bug-49202] add PERCENTRANK function

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892077 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 13:24:28 +0000 (13:24 +0000)]

add test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892076 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 13:23:28 +0000 (13:23 +0000)]

add test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892075 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 11:52:35 +0000 (11:52 +0000)]

fix TextJoin use case that was not handled

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892070 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 11:16:34 +0000 (11:16 +0000)]

fix TextJoin use case that was not handled

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892067 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 10:45:18 +0000 (10:45 +0000)]

fix TextJoin use case that was not handled

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892065 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 10:32:22 +0000 (10:32 +0000)]

fix TextJoin use case that was not handled

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892062 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 7 Aug 2021 10:25:24 +0000 (10:25 +0000)]

fix TextJoin use case that was not handled

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892061 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 6 Aug 2021 20:57:38 +0000 (20:57 +0000)]

use xmlbeans 5.0.0 in ant build

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892053 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 6 Aug 2021 20:55:15 +0000 (20:55 +0000)]

use xmlbeans 5.0.0 in ant build

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892052 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 6 Aug 2021 20:45:09 +0000 (20:45 +0000)]

try to use xmlbeans 5.0.1 in ant build

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892051 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 6 Aug 2021 20:17:48 +0000 (20:17 +0000)]

try to use xmlbeans 5.0.1 in ant build

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892050 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 6 Aug 2021 18:19:49 +0000 (18:19 +0000)]

add basic implementation of TIMEVALUE function

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892047 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 6 Aug 2021 16:53:27 +0000 (16:53 +0000)]

add basic implementation of TIMEVALUE function

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892044 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 6 Aug 2021 15:41:16 +0000 (15:41 +0000)]

extend tests

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892043 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 6 Aug 2021 15:22:32 +0000 (15:22 +0000)]

extend tests

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892042 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Mon, 2 Aug 2021 17:22:13 +0000 (17:22 +0000)]

[bug-65464] fix issue where shared formulas can be corrupted. Thanks to Nico Seegert

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891962 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Sat, 31 Jul 2021 21:20:33 +0000 (21:20 +0000)]

update docs about deferred SXSSF and limitations on what can be done in row generating function

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891937 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 30 Jul 2021 19:29:34 +0000 (19:29 +0000)]

SUMIFS should sum and treat booleans and strings as zero

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891905 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 30 Jul 2021 13:28:02 +0000 (13:28 +0000)]

SUMIFS should treat #N/A correctly

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891902 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 30 Jul 2021 12:58:21 +0000 (12:58 +0000)]

add license

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891901 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 30 Jul 2021 12:47:03 +0000 (12:47 +0000)]

SUMIFS should sum and treat booleans and strings as zero

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891900 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 30 Jul 2021 12:33:15 +0000 (12:33 +0000)]

SUMIFS should not sum if a value is #N/A

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891898 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 30 Jul 2021 12:20:08 +0000 (12:20 +0000)]

test sum with N/A

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891897 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 30 Jul 2021 11:03:33 +0000 (11:03 +0000)]

[bug-65475] SUMIF should return #N/A if any of the amounts to sum is #N/A. Thanks to zhangyajun.

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891896 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 30 Jul 2021 10:59:09 +0000 (10:59 +0000)]

fix issue with test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891895 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 30 Jul 2021 09:59:16 +0000 (09:59 +0000)]

add disabled SUMIF test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891894 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 30 Jul 2021 09:45:24 +0000 (09:45 +0000)]

add disabled SUMIF test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891893 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Fri, 30 Jul 2021 09:23:47 +0000 (09:23 +0000)]

add SUMIF tests disabling one that shows we have a bug

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891892 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Thu, 29 Jul 2021 19:30:33 +0000 (19:30 +0000)]

add datetime test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891879 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Thu, 29 Jul 2021 18:22:18 +0000 (18:22 +0000)]

add date test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891878 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Thu, 29 Jul 2021 16:57:03 +0000 (16:57 +0000)]

[bug-65467] support IFNA() function. Thanks to Ross Patterson

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891876 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Thu, 29 Jul 2021 11:15:37 +0000 (11:15 +0000)]

add tests for concat function

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891874 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Thu, 29 Jul 2021 00:33:01 +0000 (00:33 +0000)]

add tests for concat function

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891865 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Wed, 28 Jul 2021 20:15:11 +0000 (20:15 +0000)]

[bug-65471] fix DataFormatter so it can handle Ts (ISO 8601)

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891864 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Wed, 28 Jul 2021 20:06:16 +0000 (20:06 +0000)]

[bug-65471] fix DataFormatter so it can handle Ts (ISO 8601)

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891863 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Wed, 28 Jul 2021 19:46:05 +0000 (19:46 +0000)]

[bug-65471] fix DataFormatter so it can handle Ts (ISO 8601)

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891862 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Wed, 28 Jul 2021 18:38:21 +0000 (18:38 +0000)]

add broken (disabled) test to show issue with ISO 8601 format

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891859 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Wed, 28 Jul 2021 16:56:36 +0000 (16:56 +0000)]

[bug-65165] invalid date values not handled correctly in DateValue function

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891858 13f79535-47bb-0310-9956-ffa450edef68

commit | commitdiff | tree

PJ Fanning [Wed, 28 Jul 2021 14:09:28 +0000 (14:09 +0000)]

[bug-60924] add support for Excel IFS and SWITCH functions. Thanks to Pieter Degraeuwe

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891856 13f79535-47bb-0310-9956-ffa450edef68

Mirror of Apache POI: https://github.com/apache/poi

RSS Atom