Skip to main content
June 28, 2024
Solved

Unwanted link when pasting numerical text

  • June 28, 2024
  • 26 replies
  • 343 views

If I am trying to paste a decimal, like 0.0123456, when I try to paste into another shape, the text not only does not appear, but a URL link is generated. How do I turn this function off? “Paste Plain” is not an available option.

Best answer by Abby S

Thanks for following up Craig.

You can get the decimal to paste in the intended font/color/size for your text by pasting as plain text. Pasting as plain text will cause the text to match the formatting of the shape, and can be done by using the keyboard shortcut Control+Shift+V (or Command+Shift+V for Macs).

So, if you click the shape once and then paste using Ctrl+Shift+V you should sidestep both the linking and the formatting issues you are seeing.

I hope this helps!

Comments

Ria S
Lucid Legend Level 9
Lucid Legend Level 9
June 29, 2024

Hi @Craig Larson 

I am not certain if there is an option to disable the automatic URL detection.

However, you can try to copy the decimal number (e.g., 0.0123456) from your source. If pasting directly into a shape causes issues, first insert a text box. Click inside the text box and paste the decimal number using Ctrl + V (Windows) or Command + V (Mac). 

Once pasted into the text box, you can select the text and copy it again.

Now, select the target shape and paste the text using the standard paste method (Ctrl + V or Command + V). The plain text should now appear without being converted into a URL.

(This may seem tedious but it’s a few simple steps)

I hope that this helps.

Ria S.
June 30, 2024

Thank you. I have managed to find several “work-arounds” to achieve my desired result. Like the ones you offered, they all require several steps. I was hoping for a simple check-box solution - a toggle - but apparently that is not possible. I appreciate the response.

Ria S
Lucid Legend Level 9
Lucid Legend Level 9
June 30, 2024

@Craig Larson 

I’ll tag @Abby S in this thread for additional guidance - if there isn’t a simpler workaround, I do see this as a great suggestion for the idea pipeline. 

Ria S.
Abby S
Lucid community team
July 1, 2024

Hi @Craig Larson, thanks for posting in the community. 

@Ria S thanks for starting this conversation and tagging me in! 

There is not a toggle that you can turn off link generation, but you can copy and paste number strings with decimals into existing shapes without generating a link if you make sure that the text already in the shape is not selected, so clicking on the shape with just a single-click instead of a double-click. 

Please give this a try and let me know if you are still experiencing issues.

July 1, 2024

Yes, while that does eliminate the link, it does not paste the text (0.123456) to conform to my existing shape formatting like non-decimal text would.

 

 

So, in the last example, my previously formatted green box uses the darkest font color; a single-click to paste the decimal works, but alters the text color. This is a minor difference, but over the course of hundreds of hours of work does add up to a lot of extra time. 

Abby S
Abby SAnswer
Lucid community team
July 1, 2024

Thanks for following up Craig.

You can get the decimal to paste in the intended font/color/size for your text by pasting as plain text. Pasting as plain text will cause the text to match the formatting of the shape, and can be done by using the keyboard shortcut Control+Shift+V (or Command+Shift+V for Macs).

So, if you click the shape once and then paste using Ctrl+Shift+V you should sidestep both the linking and the formatting issues you are seeing.

I hope this helps!

July 1, 2024

 

Abby S
Lucid community team
July 1, 2024

Thanks for getting back to me Craig. If you try to use the keyboard shortcut, rather than the right click menu, are you able to paste plain text?

July 1, 2024

No, CTRL-SHFT-V does not paste anything.

 

I’m pasting numbers from an Excel spreadsheet. All the alternative methods you suggested do work but they don’t work as normal text would, even from Excel.

 

I appreciate your help. I should video this process.

Abby S
Lucid community team
July 1, 2024

Hi Craig, just to clarify, are you able to paste the numbers as plain text when they are not from Excel? And it is just when they are from Excel that you are running into this issue?

If that is the case, can you try clicking into the cell to select the number as text (rather than selecting and copying the cell) to see if that works?