Excel::Template::Container::KeepLeadingZeros3pm

Purpose

To set the keep_leading_zeros flag for the surrounding worksheet or any worksheets that might be contained within this node.

Node name

KEEP_LEADING_ZEROS

Inheritance

CONTAINER

Attributes

None

Children

None

Effects

Alters how leading zeros are interpreted by Spreadsheet::WriteExcel.

Dependencies

None

Usage

  <worksheet>
    ... Cells here will NOT have leading-zeros preserved
    <keep_leading_zeros>
      ... Cells here will have leading-zeros preserved
    </keep_leading_zeros>
    ... Cells here will NOT have leading-zeros preserved
  </worksheet>
  <keep_leading_zeros>
    <worksheet>
      ... Cells here will have leading-zeros preserved
    </worksheet>
    <worksheet>
      ... Cells here will have leading-zeros preserved
    </worksheet>
  </keep_leading_zeros>