Synthetic Collabora protection exercise. Enter cells manually. This text file stores no protection.
A1 Item; B1 Quantity input; C1 Calculated total
A2 Notebook; B2 2; C2 =B2*4.50
A3 Pen; B3 3; C3 =B3*1.25
Optional C4 =SUM(C2:C3)
Expected initial results: 9, 3.75, total 12.75.
After B2 becomes 4: 18, 3.75, total 21.75.
Unlock B2:B3 before protecting sheet; keep C2:C4 protected.