Bug 66885 - getCellWithMerges() return empty Cell that it is centainly not null. But it is not correct.
Summary: getCellWithMerges() return empty Cell that it is centainly not null. But it i...
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 5.2.3-FINAL
Hardware: All All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-08-12 16:35 UTC by Donggyu Augustin Lee
Modified: 2023-08-12 16:36 UTC (History)
1 user (show)



Attachments
diff orig/SheetUtil.java new/SheetUtil.java (1.18 KB, text/plain)
2023-08-12 16:35 UTC, Donggyu Augustin Lee
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Donggyu Augustin Lee 2023-08-12 16:35:02 UTC
Created attachment 38740 [details]
diff orig/SheetUtil.java new/SheetUtil.java

Most of cases, merged Cells have one to be non-empty Cell. But in that cases, getCellWithMerges() return not non-empty Cell but empty Cell. Certainly, empty Cell is not null. But it is not correct result of getCellWithMerges() for SheetUtil.

In my test results, getCell(sheet, rowIx, colIx) doesn't return null when merged some Cell is empty. getCell(sheet, rowIx, colIx) returns empty Cell that is not null. I test on Microsoft Excel file.

getCellWithMerges() is not correct. It must fix.