mxl-validate

To validate a 1C MXL spreadsheet template, run a validation check against the Template.xml file located under Templates/<Name>/Ext to verify internal consistency of rows, columns, merges, and palette index references before loading it into 1C.

Broken 1C spreadsheet templates are typically caused by out-of-range indices and invalid references, such as row heights mismatching defined row indices, merge bounds exceeding column limits, and palette references exceeding declared sizes for fonts, formats, or borders.

Yes, you can automatically check named areas and palette references in a Template.xml file by parsing the XML with spreadsheet namespaces to verify begin/end row limits, columnsID existence, and ensure picture, font, and line indices are within declared palette sizes.

You should run template validation on your 1C MXL layout immediately after creating or modifying a template for printed forms to catch structural defects and enforce index and size bounds before the file reaches runtime or confuses editors.

The 1C MXL template validator requires no external dependencies, but needs you to locate and normalize the Template.xml file under Templates/<Name>/Ext to properly parse the XML with spreadsheet namespaces and return a non-zero exit status when errors exceed zero.