.SaveHtml doesn't translate the multiline option of text cells

Posted by: anne on 8 September 2017, 1:06 pm EST

  • Posted 8 September 2017, 1:06 pm EST

    Using Spread for Windows Forms 4 for 2.0 Framework (VS 2005) Feb Update


    .SaveHtml doesn't translate the multiline option of the text cells.

  • Replied 8 September 2017, 1:06 pm EST

    Anne -

    This working correctly in my test.  What version of 4 are you using, 4.0.2001?
  • Replied 8 September 2017, 1:06 pm EST

    Could you attach a small project reproducing this for us to debug.
  • Replied 8 September 2017, 1:06 pm EST

    I don't see multiline in your example...multiline...means there are carriage returns in the data...
  • Replied 8 September 2017, 1:06 pm EST

    Anne -

    I used a TextCellType and set WordWrap = True and Multiline = True and I have attached the resultant html file.

    2008/03/two.html
  • Replied 8 September 2017, 1:06 pm EST


    In this spread .... .WordWrap  and .Multiline are both set to True 

  • Replied 8 September 2017, 1:06 pm EST

    How are you setting up the word wrap?
  • Replied 8 September 2017, 1:06 pm EST

    4.0.2001.2005 attached is a picture


    2008/03/ExampleHTML.JPG
  • Replied 8 September 2017, 1:06 pm EST

    In the picture data...there is a carriage return after "from", before "to" and after "to".  The last line is an example of word wrap...


    In your example ...where are your carriage returns...all I see is word wrap...

  • Replied 8 September 2017, 1:06 pm EST

    Hello,


    I was able to reproduce this issue and have reported this as a bug (#22265) for the development team to fix for the next maintenance release. For now, you can replace the line breaks in your text with < br > tag and this will force a new line.

  • Replied 8 September 2017, 1:06 pm EST

    The original picture ...I attached...


    It still looks like wordwrap...please try ...I think it may need to be vbCrLf  ...CHR(13) & CHR(10)


    "T" & vbCrLf & "h" & vbCrLf & "is a " & vbCrLf & "printing test"....


     

  • Replied 8 September 2017, 1:06 pm EST

    There is no picture attached.  Here is my text code...

    Dim t As New FarPoint.Win.Spread.CellType.TextCellType
    t.Multiline = True

    FpSpread1.ActiveSheet.Rows(0).CellType = t
    FpSpread1.ActiveSheet.Cells(0, 0).Text = "This is a " & Chr(10) & "printing test"

    2008/03/twotest.html
Need extra support?

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

Learn More

Forum Channels