Hello Group.

In the past I have regularly received PowerPoint files containing embedded Excel objects and there will be more similar files in the future. I have previously used my own workaround to deal with the inserted objects (which involves converting the pptx file tp zip and 'hacking' the Embeddings and Charts folders containing xlsx and xml files). The news that Studio 2017 SR1 could handle embedded content in PPTX files was music to my ears.

So I am trying this facility using a PowerPoint PPTX file, fully compatible with MS-Office 2013, size 890 KB, containing 62 slides and about 5000 words. It is a report of a user survey containing a lot of data (responses given, % meeting certain criteria, etc.) presented as inserted Excel objects: graphs, pie charts, histograms, bar charts, etc. This file was successfully translated using my workaround, but I would like to have Studio handle future files without the added worll flow.

I have changed settings in the PowerPoint 2007-2016 File Type, which is set as the FIRST PPTX File Type in the list (see Paul Filkin's Multifarious blog, issued today); on the Common tab, I have selected Master view content, Headers and footers, Notes, Hyperlinks and Embedded Excel charts and sheets. The file processes through Studio OK and so far as I can tell the Excel chart data are included in the sdlxliff file and presented in the Editor view. But at the point where I export the target file, Studio reports an error and will not save the target file (so I can't see if the Excel objects are being handled correctly).

The error message is: "Failed to save target content: Table column name can not [sic] be empty."  The error stack trace begins as follows:

at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Tables.TableColumnRoute.ReportEmptyColumnNameErrorMessage()
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Tables.TableColumnRoute.UpdateTableColumnNameFromCell(Entity writtenEntity, ExtendedCellReference extendedHeaderCellReference)
   at Sdl.FileTypeSupport.Filters.MicrosoftOffice.Excel.Writer.Tables.TableColumnRoute.WriteUpdatedColumnEntity(Entity entity, ExtendedCellReference extendedHeaderCellReference)

I suppose that there is one (or more) embedded Excel chart with an empty column header. Does anyone have any ideas about other Studio and/or File Type settings I should have checked? Or any ideas how to find the empty column header(s) and correct it/them? By the way, this file contains 40 embedded objects and is small compared to previous files (110+ embedded objects), so going through the embedded objects to find and correct errors is not an option. Similarly, repeatedly splitting the file and processing in Studio would be more time-consuming than my workaround.

Thanks, in advance, Simon