Excel-Template

 view release on metacpan or  search on metacpan

lib/Excel/Template/Container/Locked.pm  view on Meta::CPAN

1;
__END__

=head1 NAME

Excel::Template::Container::Locked - Excel::Template::Container::Locked

=head1 PURPOSE

To format all children in locked

=head1 NODE NAME

LOCKED

=head1 INHERITANCE

Excel::Template::Container::Format

=head1 ATTRIBUTES

lib/Excel/Template/Container/Locked.pm  view on Meta::CPAN

None

=head1 DEPENDENCIES

You must have protected the worksheet containing any cells that are affected by
this format. Otherwise, this node will have no effect.

=head1 USAGE

  <locked>
    ... Children here
  </locked>

In the above example, the children will be displayed (if they are displaying
elements) in a locked format. All other formatting will remain the same and the
"locked"-ness will end at the end tag.

=head1 AUTHOR

Rob Kinyon (rob.kinyon@gmail.com)

=head1 SEE ALSO

WORKSHEET, FORMAT

=cut

lib/Excel/Template/Format.pm  view on Meta::CPAN

*_retrieve_format = \&_retrieve_key;
#sub _retrieve_format {
#    my $self = shift;
#    my ($key) = @_;
#    return $self->{$key};
#}

{
    my @_boolean_formats = qw(
        bold italic locked hidden font_outline font_shadow font_strikeout
        text_wrap text_justlast shrink is_merged
    );

    my @_integer_formats = qw(
        size underline rotation indent pattern border
        bottom top left right
    );

    my @_string_formats = qw(
        num_format font color align valign bg_color fg_color border_color

t/005.xml  view on Meta::CPAN

<workbook>
  <bold />
  <hidden />
  <italic />
  <locked />
  <outline />
  <shadow />
  <strikeout />

  <format font_outline="1" />
  <format shrink="1" />
  <format text_wrap="1" />
  <format text_justlast="1" />
  <format size="3" />
  <format num_format="3" />

t/005_formats.t  view on Meta::CPAN

ok( $object->write_file( 'filename' ), 'Something returned' );

my @calls = mock::get_calls;
is( join( $/, @calls, '' ), <<__END_EXPECTED__, 'Calls match up' );
Spreadsheet::WriteExcel::new( 'filename' )
Spreadsheet::WriteExcel::add_format( '' )
Spreadsheet::WriteExcel::add_format( 'bold', '1' )
Spreadsheet::WriteExcel::add_format( 'hidden', '1' )
Spreadsheet::WriteExcel::add_format( 'italic', '1' )
Spreadsheet::WriteExcel::add_format( 'locked', '1' )
Spreadsheet::WriteExcel::add_format( 'font_outline', '1' )
Spreadsheet::WriteExcel::add_format( 'font_shadow', '1' )
Spreadsheet::WriteExcel::add_format( 'font_strikeout', '1' )
Spreadsheet::WriteExcel::add_format( 'shrink', '1' )
Spreadsheet::WriteExcel::add_format( 'text_wrap', '1' )
Spreadsheet::WriteExcel::add_format( 'text_justlast', '1' )
Spreadsheet::WriteExcel::add_format( 'size', '3' )
Spreadsheet::WriteExcel::add_format( 'num_format', '3' )
Spreadsheet::WriteExcel::add_format( 'underline', '3' )
Spreadsheet::WriteExcel::add_format( 'rotation', '3' )