diff options
| author | Randy Morgan <[email protected]> | 2012-03-21 01:24:30 +0900 |
|---|---|---|
| committer | Randy Morgan <[email protected]> | 2012-03-21 01:24:30 +0900 |
| commit | 26a8ad445d84b9dcb9fc36702ec761603a74ee20 (patch) | |
| tree | 170dce67745b8773850519ddf3603017ad820b5b /README.md | |
| parent | c7d715dea1e3829ea5110ec8bb4388f2633bf92a (diff) | |
| download | caxlsx-26a8ad445d84b9dcb9fc36702ec761603a74ee20.tar.gz caxlsx-26a8ad445d84b9dcb9fc36702ec761603a74ee20.zip | |
adding in an option to disable both the require of RMagick and auto-width processing. see Workbook#use_autowidth. Defaults to true for backward compatibility.
Diffstat (limited to 'README.md')
| -rw-r--r-- | README.md | 44 |
1 files changed, 44 insertions, 0 deletions
@@ -3,11 +3,19 @@ Axlsx: Office Open XML Spreadsheet Generation [](http://travis-ci.org/randym/axlsx/) **IRC**: [irc.freenode.net / #axlsx](irc://irc.freenode.net/axlsx) + **Git**: [http://github.com/randym/axlsx](http://github.com/randym/axlsx) + +**Twitter**: [https://twitter.com/#!/morgan_randy](https://twitter.com/#!/morgan_randy) release announcements and news will be published here + **Author**: Randy Morgan + **Copyright**: 2011 + **License**: MIT License + **Latest Version**: 1.0.18 + **Ruby Version**: 1.8.7, 1.9.2, 1.9.3 **Release Date**: March 5th 2012 @@ -275,11 +283,27 @@ To install Axlsx, use the following command: end ##Specify Page Margins for printing + margins = {:left => 3, :right => 3, :top => 1.2, :bottom => 1.2, :header => 0.7, :footer => 0.7} wb.add_worksheet(:name => "print margins", :page_margins => margins) do |sheet| sheet.add_row["this sheet uses customized page margins for printing"] end +##Fit to page printing + + wb.add_worksheet(:name => "fit to page") do |sheet| + sheet.add_row ['this all goes on one page'] + sheet.fit_to_page = true + end + + +##Hide Gridlines in worksheet + + wb.add_worksheet(:name => "No Gridlines") do |sheet| + sheet.add_row ["This", "Sheet", "Hides", "Gridlines"] + sheet.show_gridlines = false + end + ##Validate and Serialize p.validate.each { |e| puts e.message } @@ -294,6 +318,16 @@ To install Axlsx, use the following command: p.use_shared_strings = true p.serialize("shared_strings_example.xlsx") +##Disabling Autowidth + + p = Axlsx::Package.new + p.use_autowidth = false + wb = p.workbook + wb.add_worksheet(:name => "No Magick") do | sheet | + sheet.add_row ['oh look! no autowidth - and no magick loaded in your process'] + end + p.validate.each { |e| puts e.message } + p.serialize("no-use_autowidth.xlsx") #Documentation @@ -309,6 +343,16 @@ This gem has 100% test coverage using test/unit. To execute tests for this gem, #Changelog --------- +- ** March.??.12**: 1.0.19 release + - bugfix patch name_to_indecies to properly handle extended ranges. + - bugfix properly serialize chart title. + - lower rake minimum requirement for 1.8.7 apps that don't want to move on to 0.9 NOTE this will be reverted for 2.0.0 with workbook parsing! + - Added Fit to Page printing + - added support for turning off gridlines in charts. + - added support for turning off gridlines in worksheet. + - bugfix some apps like libraoffice require apply[x] attributes to be true. applyAlignment is not properly set. + - added option to *not* use RMagick - and default all assigned columns to the excel default of 8.43 + - ** March.5.12**: 1.0.18 release https://github.com/randym/axlsx/compare/1.0.17...1.0.18 - bugfix custom borders are not properly applied when using styles.add_style |
