locked
Custom Field Types Not Showing Up When Exporting to Spreadsheet/Datasheet/etc. RRS feed

  • Question

  • I have a custom field type similar to what's described here:

    http://msdn.microsoft.com/en-us/library/bb417414(v=office.12).aspx

    It works fine, but the users recently complained that it doesn't show up when using the Actions menu of the list to "Export to Spreadsheet". I also noticed it doesn't show up when editing in Datasheet mode.

    Is this a limitation of Office/SharePoint? Can custom field types display in Excel and other Office apps?

    • Moved by Mike Walsh FIN Friday, August 19, 2011 7:08 AM not programming (From:SharePoint - Development and Programming (pre-SharePoint 2010))
    Thursday, August 18, 2011 11:04 PM

Answers

All replies

  • Hi Colin,

    Just to confirm in the view you are using to export to spreadsheet - do you have that custom field listed? If not create another view / modify existing to include that field and then try to export/ edit.

    Hope that answers your question.

     


    BlueSky2010
    Friday, August 19, 2011 4:04 PM
  • Sadly, it doesn't answer the question.

    The custom field doesn't show up no matter how the views are configured. I can even create a DataSheet View with the field in question specifically selected and it still won't show up.

    Also, Mike Walsh shouldn't have moved this thread. It has to do with how a custom developed component interacts with SharePoint. I don't think non-developer admins are going to have run into this situation.

    Friday, August 19, 2011 4:53 PM
  • Saturday, August 20, 2011 10:10 AM
  • That was actually helpful, Rashu. Thanks.

    The problem ended up being that the person in question only had Office 2003 and it apparently doesn't support custom field types (and even some built-in field types).

    The datasheet/spreadsheet work fine with Office 2007 and above.

    Monday, August 22, 2011 7:19 PM
  • > Also, Mike Walsh shouldn't have moved this thread.

    Read the post again.

    The only question in the post was

    Is this a limitation of Office/SharePoint? Can custom field types display in Excel and other Office apps?

    There is nothing Programming about that.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Tuesday, August 23, 2011 6:25 AM