]> source.dussan.org Git - poi.git/log
poi.git
2 years agoadd missing licenses
PJ Fanning [Thu, 26 May 2022 15:22:01 +0000 (15:22 +0000)]
add missing licenses

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

2 years ago[bug-66094] add STDEV.S, STDEV.P, VAR.S and VAR.P functions
PJ Fanning [Thu, 26 May 2022 14:11:02 +0000 (14:11 +0000)]
[bug-66094] add STDEV.S, STDEV.P, VAR.S and VAR.P functions

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

2 years agosupport DCOUNTA function
PJ Fanning [Thu, 26 May 2022 13:48:30 +0000 (13:48 +0000)]
support DCOUNTA function

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

2 years ago[bug-66093] fix some var names
PJ Fanning [Thu, 26 May 2022 13:20:33 +0000 (13:20 +0000)]
[bug-66093] fix some var names

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

2 years ago[bug-66093] fix some var names
PJ Fanning [Thu, 26 May 2022 13:19:26 +0000 (13:19 +0000)]
[bug-66093] fix some var names

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

2 years ago[bug-66093] add tests
PJ Fanning [Thu, 26 May 2022 12:00:09 +0000 (12:00 +0000)]
[bug-66093] add tests

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

2 years ago[bug-66093] test issues
PJ Fanning [Thu, 26 May 2022 11:52:17 +0000 (11:52 +0000)]
[bug-66093] test issues

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

2 years ago[bug-66093] add support for unimplemented subfunctions to SUBTOTAL function
PJ Fanning [Thu, 26 May 2022 11:29:28 +0000 (11:29 +0000)]
[bug-66093] add support for unimplemented subfunctions to SUBTOTAL function

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

2 years agoextend test
PJ Fanning [Thu, 26 May 2022 11:20:18 +0000 (11:20 +0000)]
extend test

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

2 years agosupport DVARP and DSTDEVP
PJ Fanning [Thu, 26 May 2022 11:07:41 +0000 (11:07 +0000)]
support DVARP and DSTDEVP

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

2 years agoadd STDEVP function support
PJ Fanning [Thu, 26 May 2022 10:53:56 +0000 (10:53 +0000)]
add STDEVP function support

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

2 years agoadd DPRODUCT function support
PJ Fanning [Thu, 26 May 2022 10:25:32 +0000 (10:25 +0000)]
add DPRODUCT function support

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

2 years agosmall refactor
PJ Fanning [Thu, 26 May 2022 09:15:43 +0000 (09:15 +0000)]
small refactor

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

2 years agoadd DVAR function support
PJ Fanning [Thu, 26 May 2022 08:56:04 +0000 (08:56 +0000)]
add DVAR function support

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

2 years agosmall refactor
PJ Fanning [Wed, 25 May 2022 20:45:36 +0000 (20:45 +0000)]
small refactor

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

2 years agoadd DSTDEV function support
PJ Fanning [Wed, 25 May 2022 20:12:17 +0000 (20:12 +0000)]
add DSTDEV function support

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

2 years agoadd DAVERAGE function support
PJ Fanning [Wed, 25 May 2022 18:43:42 +0000 (18:43 +0000)]
add DAVERAGE function support

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

2 years agorevert change to IDStarAlgorithm.processMatch
PJ Fanning [Wed, 25 May 2022 18:18:40 +0000 (18:18 +0000)]
revert change to IDStarAlgorithm.processMatch

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

2 years agoDStar functions need to support field params provided as numbers as well as field...
PJ Fanning [Wed, 25 May 2022 15:54:29 +0000 (15:54 +0000)]
DStar functions need to support field params provided as numbers as well as field names

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

2 years agoextend dget test
PJ Fanning [Wed, 25 May 2022 15:23:51 +0000 (15:23 +0000)]
extend dget test

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

2 years agofix dget test
PJ Fanning [Wed, 25 May 2022 15:14:44 +0000 (15:14 +0000)]
fix dget test

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

2 years agosupport empty field param for DCount
PJ Fanning [Wed, 25 May 2022 15:06:30 +0000 (15:06 +0000)]
support empty field param for DCount

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

2 years agosupport empty field param for DCount
PJ Fanning [Wed, 25 May 2022 14:54:47 +0000 (14:54 +0000)]
support empty field param for DCount

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

