Skip to content

Draft: Add support for x14 dataValidation and conditionalFormatting extensions

Daniel Hillier requested to merge topic/3.2/formatextensions into branch/3.2

Currently this MR just adds machinery to handle extLst's and their ext's. Keen to hear your feedback early in case you had a different implementation in mind. Also happy to discuss how this patch set could incorporate !443 if it makes sense.

My plans for the new dataValidation elements is to create the new Serialisable classes for the extension version and map the new and old Serialisable classes to an intermediate class that knows the features of both versions and which representation to use to serialise the data given the features requested.

I'm also thinking of using the same strategy for the conditionalFormatting elements but that will be more involved as they have many more options. It is also possible for a single conditional formatting to have some content written to the current data structures and the rest to the new extension element and linked via and id.

Merge request reports