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:

    <FONT size=2>

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


    fpSpread1.Sheets[0].FrozenColumnCount = 2;


    fpSpread1.Sheets[0].Cells[0, 1, 20, 1].Text = </FONT><FONT color=#a31515 size=2>"some very long text"</FONT><FONT size=2>;


     


    fpSpread1.SaveExcel(</FONT><FONT color=#a31515 size=2>@"c:\test.xls"</FONT><FONT size=2>, FarPoint.Win.Spread.Model.</FONT><FONT color=#2b91af size=2>IncludeHeaders</FONT><FONT size=2>.ColumnHeadersCustomOnly);

    </FONT>

     

  • 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