NAME

Spreadsheet::Engine::Function::SUBSTITUTE - Spreadsheet funtion SUBSTITUTE()

SYNOPSIS

=SUBSTITUTE(string, oldtext, newtext, [which])

DESCRIPTION

This provides the spreadsheet text funtion SUBSTITUTE()

arguments

This takes the original string, the text to be replaced, and the text to replace it with. If the optional 'which' paramater is gien, only that occurence is replaced.

HISTORY

This is a Modified Version of code extracted from SocialCalc::Functions in SocialCalc 1.1.0

COPYRIGHT

LICENCE

The contents of this file are subject to the Artistic License 2.0; you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.perlfoundation.org/artistic_license_2_0

To install Spreadsheet::Engine, copy and paste the appropriate command in to your terminal.

cpanm

cpanm Spreadsheet::Engine

CPAN shell

perl -MCPAN -e shell
install Spreadsheet::Engine

For more information on module installation, please visit the detailed CPAN module installation guide.

	Global
`s`	Focus search bar
`?`	Bring up this help dialog

	GitHub
`g` `p`	Go to pull requests
`g` `i`	go to github issues (only if github is preferred repository)

	POD
`g` `a`	Go to author
`g` `c`	Go to changes
`g` `i`	Go to issues
`g` `d`	Go to dist
`g` `r`	Go to repository/SCM
`g` `s`	Go to source
`g` `b`	Go to file browse

	Search terms
module: (e.g. module:Plugin)
distribution: (e.g. distribution:Dancer auth)
author: (e.g. author:SONGMU Redis)
version: (e.g. version:1.00)