I create a range from Row 9 Column … to Row 14 Column …
Now if I delete any row other than the first row(Row 9), the Range end row keeps decreasing by 1 , which is correct.
But if I delete Row 9, the updated Range becomes Row 8 to Row 13, which is wrong.
It should have been Row 9 to Row 13.
Code:
import com.aspose.cells.Range;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;
public class checkRange {
public static void main(String[] args) {
Workbook wb = new Workbook();
wb.getWorksheets().add("temp");
Worksheet ws = wb.getWorksheets().get("temp");
Range range = ws.getCells().createRange("A10:R15");
ws.getCells().addRange(range);
System.out.println("Range starting: "+range.getFirstRow());
System.out.println("Range ending: "+(range.getFirstRow()+range.getRowCount()-1));
ws.getCells().deleteRow(9);
System.out.println("Range starting: "+range.getFirstRow());
System.out.println("Range ending: "+(range.getFirstRow()+range.getRowCount()-1));
}
}
Output:
Range starting: 9
Range ending: 14
Range starting: 8
Range ending: 13
It should ideally have been:
Range starting: 9
Range ending: 14
Range starting: 9
Range ending: 13