2 years agosupport empty param for DCount
PJ Fanning [Wed, 25 May 2022 14:53:42 +0000 (14:53 +0000)]
support empty  param for DCount

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

2 years agoadd initial version of DCount and broken test
PJ Fanning [Wed, 25 May 2022 13:02:33 +0000 (13:02 +0000)]
add initial version of DCount and broken test

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

2 years agoadd initial version of DCount and broken test
PJ Fanning [Wed, 25 May 2022 12:36:42 +0000 (12:36 +0000)]
add initial version of DCount and broken test

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

2 years ago[bug-66087] make DStar functions case insensitive
PJ Fanning [Wed, 25 May 2022 10:31:07 +0000 (10:31 +0000)]
[bug-66087] make DStar functions case insensitive

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

2 years agoremove unused strict zip
PJ Fanning [Tue, 24 May 2022 08:59:30 +0000 (08:59 +0000)]
remove unused strict zip

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

2 years agoadd ceiling tests
PJ Fanning [Mon, 23 May 2022 14:46:52 +0000 (14:46 +0000)]
add ceiling tests

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

2 years agoadd floor tests
PJ Fanning [Mon, 23 May 2022 14:42:50 +0000 (14:42 +0000)]
add floor tests

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

2 years agofix test issue
PJ Fanning [Mon, 23 May 2022 14:13:56 +0000 (14:13 +0000)]
fix test issue

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

2 years agopartial implementation FLOOR.MATH function (needs more testing and bad param support)
PJ Fanning [Mon, 23 May 2022 14:10:11 +0000 (14:10 +0000)]
partial implementation FLOOR.MATH function (needs more testing and bad param support)

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

2 years agopartial implementation CEILING.MATH function (needs more testing and bad param support)
PJ Fanning [Mon, 23 May 2022 14:09:07 +0000 (14:09 +0000)]
partial implementation CEILING.MATH function (needs more testing and bad param support)

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

2 years agopartial implementation FLOOR.MATH function (needs more testing and bad param support)
PJ Fanning [Mon, 23 May 2022 14:02:47 +0000 (14:02 +0000)]
partial implementation FLOOR.MATH function (needs more testing and bad param support)

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

2 years agopartial implementation FLOOR.MATH function (needs more testing and bad param support)
PJ Fanning [Mon, 23 May 2022 13:53:56 +0000 (13:53 +0000)]
partial implementation FLOOR.MATH function (needs more testing and bad param support)

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

2 years agopartial implementation FLOOR.MATH function (needs more testing and bad param support)
PJ Fanning [Mon, 23 May 2022 13:49:50 +0000 (13:49 +0000)]
partial implementation FLOOR.MATH function (needs more testing and bad param support)

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

2 years agopartial implementation CEILING.MATH function (needs more testing and bad param support)
PJ Fanning [Mon, 23 May 2022 13:28:52 +0000 (13:28 +0000)]
partial implementation CEILING.MATH function (needs more testing and bad param support)

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

