Tuesday, April 5, 2011

Lookup column gives "#" symbol when export to spreadsheet


Issue:
There are 3 lookup columns, when I export this list to spreadsheet these lookup fields export with #;ID attached to them, and I got "testdata#;15"  instead of "testdata" I get
Resolution:
It was resolved after unmarking check-box for "Allow Multiple Values" for that lookup column under column settings

Grab This Widget
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

Disclaimer

The opinions expressed on this blog are the personal views of Pratik's SharePoint Blog, and do not represent or reflect the viewpoints or policies of any past, present, or future employer, colleague, or customer, or any other entity. The posts on this blog are provided ‘as is’ with no warranties, express or implied, and confer no rights. Use of information contained within this blog, including specific technical steps mentioned herein, is at your own risk. References to specific software products, processes, resources, or companies do not imply any endorsement.