Wednesday, July 30, 2008

Export to Spreadsheet

Issue / Error:- “Cannot get the list Schema column property from the SharePoint List”
When does is occur? :– While exporting a list to Excel Spreadsheet.
Environment :- Office 2003
Resolution :- Known bug. Can be resolved by Post Service Pack 1 release http://support.microsoft.com/kb/941422/en-us

Workaround:-
Upgrade to office 2007 OR
a. Change all the Date columns in the List to use “Date Only” format.

b. Using a machine which has Office 2007 installed, Export the list to Spreadsheet.
c. Create a new Blank “Import Spreadsheet” List.
d. Import the old Exported List back.
e. Now you will be able to export the list to spreadsheet in Office 2003 also.

Note: Do not change the format back to “Date & Time”

How to Re-produce the issue?

1. Create a SharePoint List with “Date and Time” Column keeping the format as “Date Only”
2. On Office 2003 machine Export the list to Spreadsheet, it will work without any issues.
3. Change the Date Column Format to “Date & Time”
4. Now again try to export the list to spreadsheet, it will not work, you will get the error “Cannot get the list Schema column property from the SharePoint List”, but the same list will get exported without any issues in Office 2007 setup.

Note: Even if you change the Date format back to “Date Only”, the issue will still persist; it does not resolve the error.

1 comment:

rean said...

Hi,
A user of ours is trying to export a document library data to a spreadsheet. When he does this the Approval column which has "approved", "inProgress", and "rejected" as status entries gets converted to 16 for the status approved, 2 for the status In- progress....why does this happen when the data is exported to a spread sheet or even for that matter a datasheet. Is this a bug.?