Open XML SDK tool - Does it retains formatting for Rich Text Area field.

Question

I wanted to inquire about the tool – Open XML SDK for office, used for text processing.

We are using this tool with our import data feature. Below is the use case for the same:

·        We will be importing the word/PDF docs into a Rich Text Area field in Salesforce. The data in the Rich text area field should be displayed with all the formatting/images etc. intact from the word/PDF docs – However, Open XML SDK office tool is not allowing us to retain the formatting in this case.

Please advise us over this if there is any limitation for the tool or you could suggest us the workaround for the same?

Answer 1

Hi Kirti Rastogi,

Because this question is specifically about the Open XML SDK library, questions should be directed to the repo for this library and not here on Q&A. Here is the issue list: https://github.com/dotnet/Open-XML-SDK/issues

I can tell you that the Open XML SDK library does not do any conversion of PDF or WordprocessingML to Rich Text. While it can consume and allow manipulation of WordprocessingML (.docx packages) it does not contain Rich Text capabilities. You might find another library or tool to help with that but the Open XML SDK won't be able to do it.

You might also post your question to https://stackoverflow.com/questions/tagged/openxml-sdk or just Stack Overflow in general and ask if anyone knows of a programmatic tool for Rich Edit conversion.

Best regards,
Tom Jebo
Microsoft Open Specifications Support