Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Keep field formatting on export


haarbol

Recommended Posts

Hi,

 

I've tried everything i could, but it seems almost impossible to keep the formatted content of a field on export.

 

For instance, the sentence:

"This is just an example"

will always export as:

 

"This is just an example" after export.

 

There are options while exporting to HTML or Excel that let's you select "apply current layout's data formatting to exported data" but that's not making any difference.

 

How can i export the stuff to Excel, HTML, with formatting included?

(right now the only way is to export to PDF but then i need an PDF to Word or whatever converter to be able to edit afterwards and those conversions tend to be a bit unreliable)

Link to comment
Share on other sites

I guess for html you can create a calc for field in question, wrapping the field in the GetAsCSS function and exporting the CSS code to then put into html code?

 

As far as I know you cannot export formatting in a field such as bold/underline etc to those formats. Generally the export using field format option retains things such as $ sign, decimal places etc on number fields, date formats. Basically it is for field formatting, not formatting of text (manually) within that field.

 

You're best bet is to export field content by first putting it in GetAsCSS in a calc field.

Link to comment
Share on other sites

Wow, that did it :)

 

I export a HTML formatted result to PDF and then let Acrobat Reader save that pdf as plain text - that way i have a 'valid html page'. Not ideal, but in the end it does what i want it to do without the stupid PDF-to-Word converter :)

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...

Important Information

Terms of Use