When moving a row up in HSSFWorkbook, the LastRowNum decreases, but the physical rows do not decrease.

[yoi102]

NPOI Version

2.7.1

File Type

• XLS

Upload the Excel File

input.xls

Reproduce Steps

string inputFile = "input.xls";
IWorkbook workbook;

using (FileStream file = new FileStream(inputFile, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
{
    workbook = new HSSFWorkbook(file);
}


ISheet sheet = workbook.GetSheetAt(0);

Console.WriteLine(sheet.LastRowNum);
Console.WriteLine(sheet.PhysicalNumberOfRows);

sheet.ShiftRows(3, sheet.LastRowNum, -1);

Console.WriteLine(sheet.LastRowNum);
Console.WriteLine(sheet.PhysicalNumberOfRows);

string outputFile = "output.xls";
using (FileStream file = new FileStream(outputFile, FileMode.Create, FileAccess.Write))
{
    workbook.Write(file);
}

Issue Description

As shown in the code above, after I moved all rows below the third row up by one, the sheet.LastRowNum decreased by 1, but the sheet.PhysicalNumberOfRows remained unchanged.
Unlike XSSFWorkbook, where both sheet.LastRowNum and sheet.PhysicalNumberOfRows decrease by 1.