Xslx with shared strings (fixed dropdown values) - is it possible to template.

[julianthompson]

I have been given a xlsx template to populate with lots of cells with fixed drop downs (shared strings?) - like 'Yes' and 'No'... It is possible to set these properly using templator? Excel seems to set them as "shared string" (?) integer values, but templator just replaces these with a string value. I can find the values of the shared strings.

If I get the row template:

$rowTemplate = $sheet->getRowTemplate(3);
dpm($rowTemplate);

I get the following definition for the cell: