---
name: "Spreadsheet::XLSX::Fmt2007"
section: "3pm"
platform: "linux"
package: "libspreadsheet-xlsx-perl"
version: "0.13-1"
release: "Debian 8 (Jessie)"
platforms: ["linux"]
url: "https://new.carta.tech/Spreadsheet::XLSX::Fmt2007"
---

# Spreadsheet::XLSX::Fmt2007(3pm)

Formatting module for Spreadsheet::XLSX

## NAME

Spreadsheet::XLSX::Fmt2007 - Formatting module for Spreadsheet::XLSX

## SYNOPSIS

```
                $cell = $myworkbook->worksheet->{Cells}[$row][$col]
                my $type       = $cell->{Type}; # Date, Text, or Numeric
                my $disp_value = $cell->Value;  # displayed (formatted) value set in XLSX by $myFmt2007->ValFmt($cell, $workbook)
                my $fund_value = $cell->{Val};  # fundemental (underlying) value
                my $formatter;
                if ($myworkbook->excel07) {
                        $formatter=Spreadsheet::XLSX::Fmt2007->new();
                } else {
                        $formatter=Spreadsheet::ParseExcel::FmtDefault->new();
                }
                my $format_string = $formatter->FmtString($cell,$self->workbook);
```