2 years agopartial implementation CEILING.MATH function (still need to support optional 2nd...
PJ Fanning [Mon, 23 May 2022 13:12:41 +0000 (13:12 +0000)]
partial implementation CEILING.MATH function (still need to support optional 2nd param)

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

2 years ago[github-331] update dependabot settings. This close #331
PJ Fanning [Mon, 23 May 2022 11:00:03 +0000 (11:00 +0000)]
[github-331] update dependabot settings. This close #331

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

2 years ago[bug-66022] issue in Formula Parser with some sheet names
PJ Fanning [Mon, 23 May 2022 10:55:22 +0000 (10:55 +0000)]
[bug-66022] issue in Formula Parser with some sheet names

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

2 years ago[bug-66081] fix editing of added abstract numberings
PJ Fanning [Sun, 22 May 2022 10:23:59 +0000 (10:23 +0000)]
[bug-66081] fix editing of added abstract numberings

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

2 years ago[bug-66080] XWPFNumbering.addAbstractNum uses abstract numberings count as id
PJ Fanning [Sun, 22 May 2022 08:43:06 +0000 (08:43 +0000)]
[bug-66080] XWPFNumbering.addAbstractNum uses abstract numberings count as id

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

2 years ago[bug-66080] XWPFNumbering.addAbstractNum uses abstract numberings count as id
PJ Fanning [Sun, 22 May 2022 08:28:44 +0000 (08:28 +0000)]
[bug-66080] XWPFNumbering.addAbstractNum uses abstract numberings count as id

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

2 years ago[bug-66079] apply test provided by Vladislav Arakelov
PJ Fanning [Sat, 21 May 2022 22:38:43 +0000 (22:38 +0000)]
[bug-66079] apply test provided by Vladislav Arakelov

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

2 years agogradle 7.4.2
PJ Fanning [Fri, 20 May 2022 13:56:29 +0000 (13:56 +0000)]
gradle 7.4.2

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

2 years ago[bug-66079] try to fix issue with XWPFNumbering.removeAbstractNum
PJ Fanning [Fri, 20 May 2022 09:47:16 +0000 (09:47 +0000)]
[bug-66079] try to fix issue with XWPFNumbering.removeAbstractNum

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

2 years agoupgrade spotbugs
PJ Fanning [Tue, 17 May 2022 07:47:19 +0000 (07:47 +0000)]
upgrade spotbugs

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

2 years agoUpdate JaCoCo to 0.8.8
Dominik Stadler [Mon, 9 May 2022 06:21:21 +0000 (06:21 +0000)]
Update JaCoCo to 0.8.8

This may also fix running JaCoCo on JDK 18

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

2 years agotry xmlsec 3.0.0
PJ Fanning [Tue, 3 May 2022 18:57:00 +0000 (18:57 +0000)]
try xmlsec 3.0.0

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

2 years agojavadoc
PJ Fanning [Sun, 1 May 2022 18:21:31 +0000 (18:21 +0000)]
javadoc

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

2 years agosupport sqrtpi function
PJ Fanning [Sat, 30 Apr 2022 08:31:31 +0000 (08:31 +0000)]
support sqrtpi function

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

2 years agosupport sqrtpi function
PJ Fanning [Sat, 30 Apr 2022 08:16:48 +0000 (08:16 +0000)]
support sqrtpi function

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

2 years agosupport lcm function
PJ Fanning [Fri, 29 Apr 2022 23:19:53 +0000 (23:19 +0000)]
support lcm function

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

2 years agosupport gcd function
PJ Fanning [Fri, 29 Apr 2022 22:50:38 +0000 (22:50 +0000)]
support gcd function

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

2 years agosupport gcd function
PJ Fanning [Fri, 29 Apr 2022 22:44:57 +0000 (22:44 +0000)]
support gcd function

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

2 years agosupport gcd function
PJ Fanning [Fri, 29 Apr 2022 22:34:20 +0000 (22:34 +0000)]
support gcd function

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

2 years agosupport gcd function
PJ Fanning [Fri, 29 Apr 2022 22:28:35 +0000 (22:28 +0000)]
support gcd function

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

2 years agoreformat
PJ Fanning [Fri, 29 Apr 2022 21:53:33 +0000 (21:53 +0000)]
reformat

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

2 years agomake HPSF limit more configuarble
PJ Fanning [Fri, 29 Apr 2022 21:47:45 +0000 (21:47 +0000)]
make HPSF limit more configuarble

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

2 years agofix broken test
PJ Fanning [Fri, 29 Apr 2022 20:53:49 +0000 (20:53 +0000)]
fix broken test

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

2 years agoreformat
PJ Fanning [Fri, 29 Apr 2022 20:47:25 +0000 (20:47 +0000)]
reformat

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

2 years agoadd broken test that prvis new averageif code is incorrect
PJ Fanning [Fri, 29 Apr 2022 20:26:52 +0000 (20:26 +0000)]
add broken test that prvis new averageif code is incorrect

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

2 years agoreformat
PJ Fanning [Fri, 29 Apr 2022 20:12:12 +0000 (20:12 +0000)]
reformat

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

2 years ago[github-330] add averageif function support
PJ Fanning [Fri, 29 Apr 2022 19:55:12 +0000 (19:55 +0000)]
[github-330] add averageif function support

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

2 years ago[bug-66039] remove stray </p>
PJ Fanning [Fri, 29 Apr 2022 13:08:52 +0000 (13:08 +0000)]
[bug-66039] remove stray </p>

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

2 years ago[bug-66039] add more javadoc about setCellFormulaValidation
PJ Fanning [Fri, 29 Apr 2022 13:07:00 +0000 (13:07 +0000)]
[bug-66039] add more javadoc about setCellFormulaValidation

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

2 years agosmall big decimal refactor
PJ Fanning [Fri, 29 Apr 2022 12:32:54 +0000 (12:32 +0000)]
small big decimal refactor

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

2 years ago[bug-66047] change mround implementation due to issue - thanks to @fabio
PJ Fanning [Fri, 29 Apr 2022 12:25:29 +0000 (12:25 +0000)]
[bug-66047] change mround implementation due to issue - thanks to @fabio

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

2 years ago[bug-66039] show use of setCellFormulaValidation=false in a test
PJ Fanning [Fri, 29 Apr 2022 10:52:34 +0000 (10:52 +0000)]
[bug-66039] show use of setCellFormulaValidation=false in a test

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

2 years agoupdate github actions
PJ Fanning [Tue, 26 Apr 2022 12:14:54 +0000 (12:14 +0000)]
update github actions

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

2 years ago[github-325] Update GithubActions permissions. Thanks to @nathannaveen. This closes...
PJ Fanning [Tue, 26 Apr 2022 12:00:44 +0000 (12:00 +0000)]
[github-325] Update GithubActions permissions. Thanks to @nathannaveen. This closes #325

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

2 years agomockito
PJ Fanning [Fri, 22 Apr 2022 23:43:58 +0000 (23:43 +0000)]
mockito

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

2 years agoupgrafe deps
PJ Fanning [Fri, 22 Apr 2022 23:13:13 +0000 (23:13 +0000)]
upgrafe deps

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

2 years agoupdate mockito
PJ Fanning [Wed, 20 Apr 2022 14:31:22 +0000 (14:31 +0000)]
update mockito

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

2 years agosmall changes to github action
PJ Fanning [Sun, 17 Apr 2022 10:28:50 +0000 (10:28 +0000)]
small changes to github action

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

2 years agorevert fraction format change
PJ Fanning [Thu, 14 Apr 2022 21:46:13 +0000 (21:46 +0000)]
revert fraction format change

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

2 years agotry to standardise big decimal code
PJ Fanning [Thu, 14 Apr 2022 17:01:51 +0000 (17:01 +0000)]
try to standardise big decimal code

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

2 years agoupgrade deps
PJ Fanning [Thu, 14 Apr 2022 15:04:49 +0000 (15:04 +0000)]
upgrade deps

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

2 years agorefactor test
PJ Fanning [Mon, 11 Apr 2022 19:29:30 +0000 (19:29 +0000)]
refactor test

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

2 years agoPrevent an overly large allocation when using HPSF
Dominik Stadler [Mon, 11 Apr 2022 13:51:31 +0000 (13:51 +0000)]
Prevent an overly large allocation when using HPSF

Add a sample document from fuzzing which contains invalid/oversized values

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

2 years agoMissing font-system can throw two other types of exception
Dominik Stadler [Mon, 11 Apr 2022 13:51:26 +0000 (13:51 +0000)]
Missing font-system can throw two other types of exception

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

2 years agoAdd a way to not require a functioning font-setup
Dominik Stadler [Sun, 10 Apr 2022 16:45:02 +0000 (16:45 +0000)]
Add a way to not require a functioning font-setup

New configuration-method SheetUtil.setIgnoreMissingFontSystem()
This allows to do a bit more on machines where no fonts are installed

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

2 years agoRework message when reaching allocation limits
Dominik Stadler [Sun, 10 Apr 2022 16:44:58 +0000 (16:44 +0000)]
Rework message when reaching allocation limits

Also remove a useless Math.min() as the previous condition already
indicates which one is the smaller value

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

2 years agoadd test
PJ Fanning [Sat, 9 Apr 2022 21:17:49 +0000 (21:17 +0000)]
add test

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

2 years agore-enable test
PJ Fanning [Sat, 9 Apr 2022 21:13:53 +0000 (21:13 +0000)]
re-enable test

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

2 years ago[github-321] Fix issue with rounding in DataFormatter. First try broke a test.
PJ Fanning [Sat, 9 Apr 2022 13:55:25 +0000 (13:55 +0000)]
[github-321] Fix issue with rounding in DataFormatter. First try broke a test.

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

2 years agomore test issues with rate change
PJ Fanning [Sat, 9 Apr 2022 13:38:27 +0000 (13:38 +0000)]
more test issues with rate change

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

2 years ago[github-321] Fix issue with rounding in DataFormatter. First try broke a test.
PJ Fanning [Sat, 9 Apr 2022 12:30:49 +0000 (12:30 +0000)]
[github-321] Fix issue with rounding in DataFormatter. First try broke a test.

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

2 years agotry to standardise div code
PJ Fanning [Sat, 9 Apr 2022 12:07:31 +0000 (12:07 +0000)]
try to standardise div code

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

2 years ago[github-321] Fix issue with rounding in DataFormatter. Thanks to Colin Wang. This...
PJ Fanning [Sat, 9 Apr 2022 12:02:55 +0000 (12:02 +0000)]
[github-321] Fix issue with rounding in DataFormatter. Thanks to Colin Wang. This closes #321

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

2 years agoincrease tolerance on rate test due to failures
PJ Fanning [Sat, 9 Apr 2022 11:37:36 +0000 (11:37 +0000)]
increase tolerance on rate test due to failures

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

2 years agoforbidden api issue
PJ Fanning [Sat, 9 Apr 2022 08:48:58 +0000 (08:48 +0000)]
forbidden api issue

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

2 years agoBug 65988: Rate function giving incorrect results
Yegor Kozlov [Fri, 8 Apr 2022 15:08:50 +0000 (15:08 +0000)]
Bug 65988: Rate function giving incorrect results

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

2 years ago[github-321] add test case
PJ Fanning [Fri, 8 Apr 2022 13:08:10 +0000 (13:08 +0000)]
[github-321] add test case

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

2 years agoupdate apache rat
PJ Fanning [Wed, 6 Apr 2022 13:00:25 +0000 (13:00 +0000)]
update apache rat

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

2 years ago[github-319] fix javadoc on setColumnHidden. Thanks to CodeMonkeyLab. This closes...
PJ Fanning [Tue, 5 Apr 2022 10:43:54 +0000 (10:43 +0000)]
[github-319] fix javadoc on setColumnHidden. Thanks to CodeMonkeyLab. This closes #319

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

2 years agoVarious smaller changes
Dominik Stadler [Sun, 3 Apr 2022 13:25:27 +0000 (13:25 +0000)]
Various smaller changes

Improve exception messages
Add more JavaDoc
Provide more information on test-failures

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

2 years agoSpeed up execution of formulas with whole-column area reference
Dominik Stadler [Sun, 3 Apr 2022 13:25:21 +0000 (13:25 +0000)]
Speed up execution of formulas with whole-column area reference

The previous change via r1894675 did not fully solve this as
it only took place when more than one sheet were used.

There were still some cases where evaluating formulas needed
to iterate across a huge number of non-existant rows, e.g.
TestVLookup, which took more than 1 minute locally.

However doing the lowering of row-numbers always would trigger
test-regressions as some Excel-functionality depends on actions
being possible on rows larger than current "last row" in the sheet.

Thus changed this to a slightly different approach which only adjusts
last-row when it is at or above the workbook-limit of rows

Execution of TestVLookup is now at 1-2 seconds!

Also added a test-case to verify details of the implementation now.

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

2 years agoUse a modified version of NullPrintStream in integration tests
Dominik Stadler [Sun, 3 Apr 2022 13:25:15 +0000 (13:25 +0000)]
Use a modified version of NullPrintStream in integration tests

The default version from Commons-IO does not avoid doing
utf-8 conversion and other work, so it is not well suited for
cases where lots of output happens.

Using an optimized version can bring down runtime of integration-tests
somewhat, especially for large files where XLS2CSV prints out lots of
data

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

2 years ago[bug-65993] support copying hssf hyperlinks to xssf and respect full cell range
PJ Fanning [Sat, 2 Apr 2022 18:55:56 +0000 (18:55 +0000)]
[bug-65993] support copying hssf hyperlinks to xssf and respect full cell range

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