Bug 68874 - For conditional formatting, areas should be cumulated for duplications
Summary: For conditional formatting, areas should be cumulated for duplications
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 5.2.3-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-08 14:54 UTC by JD
Modified: 2024-04-08 18:30 UTC (History)
0 users


Attachments
Reproducer (8.53 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-04-08 14:54 UTC, JD 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description JD 2024-04-08 14:54:13 UTC 
Created attachment 39655 [details]
Reproducer

For a conditional formatting rule, it is possible to define multiple areas while looking for duplications.

In my reproducer, the area to check duplication is (A0;A1:H1). In Excel, if A0 and H1 have the same value, the rule triggers the conditional formatting.

With Apache POI, areas A0 and A1:H1 are checked one after the other. The rule is then not triggered.
Comment 1 PJ Fanning 2024-04-08 18:30:02 UTC 
The POI community is pretty much moribund. Unfortunately, if you want a fix, you basically need to do it yourself. If you provide a PR or patch, it might be merged.