Enterprise Spreadsheet 

Solutions
    
    

    
 
    
    

    
www.FarPointSpread.com   
    
    

    
 
    
   
  
  

  
 
 


  

  

   

    

    


    Season's greetings! Our products and services are all about helping you
    connect more data in the enterprise with more of your customers. With
    FarPoint, you can find solutions for the Web with our ASP.NET product, on
    the desktop with one of our award winning .NET products, throughout the
    enterprise with our BizTalk solution, or with the speed and performance of
    our reliable COM/ActiveX product. We have exciting news about many of these
    solutions in this newsletter.
    
We have recently released the latest version of FarPoint Spread for BizTalk
    Server, which now includes support for Excel
    2007 files. Read more on this exciting development below, and find out
    what's next in version 2.0. 
    
Perhaps our most exciting news, however, is with the
    latest version of our flagship .NET product, FarPoint Spread for Windows Forms,
    with so many added features including PDF support, floating formula bar,
    auto-completion, outline grouping, and much more. In this issue, find out
    what some of the latest features are that are new to the upcoming FarPoint
    Spread for Windows Forms version 4.
    
Derek Levandowski , Editor

    Editor@FarPointSpread.com
    
    

    
 
    
    
   
  

  

  

  
  
What's New
  

   

    

    

    
FarPoint
    Spread for BizTalk Server® 

    Version 1.7 Released 
    
    
FarPoint Spread for BizTalk Server 2006 provides a
    complete solution to integrating Microsoft Excel data seamlessly into your
    BizTalk applications.
    
<

/span>
    

    
*Note - Assembler will be available in version 2.0.
    Customers who purchase version 1.7 will be upgraded to version 2.0 at no
    additional cost. 
    
FarPoint Spread for BizTalk Server 2006 version 1.7
    includes a pipeline disassembler that parses incoming Excel data into XML,
    and coming
    soon in version 2.0, a pipeline assembler that
    converts XML data into documents of either Excel (XLS, Excel 2007 XML), or
    PDF formats.
    
FarPoint Spread for BizTalk includes the Visual
    Studio-integrated Spreadsheet Schema Wizard that enables the developer to
    codelessly create custom schemas that define the structure of the XML data
    parsed from incoming Excel streams through the disasembler. This same
    Wizard is also used to define the schema that represents incoming XML data
    streams that are assembled into Excel or PDF documents through the
    assembler.
    
 
    

    

    
    

    
Coming Soon: FarPoint Spread for Windows Forms version
    4.0 

    Features in 4.0
    
General Features 
    

     
PDF Export 
     
Barcode Cell
         Type 
     
Formula Text
         Box and Range Selection for Formula 
     
Fractions (in
         Number Cell Type) 
     
Range of Cells as a Data Source and Bind Data Source to Range 
     
Add Row (as in
         DataGrid) 
     
Automatic Completion
         (Type Ahead) for Cells 
     
Increased
         Performance (by Speeding-Up Compositing of Styles) 
     
Spread Designer
         Updates 
     
Color Picker
         Cell Type 
     
Formula
         Provider (for Calculations of Controls)
    
    
Appearance Features 
    

     
Outline
         Grouping (Excel-Style) 
     
Cell Note Indicator
         Customization 
     
Sheet Corner
         Customization 
     
Edit Control
         Style Customization (Excel-Style Focus Indicator) 
     
Text Rendering 
     
New Default
         Header Renderers (and Highlight Selected Headers) 
     
New,
         customizable FarPoint Spread (component-level) skins (themes)
    
    
Export-to-Excel Features 
    

     
Excel XML12
         Support - (Excel 2007 XML BIFF12, XLSX and XSLB) 
     
Import/Export
         Images (bitmaps) to Excel XLS (BIFF8) only (Escher layer - shapes and
         controls) 
     
Import/Export
         Validation List to Excel (ComboBoxCellType to Excel) 
     
Export
         View-Driven Version of Data to Excel with ExcelSaveFlag 
     
Export
         Alternating Rows Settings (AlternatingRow properties) to Excel 
    
    
 
    
   
   

    

    

    
 
    
    
   
  
  
to top       

  

  

  
  
Award-Winning Success
  

   

    

    


    
    
    

    

    
Best Grid in
    2007 
    
    
FarPoint Spread for Windows Forms was honored with the
    Readers’ Choice Award for ‘Best Grid’
    from Visual
    Studio Magazine. The 2007 winners, which appeared in
    the June issue, are chosen by Visual Studio Magazine’s
    readers and honor excellent software in 22 development categories.
    
