2 Replies Latest reply on Nov 19, 2012 8:02 AM by rjames

    Can we control user formatting?


      I have a layout that a user pastes into from Excel, which looks great in the layout that he/she pasted into. But, I then take that data and use it in a printing layout, which uses the same text in a different size font. This worked in 10 & 11, but 12 is making my printouts look terrible, because it is defaulting to the pasted in text formatting, and apparently (according to the help) that formatting is now the controlling formatting for that data.



        • 1. Re: Can we control user formatting?

          Hi, rjames: I don't know how v12 handles this any different, but at least in earlier versions, I 'correct' for this using an auto-enter calculation (usually a custom function) that eliminates whatever formatting or other characteristics I don't want to allow the user to enter or paste.


          For example, I have a custom function called _FontSizeCleaner( text ) =


          TextFontRemove ( TextSizeRemove ( text ) )


          This allows the user to type in any text, which then loses all its font size and font type formatting, leaving other formatting, such as style and color intact.


          Use the text style formatting functions in whatever combination you need for the task at hand.


          -- Erik

          • 2. Re: Can we control user formatting?

            Thanks Erik - that's what I ended up finding in another forum as well.