Posted 9 June 2022, 4:12 am EST
The issue that I am facing is that when a user copies a formula and then pastes it. After pasting there is code that is run specifically we update the font style using
updateSheet.setStyle(row, col, style);
When this code runs it seems to cause the spread clipboard to lose some information as if the user then attempts to paste into another cell it only pastes the value of the formula and not the formula itself. Is there a way to prevent this from happening? This only occurs in when the user uses CTRL-V and not when they use Paste button from the context menu
Attached is a video of the behavior. In the formula bar you can see in the second paste the formula is not there