Fully support localization of openxml charts using only cached values...

openxml charts sometimes reference spreadsheets (external or embedded). But, openxml does something clever. It caches spreadsheet values in the PPTX (copied from the spreadsheets). Denis and I decided it would be easier to extract the cache values vs dealing with the original spreadsheets. The spreadsheets have priority over the cached values. If the localized PPTX file with translated cache values finds the original spreadsheet then the cached values will be overwritten. We don't want to overwrite the localized target values!

My proposal is to optionally remove all embedded spreadsheets to assure localized values from the cache will not be overridden. We should also warn users that external spreadsheets originally associated with the chart will do the same (we have no control over this)

Chart values can also use a formatting string (like ICU) which can contain language specific content  (ex: <c:formatCode>#,##0"億円"</c:formatCode>)! On top of the difficulty of tracking down cached values vs spreadsheets we have an internationalization problem.

Element-ParentContexts-LocalizableContentAttribute-Notes.csv

Attached is a table of all possible chart elements that need to be extracted. Also some sample documents.