eaXL and RTF formatting in descriptions

[Mark Elson]

I am exporting element descriptions to eaXL and some of these contain RTF formatting which then appears as raw formatting codes in the excel cell, e.g. .

Is there a way to either:

i) just extract the plain text;
ii) translate the formatting to the corresponding excel formatting?

Aside from this small glitch I think the eaXL facility is going to be very useful.

Thank you,

Mark

[Mark Elson]

Just figured out the quick fix for i) – within Excel just replace <*> with nothing.

[eadocX Support]

This is a good suggestion. We’d like to do this, and it’s on the ‘to do’ list for a future release.
The reason we haven’t done it yet is because we can’t figure out how to make Excel format the text nicely, then translate that ‘nice’ formatting back to HTML when you save the element. Excel doesn’t really understand bullets and numbered lists, so this would have to be simulated.
In the end, we decided to just print the notes field ‘as is’, but strongly suggest you don’t try to add your own bullets & lists in Excel – do that inside EA.

Any other suggestions for improvements, please feel free to add them to the ‘suggestions’ forum.
Thanks

[Author]

Posts