[PR] Bump com.github.spotbugs from 5.0.14 to 5.1.5 [poi]

[via GitHub]

dependabot[bot] opened a new pull request, #535:
URL: https://github.com/apache/poi/pull/535

   Bumps com.github.spotbugs from 5.0.14 to 5.1.5.
   
   
   [![Dependabot compatibility 
score](https://dependabot-badges.githubapp.com/badges/compatibility_score?dependency-name=com.github.spotbugs=gradle=5.0.14=5.1.5)](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores)
   
   Dependabot will resolve any conflicts with this PR as long as you don't 
alter it yourself. You can also trigger a rebase manually by commenting 
`@dependabot rebase`.
   
   [//]: # (dependabot-automerge-start)
   [//]: # (dependabot-automerge-end)
   
   ---
   
   
   Dependabot commands and options
   
   
   You can trigger Dependabot actions by commenting on this PR:
   - `@dependabot rebase` will rebase this PR
   - `@dependabot recreate` will recreate this PR, overwriting any edits that 
have been made to it
   - `@dependabot merge` will merge this PR after your CI passes on it
   - `@dependabot squash and merge` will squash and merge this PR after your CI 
passes on it
   - `@dependabot cancel merge` will cancel a previously requested merge and 
block automerging
   - `@dependabot reopen` will reopen this PR if it is closed
   - `@dependabot close` will close this PR and stop Dependabot recreating it. 
You can achieve the same result by closing it manually
   - `@dependabot show  ignore conditions` will show all of 
the ignore conditions of the specified dependency
   - `@dependabot ignore this major version` will close this PR and stop 
Dependabot creating any more for this major version (unless you reopen the PR 
or upgrade to it yourself)
   - `@dependabot ignore this minor version` will close this PR and stop 
Dependabot creating any more for this minor version (unless you reopen the PR 
or upgrade to it yourself)
   - `@dependabot ignore this dependency` will close this PR and stop 
Dependabot creating any more for this dependency (unless you reopen the PR or 
upgrade to it yourself)
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[PR] Bump com.adarshr.test-logger from 3.2.0 to 4.0.0 [poi]

[via GitHub]

dependabot[bot] opened a new pull request, #534:
URL: https://github.com/apache/poi/pull/534

   Bumps com.adarshr.test-logger from 3.2.0 to 4.0.0.
   
   
   [![Dependabot compatibility 
score](https://dependabot-badges.githubapp.com/badges/compatibility_score?dependency-name=com.adarshr.test-logger=gradle=3.2.0=4.0.0)](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores)
   
   Dependabot will resolve any conflicts with this PR as long as you don't 
alter it yourself. You can also trigger a rebase manually by commenting 
`@dependabot rebase`.
   
   [//]: # (dependabot-automerge-start)
   [//]: # (dependabot-automerge-end)
   
   ---
   
   
   Dependabot commands and options
   
   
   You can trigger Dependabot actions by commenting on this PR:
   - `@dependabot rebase` will rebase this PR
   - `@dependabot recreate` will recreate this PR, overwriting any edits that 
have been made to it
   - `@dependabot merge` will merge this PR after your CI passes on it
   - `@dependabot squash and merge` will squash and merge this PR after your CI 
passes on it
   - `@dependabot cancel merge` will cancel a previously requested merge and 
block automerging
   - `@dependabot reopen` will reopen this PR if it is closed
   - `@dependabot close` will close this PR and stop Dependabot recreating it. 
You can achieve the same result by closing it manually
   - `@dependabot show  ignore conditions` will show all of 
the ignore conditions of the specified dependency
   - `@dependabot ignore this major version` will close this PR and stop 
Dependabot creating any more for this major version (unless you reopen the PR 
or upgrade to it yourself)
   - `@dependabot ignore this minor version` will close this PR and stop 
Dependabot creating any more for this minor version (unless you reopen the PR 
or upgrade to it yourself)
   - `@dependabot ignore this dependency` will close this PR and stop 
Dependabot creating any more for this dependency (unless you reopen the PR or 
upgrade to it yourself)
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Re: [Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

[stanton fisque]

there is a use case, and i have used it, so i will raise a counter comment for 
POI to retain running calculations:

i had a project where i built a harness to load an excel spreadsheet and then 
exercise it as a system of record.  if POI were to lose the ability to perform 
that function, it would be a loss for that use case.  i do accept that it is an 
exotic case, but i'd wager it is not the only one.

as a side note, some thought could be given to (if it were deemed necessary to 
go down this route) providing a contract layer so that existing functionality 
could be retained as an extension library.  the current implementation allows 
for runtime patching of the execution engine (i  had to use this for a missing 
function before PJF accepted  a PR from me sometime ago), so there is a minimal 
contract in place already.


Stanton Fisque
principal technologist
latticeware.com
portland, oregon

> On Oct 13, 2023, at 05:27 AM, bugzi...@apache.org wrote:
> 
> https://bz.apache.org/bugzilla/show_bug.cgi?id=60848
> 
> --- Comment #15 from PJ Fanning  ---
> I think it was a big mistake for POI to start evaluating formulas. It is too
> complicated and there are not enough devs interested. It doesn't just take
> someone to submit a change. It takes multiple people to review it.
> 
> 
> Releases are irregular.
> 
> Does anyone need POI to calculate formulas? The answer is no. Excel can be 
> made
> to recalculate the formulas when you load the xlsx into Excel.
> 
> See
> https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setForceFormulaRecalculation-boolean-
> 
> -- 
> You are receiving this mail because:
> You are the assignee for the bug.
> -
> To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
> For additional commands, e-mail: dev-h...@poi.apache.org
> 


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 65260] Creating an SXSSFWorkbook fails if no fonts are available on the system

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=65260

--- Comment #15 from Michal  ---
Version 5.2.4 resolved the issue, thank you all for your help!

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60848

--- Comment #15 from PJ Fanning  ---
I think it was a big mistake for POI to start evaluating formulas. It is too
complicated and there are not enough devs interested. It doesn't just take
someone to submit a change. It takes multiple people to review it.


Releases are irregular.

Does anyone need POI to calculate formulas? The answer is no. Excel can be made
to recalculate the formulas when you load the xlsx into Excel.

See
https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setForceFormulaRecalculation-boolean-

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 60848] SUMPRODUCT fails when first arg is of form --(...)

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=60848

Jakub  changed:

   What|Removed |Added

 CC||jakub.vojti...@gmail.com

--- Comment #14 from Jakub  ---
Created attachment 39124
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=39124=edit
Test cases for intersection, sumproduct and index.

I've been able to reproduce the bug, looked at the code and played a bit with
similar related cases. The problem is not in the SUMPRODUCT function nor in the
unary minus. It is about implementation of implicit intersections in POI. Here
is some introduction to the intersections:
https://www.ablebits.com/office-addins-blog/excel-implicit-intersection/

The logic when implicit intersection happens and when not is quite complex.
Here's what I've found out using Excel 2010:
- In a "normal mode" common arithmetic operations causes implicit
intersections. For example assume there are values 1 to 5 in cells A1 to A5.
Then the formula "=2*A1:A5" evaluated in the B2 cell returns the value of A2
multiplied by 2, i.e. 4.
- If a formula is saved using Ctrl+Shift+Enter it is stored as array formula
(aka CSE formula, in excel it is wrapped in curly brackets). Implicit
intersection is suppressed in CSE formulas. Let's call it an "array mode". The
whole CSE formula is evaluated in array mode.
- Some functions changes the mode in which their arguments are evaluated, in
particular:
-- SUMPRODUCT will force the array mode on all its arguments. In above example
the formula "=SUM(2*A1:A5)" in the B2 cell returns 4 (implicit intersection
happens) but "=SUMPRODUCT(2*A1:A5)" returns 30 as it doesn't intersects and
sums the range multiplied by 2.
-- INDEX function will force the array mode on it's first argument.
Interestingly it also switches the evaluation of its second and third argument
to the normal mode. That is true if INDEX is used inside SUMPRODUCT. If INDEX
is used in a CSE formula, no switching happens. Implicit intersection is
suppressed on all evaluations in CSE formula.
- Some functions which also accept array arguments just keep the mode as it
was, for example functions MIN or MAX functions. 

Now, POI seems to work well in the array mode (in CSE formulas) as well as in
the normal mode. What is not implemented is switching of the mode by certain
functions (SUMPRODUCT in this case). Note there is a piece of code attempting
to do this. The org.apache.poi.ss.formula.functions.ArrayMode interface is
clearly intended for that. See where it is used in the
org.apache.poi.ss.formula.WorkbookEvaluator. However doesn't implement the
logic above correctly. Also the INDEX is the only function implementing the
ArrayMode interface.

This is what I've found out so far. It is demonstrated in the attached
workbook. There is a column in the workbook showing where POI would give wrong
results. It is not just the SUMPRODUCT, INDEX function alone also can give
errors.

If anyone thinks it works differently or knows about some formal specification
or documentation please comment.

I have some ideas of how to fix it. Seems to resolve the bugs in the attached
workbook however there is lot more to investigate and test...

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Jenkins build is back to normal : POI » POI-DSL-no-scratchpad #172

[Apache Jenkins Server]

See 



-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Re: [PR] Bump org.mockito:mockito-core from 4.11.0 to 5.6.0 [poi]

[via GitHub]

dependabot[bot] commented on PR #530:
URL: https://github.com/apache/poi/pull/530#issuecomment-1761202896

   OK, I won't notify you again about this release, but will get in touch when 
a new version is available. If you'd rather skip all updates until the next 
major or minor version, let me know by commenting `@dependabot ignore this 
major version` or `@dependabot ignore this minor version`. You can also ignore 
all major, minor, or patch releases for a dependency by adding an [`ignore` 
condition](https://docs.github.com/en/code-security/supply-chain-security/configuration-options-for-dependency-updates#ignore)
 with the desired `update_types` to your config file.
   
   If you change your mind, just re-open this PR and I'll resolve any conflicts 
on it.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Re: [PR] Bump net.bytebuddy:byte-buddy-agent from 1.14.7 to 1.14.9 [poi]

[via GitHub]

dependabot[bot] commented on PR #529:
URL: https://github.com/apache/poi/pull/529#issuecomment-1761202875

   OK, I won't notify you again about this release, but will get in touch when 
a new version is available. If you'd rather skip all updates until the next 
major or minor version, let me know by commenting `@dependabot ignore this 
major version` or `@dependabot ignore this minor version`. You can also ignore 
all major, minor, or patch releases for a dependency by adding an [`ignore` 
condition](https://docs.github.com/en/code-security/supply-chain-security/configuration-options-for-dependency-updates#ignore)
 with the desired `update_types` to your config file.
   
   If you change your mind, just re-open this PR and I'll resolve any conflicts 
on it.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Re: [PR] Bump net.bytebuddy:byte-buddy from 1.14.7 to 1.14.9 [poi]

[via GitHub]

dependabot[bot] commented on PR #532:
URL: https://github.com/apache/poi/pull/532#issuecomment-1761202850

   OK, I won't notify you again about this release, but will get in touch when 
a new version is available. If you'd rather skip all updates until the next 
major or minor version, let me know by commenting `@dependabot ignore this 
major version` or `@dependabot ignore this minor version`. You can also ignore 
all major, minor, or patch releases for a dependency by adding an [`ignore` 
condition](https://docs.github.com/en/code-security/supply-chain-security/configuration-options-for-dependency-updates#ignore)
 with the desired `update_types` to your config file.
   
   If you change your mind, just re-open this PR and I'll resolve any conflicts 
on it.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Re: [PR] Bump com.google.guava:guava from 32.1.1-jre to 32.1.3-jre [poi]

[via GitHub]

dependabot[bot] commented on PR #533:
URL: https://github.com/apache/poi/pull/533#issuecomment-1761202837

   OK, I won't notify you again about this release, but will get in touch when 
a new version is available. If you'd rather skip all updates until the next 
major or minor version, let me know by commenting `@dependabot ignore this 
major version` or `@dependabot ignore this minor version`. You can also ignore 
all major, minor, or patch releases for a dependency by adding an [`ignore` 
condition](https://docs.github.com/en/code-security/supply-chain-security/configuration-options-for-dependency-updates#ignore)
 with the desired `update_types` to your config file.
   
   If you change your mind, just re-open this PR and I'll resolve any conflicts 
on it.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Re: [PR] Bump org.mockito:mockito-core from 4.11.0 to 5.6.0 [poi]

[via GitHub]

asfgit closed pull request #530: Bump org.mockito:mockito-core from 4.11.0 to 
5.6.0
URL: https://github.com/apache/poi/pull/530


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Re: [PR] Bump com.github.spotbugs from 5.0.14 to 5.1.4 [poi]

[via GitHub]

dependabot[bot] commented on PR #531:
URL: https://github.com/apache/poi/pull/531#issuecomment-1761202814

   OK, I won't notify you again about this release, but will get in touch when 
a new version is available. If you'd rather skip all updates until the next 
major or minor version, let me know by commenting `@dependabot ignore this 
major version` or `@dependabot ignore this minor version`. You can also ignore 
all major, minor, or patch releases for a dependency by adding an [`ignore` 
condition](https://docs.github.com/en/code-security/supply-chain-security/configuration-options-for-dependency-updates#ignore)
 with the desired `update_types` to your config file.
   
   If you change your mind, just re-open this PR and I'll resolve any conflicts 
on it.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Re: [PR] Bump net.bytebuddy:byte-buddy-agent from 1.14.7 to 1.14.9 [poi]

[via GitHub]

asfgit closed pull request #529: Bump net.bytebuddy:byte-buddy-agent from 
1.14.7 to 1.14.9
URL: https://github.com/apache/poi/pull/529


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Re: [PR] Bump net.bytebuddy:byte-buddy from 1.14.7 to 1.14.9 [poi]

[via GitHub]

asfgit closed pull request #532: Bump net.bytebuddy:byte-buddy from 1.14.7 to 
1.14.9
URL: https://github.com/apache/poi/pull/532


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Re: [PR] Bump com.google.guava:guava from 32.1.1-jre to 32.1.3-jre [poi]

[via GitHub]

asfgit closed pull request #533: Bump com.google.guava:guava from 32.1.1-jre to 
32.1.3-jre
URL: https://github.com/apache/poi/pull/533


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Re: [PR] Bump com.github.spotbugs from 5.0.14 to 5.1.4 [poi]

[via GitHub]

asfgit closed pull request #531: Bump com.github.spotbugs from 5.0.14 to 5.1.4
URL: https://github.com/apache/poi/pull/531


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 67510] No POI-generated Charts can be opened by Excel for Mac v. 16.77

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=67510

PJ Fanning  changed:

   What|Removed |Added

 CC||effort0...@naver.com

--- Comment #15 from PJ Fanning  ---
*** Bug 67726 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 67726] Error occur when using createChart

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=67726

PJ Fanning  changed:

   What|Removed |Added

 Resolution|--- |DUPLICATE
 Status|NEW |RESOLVED

--- Comment #2 from PJ Fanning  ---


*** This bug has been marked as a duplicate of bug 67510 ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org