Hi Team we are using Aspose .NET 2.0 dll v184.108.40.206.
We are facing an issue where in autofit feature is working inconsistently.
When developing and testing on my local, it is working fine for invariable length content in a merged cell. Generated cell has the target merged cell appropriately fitted.
However when we deploy template and code to development servers (IIS 6.0), for certain cases autofit is not working properly. Invariably the row is being fitted one line height shorter than required.
It is not a case of special characters or newlines in the text. Even for long plaintext strings with no newlines, sometimes the last line is cut off. (Please see attachment - There is more text in the cell than displayed because row height is not being adjusted properly).
It is happening for merged as well as non-merged cells.
For confidentiality purposes we cannot attach a sample excel or screen shot. Please revert and we will try to provide as much information as possible.
- According to the release notes for Aspose Cells v220.127.116.11, it is mentioned that a weird bug for AutoFit was fixed. Can you elaborate on that issue.
- Also if possible can you outline the steps taken to achieve autofit for merged cells. As this feature is not natively supported by Excel, we would like to know how Aspose attempts to do it.