summaryrefslogtreecommitdiffhomepage
diff options
context:
space:
mode:
authorRandy Morgan <[email protected]>2012-02-25 17:21:42 +0900
committerSean Duckett <[email protected]>2012-03-07 14:45:01 -0600
commit1cebe7fa50b71bb0b7d2e6dd0f934a2eb9e1e80b (patch)
tree5068b8c3d444bb99851cba2c09d6af1a1050e70e
parent5d0c81118bac73ab0b18804ca1a3039db9cb69dd (diff)
downloadcaxlsx-1cebe7fa50b71bb0b7d2e6dd0f934a2eb9e1e80b.tar.gz
caxlsx-1cebe7fa50b71bb0b7d2e6dd0f934a2eb9e1e80b.zip
readme and examples updates
-rw-r--r--README.md22
-rw-r--r--examples/example.rb7
2 files changed, 28 insertions, 1 deletions
diff --git a/README.md b/README.md
index 2dbfd879..24c5bf58 100644
--- a/README.md
+++ b/README.md
@@ -38,7 +38,7 @@ Feature List
**3. Custom Styles: With guaranteed document validity, you can style borders, alignment, fills, fonts, and number formats in a single line of code. Those styles can be applied to an entire row, or a single cell anywhere in your workbook.
-**4. Automatic type support: Axlsx will automatically determine the type of data you are generating. In this release Float, Integer, String and Time types are automatically identified and serialized to your spreadsheet.
+**4. Automatic type support: Axlsx will automatically determine the type of data you are generating. In this release Float, Integer, String, Date, Time and Boolean types are automatically identified and serialized to your spreadsheet.
**5. Automatic and fixed column widths: Axlsx will automatically determine the appropriate width for your columns based on the content in the worksheet, or use any value you specify for the really funky stuff.
@@ -60,6 +60,8 @@ Feature List
**14. Output to file or StringIO
+**15. Support for page margins
+
Installing
----------
@@ -272,6 +274,12 @@ To install Axlsx, use the following command:
sheet.column_widths nil, 3
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
+
##Validate and Serialize
p.validate.each { |e| puts e.message }
@@ -301,6 +309,14 @@ This gem has 100% test coverage using test/unit. To execute tests for this gem,
#Changelog
---------
+- ** March.??.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
+ - interop worksheet names must be 31 characters or less or some versions of office complain about repairs
+ - added type support for :boolean and :date types cell values
+ - iterop added some elements so that rubyXL can parse sheets generated with axlsx
+ - added support for fixed column widths
+
- ** February.14.12**: 1.0.17 release
https://github.com/randym/axlsx/compare/1.0.16...1.0.17
- Added in support for serializing to StringIO
@@ -329,6 +345,10 @@ Please see the {file:CHANGELOG.md} document for past release information.
[JonathanTron](https://github.com/JonathanTron) - for giving the gem some style, and making sure it applies.
+[JosephHalter](https://github.com/JosephHalter) - for making sure we arrive at the right time on the right date.
+
+[noniq](https://github.com/noniq) - for keeping true to the gem's style, and making sure what we put on paper does not get marginalized.
+
#Copyright and License
----------
diff --git a/examples/example.rb b/examples/example.rb
index 3487044a..41a08c50 100644
--- a/examples/example.rb
+++ b/examples/example.rb
@@ -201,6 +201,12 @@
sheet.column_widths nil, 3
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
+
##Validate and Serialize
p.validate.each { |e| puts e.message }
@@ -216,5 +222,6 @@
p.serialize("shared_strings_example.xlsx")
+