Copy from Excel / Paste to InfoPath - InfoPath Dev
in

InfoPath Dev

Copy from Excel / Paste to InfoPath

Last post 01-14-2009 09:44 AM by mjm917. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-14-2009 09:02 AM

    • mjm917
    • Not Ranked
    • Joined on 08-22-2008
    • Naperville, IL
    • Posts 16

    Copy from Excel / Paste to InfoPath

    Newbie alert!

    In past years, my organization used a MS Excel workbook to create Performance Evaluations. This year we opted to recreate the form / process and I created a new Performance Evaluation form -- my first -- in InfoPath 2003. The form resides in a SharePoint (SP) document library. Our SP environment is MOSS 2007 STD so we do not have form services, excel services etc.

    As this is the "transition year," people are wanting to copy data from old Excel workbook to the new InfoPath form. When they do, InfoPath is retaining (creating) a table in the textbox. I believe peopel are copy a cell versus the contents of the cell. How can I get Inforpath to just take the text.

    Any and all help would be appreciated.

    Thx

    mjm917
  • 01-14-2009 09:29 AM In reply to

    • mjm917
    • Not Ranked
    • Joined on 08-22-2008
    • Naperville, IL
    • Posts 16

    Re: Copy from Excel / Paste to InfoPath

    I think I may have just found the solution. In the properties of the rich textbox, there is a full rich text formatting checkbox. If I uncheck this InfoPath pastes just the text without creating a table.

    If there is another (better) way to handle this then let me know

    ***

    As a follow-up question... Is there a way to add a formatting toolbar or menu so users know that they can format the text? 

     

    Thx

    mjm917
  • 01-14-2009 09:44 AM In reply to

    • mjm917
    • Not Ranked
    • Joined on 08-22-2008
    • Naperville, IL
    • Posts 16

    Re: Copy from Excel / Paste to InfoPath

    Please disreagrd my follow-up question. I was overlooking the formatting toolbar at the top of the form.

    Thx

    mjm917
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.