I am using Aspose.Cells v220.127.116.11. There is inconsistency in the HTML output of an Excel sheet’s range.
Please refer to the attached Excel file.
Output of Single row, multiple columns:
Let range is ‘Sheet1’!A1:K1, Cells from A1 to E1 have some value, Cells from F1 to K1 are empty. When taking HTML output, it contains Cells from A1 to E1 only (because rest of the cells are empty).
Output of Single column, multiple rows:
Let range is ‘Sheet1’!A1:A10, Cells from A1 to A7 have some value, Cells from A8 to A10 are empty. When taking HTML output, it contains all Cells from A1 to A10. This is not consistent with “Single row, multiple columns” behavior. Expected Output: HTML output should contain cells from A1 to A7 only, because cells from A8 to A10 are empty. Behavior across rows and columns must be consistent.
Currently, when taking HTML output of a range, empty columns are automatically excluded but empty rows are not excluded. If range is ‘Sheet1’!A1:K10 the output will actually contain cells from A1 to E10. Expected output is cells from A1 to E7.
Please find attached the Excel file, HTML output of A1:K1, output of A1:A10 and output of A1:K10, and the sample code used to generate the HTML output.
Can you please analyse this issue?