328CEF9A-F308-413F-BFFD-2C74DA2CBB63.png (234.0 KB)
There are only 4 collumns in the picture and actually there are ten more columns。
version 20.9.2
328CEF9A-F308-413F-BFFD-2C74DA2CBB63.png (234.0 KB)
There are only 4 collumns in the picture and actually there are ten more columns。
version 20.9.2
Please share your sample code (runnable) and sample files (input file (if any) and output file(s)) to reproduce the issue on our end, we will check it soon.
PS. please zip the files prior attaching.
bug.zip (469.2 KB)
The excel file is input and others are output,just export the excel to html
sample code:AsposeTest.zip (157.3 KB)
Could you elaborate and provide more details on where is the issue, in Smart Markers processing, in the output Excel file or in the output HTML? If the issue is in output HTML only, we can simply convert the (output) Excel file to HTML via Aspose.Cells APIs to simplify the scenario.
the issue is in output HTML only,just converting the excel to html can reproduce the issue.I would like to get all the column width in the colgroup, however I can just get part of them in the output html file.
To simplify your scenario/ case, please zip your input Excel file and output HTML (by Aspose.Cells) to show the issue. We will test the conversion (Excel to HTML) by both Aspose.Cells and MS Excel to trace the issue/difference. Also, share some screenshots to highlight the problematic area(s) comparing input Excel file Vs output HTML. This will help us evaluate your issue precisely to consequently figure it out soon.
I have provided the files,thanks
There are lot of files in your provided zipped archives. I tried the scenario/ case using the following sample code and your template (input) file and could not find any issue in the output (Excel and HTML) files (attached):
e.g.
Sample code:
Workbook workbook = new Workbook("f:\\files\\TestSmartMarkers.xlsx");
WorkbookDesigner designer = new WorkbookDesigner();
designer.setWorkbook(workbook);
ArrayList<Level> list = new ArrayList<Level>();
list.add(new Level("A", "A1"));
list.add(new Level("B", "B1"));
list.add(new Level("B", "B2"));
list.add(new Level("C", "C1"));
list.add(new Level("C", "C2"));
list.add(new Level("C", "C3"));
Worksheet worksheet = workbook.getWorksheets().get(0);
Cell a4 = worksheet.getCells().get("A4");
Cell a5 = worksheet.getCells().get("A5");
Cell a6 = worksheet.getCells().get("A6");
Cell a7 = worksheet.getCells().get("A7");
worksheet.getCells().insertColumns(3, 3, true);
Range initRange = worksheet.getCells().createRange(0, 3, true);
Range copyRange = worksheet.getCells().createRange(3, 3, true);
copyRange.copyStyle(initRange);
designer.setDataSource("Level", list);
designer.setCalculateFormula(true);
designer.setRepeatFormulasWithSubtotal(true);
designer.process();
workbook.save("f:\\files\\OutPutexcel.xlsx");
workbook.save("f:\\files\\OutPuthtml.htm");
.....
class Level {
private String level1;
private String level2;
public Level(String level1, String level2) {
this.level1 = level1;
this.level2 = level2;
}
public String getLevel1() {
return level1;
}
public String getLevel2() {
return level2;
}
}
Could you check the output files (attached) and let us know what’s wrong with HTML file. We will check your issue soon.
files.zip (19.9 KB)