This tutorial would explain how to create dependent dropdown list in LibreOffice Calc. Calc-Basics Data Validation Using Double Dependent Dropdown List – LibreOffice Calc
