3 ms·
Regarding your example, you can protect worksheets and have only some cells unlocked for modification [1]. You can add conditional formatting, VBA procedures,
by layer8 3y ago
Regarding your example, you can protect worksheets and have only some cells unlocked for modification [1].
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-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a https://support.microsoft.com/en-us/office/lock-or-unlock-sp...
- x3874 3y ago...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.