Re:Technical error with Excel.swapped names.Andreas Babler e...
by x3874 on Monday June 05, 2023 @02:20PM
(#36200655)
...and in the year 2525 one still cannot avoid having their users mistakingly copy & paste formatting and thus destroy auto-extending Excel tables...
There are workarounds using VBA, but not via Typescipt - the Excel JS API knows no clipboard.
You can add conditional formatting, VBA procedures, additional formulas etc. to do whatever validation you like. However, you need a software engineer (or someone who thinks like one) to properly implement that, and it’s not exactly fun.
[1] https://support.microsoft.com/en-us/office/lock-or-unlock-sp...