如何在Apache POI中根据其他单元格值禁用单元格编辑？

Got it, let's walk through how to set up this conditional edit restriction based on your flag value—this is a super common requirement, so I’ll cover the most popular tools/scenarios you might be using:

If you're working in Excel, VBA is the most straightforward way to lock/unlock cells based on a true/false flag. Here's how to do it:

• First, make sure your flag column (let’s say Column A) uses boolean values (true/false), and your target numeric input column is right next to it (Column B).
• Open the VBA editor with Alt + F11, find your worksheet in the left pane, and double-click it to open the code window.
• Paste this code:

Private Sub Worksheet_Change(ByVal Target As Range)
    ' Only react to changes in Column A (our flag column)
    If Not Intersect(Target, Me.Range("A:A")) Is Nothing Then
        Dim cell As Range
        For Each cell In Intersect(Target, Me.Range("A:A"))
            ' Grab the corresponding cell in Column B
            Dim targetCell As Range
            Set targetCell = Me.Range("B" & cell.Row)
            
            ' Lock the cell if flag is false, unlock if true
            targetCell.Locked = (cell.Value = False)
            
            ' Critical: Keep the sheet protected so locks work, but let VBA still edit it
            Me.Protect UserInterfaceOnly:=True
        Next cell
    End If
End Sub

• The UserInterfaceOnly:=True line is key—it lets VBA modify cells even when the sheet is protected, so you don’t have to unlock/re-lock manually every time. Now whenever you toggle the flag in Column A, the Column B cell will automatically become editable (true) or locked (false).

For Google Sheets, you’ll use Apps Script to trigger permission changes when the flag is edited:

• Open your sheet, click Extensions > Apps Script to open the script editor.
• Replace the default code with this:

function onEdit(e) {
    const sheet = e.source.getActiveSheet();
    const editedCell = e.range;
    
    // Only trigger if we’re editing Column A (flag column)
    if (editedCell.getColumn() === 1) {
        const row = editedCell.getRow();
        const targetCell = sheet.getRange(row, 2); // Column B is the target
        const isFlagTrue = editedCell.getValue();
        
        // Set up protection for the target cell
        const protection = targetCell.protect();
        protection.removeEditors(protection.getEditors());
        
        if (isFlagTrue) {
            // Let the current user edit the cell
            protection.addEditor(Session.getEffectiveUser());
        } else {
            // Lock the cell (only the owner can edit it now)
            protection.setWarningOnly(false);
        }
    }
}

• Save the script, and now whenever you change a flag in Column A, the corresponding Column B cell will either be editable (true) or locked down (false).

If this is for a web-based table, you can use vanilla JS to toggle input disabled status:

• Start with a basic HTML table structure:

<table>
    <tr>
        <td>
            <label>
                <input type="checkbox" class="flag-toggle" checked> Flag: True
            </label>
        </td>
        <td><input type="number" class="numeric-input"></td>
    </tr>
    <tr>
        <td>
            <label>
                <input type="checkbox" class="flag-toggle"> Flag: False
            </label>
        </td>
        <td><input type="number" class="numeric-input" disabled></td>
    </tr>
</table>

• Add this JavaScript to handle the toggle:

// Listen for changes on all flag checkboxes
document.querySelectorAll('.flag-toggle').forEach(toggle => {
    toggle.addEventListener('change', function() {
        // Find the numeric input in the same row
        const numericInput = this.closest('tr').querySelector('.numeric-input');
        // Disable the input if flag is unchecked (false), enable if checked (true)
        numericInput.disabled = !this.checked;
    });
});

• Now when users check/uncheck the flag checkbox, the numeric input will instantly become editable or disabled.

内容的提问来源于stack exchange，提问作者Napstablook