We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

RowHidden and RowHeight issue

Hi.


I have some issue with my template. I have received a following template from customer). It perfectly displayed in my MS Excel (2010), but worst in our renderer. I have found, that it incorrectly calculated rowheight and hidden for some rows.

@Test
public void testRowHeight() {
try {
Workbook wb = new Workbook(“D:\test.xls”);
Cells cells = wb.getWorksheets().get(0).getCells();

for (int i = 0; i < 20; i++) {

boolean isHidden = cells.isRowHidden(i);
double height = cells.getRowHeight(i);

System.out.println("[" + (i+1) + “] " + cells.get(i, 6).getDisplayStringValue() + " (” + height + ") - " + isHidden);

}

} catch (Exception e) {
e.printStackTrace();
assertNull(e);
}
}

Please note:
row 2 - visible and its height 15
row 5 - visible and its height 48
rows 6,7 - hidden


Best regards. Alexey

Hi Alexey,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue. Row 2 is visible but Aspose.Cells is showing hidden, similarly Row 5 is visible but Aspose.Cells is showing it hidden and Row 6, 7 are hidden but Aspose.Cells is showing them visible.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSJAVA-40771.

Output:
[1] (15.0) - false
[2] (0.0) - true
[3] Добывающие скважины/ Producing wells (25.5) - false
[4] Месторождение/ Field (15.0) - false
[5] (0.0) - true
[6] (25.5) - false
[7] (15.0) - false
[8] Снежное (43.5) - false
[9] Снежное (0.0) - true
[10] Итого по кусту 0 Р (0.0) - true
[11] (30.0) - false
[12] Снежное (15.0) - false
[13] Снежное (15.0) - false
[14] Снежное (15.0) - false
[15] Снежное (15.0) - false
[16] Итого по кусту 1 (15.0) - false
[17] (12.75) - false
[18] Снежное (12.75) - false
[19] Снежное (12.75) - false
[20] Снежное (12.75) - false

The issues you have found earlier (filed as CELLSJAVA-40771) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.