SharePoint Choice Column In Excel Info Panel

%3CLINGO-SUB%20id%3D%22lingo-sub-2775176%22%20slang%3D%22en-US%22%3ESharePoint%20Choice%20Column%20In%20Excel%20Info%20Panel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2775176%22%20slang%3D%22en-US%22%3E%3CP%3EPretty%20sure%20I've%20come%20across%20a%20bug%20in%20the%20way%20SharePoint%20document%20library%20column%20data%20is%20exchanged%20with%20Excel%20documents%20stored%20in%20that%20library.%26nbsp%3B%20When%20attempting%20to%20save%20SharePoint%20data%20through%20the%20Excel%20Info%20panel%20I%20get%20a%20javascript%20error%20and%20the%20data%20fails%20to%20save.%26nbsp%3B%20%26nbsp%3BI%20think%20this%20is%20an%20Excel%20issue%20rather%20than%20SharePoint%20because%20all%20other%20Office%20documents%20support%20this%20functionality%20and%20work%20as%20expected%20even%20when%20housed%20in%20the%20same%20SharePoint%20doc%20library.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20error%20can%20reliably%20be%20reproduced%20by%20doing%20the%20following%3A%3C%2FP%3E%3CUL%3E%3CLI%3ECreate%20a%20new%20SharePoint%20document%20library%20with%20a%20new%20column%20of%20type%20Choice%3CUL%3E%3CLI%3ESet%20display%20choice%20to%3A%20Checkboxes%20(allow%20multiple%20selections)%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3CLI%3EUpload%20or%20create%20a%20new%20Excel%20document%20in%20the%20SharePoint%20library%3C%2FLI%3E%3CLI%3EOpen%20the%20Excel%20document%20using%20the%20desktop%20app%3C%2FLI%3E%3CLI%3EOpen%20the%20Info%20panel%20in%20the%20Excel%20doc%3C%2FLI%3E%3CLI%3EUnder%20the%20Properties%20section%20of%20the%20Info%20panel%20in%20Excel%2C%20click%20the%20Show%20Details%20button%20next%20to%20the%20Choice%20column%3C%2FLI%3E%3CLI%3EA%20script%20error%20window%20will%20pop%20up%20with%20the%20message%20%E2%80%98Unable%20to%20set%20property%20%E2%80%98value%E2%80%99%20of%20undefined%20or%20null%20reference%E2%80%99%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2775176%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Pretty sure I've come across a bug in the way SharePoint document library column data is exchanged with Excel documents stored in that library.  When attempting to save SharePoint data through the Excel Info panel I get a javascript error and the data fails to save.   I think this is an Excel issue rather than SharePoint because all other Office documents support this functionality and work as expected even when housed in the same SharePoint doc library.

 

The error can reliably be reproduced by doing the following:

  • Create a new SharePoint document library with a new column of type Choice
    • Set display choice to: Checkboxes (allow multiple selections)
  • Upload or create a new Excel document in the SharePoint library
  • Open the Excel document using the desktop app
  • Open the Info panel in the Excel doc
  • Under the Properties section of the Info panel in Excel, click the Show Details button next to the Choice column
  • A script error window will pop up with the message ‘Unable to set property ‘value’ of undefined or null reference’
0 Replies