How can I make this?http://s33.postimg.org/w78huuo3j/grid2.png
To be like this…http://s33.postimg.org/e5pcx1u2n/grid1.png
Hi Joshua,
Thank you for contacting Aspose support.
By looking at your provided snapshots, I think you may try to use GridWorksheet.AutoFitColumn method to auto-fit column(s) for your needs.
You can also handle this using Aspose.Cells for .NET while using Worksheet.AutoFitColumns method, that is; before importing the spreadsheet in GridWeb (in case you are loading an existing file).
AutoFitColumns didnt solve my problem… Actually what I want is the cell border be remove or hidden when a text overlapses it. actually the text is hidden so I force to use, overflow: visible !important to the span
The 2nd image is taken from excel file… the first image is from gridview. Is it a missing feature or Im doing something wrong.
Hi Joshua,
Please provide your sample project along with all its dependencies (assemblies. JavaScript files and input spreadsheets) here for better understanding of the scenario.
That said, in Excel application if a value is larger than the cell width and the next cell at the right is empty, the long value spans over to the next cell, just to display it completely. However, if next cell is not empty then the value trims down to the contents that can be displayed in available cell space. Whereas in Aspose.Cells.GridWeb, the value always trims down to fit the cell width regardless of the fact that next cell is empty or not. That is the reason I suggested you to expand the columns widths to accommodate the cell values.
Hi again,
This is to update you that I had a discussion with the concerned member of the product team regarding your requirement. We regret to inform you that GridWeb cannot behave similar to Excel in this regard, that is; the large values in GridCell will be trimmed according to the cell width, unless you increase the column width to make more space for the value.
That said, if you confirm, we can log your requirement as feature request in our database for feasibility analysis, and bring it on road map if found feasible.