Jump to content
Sign in to follow this  
katinak

Maintain Text Format on Export/Save As

Recommended Posts

I have a file in which I used the feature of formatting text within Browse mode and the format follows the text from layout to layout. However, when I save as Excel or export to Excel or .tab or .csv it loses this formatting. I have tried all of the maintain formatting (which appears to relate to numbers more than text) options I can find. I can export it to pdf but I need it to end up in Excel. Please help me. I am supposed to send an Excel file to my boss tonight or early tomorrow.

Share this post


Link to post
Share on other sites

I am thinking I should have been more clear.

The formatting is where one or two words in the text of a field might be bold or italicized while the rest of the text is plain.

Share this post


Link to post
Share on other sites

"... .tab or .csv it loses this formatting"

That is expected. Only *data* gets exported. Data has no formatting.

Have you tried exporting as an html table, with layout formatting selected?

Share this post


Link to post
Share on other sites

I just tried html both with it selected and without. Neither worked. In help when it explains that you can format word by word in Browse mode it states that it becomes "part of the data" and moves with it from layout to layout. I would have assumed that if it became part of the data that would include exporting. Thanks for the suggestion. I am working my way through every export option now.

Share this post


Link to post
Share on other sites

" I would have assumed that if it became part of the data that would include exporting."

No, because file formats such as tab and csv are *ancient* and only work with plain text.

I seem to remember something to do with the GetaAsCSS() function, but cannot remember the details.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.