Export sheet with frozen column causing overflow

Posted by: loy-chan on 8 September 2017, 1:30 pm EST

  • Posted 8 September 2017, 1:30 pm EST

    I have sheet with a frozen column and if I export this sheet, the frozen column (in Excel) will overflow into the next column.


    Everything looks fine in my app but Excel looks messed.


    Check this out:


    fpSpread1.Sheets[0].Columns[1].Width = 10;


    fpSpread1.Sheets[0].FrozenColumnCount = 2;


    fpSpread1.Sheets[0].Cells[0, 1, 20, 1].Text = "some very long text";


     


    fpSpread1.SaveExcel(@"c:\test.xls", FarPoint.Win.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly);


     

  • Replied 8 September 2017, 1:30 pm EST

    Hmmm, after some investigation ... this seems to be a "feature" of excel.


    To prevent the overflow, I created a column of width 1 to the right of the offending column and put a space in each cell. No overflow.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels