Feature: Column Detection and Operations
  As a developer
  I want the tracker to find columns flexibly
  So that it works with various sheet layouts

  Scenario: Find dataset name column with various names
    Given a spreadsheet with headers "Dataset, Status, Error"
    When I create an authenticated tracker with these headers
    Then the dataset name column should be identified

  Scenario: Find column with alternate naming
    Given a spreadsheet with headers "ID, State, Error Message"
    When I create an authenticated tracker with these headers
    Then the dataset name column should be identified
    And the status column should be identified
    And the error column should be identified

  Scenario: Case insensitive column matching
    Given a spreadsheet with headers "DATASET NAME, STATUS, ERROR"
    When I create an authenticated tracker with these headers
    Then the dataset name column should be identified

  Scenario: Column with extra spaces
    Given a spreadsheet with headers "  Dataset Name  , Status, Error"
    When I create an authenticated tracker with these headers
    Then the dataset name column should be identified

  Scenario: Missing dataset name column
    Given a spreadsheet with headers "Status, Error, Notes"
    When I create an authenticated tracker with these headers
    Then the dataset name column should not be found