diff options
| author | Randy Morgan <[email protected]> | 2012-07-14 13:25:52 +0900 |
|---|---|---|
| committer | Randy Morgan <[email protected]> | 2012-07-14 13:25:52 +0900 |
| commit | bcebd1714a5224a36e331a47880ae94dbc32054c (patch) | |
| tree | f6283a0beeb98c42c8fe96d0b4e4e3e071ddf1cc /examples/example.rb | |
| parent | b24833c496e84177ef1f20ea04abdfa3bc26d51c (diff) | |
| download | caxlsx-bcebd1714a5224a36e331a47880ae94dbc32054c.tar.gz caxlsx-bcebd1714a5224a36e331a47880ae94dbc32054c.zip | |
Additional validations for excel sheet name and example updates
Diffstat (limited to 'examples/example.rb')
| -rwxr-xr-x | examples/example.rb | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/examples/example.rb b/examples/example.rb index feec1a08..3ff220db 100755 --- a/examples/example.rb +++ b/examples/example.rb @@ -365,7 +365,7 @@ money = wb.styles.add_style(:format_code => '0,000', :border => Axlsx::STYLE_THI profitable = wb.styles.add_style( :fg_color=>"FF428751", :type => :dxf) -wb.add_worksheet(:name => "Conditional Formatting: Cell Is") do |ws| +wb.add_worksheet(:name => "Conditional Cell Is") do |ws| # Generate 20 rows of data ws.add_row ["Previous Year Quarterly Profits (JPY)"] @@ -380,7 +380,7 @@ wb.add_worksheet(:name => "Conditional Formatting: Cell Is") do |ws| ws.add_conditional_formatting("B3:B100", { :type => :cellIs, :operator => :greaterThan, :formula => "100000", :dxfId => profitable, :priority => 1 }) end -wb.add_worksheet(:name => "Conditional Formatting: Color Scale") do |ws| +wb.add_worksheet(:name => "Conditional Color Scale") do |ws| ws.add_row ["Previous Year Quarterly Profits (JPY)"] ws.add_row ["Quarter", "Profit", "% of Total"] offset = 3 @@ -394,7 +394,7 @@ wb.add_worksheet(:name => "Conditional Formatting: Color Scale") do |ws| end -wb.add_worksheet(:name => "Conditional Formatting: Data Bar") do |ws| +wb.add_worksheet(:name => "Conditional Data Bar") do |ws| ws.add_row ["Previous Year Quarterly Profits (JPY)"] ws.add_row ["Quarter", "Profit", "% of Total"] offset = 3 @@ -407,7 +407,7 @@ wb.add_worksheet(:name => "Conditional Formatting: Data Bar") do |ws| ws.add_conditional_formatting("B3:B100", { :type => :dataBar, :dxfId => profitable, :priority => 1, :data_bar => data_bar }) end -wb.add_worksheet(:name => "Conditional Formatting: Icon Set") do |ws| +wb.add_worksheet(:name => "Conditional Format Icon Set") do |ws| ws.add_row ["Previous Year Quarterly Profits (JPY)"] ws.add_row ["Quarter", "Profit", "% of Total"] offset = 3 |
