Clever Geek Handbook

Controlling the display of custom field types when exporting to a spreadsheet

I created a custom field type based on SPFieldLookup. However, when I use the SharePoint "Export to Spreadsheet" feature, it does not display correctly.

For normal lookup fields, only the Lookup Value is displayed. My custom field is using the string representation of the lookup value (ie "1; #My Lookup Value").

Is there a way to change the custom lookup field to only show the Lookup value when exporting to a spreadsheet?

0


source to share


1 answer


I'm not sure if it is possible to do what you want.

Here's a note from the SPFieldLookup documentation on MSDN:



Notes to Inheritors: In Windows SharePoint Services 3.0, columns based on custom field types are not displayed in the Datasheet view and are not included when the list is exported to a Microsoft Excel spreadsheet.

Maybe you can look into the DisplayPattern element in your fldtypes_XXX.xml file

+1


source






More articles:


All Articles