@kumar.penigalapati,
I am afraid that I have tried this project with the latest fix and also tried HtmlPage6.htm with the older project but in both the cases I get the attached exception.
For further investigation, this HtmlPage6.htm file is logged with the ticket and we will share our feedback at the earliest after testing this file.
HtmlPage6.png (249.3 KB)
Hi Ahsan Iqbal,
this could be because the proxy url is empty and I can not provide my proxy url for security concerns.
@kumar.penigalapati,
Thank you for the feedback. We have already logged your sample file with the ticket for further analysis.
Please try our latest version/fix: Aspose.Cells for .NET v20.11.10 (attached)
Your issue “CELLSNET-47729” should be fixed in it.
Let us know your feedback.
Aspose.Cells20.11.10 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells20.11.10 For .Net4.0.Zip (5.5 MB)
Aspose.Cells20.11.10 For .NetStandard20.Zip (5.4 MB)
The issues you have found earlier (filed as CELLSNET-47729,CELLSNET-47745) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao
Hi Amjad Sahi,
The Issue “CELLSNET-47729” seems to be not fixed with the new version of dll v20.11.10
we are still seeing images overlapping.
Image_Overlap1.zip (1.1 KB)
@kumar.penigalapati,
Thank you for the sample Html file. We have observed the issue with this sample file and re-opened the ticket for further analysis. We will write back here once any update is ready for sharing.
For managing issues accurately, we have created a new ticket with an id “CELLSNET-47792” to trace images being over lapping the text when importing “Image_Overlap1.html” to Excel via Aspose.Cells APIs.
Once we fix the issue, we will update you.
We are happy to inform you the issue (logged earlier as “CELLSNET-47792”) has been resolved. After performing QA and incorporating other enhancements and fixes, we will provide you with a fixed version soon.
Please try our latest version/fix: Aspose.Cells for .NET v20.12.3 (attached)
Aspose.Cells20.12.3 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells20.12.3 For .Net4.0.Zip (5.5 MB)
Aspose.Cells20.12.3 For .NetStandard20.Zip (5.4 MB)
Your issue “CELLSNET-47792” should be fixed now.
Let us know your feedback.
Thank you Amjad Sahi
we will validate the fix and will let you know.
Amjad Sahi,
the fix did not work as expected we are still seeing our images being overlapping in excel file.
Thanks.
Hi Amjad Sahi,
One Issue we observed is that when we do the workbook.Save before we initialize the worksheet the image over lapping issues don’t seem to be happening.
but when we do the workbook.Save at the end of all the logic of worksheets and adding oledb objects then the over lapping of images issue would still persist.
if we move the Workbook.Save like how its shown in the below code then at the end we do have logic for embedding the oldeb objects in the excel which is not working as expected.
so can you please assist us how we can have both oledb and images overlapping issues working at the same time.
HtmlLoadOptions options = new HtmlLoadOptions(LoadFormat.Html);
options.StreamProvider = new StreamProvider47584(proxyurl);
options.AutoFitColsAndRows = true;
Workbook wb = new Workbook(stream, options);
wb.Save(path1 + “\Page_out.xlsx”);
Worksheet ws = wb.Worksheets[0];
ws.Name = "Test";
ws.AutoFitRows();
ws.AutoFitColumns();
foreach(var bgattachemnt in billingGuideAttachments)
{
ws.OleObjects.Add(maxDataRow, col, 50, 50, CommonHelper.GetDocumentImageData(bgattachemnt.Value.ContentType));
// Set embedded ole object data.
ws.OleObjects[i].ObjectData = bgattachemnt.Value.Content;
ws.OleObjects[i].DisplayAsIcon = true;
ws.OleObjects[i].IsAutoSize = true;
ws.OleObjects[i].IsLink = false;
ws.OleObjects[i].ObjectSourceFullName = bgattachemnt.Value.FileName;
ws.OleObjects[i].ProgID = “Packager Shell Object”;
i++;
col += 5;
}
@kumar.penigalapati
AutoFitRows() only adapts the row height according to the text without considering the graphics. This is consistent with MS Excel. Currently, we cannot support adjusting the height of each line according to the graphics.
Hi Simon Zhao,
Thanks for the explanation that helps, we will not do the AutoFitRows and Columns when there are images.
with that change the images are showing up fine with out any over lap.
Thank you.
The issues you have found earlier (filed as CELLSNET-47792) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao
A post was split to a new topic: Exception raised while opening an XLSX file after conversion from HTML