Auto-Assignment of CALX Addresses Test

This tests that elements with data-formula but no data-cell are automatically assigned addresses like CALX1, CALX2, etc.

Test 1: Auto-assign CALX addresses

Input A: Input B:
Sum (auto CALX3):

Expected: CALX1=10, CALX2=20, CALX3=30. The sum input should automatically get address CALX3.

Test 2: Mix of explicit and auto addresses

Price (A1):
Quantity (B1):
Tax Rate (auto CALX1):
Subtotal (auto CALX2):
Tax (auto CALX3):
Total (auto CALX4):

Expected: Total = 550 (Price*Qty + Tax)

Test 3: Argument data overrides HTML attributes

Base (auto CALX1, overridden to 50):
Multiplier (auto CALX2):
Result (auto CALX3):

Expected: Result = 150 (50*3, where 50 overrides the HTML value of 10)