Cell.Value text limit

Aspose.Cells Product Family
1

Please assist with the cell.Value text length limitation. The text is trimmed.

    public byte[] CreateSamplePDFData() {

        var outPutDirectory = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase);
        var xlPath = Path.Combine(outPutDirectory, @"XL Template\Book1.xlsx");
        string localPath = new Uri(xlPath).LocalPath;
        Stream fs = File.OpenRead(localPath);

        var wb = new Workbook(fs);
        var worksheet = wb.Worksheets[0];            

        List<string> parties = new List<string>();
        for (int i = 0; i < 30; i++) {
            parties.Add( "SAMPLE_PARTY_" + i.ToString());
        }

        var cells = worksheet.Cells;
        var cell = cells[1, 1];
        cell.Value = string.Join( ";", parties);

        var someStyle = wb.CreateStyle();
        someStyle.Font.IsBold = false;
        someStyle.Font.Size = 9;
        someStyle.IsTextWrapped = true;
        someStyle.VerticalAlignment = TextAlignmentType.Top;
        cell.SetStyle( someStyle);
        worksheet.AutoFitRow(1); 

        using (var ms = new MemoryStream()) {
            wb.Save( ms, SaveFormat.Pdf);
            return ms.ToArray(); 
        }
    }
2

@sashavassilev,

Please note, in MS Excel, a row height cannot be more than 209 (points), see the MS Excel limitations for your reference. So, when you apply auto-fit row operation via Aspose.Cells, it could not extend row height more than 209 and consequently some text is trimmed to be shown in the cell. Since the column’s width is set minimum (by default) (i.e., by default a column’s
width is “8.43” points). So, you should extend the width of the column (e.g., B column) a bit. See the following sample code that works for your needs. I have extended B column’s width so all the data is completely shown/fit in the cell.
e.g.
Sample code:

            var wb = new Workbook(FileFormatType.Xlsx);
            var worksheet = wb.Worksheets[0];

            List<string> parties = new List<string>();
            for (int i = 0; i < 30; i++)
            {
                parties.Add("SAMPLE_PARTY_" + i.ToString());
            }

            var cells = worksheet.Cells;

            //Set or extend B column width.
            cells.SetColumnWidth(1, 30);

            var cell = cells[1, 1];
            cell.Value = string.Join(";", parties);

            var someStyle = wb.CreateStyle();
            someStyle.Font.IsBold = false;
            someStyle.Font.Size = 9;
            someStyle.IsTextWrapped = true;
            someStyle.VerticalAlignment = TextAlignmentType.Top;
            cell.SetStyle(someStyle);
            worksheet.AutoFitRow(1);
            wb.Save("e:\\test2\\out1.xlsx");

Hope, this helps a bit.