Row Column headings incorrectly displayed in HTML when the Excel sheet contains hidden columns

Aspose.Cells Product Family
1

We have activated display of row/column headings using setExportRowColumnHeadings() in the HTML output
When our Excel sheet contains hidden columns, the column headings displayed in HTML do not match anymore the columns. Two screenshots attached: the HTML view and the original Excel file (in which columns S, T, U and V are hidden)

image.png (11.8 KB)

image.png (4.7 KB)

3

@jlherman1
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSJAVA-46351

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

4

Thanks.
I had prepared sample code and a sample Excel but looks like you do not need it anymore.

For the record:
import com.aspose.cells.*;
public class Main {
public static void main(String[] args) {
try {
Workbook workbook = new Workbook(“columns hidden.xlsx”);

        HtmlSaveOptions saveOptions = new HtmlSaveOptions();
        saveOptions.setExportRowColumnHeadings(true); // Includes row and column headings

        String outputPath = "output.html";
        workbook.save(outputPath, saveOptions);
    } catch (Exception e) {
        e.printStackTrace();
    }
}

}

… and any Excel file with some columns hidden will exhibit the wrong behaviour

5

@jlherman1
Thanks for your codes.
We have reproduced your mentioned issue . And we have opened the following new ticket CELLSJAVA-46351 in our internal issue tracking system .

1 Like
6

@jlherman1 ,

We are pleased to inform you that your issue has been resolved. The fix will be included in an upcoming release (Aspose.Cells v25.5) that we plan to release in the first half of May 2025. You will be notified when the next version is released.

7

The issues you have found earlier (filed as CELLSJAVA-46351) have been fixed in Aspose.Cells for Java 25.5.