Patrick Meader, Visual Studio Magazine
    editor in chief, said, "The Readers Choice Awards are special because
    it is an accolade from the person most qualified to say whether a product
    is great: the person who uses it. These aren’t managers voting, but
    developers—developers who use these tools on a daily basis to
    simplify their lives and create better software at a lower price. As such,
    there is no better recommendation for the value of a given company’s
    product. I commend all the Readers Choice Award winners. Visual Studio Magazine
    readers have put your product on top.”
    
   
  
  
to top       
  
  

   size=2 width="100%"
  align=center>
  
  
 
  

   

    

    
<

/font>

    
    

    

    
FarPoint offers online demos
    and customized presentations

    via Web using Live Meeting.
    
FarPoint offers their customers and potential
    customers the opportunity to meet with them from the comfort of their own
    desk or conference room with these Web-based sessions made possible with
    Microsoft Live Meeting. Continuing to lead the industry in technical
    product support, FarPoint makes it easy to see the product in action with
    customer specific data or at least with industry specific examples.
    


    Using Live Meeting, FarPoint provides the following benefits to viewers:

    o Real-time support or answers to questions

    o Web and phone, available world-wide

    o Direct access to FarPoint solution expertise
    
    
   
  
  
to top       

  

  

  
  
Meeting FarPoint
  

   

    

    


    
    
    

    

    
Club FarPoint
    
    
    
 
    
Chat with FarPoint Developers on our message boards at
    www.ClubFarPoint.com
    
    
You can also:
    
Watch training videos

    Read whitepapers

    Interact with other FarPoint customers 

    Read about our upcoming events and tradeshow appearances

    Read Frequently Asked Questions

    Suggest new features 

    

    
    
   
   

    

    
       
    
    

    

    
Live Chat Now
    Online
    
    
For those customers
    (and potential customers) who want answers immediately, now you can reach
    us online from our main web page where you can start a chat session with a
    sales person who can answer your questions. We had enough success offering
    this for technical support that we thought we would offer it to everyone.
    If you have a question, just start an online chat
    session with us. 

    

    You can reach us for tech support questions on the live technical
    support chat sessions every Tuesday from 10:00 am to 11:00 am and Thursday from 2:00 pm to 3:00 pm ET. Drop by
    and chat with us. 
    
to top       
    
   
  

  

  

  
  
Nifty Tech Tips
  

   

    

    
Here are a few posts that many users have found
    helpful on our Tech Support
    forums. If you have found these posts helpful, let us know. If there
    are tips you would like to share with others, post them on the forum or
    send them to us. Visit www.ClubFarPoint.com for all of your development
    needs.
    

    
 
    FarPoint Spread for Web Forms
    
    
Did you know that
    you can use FarPoint Spread for Web Forms as a SharePoint web part?
    
For those customers who are
    using Microsoft SharePoint, you might be interested to know that FarPoint
    Spread for Web Forms can be used as a Web Part in your SharePoint solution.

    Basically, FarPoint Spread for Web Forms can be put in a Web Part created
    in Visual Studio 2005 and then you can use that Web Part in the SharePoint
    solution.Here are the three basic steps to make FarPoint Spread for Web
    Forms work in a SharePoint Web Part.

    

    1. Set the
    trust: 

    In the SharePoint web.config file, set the TrustLevel to Full.

    

    2. Mark
    DLLs as safe: 

    In the SharePoint web.config file, mark the FarPoint product DLLs as safe.
    This includes FarPoint.CalcEngine.dll, FarPoint.Excel.dll and
    FarPoint.Web.Spread.dll.

    

    3. Less is
    more:

    This assumes you are using the latest version of SharePoint (WSS or MOSS).
    For earlier versions of SharePoint you also had the additional step of
    excluding the fp_client folder from the SharePoint server. 

    This is no longer necessary. From the SharePoint server, exclude the
    fp_client folder of FarPoint Spread for Web Forms. 

    

    FarPoint Spread can be used inside the Web Part you are developing.

    

    In earlier versions of the product, the FpSpread.RenderWebPart method was
    used for the .NET Framework 1.x when you created a Web Part based on
    Microsoft.SharePoint.WebPartPages.WebPart class. 

    In .NET Framework 2.x, the Web Part becomes part of the framework. If you
    use the framework WebPart class,
    System.Web.UI.WebControls.WebParts.WebPart, the FpSpread.RenderWebPart
    method is no longer needed.

    

    For more information on Web Parts in SharePoint, you may want to read
    "Building Web Parts for Microsoft SharePoint Products and
    Technologies" Parts I and II:
    


    * Part I - The Basics  http://www.microsoft.com/belux/nl/msdn/community/columns/tisseghem/webparts1.mspx

    * Part II - Web Parts and User Controls   http://www.microsoft.com/belux/nl/msdn/community/columns/tisseghem/webparts2.mspx
    
    

    

    
    

    
 
    FarPoint Spread for Windows Forms
    
    
