Tuesday, April 5, 2011

Lookup column gives "#" symbol when export to spreadsheet

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
It was resolved after unmarking check-box for "Allow Multiple Values" for that lookup column under column settings

No comments: