Shift first column

Aspose.Cells Product Family
1

screens.png (12.4 KB)

test.zip (29.6 KB)

2

@PolyakovDN,

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:
e.g.
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.

3

@PolyakovDN
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);

4

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

5

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