---
name: "Excel::Template::Container::KeepLeadingZeros"
section: "3pm"
platform: "linux"
package: "libexcel-template-perl"
version: "0.34-3"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/Excel::Template::Container::KeepLeadingZeros"
---

# Excel::Template::Container::KeepLeadingZeros(3pm)

Excel::Template::Container::KeepLeadingZeros

## NAME

Excel::Template::Container::KeepLeadingZeros - Excel::Template::Container::KeepLeadingZeros

## 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>
```

## AUTHOR

Rob Kinyon (rob.kinyon@gmail.com)

## SEE ALSO

CELL, Spreadsheet::WriteExcel