Bug 66303 - POI excel formula support does not take into account that many formulas can take a cell range
Summary: POI excel formula support does not take into account that many formulas can t...
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 5.2.2-FINAL
Hardware: All All
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-10-11 18:07 UTC by PJ Fanning
Modified: 2022-12-26 09:42 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description PJ Fanning 2022-10-11 18:07:30 UTC
Based on https://bz.apache.org/bugzilla/show_bug.cgi?id=65743

It turns out that ABS can take a cell range as input. The POI code only seems to support ABS taking a single value.

ABS(A1:A5) is supported in Excel and returns 5 cells as a result with each value in the return being the ABS result of equivalent cell in the input range.

This seems to be a general issues. There are a lot of other functions where POI seems to expect just one input value but where Excel allows you to provide a range.
Comment 1 PJ Fanning 2022-10-11 18:08:22 UTC
Apologies - wrong link in the issue description - I meant to paste https://stackoverflow.com/questions/74025753/apache-poi-522-and-sumproductabsa1a5-formula-evaluation