Jump to content
Sign in to follow this  
MorFologist

client formatted text

Recommended Posts

I just checked my notes from DevCon, and it seems sad but true: Client formatted text overrides conditional formatted text. So -- we are still forced to create calc fields or use to display data cleanly for a report? Or did I miss something?

Is there some way to set a field to refuse or ignore client formatting (other than key command to paste unformatted)?

I'm also thinking of using a replace or loop command to strip it on existing data. (Client had been pasting text from all sources, retaining many fonts, color and sizes.) I can try to teach them to paste as unformatted, but the existing data is a mess. I'd like to fix with the least amount of fuss.

Share this post


Link to post
Share on other sites

How about putting this into the fields autoenter (update):

Evaluate ( Quote ( text ) )

This template accepts you paste something in the field, but as soon as the record is committed, such as clicking outside any of the fields, is the pasted turned into the webdings font.

---------------------------------------------------

Update! I forgot about the new Self-function, now it can't be stuffed into a CF directly but you can cheat by:

CFFormat()

which is defined as:

Evaluate ( "Self" )

One weird sideeffect is that because no referenced fields are involved any more, isn't committing required ...it seems even faster, because it looks like stream editing...

--sd

Format.zip

Edited by Guest

Share this post


Link to post
Share on other sites

That's one way. Easier though to just use the existing function designed for this purpose: TextFormatRemove().

Share this post


Link to post
Share on other sites

But you can't define it as a customfunction - or??

I read a nice way to put it yesterday:

"I'm paid to make decisions, not to type"

Snipped from: http://www.runrev.com/newsletter/september/issue33/newsletter1.php?id=NWLLP433796

When defined as CF is it just a click away!

--sd

Share this post


Link to post
Share on other sites

Sadly, it looks like the CF axiom holds true regarding formatting -- user formatting overrides whatever you do. Dang it. a Custom Function Conditional Formatting is more enticing than sprinkling auto entry calcs on my the problem fields, but it will do for the most egregious!

Self works in auto-entry calc, so that makes it easy to paste around now at least.

Edited by Guest
Had mindlessly wrote out the wrong acronym for CF!

Share this post


Link to post
Share on other sites

If you mean there is a way to prevent a field or all fields from accepting any user-entered, rich-formatted text, other than the previous suggestions, please share.

But disabling menus and toolbar won't help as the issue is rich text pasted from external sources, and user's cannot be reliably trained to use the "paste as unformatted text" command.

I went with AECs. Not too painful as "Self" works in ae-calc (although not in replace calc).

Share this post


Link to post
Share on other sites

Go to 'Manage Custom Menus...'.

Establish a custom menu set which is a copy of the Standard FM menu set.

Select the 'Paste' menu item (in 'Edit').

Change the action to: Script Step Paste [No style].

You may also take away the Format menu.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

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.

Sign in to follow this  

×
×
  • Create New...

Important Information

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