Thank you for using Aspose products.
I have evaluated your presented scenario while using the latest version of Aspose.Cells for .NET 7.7.0, and I am unable to detect any problem in the resultant spreadsheet (attached). I would request you to give a try to the latest build on your end. In case you have any ambiguity, please feel free to write back.
Thank you for the elaboration, and for providing a snapshot of your desired results.
I am able to observe the presented issue while using the latest version of Aspose.Cells for .NET 7.7.0. A ticket (CELLSNET-42245) has been logged in our bug tracking system to probe further into this matter, and to provide a fix at earliest. Please spare us little time to properly analyze the problem cause on our end. In the meanwhile, we will keep you posted with updates in this regard.
For future reference, I have found two issues with AutoFitColumn method that have been logged for further analysis,
- Resultant spreadsheet seems to ignore the left border for column B.
- AutoFitColumn method is making the column width too tight for the text in cells. In some portions of the spreadsheet such as G12, the text seems to be touching the right cells border.
We are sorry for the inconvenience cause.
Unfortunately, we haven’t yet received any news in reference to the ticket logged earlier as CELLSNET-42245. A note has been recorded for the concerned development member to share the updates regarding the ticket status and ETA (if possible). As soon we have any updates, we will post here for your kind reference.