Setup warning : Missing dependency FarPoint.Win.Ink.dll

Posted by: marvel on 8 September 2017, 2:29 pm EST

  • Posted 8 September 2017, 2:29 pm EST

    Hi there,


     I'm using the Farpoint spread v. 5.0.3503.2008 In combination with .Net 2008. And got 2 questions.



    1. When I build a setup of my solution, I get the following warning in the err.List :   Unable to find dependency 'MICROSOFT.INK' (Signature='31BF3856AD364E35' Version='6.0.0.0') of assembly 'FarPoint.Win.Ink.dll' D:\Data Files\....
      I know a warning is no error but this can be an issue when we deploy it at customers, and like to get ridd of this when I hand it over to other programmer(s) / develop-team.
      Seems that there was a thread in 2006 for that same question / problem / issue:  http://www.clubfarpoint.com/Forums/forums/post/36849.aspx

    2. Is it possible to ajust the columns width to the text that its shows. Cant seem to find that propperty. And to calculate all the info that its showing in the grid for the text that is the broadest seems a bit overkill / outdated.

     


    Thanks in advanced

  • Replied 8 September 2017, 2:29 pm EST

    1. Microsoft.Ink is an assembly of the 3.0 and 3.5 .Net Framework, you may need to reinstall or get the latest version of that.


    2. As far as I can tell from the documentation there is no GetPreferredWidth method for columns in asp.net, I don't see any property of Column that can be set to automatically size the column. I believe if you want to set a column width to the witdth of its widest cell contents then you will have to loop thru all the cells in a column calling GetPreferredSize on each cell and getting the width out of the returned Size object and setting the Column.Width property to the largest.

  • Replied 8 September 2017, 2:29 pm EST

    Hello,

     It looks like you are trying to use the InkProvider on a system that does not have the MS Ink components installed. If you are designing Ink-enabled applications, you will want to get the Ink SDK from Microsoft. If you use the ink notation feature in your project then you will also need to distribute the FarPoint.Win.Ink.dll. This DLL would need to be installed to the directory where the application's executable file resides or be installed in the global assembly cache (GAC). This also requires the runtime components of the Microsoft Tablet PC SDK. The FarPoint.Win.Ink assembly is currently built with version 1.7 of the Microsoft Tablet PC SDK.

    For more information, see the following web site: http://msdn.microsoft.com/mobility/tabletpc/default.aspx

    If you are not using ink notation in your project, I do not think its gonna create any problem when it comes to running the project, you may ignore it too.

    In order to adjust the column width to show all the text in the cell , you may use GetPreferredWidth Method to get the desired width and set the column width accordingly.

     

    Thanks,

     

     

  • Replied 8 September 2017, 2:29 pm EST

    Hello,

    I believe you are using Spread 5 for Windows forms as FarPoint.Win.Ink.dll is a part of Windows version.

     

    Thanks,

     

     

  • Replied 8 September 2017, 2:29 pm EST

    Hi


    Thanks all for the reply. Seems that I did not needed the ink.dll. But the setup/solution had build/refferenced it by default or something.
    So thats solved.


     BUT.  the .ActiveColumn.GetPreferredWidth ( it does exists) only gives the preferred width of the actual grid and not of the column header.


    So if my header says: Bag size
    And the data in that column is : (row1) 90 , (row2) 80 ,(row3) 90 etc.


    the column PreferredWidth gives back the value of the Row 1 to #### and not the caption that is much wider.


    Heres my code :


    [CODE]


    Dim intActiveCol As Integer = 0
    Dim sngActiveColWidth As Single =0


    With ofpSpreadDispensed.ActiveSheet
       For intActCol = -1 To .ColumnCount - 1
          .SetActiveCell(-1, intActCol)
          
    sngActiveColWidth = .ActiveColumn.GetPreferredWidth
         
    .ActiveColumn.Width = sngActiveColWidth
       Next
    End with


    [/CODE]


    I have allso tried


    ofpSpreadDispensed.ActiveSheet.GetPreferredColumnWidth(intActiveCol, False)

    And


    ofpSpreadDispensed.ActiveSheet.GetPreferredColumnWidth(intActiveCol, False,False)



    But that one gives the same result. (Allso with the bools set to true, bit strange)




     


     


     

  • Replied 8 September 2017, 2:29 pm EST

    Hello,

    You need to set ColumnHeaderRenderer CellType to the ColumnHeader having WordWrap property to false and then set the width accordingly:-

    Dim c As New FarPoint.Win.Spread.CellType.ColumnHeaderRenderer()
    c.WordWrap = False
    fpSpread1.ActiveSheet.ColumnHeader.DefaultStyle.Renderer = c
    fpSpread1.ActiveSheet.ColumnHeader.Cells(0, 0).Text = "Longg Texttttt"
    fpSpread1.ActiveSheet.Cells(0, 0).Value = 21
    fpSpread1.ActiveSheet.ColumnHeader.Columns(0).Width = fpSpread1.ActiveSheet.GetPreferredColumnWidth(0)

    Thanks.

  • Replied 8 September 2017, 2:29 pm EST

    Reeva Dhingra:

    Hello,

    You need to set ColumnHeaderRenderer CellType to the ColumnHeader having WordWrap property to false and then set the width accordingly:-

    Dim c As New FarPoint.Win.Spread.CellType.ColumnHeaderRenderer()
    c.WordWrap = False
    fpSpread1.ActiveSheet.ColumnHeader.DefaultStyle.Renderer = c
    fpSpread1.ActiveSheet.ColumnHeader.Cells(0, 0).Text = "Longg Texttttt"
    fpSpread1.ActiveSheet.Cells(0, 0).Value = 21
    fpSpread1.ActiveSheet.ColumnHeader.Columns(0).Width = fpSpread1.ActiveSheet.GetPreferredColumnWidth(0)

    Thanks.





    Thanks,great info.
    I Only see that the header style is changed by the code, but that doesn't bother me (went from gold/yellow to Silver/Gray), but ok


    this solves my real problems
    so this thread can be closed
Need extra support?

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

Learn More

Forum Channels