Form Mode

A business app often uses a spreadsheet as a form, not as a spreadsheet: the layout is fixed, most cells are protected, and the user only fills values into a handful of boxes. v1.6.0 covers that shape with four worksheet switches. This demo is an application form — click a box once and type; Enter carries you to the end. Available in both editions.

• ws.clickToEdit — a single click opens the editor with the caret at the end, and the pointer shows an I-beam over editable cells. Protected cells and checkbox-style cell types are unaffected
• ws.formNavigation — Enter and Tab commit and move to the next input cell (Shift reverses), using a reading-order scan that skips protected cells, hidden lines and merge interiors, and wraps at the end of a row
• ws.layoutLocked — header drag-resize, double-click auto-fit and whole-line reorder are all off. Sizing from the API still works, so your template code is unaffected
• setCellPlaceholder() draws the grey hints. They appear only while the cell is empty and are never part of the value — not in PDF, print, xlsx or JSON
• On ご希望プラン, press ↓ while editing or Alt+↓ while selected to open the list from the keyboard; the list opens at the current value, so ↓ then Enter is a two-keystroke pick
• “Custom tab order” installs a setFormNavigator() that skips the optional Notes field — returning null stops at the end of the form
• None of these switches is persisted, so re-apply them after loadJson() or reset()