Build
    a Hierarchy without Data 

    FarPoint Spread for Windows
    Forms > Hierarchy > Build a Hierarchy without Data 

    http://www.clubfarpoint.com/Forums/forums/thread/13140.aspx
    
GetSpanCell for
    Column Header Cells 

    FarPoint Spread for Windows Forms > Appearance > GetSpanCell for
    Column Header Cells 

    http://www.clubfarpoint.com/Forums/forums/thread/53220.aspx
    
    
Adding Tool Tip Over Button
    Cell

    FarPoint Spread for Windows Forms > General > Adding tool tip over
    button cell 

    http://www.clubfarpoint.com/Forums/forums/thread/51029.aspx
    

    

    Sizing a
    Spreadsheet 

    FarPoint Spread for Windows Forms > Appearance > Sizing a spreadsheet
    

    http://www.clubfarpoint.com/Forums/forums/thread/11149.aspx
    

    

    Determine
    Cursor Position Inside the Cell 

    FarPoint Spread for Windows Forms > Appearance > Determine cursor
    position inside the cell 

    http://www.clubfarpoint.com/Forums/forums/thread/53807.aspx
    
    

    

    
    

    
 
    FarPoint Spread for COM/ActiveX
    
    
Auto-Resize Columns to Fill
    Available Area 

    FarPoint Spread (COM) > Appearance > Auto-Resize Columns to Fill
    Available Area 

    http://www.clubfarpoint.com/Forums/forums/thread/52909.aspx
    

    

    

    
    
   
  
  
to top       

  

  

  
  
Current Versions
  

   

    

    
Are you using the
    latest version? If not, log into the support site at www.clubFarPoint.com
    to download the latest maintenance release. If you haven't logged in
    before, click on the 'Not a Member Yet?' link when online to join. It's
    free!
    

     

      

      
.NET Products
      
      

      
Version
      
      

      
       
               
      
      

      
COM Products
      
      

      
Version
      
     
     

      

      
FarPoint Spread 

      for Web Forms 3.0 VS2005
      
      

      
03.00.2005
      
      

      
  
      
      

      
FarPoint Spread 7
      
      

      
07.00.43
      
     
     

      

      
FarPoint Spread 

      for Web Forms 3.0 VS2002/2003
      
      

      
03.00.1005
      
      

      
  
      
      

      
Tab Pro 3.1
      
      

      
03.01.24
      
     
     

      

      
FarPoint Spread 

      for Web Forms 2.5
      
      

      
02.05.2009
      
      

      
  
      
      

      
List Pro 3
      
      

      
03.00.48
      
     
     

      

      
FarPoint Spread 

      for Windows Forms 3.0 VS2005
      
      

      
03.00.2005
      
      

      
  
      
      

      
Input Pro 3
      
      

      
03.00.37
      
     
     

      

      
FarPoint Spread 

      for Windows Forms 3.0 VS2002/2003
      
      

      
03.00.1005
      
      

      
  
      
      

      
Calendar Objx 3
      
      

      
03.00.16
      
     
     

      

      
FarPoint Spread 

      for Windows Forms 2.5
      
      

      
02.05.2013
      
      

      
  
      
      

      
Button Objx 2
      
      

      
02.00.35
      
     
     

      

      
Input Pro for Windows Forms
      
      

      
01.00.13
      
      

      
  
      
      

      
  
      
      

      
  
      
     
     

      

      
  
      
      

      
  
      
      

      
  
      
      

      
  
      
      

      
  
      
     
     

      

      


      Service
      Oriented Architecture

      (SOA)
      Products 
      
      

      
Version
      
      

      
  
      
      

      
  
      
      

      
  
      
     
     

      

      
FarPoint Spread for BizTalk
      
      

      
1.7
      
      

      
  
      
      

      
  
      
      

      
  
      
     
    
  
    
   
  
  
 
  
to top       

  

  

  
  
Contact Us
  

   

    

    


    FarPoint
    Technologies, Inc.

808 Aviation Parkway, Suite 1300

Morrisville, NC 27560 USA

    800-645-5913 or 919-460-4551

    FPSales@FarPointSpread.com 


    
    

    
FarPoint Europe Ltd. 

    Whiteleaf, Roundabout Lane 

      West Chiltington, Pulborough West Sussex

    RH20 2RL England
    

    +44 (0) 1798 812 372 

    SalesEurope@FarPointSpread.com