Shift first column

screens.png (12.4 KB) (29.6 KB)


Thanks for the template file and screenshot.

Please notice, I am able to reproduce the issue as you mentioned by converting your template XLSX file to HTML. I found some data/columns are shifted and formatting is broken:
Sample code:

Workbook workbook = new Workbook("e:\\test2\\test.xlsx");
workbook.Save("e:\\test2\\out1.html", SaveFormat.Html);

I have logged a ticket with an id “CELLSNET-52019” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

The merged area spans some hidden rows, but the explorer skips rows where style.display is none , so the data moves in the other rows. At present, there is no good way , we have to delete the hidden lines with the following codes:
Workbook workbook = new Workbook(dir + “test.xlsx”);
HtmlSaveOptions htmlSaveOptions = new HtmlSaveOptions();
htmlSaveOptions.HiddenRowDisplayType = HtmlHiddenRowDisplayType.Remove;
workbook.Save(dir + “dest2.html”, htmlSaveOptions);

Please try the latest version 23.2 and you can simply open source file and save as html file now.

The issues you have found earlier (filed as CELLSNET-52019) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi