{"abstract":"An anchored row or column changes when a formula is copied.","category":"Spreadsheet calculation semantics","checks":6,"contract":"Given positive row and column coordinates, independent anchor booleans and copy deltas, return translated [row,column]; resulting coordinates are positive.","evaluation_group":"model-00a0b9d3395d8c62","failed_approach":"Freezing both coordinates whenever either is anchored loses the movable coordinate.","family":"z-spreadsheets-mixed-reference-copy","id":"FA-11341","implementations":{"attempt":{"sha256":"913d321f0a2c967cf23c7cf229f1913e18fef50e6a149e65fae4597c6e7e2237","source":"\"\"\"Failure Map reference implementation. Python standard library only.\"\"\"\nimport json\n\nN = 1\nobservations = []\ndef solve(row, col, row_abs, col_abs, dr, dc):\n    return [row, col] if row_abs or col_abs else [row + dr, col + dc]\ndef check(label, actual, expected):\n    observations.append({\"check\": label, \"actual\": actual, \"expected\": expected, \"passed\": actual == expected})\ncheck('fixed row movable column', solve(10, 10, True, False, N, N), [10, 10+N])\ncheck('movable row fixed column', solve(10, 10, False, True, -N, N), [10-N, 10])\ncheck('fully relative', solve(10, 10, False, False, N, -N), [10+N, 10-N])\ncheck('fully anchored', solve(10, 10, True, True, N, N), [10, 10])\ncheck('identity copy', solve(1, 1, False, True, 0, 0), [1, 1])\ncheck('first coordinate boundary', solve(N+1, 1, False, False, -N, 0), [1, 1])\nprint(json.dumps({\"observations\": observations, \"passed\": all(x[\"passed\"] for x in observations)}, ensure_ascii=False))\nraise SystemExit(0 if all(x[\"passed\"] for x in observations) else 1)\n"},"broken":{"sha256":"bda0e5f2e5c0862cb9bce44910d1dee5f1315de51e56c439a0112839816b59fd","source":"\"\"\"Failure Map reference implementation. Python standard library only.\"\"\"\nimport json\n\nN = 1\nobservations = []\ndef solve(row, col, row_abs, col_abs, dr, dc):\n    return [row + dr, col + dc]\ndef check(label, actual, expected):\n    observations.append({\"check\": label, \"actual\": actual, \"expected\": expected, \"passed\": actual == expected})\ncheck('fixed row movable column', solve(10, 10, True, False, N, N), [10, 10+N])\ncheck('movable row fixed column', solve(10, 10, False, True, -N, N), [10-N, 10])\ncheck('fully relative', solve(10, 10, False, False, N, -N), [10+N, 10-N])\ncheck('fully anchored', solve(10, 10, True, True, N, N), [10, 10])\ncheck('identity copy', solve(1, 1, False, True, 0, 0), [1, 1])\ncheck('first coordinate boundary', solve(N+1, 1, False, False, -N, 0), [1, 1])\nprint(json.dumps({\"observations\": observations, \"passed\": all(x[\"passed\"] for x in observations)}, ensure_ascii=False))\nraise SystemExit(0 if all(x[\"passed\"] for x in observations) else 1)\n"},"fixed":{"sha256":"cee40fddfc86ea2e40d6e81814356a57f9d93f22370f6cdb21b5d1e381af8b1c","source":"\"\"\"Failure Map reference implementation. Python standard library only.\"\"\"\nimport json\n\nN = 1\nobservations = []\ndef solve(row, col, row_abs, col_abs, dr, dc):\n    return [row if row_abs else row + dr, col if col_abs else col + dc]\ndef check(label, actual, expected):\n    observations.append({\"check\": label, \"actual\": actual, \"expected\": expected, \"passed\": actual == expected})\ncheck('fixed row movable column', solve(10, 10, True, False, N, N), [10, 10+N])\ncheck('movable row fixed column', solve(10, 10, False, True, -N, N), [10-N, 10])\ncheck('fully relative', solve(10, 10, False, False, N, -N), [10+N, 10-N])\ncheck('fully anchored', solve(10, 10, True, True, N, N), [10, 10])\ncheck('identity copy', solve(1, 1, False, True, 0, 0), [1, 1])\ncheck('first coordinate boundary', solve(N+1, 1, False, False, -N, 0), [1, 1])\nprint(json.dumps({\"observations\": observations, \"passed\": all(x[\"passed\"] for x in observations)}, ensure_ascii=False))\nraise SystemExit(0 if all(x[\"passed\"] for x in observations) else 1)\n"}},"limitations":" This reproducer isolates one failure mechanism. Results cover the supplied fixtures. Variants within a family share a test contract and should remain grouped when constructing evaluation splits. Related mechanisms with a shared evaluation_group must also remain together; these controlled models are not independent production incidents.","method":"Deterministic executable model with adversarial boundary fixtures.","provenance":{"created_by":"Failure Map","dependencies":"Python standard library","family":"z-spreadsheets-mixed-reference-copy","generated_at":"2026-09-29T14:38:47.072227+00:00","license":"CC0-1.0","python":"3.12.14","seed":1,"split":"open-access"},"relevance":"This isolated spreadsheet model makes cell semantics explicit; it does not claim compatibility with every workbook engine.","repair":"Apply row and column anchoring independently.","root_cause":"One anchor flag is applied to both coordinates.","sha256":"ba612fc79981c8d249c219135e0ee9f7237fda9702fac87ba50b7c8e18d725d1","title":"Copying a mixed reference moves an anchored coordinate · case 01","variant":1,"variant_policy":"Five numbered records share a model and may reuse boundary fixtures.","verification":{"attempt":{"elapsed_ms":38.884,"exit_code":1,"observations":[{"actual":[10,10],"check":"fixed row movable column","expected":[10,11],"passed":false},{"actual":[10,10],"check":"movable row fixed column","expected":[9,10],"passed":false},{"actual":[11,9],"check":"fully relative","expected":[11,9],"passed":true},{"actual":[10,10],"check":"fully anchored","expected":[10,10],"passed":true},{"actual":[1,1],"check":"identity copy","expected":[1,1],"passed":true},{"actual":[1,1],"check":"first coordinate boundary","expected":[1,1],"passed":true}],"passed":false,"stderr":"","stdout":"{\"observations\": [{\"check\": \"fixed row movable column\", \"actual\": [10, 10], \"expected\": [10, 11], \"passed\": false}, {\"check\": \"movable row fixed column\", \"actual\": [10, 10], \"expected\": [9, 10], \"passed\": false}, {\"check\": \"fully relative\", \"actual\": [11, 9], \"expected\": [11, 9], \"passed\": true}, {\"check\": \"fully anchored\", \"actual\": [10, 10], \"expected\": [10, 10], \"passed\": true}, {\"check\": \"identity copy\", \"actual\": [1, 1], \"expected\": [1, 1], \"passed\": true}, {\"check\": \"first coordinate boundary\", \"actual\": [1, 1], \"expected\": [1, 1], \"passed\": true}], \"passed\": false}\n"},"broken":{"elapsed_ms":42.08,"exit_code":1,"observations":[{"actual":[11,11],"check":"fixed row movable column","expected":[10,11],"passed":false},{"actual":[9,11],"check":"movable row fixed column","expected":[9,10],"passed":false},{"actual":[11,9],"check":"fully relative","expected":[11,9],"passed":true},{"actual":[11,11],"check":"fully anchored","expected":[10,10],"passed":false},{"actual":[1,1],"check":"identity copy","expected":[1,1],"passed":true},{"actual":[1,1],"check":"first coordinate boundary","expected":[1,1],"passed":true}],"passed":false,"stderr":"","stdout":"{\"observations\": [{\"check\": \"fixed row movable column\", \"actual\": [11, 11], \"expected\": [10, 11], \"passed\": false}, {\"check\": \"movable row fixed column\", \"actual\": [9, 11], \"expected\": [9, 10], \"passed\": false}, {\"check\": \"fully relative\", \"actual\": [11, 9], \"expected\": [11, 9], \"passed\": true}, {\"check\": \"fully anchored\", \"actual\": [11, 11], \"expected\": [10, 10], \"passed\": false}, {\"check\": \"identity copy\", \"actual\": [1, 1], \"expected\": [1, 1], \"passed\": true}, {\"check\": \"first coordinate boundary\", \"actual\": [1, 1], \"expected\": [1, 1], \"passed\": true}], \"passed\": false}\n"},"fixed":{"elapsed_ms":41.039,"exit_code":0,"observations":[{"actual":[10,11],"check":"fixed row movable column","expected":[10,11],"passed":true},{"actual":[9,10],"check":"movable row fixed column","expected":[9,10],"passed":true},{"actual":[11,9],"check":"fully relative","expected":[11,9],"passed":true},{"actual":[10,10],"check":"fully anchored","expected":[10,10],"passed":true},{"actual":[1,1],"check":"identity copy","expected":[1,1],"passed":true},{"actual":[1,1],"check":"first coordinate boundary","expected":[1,1],"passed":true}],"passed":true,"stderr":"","stdout":"{\"observations\": [{\"check\": \"fixed row movable column\", \"actual\": [10, 11], \"expected\": [10, 11], \"passed\": true}, {\"check\": \"movable row fixed column\", \"actual\": [9, 10], \"expected\": [9, 10], \"passed\": true}, {\"check\": \"fully relative\", \"actual\": [11, 9], \"expected\": [11, 9], \"passed\": true}, {\"check\": \"fully anchored\", \"actual\": [10, 10], \"expected\": [10, 10], \"passed\": true}, {\"check\": \"identity copy\", \"actual\": [1, 1], \"expected\": [1, 1], \"passed\": true}, {\"check\": \"first coordinate boundary\", \"actual\": [1, 1], \"expected\": [1, 1], \"passed\": true}], \"passed\": true}\n"}},"verified":true,"visibility":"public"}