AnsweredAssumed Answered

Pasting formatted data

Question asked by krol on Jun 15, 2018
Latest reply on Jun 15, 2018 by Jason Wood



When pasting text from a calculation field that combines data from several text fields into a spreadsheet if there are any formatting errors - such as an item being in UPPERCASE rather than title case, even if it is displayed correctly in FM the pasted text in Excel shows UPPERCASE.


I have tried creating scripts to strip out formatting such as TextFormatRemove and TextStyleRemove but I cannot get the text to paste from FM into Excel in the correct format, or simple plain text - if the source data was entered in UPPERCASE that is how it pastes - is there any way I can get FM to chnage the underlying formatting of text in a field.


The only solution I can find if to delete the text and manually retype!