From 076be316935180341d7ee7a9335281a4b18d1fa9 Mon Sep 17 00:00:00 2001 From: Randy Morgan Date: Wed, 30 Nov 2011 08:53:14 +0900 Subject: pre 1.0.10 release commit --- .yardoc/checksums | 4 +- .yardoc/objects/root.dat | Bin 431340 -> 430237 bytes Gemfile.lock | 22 +- README.md | 9 +- axlsx.gemspec | 2 + doc/Axlsx.html | 592 +++++++++++++----------------- doc/Axlsx/App.html | 396 +++++++++------------ doc/Axlsx/Axis.html | 126 +++---- doc/Axlsx/Bar3DChart.html | 128 +++---- doc/Axlsx/BarSeries.html | 76 ++-- doc/Axlsx/Border.html | 120 +++---- doc/Axlsx/BorderPr.html | 142 ++++---- doc/Axlsx/CatAxis.html | 105 +++--- doc/Axlsx/CatAxisData.html | 39 +- doc/Axlsx/Cell.html | 333 ++++++++--------- doc/Axlsx/CellAlignment.html | 178 ++++------ doc/Axlsx/CellProtection.html | 74 ++-- doc/Axlsx/CellStyle.html | 112 +++--- doc/Axlsx/Chart.html | 235 +++++------- doc/Axlsx/Color.html | 84 ++--- doc/Axlsx/ContentType.html | 34 +- doc/Axlsx/Core.html | 49 ++- doc/Axlsx/DataTypeValidator.html | 46 +-- doc/Axlsx/Default.html | 66 ++-- doc/Axlsx/Drawing.html | 174 ++++----- doc/Axlsx/Fill.html | 56 ++- doc/Axlsx/Font.html | 230 +++++------- doc/Axlsx/GradientFill.html | 118 +++--- doc/Axlsx/GradientStop.html | 52 ++- doc/Axlsx/GraphicFrame.html | 67 ++-- doc/Axlsx/Line3DChart.html | 105 +++--- doc/Axlsx/LineSeries.html | 62 ++-- doc/Axlsx/Marker.html | 106 +++--- doc/Axlsx/NumFmt.html | 144 ++++---- doc/Axlsx/OneCellAnchor.html | 132 +++---- doc/Axlsx/Override.html | 66 ++-- doc/Axlsx/Package.html | 166 ++++----- doc/Axlsx/PatternFill.html | 117 +++--- doc/Axlsx/Pic.html | 186 ++++------ doc/Axlsx/Pie3DChart.html | 39 +- doc/Axlsx/PieSeries.html | 74 ++-- doc/Axlsx/RegexValidator.html | 24 +- doc/Axlsx/Relationship.html | 67 ++-- doc/Axlsx/Relationships.html | 34 +- doc/Axlsx/RestrictionValidator.html | 42 +-- doc/Axlsx/Row.html | 126 +++---- doc/Axlsx/Scaling.html | 77 ++-- doc/Axlsx/SerAxis.html | 82 ++--- doc/Axlsx/Series.html | 86 ++--- doc/Axlsx/SeriesTitle.html | 24 +- doc/Axlsx/Styles.html | 366 ++++++++----------- doc/Axlsx/TableStyle.html | 79 ++-- doc/Axlsx/TableStyleElement.html | 136 ++++--- doc/Axlsx/TableStyles.html | 70 ++-- doc/Axlsx/Title.html | 61 ++-- doc/Axlsx/TwoCellAnchor.html | 141 +++----- doc/Axlsx/ValAxis.html | 59 ++- doc/Axlsx/ValAxisData.html | 22 +- doc/Axlsx/View3D.html | 107 +++--- doc/Axlsx/Workbook.html | 233 +++++------- doc/Axlsx/Worksheet.html | 353 ++++++++---------- doc/Axlsx/Xf.html | 191 ++++------ doc/_index.html | 2 +- doc/css/style.css | 2 +- doc/file.LICENSE.html | 46 ++- doc/file.README.html | 16 +- doc/index.html | 16 +- doc/js/app.js | 8 +- doc/method_list.html | 692 ++++++++++++++++++------------------ doc/top-level-namespace.html | 2 +- examples/example.rb | 2 +- 71 files changed, 3401 insertions(+), 4631 deletions(-) diff --git a/.yardoc/checksums b/.yardoc/checksums index 2d1319ca..c90eb6b9 100644 --- a/.yardoc/checksums +++ b/.yardoc/checksums @@ -19,7 +19,7 @@ lib/axlsx/stylesheet/table_style_element.rb 117b80432ed6191c81a9e07bd467281319d2 lib/axlsx/content_type/content_type.rb 6c576e1618f99f7163fffa6b6e89e964653dcb5f lib/axlsx/rels/relationships.rb 9c741e180796259bb378a789fd484fa1d8f04425 lib/axlsx/stylesheet/num_fmt.rb 796ee45611b89e8a670dcff3dd97ad9306f18048 -lib/axlsx.rb 95ca38c3323064bedcfc86ac80488c25b8841762 +lib/axlsx.rb 98da8c39c002ea0389b3d91318a10fada3a96d92 lib/axlsx/content_type/override.rb 43ff5dbbb01fbe0237a11c3da7fa5d8e1d5b67ef lib/axlsx/drawing/graphic_frame.rb 271e897616d85ebc069820c0d6a7dd3a716deff2 lib/axlsx/drawing/pie_series.rb 66dfb2152f3b0e80b358c7af9061beb3c4ab984d @@ -39,7 +39,7 @@ lib/axlsx/util/validators.rb c70f27b943d3711fbe1244a8311789a6fad7e31e lib/axlsx/stylesheet/font.rb 1ee29414f720d26b7d484a90d8ebdaa7ecda4fa6 lib/axlsx/doc_props/app.rb c64077808d7cb6aa30472e15c600009a01f3f338 lib/axlsx/workbook/worksheet/worksheet.rb 8f2dea71b5b95d700127958757301495a444e5c8 -lib/axlsx/workbook/worksheet/cell.rb 043fb997d55e24cd0c11bc20cf43e36b0fadb9c1 +lib/axlsx/workbook/worksheet/cell.rb 38a373677f808fabf4b65eaff7e081dca0e539de lib/axlsx/rels/relationship.rb 8d279056b53ba22ff288187ff0f3d18273dcdcb7 lib/axlsx/stylesheet/border.rb cee9b6982c4a946f7caa850090f72d0d7ce0a0d2 lib/axlsx/drawing/ser_axis.rb 1f4952403738e3089e30deb266b1385679d46096 diff --git a/.yardoc/objects/root.dat b/.yardoc/objects/root.dat index dddaa35f..f36ded2c 100644 Binary files a/.yardoc/objects/root.dat and b/.yardoc/objects/root.dat differ diff --git a/Gemfile.lock b/Gemfile.lock index 9f828391..0f4d18d1 100644 --- a/Gemfile.lock +++ b/Gemfile.lock @@ -1,19 +1,10 @@ -PATH - remote: . - specs: - axlsx (1.0.10) - activesupport (>= 2.3.9) - nokogiri (>= 1.4.1) - rmagick (>= 2.12.2) - zip (~> 2.0.2) - GEM remote: http://rubygems.org/ specs: - activesupport (3.1.3) - multi_json (~> 1.0) - multi_json (1.0.3) + activesupport (3.0.0) + i18n (0.6.0) nokogiri (1.5.0) + rake (0.9.2) rmagick (2.13.1) zip (2.0.2) @@ -21,4 +12,9 @@ PLATFORMS ruby DEPENDENCIES - axlsx! + activesupport (>= 2.3.9) + i18n + nokogiri (>= 1.4.1) + rake + rmagick (>= 2.12.2) + zip (>= 2.0.2) diff --git a/README.md b/README.md index 8d7d1d7e..dd3cbe3e 100644 --- a/README.md +++ b/README.md @@ -10,7 +10,7 @@ Axlsx: Office Open XML Spreadsheet Generation **Latest Version**: 1.0.10 **Ruby Version**: 1.8.7, 1.9.3 -**Release Date**: November 29th 2011 +**Release Date**: November 30th 2011 Synopsis -------- @@ -209,12 +209,15 @@ This gem has 100% test coverage using test/unit. To execute tests for this gem, Changelog --------- -- **October.29.11**: 1.0.10 release +- **October.30.11**: 1.0.10 release - Updating gemspec to lower gem version requirements. - Added row.style assignation for updating the cell style for an entire row - Added col_style method to worksheet upate a the style for a column of cells - Added cols for an easy reference to columns in a worksheet. - - prep for release of acts_as_xlsx gem + - prep for pre release of acts_as_xlsx gem + - added in travis.ci configuration and build status + - fixed out of range bug in time calculations for 32bit time. + - added i18n for active support - **October.26.11**: 1.0.9 release - Updated to support ruby 1.9.3 diff --git a/axlsx.gemspec b/axlsx.gemspec index ae686a0c..793e7e0c 100644 --- a/axlsx.gemspec +++ b/axlsx.gemspec @@ -25,9 +25,11 @@ Gem::Specification.new do |s| s.add_runtime_dependency 'nokogiri', '>= 1.4.1' s.add_runtime_dependency 'activesupport', '>= 2.3.9' + s.add_runtime_dependency 'i18n', '>= 0.6.0' s.add_runtime_dependency 'rmagick', '>= 2.12.2' s.add_runtime_dependency 'zip', '>= 2.0.2' s.add_development_dependency 'rake' + s.add_development_dependency 'bundler' s.required_ruby_version = '>= 1.8.7' s.require_path = 'lib' diff --git a/doc/Axlsx.html b/doc/Axlsx.html index cf1968d4..402e44ca 100644 --- a/doc/Axlsx.html +++ b/doc/Axlsx.html @@ -81,15 +81,14 @@

Overview

-

-xlsx generation with charts, images, automated column width, customizable + +

xlsx generation with charts, images, automated column width, customizable styles and full schema validation. Axlsx excels at helping you generate beautiful Office Open XML Spreadsheet documents without having to understand the entire ECMA specification. Check out the README for some examples of how easy it is. Best of all, you can validate your xlsx file before serialization so you know for sure that anything generated is going -to load on your client’s machine. -

+to load on your client’s machine.

@@ -115,9 +114,8 @@ to load on your client’s machine.
VERSION =
-

-version -

+ +

version

@@ -133,9 +131,8 @@ version
ENCODING =
-

-XML Encoding -

+ +

XML Encoding

@@ -151,9 +148,8 @@ XML Encoding
XML_NS =
-

-spreadsheetML namespace -

+ +

spreadsheetML namespace

@@ -169,9 +165,8 @@ spreadsheetML namespace
XML_NS_T =
-

-content-types namespace -

+ +

content-types namespace

@@ -187,9 +182,8 @@ content-types namespace
APP_NS =
-

-extended-properties namespace -

+ +

extended-properties namespace

@@ -205,9 +199,8 @@ extended-properties namespace
APP_NS_VT =
-

-doc props namespace -

+ +

doc props namespace

@@ -223,9 +216,8 @@ doc props namespace
CORE_NS =
-

-core properties namespace -

+ +

core properties namespace

@@ -241,9 +233,8 @@ core properties namespace
CORE_NS_DC =
-

-dc elements (core) namespace -

+ +

dc elements (core) namespace

@@ -259,9 +250,8 @@ dc elements (core) namespace
CORE_NS_DCMIT =
-

-dcmit (core) namespcace -

+ +

dcmit (core) namespcace

@@ -277,9 +267,8 @@ dcmit (core) namespcace
CORE_NS_DCT =
-

-dc terms namespace -

+ +

dc terms namespace

@@ -295,9 +284,8 @@ dc terms namespace
CORE_NS_XSI =
-

-xml schema namespace -

+ +

xml schema namespace

@@ -313,9 +301,8 @@ xml schema namespace
XML_NS_XDR =
-

-spreadsheet drawing namespace -

+ +

spreadsheet drawing namespace

@@ -331,9 +318,8 @@ spreadsheet drawing namespace
XML_NS_A =
-

-drawing namespace -

+ +

drawing namespace

@@ -349,9 +335,8 @@ drawing namespace
XML_NS_C =
-

-chart namespace -

+ +

chart namespace

@@ -367,9 +352,8 @@ chart namespace
XML_NS_R =
-

-relationships namespace -

+ +

relationships namespace

@@ -385,9 +369,8 @@ relationships namespace
RELS_R =
-

-relationships name space -

+ +

relationships name space

@@ -403,9 +386,8 @@ relationships name space
TABLE_R =
-

-table rels namespace -

+ +

table rels namespace

@@ -421,9 +403,8 @@ table rels namespace
WORKBOOK_R =
-

-workbook rels namespace -

+ +

workbook rels namespace

@@ -439,9 +420,8 @@ workbook rels namespace
WORKSHEET_R =
-

-worksheet rels namespace -

+ +

worksheet rels namespace

@@ -457,9 +437,8 @@ worksheet rels namespace
APP_R =
-

-app rels namespace -

+ +

app rels namespace

@@ -475,9 +454,8 @@ app rels namespace
CORE_R =
-

-core rels namespace -

+ +

core rels namespace

@@ -493,9 +471,8 @@ core rels namespace
STYLES_R =
-

-styles rels namespace -

+ +

styles rels namespace

@@ -511,9 +488,8 @@ styles rels namespace
DRAWING_R =
-

-drawing rels namespace -

+ +

drawing rels namespace

@@ -529,9 +505,8 @@ drawing rels namespace
CHART_R =
-

-chart rels namespace -

+ +

chart rels namespace

@@ -547,9 +522,8 @@ chart rels namespace
IMAGE_R =
-

-image rels namespace -

+ +

image rels namespace

@@ -565,9 +539,8 @@ image rels namespace
TABLE_CT =
-

-table content type -

+ +

table content type

@@ -583,9 +556,8 @@ table content type
WORKBOOK_CT =
-

-workbook content type -

+ +

workbook content type

@@ -601,9 +573,8 @@ workbook content type
APP_CT =
-

-app content type -

+ +

app content type

@@ -619,9 +590,8 @@ app content type
RELS_CT =
-

-rels content type -

+ +

rels content type

@@ -637,9 +607,8 @@ rels content type
STYLES_CT =
-

-styles content type -

+ +

styles content type

@@ -655,9 +624,8 @@ styles content type
XML_CT =
-

-xml content type -

+ +

xml content type

@@ -673,9 +641,8 @@ xml content type
WORKSHEET_CT =
-

-worksheet content type -

+ +

worksheet content type

@@ -691,9 +658,8 @@ worksheet content type
SHARED_STRINGS_CT =
-

-shared strings content type -

+ +

shared strings content type

@@ -709,9 +675,8 @@ shared strings content type
CORE_CT =
-

-core content type -

+ +

core content type

@@ -727,9 +692,8 @@ core content type
CHART_CT =
-

-chart content type -

+ +

chart content type

@@ -745,9 +709,8 @@ chart content type
JPEG_CT =
-

-jpeg content type -

+ +

jpeg content type

@@ -763,9 +726,8 @@ jpeg content type
GIF_CT =
-

-gif content type -

+ +

gif content type

@@ -781,9 +743,8 @@ gif content type
PNG_CT =
-

-png content type -

+ +

png content type

@@ -799,9 +760,8 @@ png content type
DRAWING_CT =
-

-drawing content type -

+ +

drawing content type

@@ -817,9 +777,8 @@ drawing content type
XML_EX =
-

-xml content type extensions -

+ +

xml content type extensions

@@ -835,9 +794,8 @@ xml content type extensions
JPEG_EX =
-

-jpeg extension -

+ +

jpeg extension

@@ -853,9 +811,8 @@ jpeg extension
GIF_EX =
-

-gif extension -

+ +

gif extension

@@ -871,9 +828,8 @@ gif extension
PNG_EX =
-

-png extension -

+ +

png extension

@@ -889,9 +845,8 @@ png extension
RELS_EX =
-

-rels content type extension -

+ +

rels content type extension

@@ -907,9 +862,8 @@ rels content type extension
WORKBOOK_PN =
-

-workbook part -

+ +

workbook part

@@ -925,9 +879,8 @@ workbook part
STYLES_PN =
-

-styles part -

+ +

styles part

@@ -943,9 +896,8 @@ styles part
APP_PN =
-

-app part -

+ +

app part

@@ -961,9 +913,8 @@ app part
CORE_PN =
-

-core part -

+ +

core part

@@ -979,9 +930,8 @@ core part
CONTENT_TYPES_PN =
-

-content types part -

+ +

content types part

@@ -997,9 +947,8 @@ content types part
RELS_PN =
-

-rels part -

+ +

rels part

@@ -1015,9 +964,8 @@ rels part
WORKBOOK_RELS_PN =
-

-workbook rels part -

+ +

workbook rels part

@@ -1033,9 +981,8 @@ workbook rels part
WORKSHEET_PN =
-

-worksheet part -

+ +

worksheet part

@@ -1051,9 +998,8 @@ worksheet part
WORKSHEET_RELS_PN =
-

-worksheet rels part -

+ +

worksheet rels part

@@ -1069,9 +1015,8 @@ worksheet rels part
DRAWING_PN =
-

-drawing part -

+ +

drawing part

@@ -1087,9 +1032,8 @@ drawing part
DRAWING_RELS_PN =
-

-drawing rels part -

+ +

drawing rels part

@@ -1105,9 +1049,8 @@ drawing rels part
CHART_PN =
-

-chart part -

+ +

chart part

@@ -1123,9 +1066,8 @@ chart part
IMAGE_PN =
-

-chart part -

+ +

chart part

@@ -1141,9 +1083,8 @@ chart part
APP_XSD =
-

-App validation schema -

+ +

App validation schema

@@ -1159,9 +1100,8 @@ App validation schema
CORE_XSD =
-

-core validation schema -

+ +

core validation schema

@@ -1177,9 +1117,8 @@ core validation schema
CONTENT_TYPES_XSD =
-

-content types validation schema -

+ +

content types validation schema

@@ -1195,9 +1134,8 @@ content types validation schema
RELS_XSD =
-

-rels validation schema -

+ +

rels validation schema

@@ -1213,9 +1151,8 @@ rels validation schema
SML_XSD =
-

-spreadsheetML validation schema -

+ +

spreadsheetML validation schema

@@ -1231,9 +1168,8 @@ spreadsheetML validation schema
DRAWING_XSD =
-

-drawing validation schema -

+ +

drawing validation schema

@@ -1249,9 +1185,8 @@ drawing validation schema
NUM_FMT_PERCENT =
-

-number format id for pecentage formatting using the default formatting id. -

+ +

number format id for pecentage formatting using the default formatting id.

@@ -1267,9 +1202,8 @@ number format id for pecentage formatting using the default formatting id.
NUM_FMT_YYYYMMDD =
-

-number format id for date format like 2011/11/13 -

+ +

number format id for date format like 2011/11/13

@@ -1285,9 +1219,8 @@ number format id for date format like 2011/11/13
NUM_FMT_YYYYMMDDHHMMSS =
-

-number format id for time format the creates 2011/11/13 12:23:10 -

+ +

number format id for time format the creates 2011/11/13 12:23:10

@@ -1303,9 +1236,8 @@ number format id for time format the creates 2011/11/13 12:23:10
STYLE_THIN_BORDER =
-

-cellXfs id for thin borders around the cell -

+ +

cellXfs id for thin borders around the cell

@@ -1321,9 +1253,8 @@ cellXfs id for thin borders around the cell
ERR_RESTRICTION =
-

-error messages RestrictionValidor -

+ +

error messages RestrictionValidor

@@ -1339,9 +1270,8 @@ error messages RestrictionValidor
ERR_TYPE =
-

-error message DataTypeValidator -

+ +

error message DataTypeValidator

@@ -1357,9 +1287,8 @@ error message DataTypeValidator
ERR_REGEX =
-

-error message for RegexValidator -

+ +

error message for RegexValidator

@@ -1403,9 +1332,8 @@ error message for RegexValidator -

-determines the cell range for the items provided. -

+
+

determines the cell range for the items provided.

@@ -1427,10 +1355,9 @@ determines the cell range for the items provided. -

-Requires that the value is a form that can be evaluated as a boolean in an -xml document. -

+
+

Requires that the value is a form that can be evaluated as a boolean in an +xml document.

@@ -1452,11 +1379,10 @@ xml document. -

-Requires that the value is a valid content_type TABLE_CT, WORKBOOK_CT, +

+

Requires that the value is a valid content_type TABLE_CT, WORKBOOK_CT, APP_CT, RELS_CT, STYLES_CT, XML_CT, WORKSHEET_CT, SHARED_STRINGS_CT, -CORE_CT, CHART_CT, DRAWING_CT are allowed. -

+CORE_CT, CHART_CT, DRAWING_CT are allowed.

@@ -1478,9 +1404,8 @@ CORE_CT, CHART_CT, DRAWING_CT are allowed. -

-Requires that the value is a Float. -

+
+

Requires that the value is a Float.

@@ -1502,9 +1427,8 @@ Requires that the value is a Float. -

-Requires that the value is a gradient_type. -

+
+

Requires that the value is a gradient_type.

@@ -1526,11 +1450,10 @@ Requires that the value is a gradient_type. -

-Requires that the value is a valid horizontal_alignment :general, :left, +

+

Requires that the value is a valid horizontal_alignment :general, :left, :center, :right, :fill, :justify, :centerContinuous, :distributed are -allowed. -

+allowed.

@@ -1552,9 +1475,8 @@ allowed. -

-Requires that the value is a Fixnum or Integer. -

+
+

Requires that the value is a Fixnum or Integer.

@@ -1576,9 +1498,8 @@ Requires that the value is a Fixnum or Integer. -

-Requires that the value is valid pattern type. -

+
+

Requires that the value is valid pattern type.

@@ -1600,11 +1521,10 @@ Requires that the value is valid pattern type. -

-Requires that the value is a valid relationship_type XML_NS_R, TABLE_R, +

+

Requires that the value is a valid relationship_type XML_NS_R, TABLE_R, WORKBOOK_R, WORKSHEET_R, APP_R, RELS_R, CORE_R, STYLES_R, CHART_R, -DRAWING_R are allowed. -

+DRAWING_R are allowed.

@@ -1626,9 +1546,8 @@ DRAWING_R are allowed. -

-Requires that the value is a String. -

+
+

Requires that the value is a String.

@@ -1650,8 +1569,8 @@ Requires that the value is a String. -

-Requires that the value is a valid table element type :wholeTable, +

+

Requires that the value is a valid table element type :wholeTable, :headerRow, :totalRow, :firstColumn, :lastColumn, :firstRowStripe, :secondRowStripe, :firstColumnStripe, :secondColumnStripe, :firstHeaderCell, :lastHeaderCell, :firstTotalCell, :lastTotalCell, @@ -1659,8 +1578,7 @@ Requires that the value is a valid table element type :wholeTable, :firstSubtotalRow, :secondSubtotalRow, :thirdSubtotalRow, :blankRow, :firstColumnSubheading, :secondColumnSubheading, :thirdColumnSubheading, :firstRowSubheading, :secondRowSubheading, :thirdRowSubheading, -:pageFieldLabels, :pageFieldValues are allowed. -

+:pageFieldLabels, :pageFieldValues are allowed.

@@ -1682,10 +1600,9 @@ Requires that the value is a valid table element type :wholeTable, -

-Requires that the value is a Fixnum or Integer and is greater or equal to -0. -

+
+

Requires that the value is a Fixnum or Integer and is greater or equal to +0.

@@ -1707,10 +1624,9 @@ Requires that the value is a Fixnum or Integer and is greater or equal to -

-Requires that the value is a valid vertical_alignment :top, :center, -:bottom, :justify, :distributed are allowed. -

+
+

Requires that the value is a valid vertical_alignment :top, :center, +:bottom, :justify, :distributed are allowed.

@@ -1734,9 +1650,8 @@ Requires that the value is a valid vertical_alignment :top, :center,

-

-determines the cell range for the items provided -

+ +

determines the cell range for the items provided

@@ -1783,13 +1698,11 @@ determines the cell range for the items provided

-

-Requires that the value is a form that can be evaluated as a boolean in an + +

Requires that the value is a form that can be evaluated as a boolean in an xml document. The value must be an instance of Fixnum, String, Integer, -Symbol, TrueClass or FalseClass and it must be one of 0, 1, -"true", "false", :true, :false, true, false, -"0", or "1" -

+Symbol, TrueClass or FalseClass and it must be one of 0, 1, “true”, +“false”, :true, :false, true, false, “0”, or “1”

@@ -1808,9 +1721,8 @@ Symbol, TrueClass or FalseClass and it must be one of 0, 1, — -

-The value validated -

+
+

The value validated

@@ -1849,11 +1761,10 @@ The value validated

-

-Requires that the value is a valid content_type TABLE_CT, WORKBOOK_CT, + +

Requires that the value is a valid content_type TABLE_CT, WORKBOOK_CT, APP_CT, RELS_CT, STYLES_CT, XML_CT, WORKSHEET_CT, SHARED_STRINGS_CT, -CORE_CT, CHART_CT, DRAWING_CT are allowed -

+CORE_CT, CHART_CT, DRAWING_CT are allowed

@@ -1872,9 +1783,8 @@ CORE_CT, CHART_CT, DRAWING_CT are allowed — -

-The value validated -

+
+

The value validated

@@ -1913,9 +1823,8 @@ The value validated

-

-Requires that the value is a Float -

+ +

Requires that the value is a Float

@@ -1934,9 +1843,8 @@ Requires that the value is a Float — -

-The value validated -

+
+

The value validated

@@ -1975,10 +1883,9 @@ The value validated

-

-Requires that the value is a gradient_type. valid types are :linear and -:path -

+ +

Requires that the value is a gradient_type. valid types are :linear and +:path

@@ -1997,9 +1904,8 @@ Requires that the value is a gradient_type. valid types are :linear and — -

-The value validated -

+
+

The value validated

@@ -2038,11 +1944,10 @@ The value validated

-

-Requires that the value is a valid horizontal_alignment :general, :left, + +

Requires that the value is a valid horizontal_alignment :general, :left, :center, :right, :fill, :justify, :centerContinuous, :distributed are -allowed -

+allowed

@@ -2061,9 +1966,8 @@ allowed — -

-The value validated -

+
+

The value validated

@@ -2102,9 +2006,8 @@ The value validated

-

-Requires that the value is a Fixnum or Integer -

+ +

Requires that the value is a Fixnum or Integer

@@ -2123,9 +2026,8 @@ Requires that the value is a Fixnum or Integer — -

-The value validated -

+
+

The value validated

@@ -2164,13 +2066,12 @@ The value validated

-

-Requires that the value is valid pattern type. valid pattern types must be + +

Requires that the value is valid pattern type. valid pattern types must be one of :none, :solid, :mediumGray, :darkGray, :lightGray, :darkHorizontal, :darkVertical, :darkDown, :darkUp, :darkGrid, :darkTrellis, :lightHorizontal, :lightVertical, :lightDown, :lightUp, :lightGrid, -:lightTrellis, :gray125, or :gray0625. -

+:lightTrellis, :gray125, or :gray0625.

@@ -2189,9 +2090,8 @@ one of :none, :solid, :mediumGray, :darkGray, :lightGray, :darkHorizontal, — -

-The value validated -

+
+

The value validated

@@ -2232,11 +2132,10 @@ The value validated

-

-Requires that the value is a valid relationship_type XML_NS_R, TABLE_R, + +

Requires that the value is a valid relationship_type XML_NS_R, TABLE_R, WORKBOOK_R, WORKSHEET_R, APP_R, RELS_R, CORE_R, STYLES_R, CHART_R, -DRAWING_R are allowed -

+DRAWING_R are allowed

@@ -2255,9 +2154,8 @@ DRAWING_R are allowed — -

-The value validated -

+
+

The value validated

@@ -2296,9 +2194,8 @@ The value validated

-

-Requires that the value is a String -

+ +

Requires that the value is a String

@@ -2317,9 +2214,8 @@ Requires that the value is a String — -

-The value validated -

+
+

The value validated

@@ -2358,8 +2254,8 @@ The value validated

-

-Requires that the value is a valid table element type :wholeTable, + +

Requires that the value is a valid table element type :wholeTable, :headerRow, :totalRow, :firstColumn, :lastColumn, :firstRowStripe, :secondRowStripe, :firstColumnStripe, :secondColumnStripe, :firstHeaderCell, :lastHeaderCell, :firstTotalCell, :lastTotalCell, @@ -2367,8 +2263,7 @@ Requires that the value is a valid table element type :wholeTable, :firstSubtotalRow, :secondSubtotalRow, :thirdSubtotalRow, :blankRow, :firstColumnSubheading, :secondColumnSubheading, :thirdColumnSubheading, :firstRowSubheading, :secondRowSubheading, :thirdRowSubheading, -:pageFieldLabels, :pageFieldValues are allowed -

+:pageFieldLabels, :pageFieldValues are allowed

@@ -2387,9 +2282,8 @@ Requires that the value is a valid table element type :wholeTable, — -

-The value validated -

+
+

The value validated

@@ -2428,9 +2322,8 @@ The value validated

-

-Requires that the value is a Fixnum or Integer and is greater or equal to 0 -

+ +

Requires that the value is a Fixnum or Integer and is greater or equal to 0

@@ -2449,9 +2342,8 @@ Requires that the value is a Fixnum or Integer and is greater or equal to 0 — -

-The value validated -

+
+

The value validated

@@ -2469,9 +2361,8 @@ The value validated — -

-true if the data is valid -

+
+

true if the data is valid

@@ -2488,9 +2379,8 @@ true if the data is valid — -

-raised if the value is not a Fixnum or Integer value greater or equal to 0 -

+
+

raised if the value is not a Fixnum or Integer value greater or equal to 0

@@ -2528,10 +2418,9 @@ raised if the value is not a Fixnum or Integer value greater or equal to 0

-

-Requires that the value is a valid vertical_alignment :top, :center, -:bottom, :justify, :distributed are allowed -

+ +

Requires that the value is a valid vertical_alignment :top, :center, +:bottom, :justify, :distributed are allowed

@@ -2550,9 +2439,8 @@ Requires that the value is a valid vertical_alignment :top, :center, — -

-The value validated -

+
+

The value validated

@@ -2587,7 +2475,7 @@ The value validated
diff --git a/doc/Axlsx/App.html b/doc/Axlsx/App.html index dcc7eb99..f7e59649 100644 --- a/doc/Axlsx/App.html +++ b/doc/Axlsx/App.html @@ -97,22 +97,19 @@
Note: -

-Support is not implemented for the following complex types: -

-

-HeadingPairs (VectorVariant), TitlesOfParts (VectorLpstr), HLinks -(VectorVariant), DigSig (DigSigBlob) -

+
+

Support is not implemented for the following complex types:

+ +

HeadingPairs (VectorVariant), TitlesOfParts (VectorLpstr), HLinks +(VectorVariant), DigSig (DigSigBlob)

-

-App represents the app.xml document. The attributes for this object are + +

App represents the app.xml document. The attributes for this object are primarily managed by the application the end user uses to edit the document. None of the attributes are required to serialize a valid xlsx -object. -

+object.

@@ -151,9 +148,8 @@ object. -

-The name of the application. -

+
+

The name of the application.

@@ -178,9 +174,8 @@ The name of the application. -

-The version of the application. -

+
+

The version of the application.

@@ -205,9 +200,8 @@ The version of the application. -

-The number of characters in the document. -

+
+

The number of characters in the document.

@@ -232,9 +226,8 @@ The number of characters in the document. -

-The number of characters in the document including spaces. -

+
+

The number of characters in the document including spaces.

@@ -259,9 +252,8 @@ The number of characters in the document including spaces. -

-The name of the company generating the document. -

+
+

The name of the company generating the document.

@@ -286,9 +278,8 @@ The name of the company generating the document. -

-Document security. -

+
+

Document security.

@@ -313,9 +304,8 @@ Document security. -

-The number of hidden slides. -

+
+

The number of hidden slides.

@@ -340,9 +330,8 @@ The number of hidden slides. -

-The base for hyper links in the document. -

+
+

The base for hyper links in the document.

@@ -367,9 +356,8 @@ The base for hyper links in the document. -

-Indicates that the hyper links in the document have been changed. -

+
+

Indicates that the hyper links in the document have been changed.

@@ -394,9 +382,8 @@ Indicates that the hyper links in the document have been changed. -

-The number of lines in the document. -

+
+

The number of lines in the document.

@@ -421,9 +408,8 @@ The number of lines in the document. -

-The links in the document are up to date. -

+
+

The links in the document are up to date.

@@ -448,9 +434,8 @@ The links in the document are up to date. -

-The name of the manager for the document. -

+
+

The name of the manager for the document.

@@ -475,9 +460,8 @@ The name of the manager for the document. -

-The total number multimedia clips. -

+
+

The total number multimedia clips.

@@ -502,9 +486,8 @@ The total number multimedia clips. -

-The number of slides that have notes. -

+
+

The number of slides that have notes.

@@ -529,9 +512,8 @@ The number of slides that have notes. -

-The number of pages in the document. -

+
+

The number of pages in the document.

@@ -556,9 +538,8 @@ The number of pages in the document. -

-The number of paragraphs in the document. -

+
+

The number of paragraphs in the document.

@@ -583,9 +564,8 @@ The number of paragraphs in the document. -

-The intended format of the presentation. -

+
+

The intended format of the presentation.

@@ -610,9 +590,8 @@ The intended format of the presentation. -

-The display mode for the document thumbnail. -

+
+

The display mode for the document thumbnail.

@@ -637,9 +616,8 @@ The display mode for the document thumbnail. -

-Indicates if the document is shared. -

+
+

Indicates if the document is shared.

@@ -664,9 +642,8 @@ Indicates if the document is shared. -

-The number of slides in the document. -

+
+

The number of slides in the document.

@@ -691,9 +668,8 @@ The number of slides in the document. -

-The name of the document template. -

+
+

The name of the document template.

@@ -718,9 +694,8 @@ The name of the document template. -

-The total amount of time spent editing. -

+
+

The total amount of time spent editing.

@@ -745,9 +720,8 @@ The total amount of time spent editing. -

-The number of words in the document. -

+
+

The number of words in the document.

@@ -782,9 +756,8 @@ The number of words in the document. -

-Creates an App object. -

+
+

Creates an App object.

@@ -806,9 +779,8 @@ Creates an App object. -

-Generate an app.xml document. -

+
+

Generate an app.xml document.

@@ -833,9 +805,8 @@ Generate an app.xml document.

-

-The name of the application -

+ +

The name of the application

@@ -853,9 +824,8 @@ The name of the application — -

-The name of the application -

+
+

The name of the application

@@ -896,9 +866,8 @@ The name of the application

-

-The version of the application. -

+ +

The version of the application.

@@ -916,9 +885,8 @@ The version of the application. — -

-The version of the application. -

+
+

The version of the application.

@@ -959,9 +927,8 @@ The version of the application.

-

-The number of characters in the document. -

+ +

The number of characters in the document.

@@ -979,9 +946,8 @@ The number of characters in the document. — -

-The number of characters in the document. -

+
+

The number of characters in the document.

@@ -1022,9 +988,8 @@ The number of characters in the document.

-

-The number of characters in the document including spaces. -

+ +

The number of characters in the document including spaces.

@@ -1042,9 +1007,8 @@ The number of characters in the document including spaces. — -

-The number of characters in the document including spaces. -

+
+

The number of characters in the document including spaces.

@@ -1085,9 +1049,8 @@ The number of characters in the document including spaces.

-

-The name of the company generating the document. -

+ +

The name of the company generating the document.

@@ -1105,9 +1068,8 @@ The name of the company generating the document. — -

-The name of the company generating the document. -

+
+

The name of the company generating the document.

@@ -1148,9 +1110,8 @@ The name of the company generating the document.

-

-Document security -

+ +

Document security

@@ -1168,9 +1129,8 @@ Document security — -

-Document security -

+
+

Document security

@@ -1211,9 +1171,8 @@ Document security

-

-The number of hidden slides. -

+ +

The number of hidden slides.

@@ -1231,9 +1190,8 @@ The number of hidden slides. — -

-The number of hidden slides. -

+
+

The number of hidden slides.

@@ -1274,9 +1232,8 @@ The number of hidden slides.

-

-The base for hyper links in the document. -

+ +

The base for hyper links in the document.

@@ -1294,9 +1251,8 @@ The base for hyper links in the document. — -

-The base for hyper links in the document. -

+
+

The base for hyper links in the document.

@@ -1337,9 +1293,8 @@ The base for hyper links in the document.

-

-Indicates that the hyper links in the document have been changed. -

+ +

Indicates that the hyper links in the document have been changed.

@@ -1357,9 +1312,8 @@ Indicates that the hyper links in the document have been changed. — -

-Indicates that the hyper links in the document have been changed. -

+
+

Indicates that the hyper links in the document have been changed.

@@ -1400,9 +1354,8 @@ Indicates that the hyper links in the document have been changed.

-

-The number of lines in the document. -

+ +

The number of lines in the document.

@@ -1420,9 +1373,8 @@ The number of lines in the document. — -

-The number of lines in the document. -

+
+

The number of lines in the document.

@@ -1463,9 +1415,8 @@ The number of lines in the document.

-

-The links in the document are up to date. -

+ +

The links in the document are up to date.

@@ -1483,9 +1434,8 @@ The links in the document are up to date. — -

-The links in the document are up to date. -

+
+

The links in the document are up to date.

@@ -1526,9 +1476,8 @@ The links in the document are up to date.

-

-The name of the manager for the document. -

+ +

The name of the manager for the document.

@@ -1546,9 +1495,8 @@ The name of the manager for the document. — -

-The name of the manager for the document. -

+
+

The name of the manager for the document.

@@ -1589,9 +1537,8 @@ The name of the manager for the document.

-

-The total number multimedia clips -

+ +

The total number multimedia clips

@@ -1609,9 +1556,8 @@ The total number multimedia clips — -

-The total number multimedia clips -

+
+

The total number multimedia clips

@@ -1652,9 +1598,8 @@ The total number multimedia clips

-

-The number of slides that have notes. -

+ +

The number of slides that have notes.

@@ -1672,9 +1617,8 @@ The number of slides that have notes. — -

-The number of slides that have notes. -

+
+

The number of slides that have notes.

@@ -1715,9 +1659,8 @@ The number of slides that have notes.

-

-The number of pages in the document. -

+ +

The number of pages in the document.

@@ -1735,9 +1678,8 @@ The number of pages in the document. — -

-The number of pages in the document. -

+
+

The number of pages in the document.

@@ -1778,9 +1720,8 @@ The number of pages in the document.

-

-The number of paragraphs in the document -

+ +

The number of paragraphs in the document

@@ -1798,9 +1739,8 @@ The number of paragraphs in the document — -

-The number of paragraphs in the document -

+
+

The number of paragraphs in the document

@@ -1841,9 +1781,8 @@ The number of paragraphs in the document

-

-The intended format of the presentation. -

+ +

The intended format of the presentation.

@@ -1861,9 +1800,8 @@ The intended format of the presentation. — -

-The intended format of the presentation. -

+
+

The intended format of the presentation.

@@ -1904,9 +1842,8 @@ The intended format of the presentation.

-

-The display mode for the document thumbnail. -

+ +

The display mode for the document thumbnail.

@@ -1924,9 +1861,8 @@ The display mode for the document thumbnail. — -

-The display mode for the document thumbnail. -

+
+

The display mode for the document thumbnail.

@@ -1967,9 +1903,8 @@ The display mode for the document thumbnail.

-

-Indicates if the document is shared. -

+ +

Indicates if the document is shared.

@@ -1987,9 +1922,8 @@ Indicates if the document is shared. — -

-Indicates if the document is shared. -

+
+

Indicates if the document is shared.

@@ -2030,9 +1964,8 @@ Indicates if the document is shared.

-

-The number of slides in the document. -

+ +

The number of slides in the document.

@@ -2050,9 +1983,8 @@ The number of slides in the document. — -

-The number of slides in the document. -

+
+

The number of slides in the document.

@@ -2093,9 +2025,8 @@ The number of slides in the document.

-

-The name of the document template. -

+ +

The name of the document template.

@@ -2113,9 +2044,8 @@ The name of the document template. — -

-The name of the document template. -

+
+

The name of the document template.

@@ -2156,9 +2086,8 @@ The name of the document template.

-

-The total amount of time spent editing. -

+ +

The total amount of time spent editing.

@@ -2176,9 +2105,8 @@ The total amount of time spent editing. — -

-The total amount of time spent editing. -

+
+

The total amount of time spent editing.

@@ -2219,9 +2147,8 @@ The total amount of time spent editing.

-

-The number of words in the document. -

+ +

The number of words in the document.

@@ -2239,9 +2166,8 @@ The number of words in the document. — -

-The number of words in the document. -

+
+

The number of words in the document.

@@ -2286,9 +2212,8 @@ The number of words in the document.

-

-Creates an App object -

+ +

Creates an App object

@@ -2309,9 +2234,8 @@ Creates an App object — -

-a customizable set of options -

+
+

a customizable set of options

@@ -2561,9 +2485,8 @@ a customizable set of options

-

-Generate an app.xml document -

+ +

Generate an app.xml document

@@ -2581,9 +2504,8 @@ Generate an app.xml document — -

-The document as a string -

+
+

The document as a string

@@ -2631,7 +2553,7 @@ The document as a string
diff --git a/doc/Axlsx/Axis.html b/doc/Axlsx/Axis.html index a7c7b2d3..11b4f2bc 100644 --- a/doc/Axlsx/Axis.html +++ b/doc/Axlsx/Axis.html @@ -94,9 +94,8 @@

Overview

-

-the access class defines common properties and values for a chart axis. -

+ +

the access class defines common properties and values for a chart axis.

@@ -132,9 +131,8 @@ the access class defines common properties and values for a chart axis. -

-the id of the axis. -

+
+

the id of the axis.

@@ -159,9 +157,8 @@ the id of the axis. -

-The position of the axis must be one of [:l, :r, :t, :b]. -

+
+

The position of the axis must be one of [:l, :r, :t, :b].

@@ -186,9 +183,8 @@ The position of the axis must be one of [:l, :r, :t, :b]. -

-The perpendicular axis. -

+
+

The perpendicular axis.

@@ -213,10 +209,9 @@ The perpendicular axis. -

-specifies how the perpendicular axis is crossed must be one of [:autoZero, -:min, :max]. -

+
+

specifies how the perpendicular axis is crossed must be one of [:autoZero, +:min, :max].

@@ -241,9 +236,8 @@ specifies how the perpendicular axis is crossed must be one of [:autoZero, -

-The number format format code for this axis default :General. -

+
+

The number format format code for this axis default :General.

@@ -268,9 +262,8 @@ The number format format code for this axis default :General. -

-The scaling of the axis. -

+
+

The scaling of the axis.

@@ -295,9 +288,8 @@ The scaling of the axis. -

-the position of the tick labels must be one of [:nextTo, :high, :low]. -

+
+

the position of the tick labels must be one of [:nextTo, :high, :low].

@@ -334,9 +326,8 @@ the position of the tick labels must be one of [:nextTo, :high, :low]. -

-Creates an Axis object. -

+
+

Creates an Axis object.

@@ -358,9 +349,8 @@ Creates an Axis object. -

-Serializes the common axis. -

+
+

Serializes the common axis.

@@ -381,9 +371,8 @@ Serializes the common axis.

-

-Creates an Axis object -

+ +

Creates an Axis object

@@ -402,9 +391,8 @@ Creates an Axis object — -

-the id of this axis -

+
+

the id of this axis

@@ -419,9 +407,8 @@ the id of this axis — -

-the id of the perpendicular axis -

+
+

the id of the perpendicular axis

@@ -438,9 +425,8 @@ the id of the perpendicular axis — -

-a customizable set of options -

+
+

a customizable set of options

@@ -498,9 +484,8 @@ a customizable set of options — -

-If axId or crossAx are not unsigned integers -

+
+

If axId or crossAx are not unsigned integers

@@ -570,9 +555,8 @@ If axId or crossAx are not unsigned integers

-

-the id of the axis. -

+ +

the id of the axis.

@@ -627,9 +611,8 @@ the id of the axis.

-

-The position of the axis must be one of [:l, :r, :t, :b] -

+ +

The position of the axis must be one of [:l, :r, :t, :b]

@@ -684,9 +667,8 @@ The position of the axis must be one of [:l, :r, :t, :b]

-

-The perpendicular axis -

+ +

The perpendicular axis

@@ -741,10 +723,9 @@ The perpendicular axis

-

-specifies how the perpendicular axis is crossed must be one of [:autoZero, -:min, :max] -

+ +

specifies how the perpendicular axis is crossed must be one of [:autoZero, +:min, :max]

@@ -799,9 +780,8 @@ specifies how the perpendicular axis is crossed must be one of [:autoZero,

-

-The number format format code for this axis default :General -

+ +

The number format format code for this axis default :General

@@ -856,9 +836,8 @@ The number format format code for this axis default :General

-

-The scaling of the axis -

+ +

The scaling of the axis

@@ -920,9 +899,8 @@ The scaling of the axis

-

-the position of the tick labels must be one of [:nextTo, :high, :low] -

+ +

the position of the tick labels must be one of [:nextTo, :high, :low]

@@ -981,9 +959,8 @@ the position of the tick labels must be one of [:nextTo, :high, :low]

-

-Serializes the common axis -

+ +

Serializes the common axis

@@ -1002,9 +979,8 @@ Serializes the common axis — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -1066,7 +1042,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Bar3DChart.html b/doc/Axlsx/Bar3DChart.html index 43c620c9..fb338d09 100644 --- a/doc/Axlsx/Bar3DChart.html +++ b/doc/Axlsx/Bar3DChart.html @@ -96,10 +96,9 @@

Overview

-

-The Bar3DChart is a three dimentional barchart (who would have guessed?) -that you can add to your worksheet. -

+ +

The Bar3DChart is a three dimentional barchart (who would have guessed?) +that you can add to your worksheet.

@@ -128,9 +127,8 @@ that you can add to your worksheet.
GAP_AMOUNT_PERCENT =
-

-validation regex for gap amount percent -

+ +

validation regex for gap amount percent

@@ -173,9 +171,8 @@ validation regex for gap amount percent -

-The direction of the bars in the chart must be one of [:bar, :col]. -

+
+

The direction of the bars in the chart must be one of [:bar, :col].

@@ -200,9 +197,8 @@ The direction of the bars in the chart must be one of [:bar, :col]. -

-the category axis. -

+
+

the category axis.

@@ -227,10 +223,9 @@ the category axis. -

-space between bar or column clusters, as a percentage of the bar or column -width. -

+
+

space between bar or column clusters, as a percentage of the bar or column +width.

@@ -255,10 +250,9 @@ width. -

-space between bar or column clusters, as a percentage of the bar or column -width. -

+
+

space between bar or column clusters, as a percentage of the bar or column +width.

@@ -283,9 +277,8 @@ width. -

-grouping for a column, line, or area chart. -

+
+

grouping for a column, line, or area chart.

@@ -310,10 +303,9 @@ grouping for a column, line, or area chart. -

-The shabe of the bars or columns must be one of [:cone, :coneToMax, :box, -:cylinder, :pyramid, :pyramidToMax]. -

+
+

The shabe of the bars or columns must be one of [:cone, :coneToMax, :box, +:cylinder, :pyramid, :pyramidToMax].

@@ -338,9 +330,8 @@ The shabe of the bars or columns must be one of [:cone, :coneToMax, :box, -

-the valueaxis. -

+
+

the valueaxis.

@@ -385,9 +376,8 @@ the valueaxis. -

-Creates a new bar chart object. -

+
+

Creates a new bar chart object.

@@ -409,9 +399,8 @@ Creates a new bar chart object. -

-Serializes the bar chart. -

+
+

Serializes the bar chart.

@@ -442,9 +431,8 @@ Serializes the bar chart.

-

-Creates a new bar chart object -

+ +

Creates a new bar chart object

@@ -463,9 +451,8 @@ Creates a new bar chart object — -

-The workbook that owns this chart. -

+
+

The workbook that owns this chart.

@@ -482,9 +469,8 @@ The workbook that owns this chart. — -

-a customizable set of options -

+
+

a customizable set of options

@@ -686,9 +672,8 @@ a customizable set of options

-

-The direction of the bars in the chart must be one of [:bar, :col] -

+ +

The direction of the bars in the chart must be one of [:bar, :col]

@@ -743,9 +728,8 @@ The direction of the bars in the chart must be one of [:bar, :col]

-

-the category axis -

+ +

the category axis

@@ -800,10 +784,9 @@ the category axis

-

-space between bar or column clusters, as a percentage of the bar or column -width. -

+ +

space between bar or column clusters, as a percentage of the bar or column +width.

@@ -858,10 +841,9 @@ width.

-

-space between bar or column clusters, as a percentage of the bar or column -width. -

+ +

space between bar or column clusters, as a percentage of the bar or column +width.

@@ -916,10 +898,9 @@ width.

-

-grouping for a column, line, or area chart. must be one of -[:percentStacked, :clustered, :standard, :stacked] -

+ +

grouping for a column, line, or area chart. must be one of +[:percentStacked, :clustered, :standard, :stacked]

@@ -974,10 +955,9 @@ grouping for a column, line, or area chart. must be one of

-

-The shabe of the bars or columns must be one of [:cone, :coneToMax, :box, -:cylinder, :pyramid, :pyramidToMax] -

+ +

The shabe of the bars or columns must be one of [:cone, :coneToMax, :box, +:cylinder, :pyramid, :pyramidToMax]

@@ -1032,9 +1012,8 @@ The shabe of the bars or columns must be one of [:cone, :coneToMax, :box,

-

-the valueaxis -

+ +

the valueaxis

@@ -1093,9 +1072,8 @@ the valueaxis

-

-Serializes the bar chart -

+ +

Serializes the bar chart

@@ -1173,7 +1151,7 @@ Serializes the bar chart
diff --git a/doc/Axlsx/BarSeries.html b/doc/Axlsx/BarSeries.html index 283f7c6d..30362718 100644 --- a/doc/Axlsx/BarSeries.html +++ b/doc/Axlsx/BarSeries.html @@ -99,15 +99,13 @@
Note: -

-The recommended way to manage series is to use Chart#add_series -

+
+

The recommended way to manage series is to use Chart#add_series

-

-A BarSeries defines the title, data and labels for bar charts -

+ +

A BarSeries defines the title, data and labels for bar charts

@@ -152,9 +150,8 @@ A BarSeries defines the title, data and labels for bar charts -

-The data for this series. -

+
+

The data for this series.

@@ -179,9 +176,8 @@ The data for this series. -

-The labels for this series. -

+
+

The labels for this series.

@@ -206,10 +202,9 @@ The labels for this series. -

-The shabe of the bars or columns must be one of [:percentStacked, -:clustered, :standard, :stacked]. -

+
+

The shabe of the bars or columns must be one of [:percentStacked, +:clustered, :standard, :stacked].

@@ -254,9 +249,8 @@ The shabe of the bars or columns must be one of [:percentStacked, -

-Creates a new series. -

+
+

Creates a new series.

@@ -278,9 +272,8 @@ Creates a new series. -

-Serializes the series. -

+
+

Serializes the series.

@@ -311,9 +304,8 @@ Serializes the series.

-

-Creates a new series -

+ +

Creates a new series

@@ -345,9 +337,8 @@ Creates a new series — -

-a customizable set of options -

+
+

a customizable set of options

@@ -447,9 +438,8 @@ a customizable set of options

-

-The data for this series. -

+ +

The data for this series.

@@ -504,9 +494,8 @@ The data for this series.

-

-The labels for this series. -

+ +

The labels for this series.

@@ -561,10 +550,9 @@ The labels for this series.

-

-The shabe of the bars or columns must be one of [:percentStacked, -:clustered, :standard, :stacked] -

+ +

The shabe of the bars or columns must be one of [:percentStacked, +:clustered, :standard, :stacked]

@@ -623,9 +611,8 @@ The shabe of the bars or columns must be one of [:percentStacked,

-

-Serializes the series -

+ +

Serializes the series

@@ -644,9 +631,8 @@ Serializes the series — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -702,7 +688,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Border.html b/doc/Axlsx/Border.html index 8db0c7f0..71a33a92 100644 --- a/doc/Axlsx/Border.html +++ b/doc/Axlsx/Border.html @@ -94,9 +94,8 @@

Overview

-

-This class details a border used in Office Open XML spreadsheet styles. -

+ +

This class details a border used in Office Open XML spreadsheet styles.

@@ -128,11 +127,10 @@ This class details a border used in Office Open XML spreadsheet styles. -

-The diagonal down property for the border that indicates if the border +

+

The diagonal down property for the border that indicates if the border should include a diagonal line from the top left to the top right of the -cell. -

+cell.

@@ -157,10 +155,9 @@ cell. -

-The diagonal up property for the border that indicates if the border should -include a diagonal line from the bottom left to the top right of the cell. -

+
+

The diagonal up property for the border that indicates if the border should +include a diagonal line from the bottom left to the top right of the cell.

@@ -185,11 +182,10 @@ include a diagonal line from the bottom left to the top right of the cell. -

-The outline property for the border indicating that top, left, right and +

+

The outline property for the border indicating that top, left, right and bottom borders should only be applied to the outside border of a range of -cells. -

+cells.

@@ -214,9 +210,8 @@ cells. -

-A list of BorderPr objects for this border. -

+
+

A list of BorderPr objects for this border.

@@ -253,9 +248,8 @@ A list of BorderPr objects for this border. -

-Creates a new Border object. -

+
+

Creates a new Border object.

@@ -277,9 +271,8 @@ Creates a new Border object. -

-Serializes the border element. -

+
+

Serializes the border element.

@@ -300,9 +293,8 @@ Serializes the border element.

-

-Creates a new Border object -

+ +

Creates a new Border object

@@ -312,9 +304,8 @@ Creates a new Border object

Examples:

-

-Making a border -

+

+

Making a border

p = Package.new
 red_border = Border.new
@@ -343,9 +334,8 @@ Making a border
       
       
         —
-        

-a customizable set of options -

+
+

a customizable set of options

@@ -434,11 +424,10 @@ a customizable set of options

-

-The diagonal down property for the border that indicates if the border + +

The diagonal down property for the border that indicates if the border should include a diagonal line from the top left to the top right of the -cell. -

+cell.

@@ -456,11 +445,10 @@ cell. — -

-The diagonal down property for the border that indicates if the border +

+

The diagonal down property for the border that indicates if the border should include a diagonal line from the top left to the top right of the -cell. -

+cell.

@@ -501,10 +489,9 @@ cell.

-

-The diagonal up property for the border that indicates if the border should -include a diagonal line from the bottom left to the top right of the cell. -

+ +

The diagonal up property for the border that indicates if the border should +include a diagonal line from the bottom left to the top right of the cell.

@@ -522,10 +509,9 @@ include a diagonal line from the bottom left to the top right of the cell. — -

-The diagonal up property for the border that indicates if the border should -include a diagonal line from the bottom left to the top right of the cell. -

+
+

The diagonal up property for the border that indicates if the border should +include a diagonal line from the bottom left to the top right of the cell.

@@ -566,11 +552,10 @@ include a diagonal line from the bottom left to the top right of the cell.

-

-The outline property for the border indicating that top, left, right and + +

The outline property for the border indicating that top, left, right and bottom borders should only be applied to the outside border of a range of -cells. -

+cells.

@@ -588,11 +573,10 @@ cells. — -

-The outline property for the border indicating that top, left, right and +

+

The outline property for the border indicating that top, left, right and bottom borders should only be applied to the outside border of a range of -cells. -

+cells.

@@ -633,9 +617,8 @@ cells.

-

-A list of BorderPr objects for this border. -

+ +

A list of BorderPr objects for this border.

@@ -653,9 +636,8 @@ A list of BorderPr objects for this border. — -

-A list of BorderPr objects for this border. -

+
+

A list of BorderPr objects for this border.

@@ -700,9 +682,8 @@ A list of BorderPr objects for this border.

-

-Serializes the border element -

+ +

Serializes the border element

@@ -721,9 +702,8 @@ Serializes the border element — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -770,7 +750,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/BorderPr.html b/doc/Axlsx/BorderPr.html index 9d7ac897..6daa67a9 100644 --- a/doc/Axlsx/BorderPr.html +++ b/doc/Axlsx/BorderPr.html @@ -94,9 +94,8 @@

Overview

-

-A border part. -

+ +

A border part.

@@ -128,9 +127,8 @@ A border part. -

-The color of this border part. -

+
+

The color of this border part.

@@ -155,9 +153,8 @@ The color of this border part. -

-The name of this border part. -

+
+

The name of this border part.

@@ -182,9 +179,8 @@ The name of this border part. -

-The syle of this border part. -

+
+

The syle of this border part.

@@ -221,9 +217,8 @@ The syle of this border part. -

-Creates a new Border Part Object. -

+
+

Creates a new Border Part Object.

@@ -245,9 +240,8 @@ Creates a new Border Part Object. -

-Serializes the border part. -

+
+

Serializes the border part.

@@ -268,9 +262,8 @@ Serializes the border part.

-

-Creates a new Border Part Object -

+ +

Creates a new Border Part Object

@@ -291,9 +284,8 @@ Creates a new Border Part Object — -

-a customizable set of options -

+
+

a customizable set of options

@@ -387,9 +379,8 @@ a customizable set of options

-

-The color of this border part. -

+ +

The color of this border part.

@@ -407,9 +398,8 @@ The color of this border part. — -

-The color of this border part. -

+
+

The color of this border part.

@@ -453,26 +443,24 @@ The color of this border part.
Note: -

-The following are allowed -

-
- :start
- :end
- :left
- :right
- :top
- :bottom
- :diagonal
- :vertical
- :horizontal
+    
+

The following are allowed

+ +
:start
+:end
+:left
+:right
+:top
+:bottom
+:diagonal
+:vertical
+:horizontal
 
-

-The name of this border part -

+ +

The name of this border part

@@ -490,9 +478,8 @@ The name of this border part — -

-The name of this border part -

+
+

The name of this border part

@@ -536,31 +523,29 @@ The name of this border part
Note: -

-The following are allowed -

-
- :none
- :thin
- :medium
- :dashed
- :dotted
- :thick
- :double
- :hair
- :mediumDashed
- :dashDot
- :mediumDashDot
- :dashDotDot
- :mediumDashDotDot
- :slantDashDot
+    
+

The following are allowed

+ +
:none 
+:thin
+:medium
+:dashed
+:dotted
+:thick
+:double
+:hair 
+:mediumDashed
+:dashDot
+:mediumDashDot
+:dashDotDot
+:mediumDashDotDot
+:slantDashDot
 
-

-The syle of this border part. -

+ +

The syle of this border part.

@@ -578,9 +563,8 @@ The syle of this border part. — -

-The syle of this border part. -

+
+

The syle of this border part.

@@ -625,9 +609,8 @@ The syle of this border part.

-

-Serializes the border part -

+ +

Serializes the border part

@@ -646,9 +629,8 @@ Serializes the border part — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -700,7 +682,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/CatAxis.html b/doc/Axlsx/CatAxis.html index bad9fa72..51fbc5ab 100644 --- a/doc/Axlsx/CatAxis.html +++ b/doc/Axlsx/CatAxis.html @@ -96,9 +96,8 @@

Overview

-

-A CatAxis object defines a chart category axis -

+ +

A CatAxis object defines a chart category axis

@@ -114,9 +113,8 @@ A CatAxis object defines a chart category axis
LBL_OFFSET_REGEX =
-

-regex for validating label offset -

+ +

regex for validating label offset

@@ -159,10 +157,9 @@ regex for validating label offset -

-From the docs: This element specifies that this axis is a date or text axis -based on the data that is used for the axis labels, not a specific choice. -

+
+

From the docs: This element specifies that this axis is a date or text axis +based on the data that is used for the axis labels, not a specific choice.

@@ -187,10 +184,9 @@ based on the data that is used for the axis labels, not a specific choice. -

-specifies how the perpendicular axis is crossed must be one of [:ctr, :l, -:r]. -

+
+

specifies how the perpendicular axis is crossed must be one of [:ctr, :l, +:r].

@@ -215,9 +211,8 @@ specifies how the perpendicular axis is crossed must be one of [:ctr, :l, -

-The offset of the labels must be between a string between 0 and 1000. -

+
+

The offset of the labels must be between a string between 0 and 1000.

@@ -262,9 +257,8 @@ The offset of the labels must be between a string between 0 and 1000. -

-Creates a new CatAxis object. -

+
+

Creates a new CatAxis object.

@@ -286,9 +280,8 @@ Creates a new CatAxis object. -

-Serializes the category axis. -

+
+

Serializes the category axis.

@@ -314,9 +307,8 @@ Serializes the category axis.

-

-Creates a new CatAxis object -

+ +

Creates a new CatAxis object

@@ -335,9 +327,8 @@ Creates a new CatAxis object — -

-the id of this axis. Inherited -

+
+

the id of this axis. Inherited

@@ -352,9 +343,8 @@ the id of this axis. Inherited — -

-the id of the perpendicular axis. Inherited -

+
+

the id of the perpendicular axis. Inherited

@@ -371,9 +361,8 @@ the id of the perpendicular axis. Inherited — -

-a customizable set of options -

+
+

a customizable set of options

@@ -396,9 +385,8 @@ a customizable set of options - —

-Inherited -

+ —
+

Inherited

@@ -408,9 +396,8 @@ Inherited - —

-Inherited -

+ —
+

Inherited

@@ -420,9 +407,8 @@ Inherited - —

-Inherited -

+ —
+

Inherited

@@ -502,10 +488,9 @@ Inherited

-

-From the docs: This element specifies that this axis is a date or text axis -based on the data that is used for the axis labels, not a specific choice. -

+ +

From the docs: This element specifies that this axis is a date or text axis +based on the data that is used for the axis labels, not a specific choice.

@@ -560,10 +545,9 @@ based on the data that is used for the axis labels, not a specific choice.

-

-specifies how the perpendicular axis is crossed must be one of [:ctr, :l, -:r] -

+ +

specifies how the perpendicular axis is crossed must be one of [:ctr, :l, +:r]

@@ -618,9 +602,8 @@ specifies how the perpendicular axis is crossed must be one of [:ctr, :l,

-

-The offset of the labels must be between a string between 0 and 1000 -

+ +

The offset of the labels must be between a string between 0 and 1000

@@ -679,9 +662,8 @@ The offset of the labels must be between a string between 0 and 1000

-

-Serializes the category axis -

+ +

Serializes the category axis

@@ -700,9 +682,8 @@ Serializes the category axis — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -760,7 +741,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/CatAxisData.html b/doc/Axlsx/CatAxisData.html index b66657e2..7530a7c6 100644 --- a/doc/Axlsx/CatAxisData.html +++ b/doc/Axlsx/CatAxisData.html @@ -96,9 +96,8 @@

Overview

-

-The CatAxisData class serializes the category axis data for a chart -

+ +

The CatAxisData class serializes the category axis data for a chart

@@ -153,9 +152,8 @@ The CatAxisData class serializes the category axis data for a chart -

-Create a new CatAxisData object. -

+
+

Create a new CatAxisData object.

@@ -177,9 +175,8 @@ Create a new CatAxisData object. -

-Serializes the category axis data. -

+
+

Serializes the category axis data.

@@ -205,9 +202,8 @@ Serializes the category axis data.

-

-Create a new CatAxisData object -

+ +

Create a new CatAxisData object

@@ -228,10 +224,9 @@ Create a new CatAxisData object — -

-the data for this category axis. This can be a simple array or a simple -typed list of cells. -

+
+

the data for this category axis. This can be a simple array or a simple +typed list of cells.

@@ -291,9 +286,8 @@ typed list of cells.

-

-Serializes the category axis data -

+ +

Serializes the category axis data

@@ -312,9 +306,8 @@ Serializes the category axis data — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -388,7 +381,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Cell.html b/doc/Axlsx/Cell.html index 574297f4..59403b4a 100644 --- a/doc/Axlsx/Cell.html +++ b/doc/Axlsx/Cell.html @@ -97,22 +97,20 @@
Note: -

-The recommended way to generate cells is via Worksheet#add_row -

+
+

The recommended way to generate cells is via Worksheet#add_row

-

-A cell in a worksheet. Cell stores inforamation requried to serialize a + +

A cell in a worksheet. Cell stores inforamation requried to serialize a single worksheet cell to xml. You must provde the Row that the cell belongs to and the cells value. The data type will automatically be determed if you do not specify the :type option. The default style will be applied if you -do not supply the :style option. Changing the cell’s type will recast -the value to the type specified. Altering the cell’s value via the -property accessor will also automatically cast the provided value to the -cell’s type. -

+do not supply the :style option. Changing the cell’s type will recast the +value to the type specified. Altering the cell’s value via the property +accessor will also automatically cast the provided value to the cell’s +type.

@@ -122,9 +120,8 @@ cell’s type.

Examples:

-

-Manually creating and manipulating Cell objects -

+

+

Manually creating and manipulating Cell objects

ws = Workbook.new.add_worksheet 
 # This is the simple, and recommended way to create cells. Data types will automatically be determined for you.
@@ -176,9 +173,8 @@ Manually creating and manipulating Cell objects
   
 
   
-    

-The row this cell belongs to. -

+
+

The row this cell belongs to.

@@ -203,9 +199,8 @@ The row this cell belongs to. -

-The index of the cellXfs item to be applied to this cell. -

+
+

The index of the cellXfs item to be applied to this cell.

@@ -230,9 +225,8 @@ The index of the cellXfs item to be applied to this cell. -

-The cell’s data type. -

+
+

The cell’s data type.

@@ -257,9 +251,8 @@ The cell’s data type. -

-The value of this cell. -

+
+

The value of this cell.

@@ -294,9 +287,8 @@ The value of this cell. -

-Cast the value into this cells data type. -

+
+

Cast the value into this cells data type.

@@ -318,9 +310,8 @@ Cast the value into this cells data type. -

-Determines the cell type based on the cell value. -

+
+

Determines the cell type based on the cell value.

@@ -342,9 +333,8 @@ Determines the cell type based on the cell value. -

-converts the column index into alphabetical values. -

+
+

converts the column index into alphabetical values.

@@ -366,9 +356,8 @@ converts the column index into alphabetical values. -

-The index of the cell in the containing row. -

+
+

The index of the cell in the containing row.

@@ -392,9 +381,8 @@ The index of the cell in the containing row. -

-A new instance of Cell. -

+
+

A new instance of Cell.

@@ -416,9 +404,8 @@ A new instance of Cell. -

-The alpha(column)numeric(row) reference for this sell. -

+
+

The alpha(column)numeric(row) reference for this sell.

@@ -440,9 +427,8 @@ The alpha(column)numeric(row) reference for this sell. -

-The absolute alpha(column)numeric(row) reference for this sell. -

+
+

The absolute alpha(column)numeric(row) reference for this sell.

@@ -464,9 +450,8 @@ The absolute alpha(column)numeric(row) reference for this sell. -

-Serializes the cell. -

+
+

Serializes the cell.

@@ -487,9 +472,8 @@ Serializes the cell.

-

-A new instance of Cell -

+ +

A new instance of Cell

@@ -508,9 +492,8 @@ A new instance of Cell — -

-The row this cell belongs to. -

+
+

The row this cell belongs to.

@@ -527,9 +510,8 @@ The row this cell belongs to. — -

-The value associated with this cell. -

+
+

The value associated with this cell.

@@ -546,9 +528,8 @@ The value associated with this cell. — -

-a customizable set of options -

+
+

a customizable set of options

@@ -571,10 +552,9 @@ a customizable set of options - —

-The intended data type for this cell. If not specified the data type will -be determined internally based on the vlue provided. -

+ —
+

The intended data type for this cell. If not specified the data type will +be determined internally based on the vlue provided.

@@ -584,10 +564,9 @@ be determined internally based on the vlue provided. - —

-The index of the cellXfs item to be applied to this cell. If not specified, -the default style (0) will be applied. -

+ —
+

The index of the cellXfs item to be applied to this cell. If not specified, +the default style (0) will be applied.

@@ -646,9 +625,8 @@ the default style (0) will be applied.

-

-The row this cell belongs to. -

+ +

The row this cell belongs to.

@@ -703,9 +681,8 @@ The row this cell belongs to.

-

-The index of the cellXfs item to be applied to this cell. -

+ +

The index of the cellXfs item to be applied to this cell.

@@ -770,26 +747,23 @@ The index of the cellXfs item to be applied to this cell.
Note: -

-If the value provided cannot be cast into the type specified, type is -changed to :string and the following logic is applied. -

-
- :string to :integer or :float, type coversions always return 0 or 0.0
- :string, :integer, or :float to :time conversions always return the original value as a string and set the cells type to :string.
+    
+

If the value provided cannot be cast into the type specified, type is +changed to :string and the following logic is applied.

+ +
:string to :integer or :float, type coversions always return 0 or 0.0    
+:string, :integer, or :float to :time conversions always return the original value as a string and set the cells type to :string.
 
-

-No support is currently implemented for parsing time strings. -

+ +

No support is currently implemented for parsing time strings.

-

-The cell’s data type. Currently only four types are supported, :time, + +

The cell’s data type. Currently only four types are supported, :time, :float, :integer and :string. Changing the type for a cell will recast the value into that type. If no type option is specified in the constructor, -the type is automatically determed. -

+the type is automatically determed.

@@ -807,9 +781,8 @@ the type is automatically determed. — -

-The type of data this cell’s value is cast to. -

+
+

The type of data this cell’s value is cast to.

@@ -826,9 +799,8 @@ The type of data this cell’s value is cast to. — -

-Cell.type must be one of [:time, :float, :integer, :string] -

+
+

Cell.type must be one of [:time, :float, :integer, :string]

@@ -876,9 +848,8 @@ Cell.type must be one of [:time, :float, :integer, :string]

-

-The value of this cell. -

+ +

The value of this cell.

@@ -896,9 +867,8 @@ The value of this cell. -

-casted value based on cell’s type attribute. -

+
+

casted value based on cell’s type attribute.

@@ -946,18 +916,16 @@ casted value based on cell’s type attribute.
Note: -

-About Time - Time in OOXML is different from what you might expect. -The history as to why is interesting, but you can safely assume that if you -are generating docs on a mac, you will want to specify Workbook.1904 as -true when using time typed values. -

+
+

About Time - Time in OOXML is different from what you +might expect. The history as to why is interesting, but you can safely +assume that if you are generating docs on a mac, you will want to specify +Workbook.1904 as true when using time typed values.

-

-Cast the value into this cells data type. -

+ +

Cast the value into this cells data type.

@@ -991,16 +959,24 @@ Cast the value into this cells data type. 179 180 181 -182
+182 +183 +184 +185 +186

# File 'lib/axlsx/workbook/worksheet/cell.rb', line 169
 
 def cast_value(v)
   if (@type == :time && v.is_a?(Time)) || (@type == :time && v.respond_to?(:to_time))
-    v = v.to_time
-    epoc = Workbook.date1904 ? Time.local(1904,1,1,0,0,0,0,v.zone) : Time.local(1900,1,1,0,0,0,0,v.zone)
-    ((v - epoc) /60.0/60.0/24.0).to_f
+    v = v.respond_to?(:to_time) ? v.to_time : v
+    # Using hardcoded offsets here as some operating systems will not except a 'negative' offset from the ruby epoc.
+    # (1970)
+    epoc1900 = -2209021200 #Time.local(1900, 1, 1) 
+    epoc1904 = -2082877200 #Time.local(1904, 1, 1) 
+    epoc = Workbook.date1904 ? epoc1904 : epoc1900
+    ((v.localtime.to_f - epoc) /60.0/60.0/24.0).to_f
   elsif @type == :float
     v.to_f
   elsif @type == :integer
@@ -1028,28 +1004,22 @@ Cast the value into this cells data type.
     
   
Note: -

-This is only used when a cell is created but no :type option is specified, -the following rules apply: -

-
    -
  1. If the value is an instance of Time, the type is set to :time - -
  2. -
  3. :float and :integer types are determined by regular expression matching. - -
  4. -
  5. Anything that does not meet either of the above is determined to be -:string. - -
  6. -
+
+

This is only used when a cell is created but no :type option is specified, +the following rules apply:

+
  1. +

    If the value is an instance of Time, the type is set to :time

    +
  2. +

    :float and :integer types are determined by regular expression matching.

    +
  3. +

    Anything that does not meet either of the above is determined to be +:string.

    +
-

-Determines the cell type based on the cell value. -

+ +

Determines the cell type based on the cell value.

@@ -1067,9 +1037,8 @@ Determines the cell type based on the cell value. — -

-The determined type -

+
+

The determined type

@@ -1126,16 +1095,14 @@ The determined type
Note: -

-This follows the standard spreadsheet convention of naming columns A to Z, -followed by AA to AZ etc. -

+
+

This follows the standard spreadsheet convention of naming columns A to Z, +followed by AA to AZ etc.

-

-converts the column index into alphabetical values. -

+ +

converts the column index into alphabetical values.

@@ -1209,7 +1176,11 @@ converts the column index into alphabetical values. 180 181 182 -183
+183 +184 +185 +186 +187
# File 'lib/axlsx/workbook/worksheet/cell.rb', line 136
@@ -1249,9 +1220,13 @@ converts the column index into alphabetical values.
   # @see Axlsx#date1904
   def cast_value(v)
     if (@type == :time && v.is_a?(Time)) || (@type == :time && v.respond_to?(:to_time))
-      v = v.to_time
-      epoc = Workbook.date1904 ? Time.local(1904,1,1,0,0,0,0,v.zone) : Time.local(1900,1,1,0,0,0,0,v.zone)
-      ((v - epoc) /60.0/60.0/24.0).to_f
+      v = v.respond_to?(:to_time) ? v.to_time : v
+      # Using hardcoded offsets here as some operating systems will not except a 'negative' offset from the ruby epoc.
+      # (1970)
+      epoc1900 = -2209021200 #Time.local(1900, 1, 1) 
+      epoc1904 = -2082877200 #Time.local(1904, 1, 1) 
+      epoc = Workbook.date1904 ? epoc1904 : epoc1900
+      ((v.localtime.to_f - epoc) /60.0/60.0/24.0).to_f
     elsif @type == :float
       v.to_f
     elsif @type == :integer
@@ -1277,9 +1252,8 @@ converts the column index into alphabetical values.
   
 

-

-The index of the cell in the containing row. -

+ +

The index of the cell in the containing row.

@@ -1297,9 +1271,8 @@ The index of the cell in the containing row. — -

-The index of the cell in the containing row. -

+
+

The index of the cell in the containing row.

@@ -1337,9 +1310,8 @@ The index of the cell in the containing row.

-

-The alpha(column)numeric(row) reference for this sell. -

+ +

The alpha(column)numeric(row) reference for this sell.

@@ -1349,9 +1321,8 @@ The alpha(column)numeric(row) reference for this sell.

Examples:

-

-Relative Cell Reference -

+

+

Relative Cell Reference

ws.rows.first.cells.first.r #=> "A1" 
 
@@ -1369,9 +1340,8 @@ Relative Cell Reference — -

-The alpha(column)numeric(row) reference for this sell. -

+
+

The alpha(column)numeric(row) reference for this sell.

@@ -1409,9 +1379,8 @@ The alpha(column)numeric(row) reference for this sell.

-

-The absolute alpha(column)numeric(row) reference for this sell. -

+ +

The absolute alpha(column)numeric(row) reference for this sell.

@@ -1421,9 +1390,8 @@ The absolute alpha(column)numeric(row) reference for this sell.

Examples:

-

-Absolute Cell Reference -

+

+

Absolute Cell Reference

ws.rows.first.cells.first.r #=> "$A$1" 
 
@@ -1441,9 +1409,8 @@ Absolute Cell Reference — -

-The absolute alpha(column)numeric(row) reference for this sell. -

+
+

The absolute alpha(column)numeric(row) reference for this sell.

@@ -1484,16 +1451,14 @@ The absolute alpha(column)numeric(row) reference for this sell.
Note: -

-Shared Strings are not used in this library. All values are set directly in -the each sheet. -

+
+

Shared Strings are not used in this library. All values are set directly in +the each sheet.

-

-Serializes the cell -

+ +

Serializes the cell

@@ -1512,9 +1477,8 @@ Serializes the cell — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -1532,9 +1496,8 @@ The document builder instance this objects xml will be added to. — -

-xml text for the cell -

+
+

xml text for the cell

@@ -1586,7 +1549,7 @@ xml text for the cell
diff --git a/doc/Axlsx/CellAlignment.html b/doc/Axlsx/CellAlignment.html index 5a04b500..480b145f 100644 --- a/doc/Axlsx/CellAlignment.html +++ b/doc/Axlsx/CellAlignment.html @@ -97,16 +97,14 @@
Note: -

-Using Styles#add_style is the recommended way to manage cell alignment. -

+
+

Using Styles#add_style is the recommended way to manage cell alignment.

-

-CellAlignment stores information about the cell alignment of a style Xf -Object. -

+ +

CellAlignment stores information about the cell alignment of a style Xf +Object.

@@ -145,9 +143,8 @@ Object. -

-The horizontal alignment of the cell. -

+
+

The horizontal alignment of the cell.

@@ -172,9 +169,8 @@ The horizontal alignment of the cell. -

-The amount of indent. -

+
+

The amount of indent.

@@ -199,9 +195,8 @@ The amount of indent. -

-Indicate if the last line should be justified. -

+
+

Indicate if the last line should be justified.

@@ -226,10 +221,9 @@ Indicate if the last line should be justified. -

-The reading order of the text 0 Context Dependent 1 Left-to-Right 2 -Right-to-Left. -

+
+

The reading order of the text 0 Context Dependent 1 Left-to-Right 2 +Right-to-Left.

@@ -254,9 +248,8 @@ Right-to-Left. -

-The amount of relativeIndent. -

+
+

The amount of relativeIndent.

@@ -281,9 +274,8 @@ The amount of relativeIndent. -

-Indicate if the text should be shrunk to the fit in the cell. -

+
+

Indicate if the text should be shrunk to the fit in the cell.

@@ -308,9 +300,8 @@ Indicate if the text should be shrunk to the fit in the cell. -

-The textRotation of the cell. -

+
+

The textRotation of the cell.

@@ -335,9 +326,8 @@ The textRotation of the cell. -

-The vertical alignment of the cell. -

+
+

The vertical alignment of the cell.

@@ -362,9 +352,8 @@ The vertical alignment of the cell. -

-Indicate if the text of the cell should wrap. -

+
+

Indicate if the text of the cell should wrap.

@@ -401,9 +390,8 @@ Indicate if the text of the cell should wrap. -

-Create a new cell_alignment object. -

+
+

Create a new cell_alignment object.

@@ -425,9 +413,8 @@ Create a new cell_alignment object. -

-Serializes the cell alignment. -

+
+

Serializes the cell alignment.

@@ -448,9 +435,8 @@ Serializes the cell alignment.

-

-Create a new cell_alignment object -

+ +

Create a new cell_alignment object

@@ -471,9 +457,8 @@ Create a new cell_alignment object — -

-a customizable set of options -

+
+

a customizable set of options

@@ -617,25 +602,23 @@ a customizable set of options
Note: -

-The horizontal cell alignement style must be one of -

-
- :general
- :left
- :center
- :right
- :fill
- :justify
- :centerContinuous
- :distributed
+    
+

The horizontal cell alignement style must be one of

+ +
:general
+:left
+:center
+:right
+:fill
+:justify
+:centerContinuous
+:distributed
 
-

-The horizontal alignment of the cell. -

+ +

The horizontal alignment of the cell.

@@ -690,9 +673,8 @@ The horizontal alignment of the cell.

-

-The amount of indent -

+ +

The amount of indent

@@ -747,9 +729,8 @@ The amount of indent

-

-Indicate if the last line should be justified. -

+ +

Indicate if the last line should be justified.

@@ -804,10 +785,9 @@ Indicate if the last line should be justified.

-

-The reading order of the text 0 Context Dependent 1 Left-to-Right 2 -Right-to-Left -

+ +

The reading order of the text 0 Context Dependent 1 Left-to-Right 2 +Right-to-Left

@@ -862,9 +842,8 @@ Right-to-Left

-

-The amount of relativeIndent -

+ +

The amount of relativeIndent

@@ -919,9 +898,8 @@ The amount of relativeIndent

-

-Indicate if the text should be shrunk to the fit in the cell. -

+ +

Indicate if the text should be shrunk to the fit in the cell.

@@ -976,9 +954,8 @@ Indicate if the text should be shrunk to the fit in the cell.

-

-The textRotation of the cell. -

+ +

The textRotation of the cell.

@@ -1036,22 +1013,20 @@ The textRotation of the cell.
Note: -

-The vertical cell allingment style must be one of the following: -

-
- :top
- :center
- :bottom
- :justify
- :distributed
+    
+

The vertical cell allingment style must be one of the following:

+ +
:top
+:center
+:bottom
+:justify
+:distributed
 
-

-The vertical alignment of the cell. -

+ +

The vertical alignment of the cell.

@@ -1106,9 +1081,8 @@ The vertical alignment of the cell.

-

-Indicate if the text of the cell should wrap -

+ +

Indicate if the text of the cell should wrap

@@ -1167,9 +1141,8 @@ Indicate if the text of the cell should wrap

-

-Serializes the cell alignment -

+ +

Serializes the cell alignment

@@ -1188,9 +1161,8 @@ Serializes the cell alignment — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -1238,7 +1210,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/CellProtection.html b/doc/Axlsx/CellProtection.html index 1d099ed0..ae7793ce 100644 --- a/doc/Axlsx/CellProtection.html +++ b/doc/Axlsx/CellProtection.html @@ -97,16 +97,14 @@
Note: -

-Using Styles#add_style is the recommended way to manage cell protection. -

+
+

Using Styles#add_style is the recommended way to manage cell protection.

-

-CellProtection stores information about locking or hiding cells in -spreadsheet. -

+ +

CellProtection stores information about locking or hiding cells in +spreadsheet.

@@ -145,9 +143,8 @@ spreadsheet. -

-specifies locking for cells that have the style containing this protection. -

+
+

specifies locking for cells that have the style containing this protection.

@@ -172,9 +169,8 @@ specifies locking for cells that have the style containing this protection. -

-specifies if the cells that have the style containing this protection. -

+
+

specifies if the cells that have the style containing this protection.

@@ -211,9 +207,8 @@ specifies if the cells that have the style containing this protection. -

-Creates a new CellProtection. -

+
+

Creates a new CellProtection.

@@ -235,9 +230,8 @@ Creates a new CellProtection. -

-Serializes the cell protection. -

+
+

Serializes the cell protection.

@@ -258,9 +252,8 @@ Serializes the cell protection.

-

-Creates a new CellProtection -

+ +

Creates a new CellProtection

@@ -281,9 +274,8 @@ Creates a new CellProtection — -

-a customizable set of options -

+
+

a customizable set of options

@@ -302,9 +294,8 @@ a customizable set of options - —

-value for hidden protection -

+ —
+

value for hidden protection

@@ -314,9 +305,8 @@ value for hidden protection - —

-value for locked protection -

+ —
+

value for locked protection

@@ -367,9 +357,8 @@ value for locked protection

-

-specifies locking for cells that have the style containing this protection -

+ +

specifies locking for cells that have the style containing this protection

@@ -424,9 +413,8 @@ specifies locking for cells that have the style containing this protection

-

-specifies if the cells that have the style containing this protection -

+ +

specifies if the cells that have the style containing this protection

@@ -485,9 +473,8 @@ specifies if the cells that have the style containing this protection

-

-Serializes the cell protection -

+ +

Serializes the cell protection

@@ -506,9 +493,8 @@ Serializes the cell protection — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -556,7 +542,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/CellStyle.html b/doc/Axlsx/CellStyle.html index bf6ede68..b66ceaf8 100644 --- a/doc/Axlsx/CellStyle.html +++ b/doc/Axlsx/CellStyle.html @@ -97,16 +97,14 @@
Note: -

-Using Styles#add_style is the recommended way to manage cell styling. -

+
+

Using Styles#add_style is the recommended way to manage cell styling.

-

-CellStyle defines named styles that reference defined formatting records -and can be used in your worksheet. -

+ +

CellStyle defines named styles that reference defined formatting records +and can be used in your worksheet.

@@ -145,9 +143,8 @@ and can be used in your worksheet. -

-The buildinId to use when this named style is applied. -

+
+

The buildinId to use when this named style is applied.

@@ -172,9 +169,8 @@ The buildinId to use when this named style is applied. -

-Indicates that the build in style reference has been customized. -

+
+

Indicates that the build in style reference has been customized.

@@ -199,10 +195,9 @@ Indicates that the build in style reference has been customized. -

-Determines if this named style should show in the list of styles when using -excel. -

+
+

Determines if this named style should show in the list of styles when using +excel.

@@ -227,10 +222,9 @@ excel. -

-Determines if this formatting is for an outline style, and what level of -the outline it is to be applied to. -

+
+

Determines if this formatting is for an outline style, and what level of +the outline it is to be applied to.

@@ -255,9 +249,8 @@ the outline it is to be applied to. -

-The name of this cell style. -

+
+

The name of this cell style.

@@ -282,9 +275,8 @@ The name of this cell style. -

-The formatting record id this named style utilizes. -

+
+

The formatting record id this named style utilizes.

@@ -321,9 +313,8 @@ The formatting record id this named style utilizes. -

-Creats a new CellStyle object. -

+
+

Creats a new CellStyle object.

@@ -345,9 +336,8 @@ Creats a new CellStyle object. -

-Serializes the cell style. -

+
+

Serializes the cell style.

@@ -368,9 +358,8 @@ Serializes the cell style.

-

-Creats a new CellStyle object -

+ +

Creats a new CellStyle object

@@ -391,9 +380,8 @@ Creats a new CellStyle object — -

-a customizable set of options -

+
+

a customizable set of options

@@ -507,9 +495,8 @@ a customizable set of options

-

-The buildinId to use when this named style is applied -

+ +

The buildinId to use when this named style is applied

@@ -571,9 +558,8 @@ The buildinId to use when this named style is applied

-

-Indicates that the build in style reference has been customized. -

+ +

Indicates that the build in style reference has been customized.

@@ -628,10 +614,9 @@ Indicates that the build in style reference has been customized.

-

-Determines if this named style should show in the list of styles when using -excel -

+ +

Determines if this named style should show in the list of styles when using +excel

@@ -686,10 +671,9 @@ excel

-

-Determines if this formatting is for an outline style, and what level of -the outline it is to be applied to. -

+ +

Determines if this formatting is for an outline style, and what level of +the outline it is to be applied to.

@@ -744,9 +728,8 @@ the outline it is to be applied to.

-

-The name of this cell style -

+ +

The name of this cell style

@@ -801,9 +784,8 @@ The name of this cell style

-

-The formatting record id this named style utilizes -

+ +

The formatting record id this named style utilizes

@@ -869,9 +851,8 @@ The formatting record id this named style utilizes

-

-Serializes the cell style -

+ +

Serializes the cell style

@@ -890,9 +871,8 @@ Serializes the cell style — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -940,7 +920,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Chart.html b/doc/Axlsx/Chart.html index d4fac7eb..2fe97954 100644 --- a/doc/Axlsx/Chart.html +++ b/doc/Axlsx/Chart.html @@ -97,16 +97,14 @@
Note: -

-Worksheet#add_chart is the recommended way to create charts for your -worksheets. -

+
+

Worksheet#add_chart is the recommended way to create charts for your +worksheets.

-

-A Chart is the superclass for specific charts -

+ +

A Chart is the superclass for specific charts

@@ -149,9 +147,8 @@ A Chart is the superclass for specific charts -

-A reference to the graphic frame that owns this chart. -

+
+

A reference to the graphic frame that owns this chart.

@@ -176,9 +173,8 @@ A reference to the graphic frame that owns this chart. -

-A collection of series objects that are applied to the chart. -

+
+

A collection of series objects that are applied to the chart.

@@ -203,9 +199,8 @@ A collection of series objects that are applied to the chart. -

-The type of series to use for this chart. -

+
+

The type of series to use for this chart.

@@ -230,9 +225,8 @@ The type of series to use for this chart. -

-Show the legend in the chart. -

+
+

Show the legend in the chart.

@@ -257,9 +251,8 @@ Show the legend in the chart. -

-The style for the chart. -

+
+

The style for the chart.

@@ -284,9 +277,8 @@ The style for the chart. -

-The title object for the chart. -

+
+

The title object for the chart.

@@ -311,9 +303,8 @@ The title object for the chart. -

-The 3D view properties for the chart. -

+
+

The 3D view properties for the chart.

@@ -348,9 +339,8 @@ The 3D view properties for the chart. -

-Adds a new series to the chart’s series collection. -

+
+

Adds a new series to the chart’s series collection.

@@ -372,10 +362,9 @@ Adds a new series to the chart’s series collection. -

-This is a short cut method to set the end anchor position If you need finer -granularity in positioning use graphic_frame.anchor.to.colOff / rowOff. -

+
+

This is a short cut method to set the end anchor position If you need finer +granularity in positioning use graphic_frame.anchor.to.colOff / rowOff.

@@ -397,10 +386,9 @@ granularity in positioning use graphic_frame.anchor.to.colOff / rowOff. -

-backwards compatibility to allow chart.to and chart.from access to anchor -markers. -

+
+

backwards compatibility to allow chart.to and chart.from access to anchor +markers.

@@ -422,9 +410,8 @@ markers. -

-The index of this chart in the workbooks charts collection. -

+
+

The index of this chart in the workbooks charts collection.

@@ -448,9 +435,8 @@ The index of this chart in the workbooks charts collection. -

-Creates a new chart object. -

+
+

Creates a new chart object.

@@ -472,9 +458,8 @@ Creates a new chart object. -

-The part name for this chart. -

+
+

The part name for this chart.

@@ -496,11 +481,10 @@ The part name for this chart. -

-This is a short cut method to set the start anchor position If you need +

+

This is a short cut method to set the start anchor position If you need finer granularity in positioning use graphic_frame.anchor.from.colOff / -rowOff. -

+rowOff.

@@ -522,10 +506,9 @@ rowOff. -

-backwards compatibility to allow chart.to and chart.from access to anchor -markers. -

+
+

backwards compatibility to allow chart.to and chart.from access to anchor +markers.

@@ -547,9 +530,8 @@ markers. -

-Chart Serialization serializes the chart. -

+
+

Chart Serialization serializes the chart.

@@ -570,9 +552,8 @@ Chart Serialization serializes the chart.

-

-Creates a new chart object -

+ +

Creates a new chart object

@@ -591,9 +572,8 @@ Creates a new chart object — -

-The frame that holds this chart. -

+
+

The frame that holds this chart.

@@ -610,9 +590,8 @@ The frame that holds this chart. — -

-a customizable set of options -

+
+

a customizable set of options

@@ -674,9 +653,8 @@ a customizable set of options — -

-the object that the method was called on -

+
+

the object that the method was called on

@@ -744,9 +722,8 @@ the object that the method was called on

-

-A reference to the graphic frame that owns this chart -

+ +

A reference to the graphic frame that owns this chart

@@ -801,9 +778,8 @@ A reference to the graphic frame that owns this chart

-

-A collection of series objects that are applied to the chart -

+ +

A collection of series objects that are applied to the chart

@@ -858,9 +834,8 @@ A collection of series objects that are applied to the chart

-

-The type of series to use for this chart. -

+ +

The type of series to use for this chart.

@@ -915,9 +890,8 @@ The type of series to use for this chart.

-

-Show the legend in the chart -

+ +

Show the legend in the chart

@@ -972,9 +946,8 @@ Show the legend in the chart

-

-The style for the chart. see ECMA Part 1 §21.2.2.196 -

+ +

The style for the chart. see ECMA Part 1 §21.2.2.196

@@ -1029,9 +1002,8 @@ The style for the chart. see ECMA Part 1 §21.2.2.196

-

-The title object for the chart. -

+ +

The title object for the chart.

@@ -1086,9 +1058,8 @@ The title object for the chart.

-

-The 3D view properties for the chart -

+ +

The 3D view properties for the chart

@@ -1134,9 +1105,8 @@ The 3D view properties for the chart

-

-Adds a new series to the chart’s series collection. -

+ +

Adds a new series to the chart’s series collection.

@@ -1197,10 +1167,9 @@ Adds a new series to the chart’s series collection.

-

-This is a short cut method to set the end anchor position If you need finer -granularity in positioning use graphic_frame.anchor.to.colOff / rowOff -

+ +

This is a short cut method to set the end anchor position If you need finer +granularity in positioning use graphic_frame.anchor.to.colOff / rowOff

@@ -1219,9 +1188,8 @@ granularity in positioning use graphic_frame.anchor.to.colOff / rowOff — -

-The column -

+
+

The column

@@ -1236,9 +1204,8 @@ The column — -

-The row -

+
+

The row

@@ -1295,16 +1262,14 @@ The row
Note: -

-This will be disconinued in version 2.0.0. please use the start_at method -

+
+

This will be disconinued in version 2.0.0. please use the start_at method

-

-backwards compatibility to allow chart.to and chart.from access to anchor -markers -

+ +

backwards compatibility to allow chart.to and chart.from access to anchor +markers

@@ -1343,9 +1308,8 @@ markers

-

-The index of this chart in the workbooks charts collection -

+ +

The index of this chart in the workbooks charts collection

@@ -1397,9 +1361,8 @@ The index of this chart in the workbooks charts collection

-

-The part name for this chart -

+ +

The part name for this chart

@@ -1451,11 +1414,10 @@ The part name for this chart

-

-This is a short cut method to set the start anchor position If you need + +

This is a short cut method to set the start anchor position If you need finer granularity in positioning use graphic_frame.anchor.from.colOff / -rowOff -

+rowOff

@@ -1474,9 +1436,8 @@ rowOff — -

-The column -

+
+

The column

@@ -1491,9 +1452,8 @@ The column — -

-The row -

+
+

The row

@@ -1550,16 +1510,14 @@ The row
Note: -

-This will be disconinued in version 2.0.0. Please use the end_at method -

+
+

This will be disconinued in version 2.0.0. Please use the end_at method

-

-backwards compatibility to allow chart.to and chart.from access to anchor -markers -

+ +

backwards compatibility to allow chart.to and chart.from access to anchor +markers

@@ -1598,9 +1556,8 @@ markers

-

-Chart Serialization serializes the chart -

+ +

Chart Serialization serializes the chart

@@ -1675,7 +1632,7 @@ Chart Serialization serializes the chart
diff --git a/doc/Axlsx/Color.html b/doc/Axlsx/Color.html index b0149d6c..4229122e 100644 --- a/doc/Axlsx/Color.html +++ b/doc/Axlsx/Color.html @@ -94,9 +94,8 @@

Overview

-

-The color class represents a color used for borders, fills an fonts -

+ +

The color class represents a color used for borders, fills an fonts

@@ -128,9 +127,8 @@ The color class represents a color used for borders, fills an fonts -

-Determines if the color is system color dependant. -

+
+

Determines if the color is system color dependant.

@@ -155,9 +153,8 @@ Determines if the color is system color dependant. -

-The color as defined in rgb terms. -

+
+

The color as defined in rgb terms.

@@ -182,9 +179,8 @@ The color as defined in rgb terms. -

-The tint value. -

+
+

The tint value.

@@ -221,9 +217,8 @@ The tint value. -

-Creates a new Color object. -

+
+

Creates a new Color object.

@@ -245,9 +240,8 @@ Creates a new Color object. -

-Serializes the color. -

+
+

Serializes the color.

@@ -268,9 +262,8 @@ Serializes the color.

-

-Creates a new Color object -

+ +

Creates a new Color object

@@ -291,9 +284,8 @@ Creates a new Color object — -

-a customizable set of options -

+
+

a customizable set of options

@@ -382,9 +374,8 @@ a customizable set of options

-

-Determines if the color is system color dependant -

+ +

Determines if the color is system color dependant

@@ -442,16 +433,14 @@ Determines if the color is system color dependant
Note: -

-rgb colors need to conform to ST_UnsignedIntHex. That basically means put -‘FF’ before you color -

+
+

rgb colors need to conform to ST_UnsignedIntHex. That basically means put +‘FF’ before you color

-

-The color as defined in rgb terms. -

+ +

The color as defined in rgb terms.

@@ -461,9 +450,8 @@ The color as defined in rgb terms.

Examples:

-

-rgb colors -

+

+

rgb colors

"FF000000" is black
 "FFFFFFFF" is white
@@ -522,15 +510,13 @@ rgb colors
     
   
Note: -

-valid values are between -1.0 and 1.0 -

+
+

valid values are between -1.0 and 1.0

-

-The tint value. -

+ +

The tint value.

@@ -589,9 +575,8 @@ The tint value.

-

-Serializes the color -

+ +

Serializes the color

@@ -610,9 +595,8 @@ Serializes the color — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -656,7 +640,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/ContentType.html b/doc/Axlsx/ContentType.html index 1ee32909..aad3a085 100644 --- a/doc/Axlsx/ContentType.html +++ b/doc/Axlsx/ContentType.html @@ -96,10 +96,9 @@

Overview

-

-ContentTypes used in the package. This is automatcially managed by the -package package. -

+ +

ContentTypes used in the package. This is automatcially managed by the +package package.

@@ -150,9 +149,8 @@ package package. -

-A new instance of ContentType. -

+
+

A new instance of ContentType.

@@ -174,9 +172,8 @@ A new instance of ContentType. -

-Generates the xml document for [Content_Types].xml. -

+
+

Generates the xml document for [Content_Types].xml.

@@ -202,9 +199,8 @@ Generates the xml document for [Content_Types].xml.

-

-A new instance of ContentType -

+ +

A new instance of ContentType

@@ -260,9 +256,8 @@ A new instance of ContentType

-

-Generates the xml document for [Content_Types].xml -

+ +

Generates the xml document for [Content_Types].xml

@@ -280,9 +275,8 @@ Generates the xml document for [Content_Types].xml — -

-The document as a string. -

+
+

The document as a string.

@@ -326,7 +320,7 @@ The document as a string.
diff --git a/doc/Axlsx/Core.html b/doc/Axlsx/Core.html index f489141f..69314818 100644 --- a/doc/Axlsx/Core.html +++ b/doc/Axlsx/Core.html @@ -97,15 +97,13 @@
Note: -

-Packages manage their own core object. -

+
+

Packages manage their own core object.

-

-The core object for the package. -

+ +

The core object for the package.

@@ -144,9 +142,8 @@ The core object for the package. -

-The author of the document. -

+
+

The author of the document.

@@ -183,9 +180,8 @@ The author of the document. -

-Creates a new Core object. -

+
+

Creates a new Core object.

@@ -207,9 +203,8 @@ Creates a new Core object. -

-Serializes the core object. -

+
+

Serializes the core object.

@@ -230,9 +225,8 @@ Serializes the core object.

-

-Creates a new Core object. -

+ +

Creates a new Core object.

@@ -253,9 +247,8 @@ Creates a new Core object. — -

-a customizable set of options -

+
+

a customizable set of options

@@ -320,9 +313,8 @@ a customizable set of options

-

-The author of the document. By default this is ‘axlsx’ -

+ +

The author of the document. By default this is ‘axlsx’

@@ -381,10 +373,9 @@ The author of the document. By default this is ‘axlsx’

-

-Serializes the core object. The created dcterms item is set to the current -time when this method is called. -

+ +

Serializes the core object. The created dcterms item is set to the current +time when this method is called.

@@ -456,7 +447,7 @@ time when this method is called.
diff --git a/doc/Axlsx/DataTypeValidator.html b/doc/Axlsx/DataTypeValidator.html index d3698abf..b120e469 100644 --- a/doc/Axlsx/DataTypeValidator.html +++ b/doc/Axlsx/DataTypeValidator.html @@ -94,11 +94,10 @@

Overview

-

-Validate that the class of the value provided is either an instance or the + +

Validate that the class of the value provided is either an instance or the class of the allowed types and that any specified additional validation -returns true. -

+returns true.

@@ -135,9 +134,8 @@ returns true. -

-Perform validation. -

+
+

Perform validation.

@@ -161,9 +159,8 @@ Perform validation.

-

-Perform validation -

+ +

Perform validation

@@ -182,9 +179,8 @@ Perform validation — -

-The name of what is being validated. This is included in the error message -

+
+

The name of what is being validated. This is included in the error message

@@ -199,9 +195,8 @@ The name of what is being validated. This is included in the error message — -

-A single class or array of classes that the value is validated against. -

+
+

A single class or array of classes that the value is validated against.

@@ -218,9 +213,8 @@ A single class or array of classes that the value is validated against. — -

-Any block that must evaluate to true for the value to be valid -

+
+

Any block that must evaluate to true for the value to be valid

@@ -238,9 +232,8 @@ Any block that must evaluate to true for the value to be valid — -

-true if validation succeeds. -

+
+

true if validation succeeds.

@@ -257,10 +250,9 @@ true if validation succeeds. — -

-Raised if the class of the value provided is not in the specified array of -types or the block passed returns false -

+
+

Raised if the class of the value provided is not in the specified array of +types or the block passed returns false

@@ -315,7 +307,7 @@ types or the block passed returns false
diff --git a/doc/Axlsx/Default.html b/doc/Axlsx/Default.html index ad41bf7c..20e7aab2 100644 --- a/doc/Axlsx/Default.html +++ b/doc/Axlsx/Default.html @@ -94,10 +94,9 @@

Overview

-

-An default content part. These parts are automatically created by for you -based on the content of your package. -

+ +

An default content part. These parts are automatically created by for you +based on the content of your package.

@@ -129,9 +128,8 @@ based on the content of your package. -

-The type of content. -

+
+

The type of content.

@@ -156,9 +154,8 @@ The type of content. -

-The extension of the content type. -

+
+

The extension of the content type.

@@ -195,9 +192,8 @@ The extension of the content type. -

-Creates a new Default object. -

+
+

Creates a new Default object.

@@ -219,9 +215,8 @@ Creates a new Default object. -

-Serializes the object to xml. -

+
+

Serializes the object to xml.

@@ -242,9 +237,8 @@ Serializes the object to xml.

-

-Creates a new Default object -

+ +

Creates a new Default object

@@ -265,9 +259,8 @@ Creates a new Default object — -

-a customizable set of options -

+
+

a customizable set of options

@@ -312,10 +305,9 @@ a customizable set of options — -

-An argument error is raised if both Extension and ContentType are not -specified. -

+
+

An argument error is raised if both Extension and ContentType are not +specified.

@@ -367,9 +359,8 @@ specified.

-

-The type of content. -

+ +

The type of content.

@@ -424,9 +415,8 @@ The type of content.

-

-The extension of the content type. -

+ +

The extension of the content type.

@@ -485,9 +475,8 @@ The extension of the content type.

-

-Serializes the object to xml -

+ +

Serializes the object to xml

@@ -506,9 +495,8 @@ Serializes the object to xml — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -556,7 +544,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Drawing.html b/doc/Axlsx/Drawing.html index edabb5ed..b6e3ee72 100644 --- a/doc/Axlsx/Drawing.html +++ b/doc/Axlsx/Drawing.html @@ -97,19 +97,17 @@
Note: -

-The recommended way to manage drawings is to use the Worksheet.add_chart -method. -

+
+

The recommended way to manage drawings is to use the Worksheet.add_chart +method.

-

-A Drawing is a canvas for charts. Each worksheet has a single drawing that + +

A Drawing is a canvas for charts. Each worksheet has a single drawing that manages anchors. The anchors reference the charts via graphical frames. This is not a trivial relationship so please do follow the advice in the -note. see README for an example of how to create a chart. -

+note. see README for an example of how to create a chart.

@@ -150,10 +148,9 @@ note. see README for an example of how to create a chart. -

-A collection of anchors for this drawing only TwoCellAnchors are supported -in this version. -

+
+

A collection of anchors for this drawing only TwoCellAnchors are supported +in this version.

@@ -178,9 +175,8 @@ in this version. -

-The worksheet that owns the drawing. -

+
+

The worksheet that owns the drawing.

@@ -215,9 +211,8 @@ The worksheet that owns the drawing. -

-Adds a chart to the drawing. -

+
+

Adds a chart to the drawing.

@@ -239,9 +234,8 @@ Adds a chart to the drawing. -

-Adds an image to the chart. -

+
+

Adds an image to the chart.

@@ -263,9 +257,8 @@ Adds an image to the chart. -

-An array of charts that are associated with this drawing’s anchors. -

+
+

An array of charts that are associated with this drawing’s anchors.

@@ -287,10 +280,9 @@ An array of charts that are associated with this drawing’s anchors. -

-An array of image objects that are associated with this drawing’s -anchors. -

+
+

An array of image objects that are associated with this drawing’s +anchors.

@@ -312,10 +304,8 @@ anchors. -

-The index of this drawing in the owning workbooks’s drawings -collection. -

+
+

The index of this drawing in the owning workbooks’s drawings collection.

@@ -339,9 +329,8 @@ collection. -

-Creates a new Drawing object. -

+
+

Creates a new Drawing object.

@@ -363,9 +352,8 @@ Creates a new Drawing object. -

-The part name for this drawing. -

+
+

The part name for this drawing.

@@ -387,9 +375,8 @@ The part name for this drawing. -

-The drawing’s relationships. -

+
+

The drawing’s relationships.

@@ -411,9 +398,8 @@ The drawing’s relationships. -

-The relational part name for this drawing. -

+
+

The relational part name for this drawing.

@@ -435,9 +421,8 @@ The relational part name for this drawing. -

-The relation reference id for this drawing. -

+
+

The relation reference id for this drawing.

@@ -459,9 +444,8 @@ The relation reference id for this drawing. -

-Serializes the drawing. -

+
+

Serializes the drawing.

@@ -482,9 +466,8 @@ Serializes the drawing.

-

-Creates a new Drawing object -

+ +

Creates a new Drawing object

@@ -503,9 +486,8 @@ Creates a new Drawing object — -

-The worksheet that owns this drawing -

+
+

The worksheet that owns this drawing

@@ -558,10 +540,9 @@ The worksheet that owns this drawing

-

-A collection of anchors for this drawing only TwoCellAnchors are supported -in this version -

+ +

A collection of anchors for this drawing only TwoCellAnchors are supported +in this version

@@ -616,9 +597,8 @@ in this version

-

-The worksheet that owns the drawing -

+ +

The worksheet that owns the drawing

@@ -680,16 +660,14 @@ The worksheet that owns the drawing
Note: -

-The recommended way to manage charts is to use Worksheet.add_chart. Please -refer to that method for documentation. -

+
+

The recommended way to manage charts is to use Worksheet.add_chart. Please +refer to that method for documentation.

-

-Adds a chart to the drawing. -

+ +

Adds a chart to the drawing.

@@ -740,16 +718,14 @@ Adds a chart to the drawing.
Note: -

-The recommended way to manage images is to use Worksheet.add_image. Please -refer to that method for documentation. -

+
+

The recommended way to manage images is to use Worksheet.add_image. Please +refer to that method for documentation.

-

-Adds an image to the chart -

+ +

Adds an image to the chart

@@ -797,9 +773,8 @@ Adds an image to the chart

-

-An array of charts that are associated with this drawing’s anchors -

+ +

An array of charts that are associated with this drawing’s anchors

@@ -853,10 +828,8 @@ An array of charts that are associated with this drawing’s anchors

-

-An array of image objects that are associated with this drawing’s -anchors -

+ +

An array of image objects that are associated with this drawing’s anchors

@@ -910,10 +883,8 @@ anchors

-

-The index of this drawing in the owning workbooks’s drawings -collection. -

+ +

The index of this drawing in the owning workbooks’s drawings collection.

@@ -965,9 +936,8 @@ collection.

-

-The part name for this drawing -

+ +

The part name for this drawing

@@ -1019,9 +989,8 @@ The part name for this drawing

-

-The drawing’s relationships. -

+ +

The drawing’s relationships.

@@ -1087,9 +1056,8 @@ The drawing’s relationships.

-

-The relational part name for this drawing -

+ +

The relational part name for this drawing

@@ -1141,9 +1109,8 @@ The relational part name for this drawing

-

-The relation reference id for this drawing -

+ +

The relation reference id for this drawing

@@ -1195,9 +1162,8 @@ The relation reference id for this drawing

-

-Serializes the drawing -

+ +

Serializes the drawing

@@ -1255,7 +1221,7 @@ Serializes the drawing
diff --git a/doc/Axlsx/Fill.html b/doc/Axlsx/Fill.html index 6f6b98b0..d2ae770c 100644 --- a/doc/Axlsx/Fill.html +++ b/doc/Axlsx/Fill.html @@ -97,17 +97,15 @@
Note: -

-The recommended way to manage styles in your workbook is to use -Styles#add_style. -

+
+

The recommended way to manage styles in your workbook is to use +Styles#add_style.

-

-The Fill is a formatting object that manages the background color, and -pattern for cells. -

+ +

The Fill is a formatting object that manages the background color, and +pattern for cells.

@@ -150,9 +148,8 @@ pattern for cells. -

-The type of fill. -

+
+

The type of fill.

@@ -189,9 +186,8 @@ The type of fill. -

-Creates a new Fill object. -

+
+

Creates a new Fill object.

@@ -213,9 +209,8 @@ Creates a new Fill object. -

-Serializes the fill. -

+
+

Serializes the fill.

@@ -236,9 +231,8 @@ Serializes the fill.

-

-Creates a new Fill object -

+ +

Creates a new Fill object

@@ -271,9 +265,8 @@ Creates a new Fill object — -

-if the fill_type parameter is not a PatternFill or a GradientFill instance -

+
+

if the fill_type parameter is not a PatternFill or a GradientFill instance

@@ -319,9 +312,8 @@ if the fill_type parameter is not a PatternFill or a GradientFill instance

-

-The type of fill -

+ +

The type of fill

@@ -380,9 +372,8 @@ The type of fill

-

-Serializes the fill -

+ +

Serializes the fill

@@ -401,9 +392,8 @@ Serializes the fill — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -451,7 +441,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Font.html b/doc/Axlsx/Font.html index df03d441..efc6b488 100644 --- a/doc/Axlsx/Font.html +++ b/doc/Axlsx/Font.html @@ -97,15 +97,13 @@
Note: -

-The recommended way to manage fonts, and other styles is Styles#add_style -

+
+

The recommended way to manage fonts, and other styles is Styles#add_style

-

-The Font class details a font instance for use in styling cells. -

+ +

The Font class details a font instance for use in styling cells.

@@ -144,9 +142,8 @@ The Font class details a font instance for use in styling cells. -

-Indicates if the font should be rendered in bold. -

+
+

Indicates if the font should be rendered in bold.

@@ -171,9 +168,8 @@ Indicates if the font should be rendered in bold. -

-The charset of the font. -

+
+

The charset of the font.

@@ -198,9 +194,8 @@ The charset of the font. -

-The color of the font. -

+
+

The color of the font.

@@ -225,9 +220,8 @@ The color of the font. -

-Indicates if the font should be condensed. -

+
+

Indicates if the font should be condensed.

@@ -252,9 +246,8 @@ Indicates if the font should be condensed. -

-The font’s extend property. -

+
+

The font’s extend property.

@@ -279,9 +272,8 @@ The font’s extend property. -

-The font’s family. -

+
+

The font’s family.

@@ -306,9 +298,8 @@ The font’s family. -

-Indicates if the font should be rendered italicized. -

+
+

Indicates if the font should be rendered italicized.

@@ -333,9 +324,8 @@ Indicates if the font should be rendered italicized. -

-The name of the font. -

+
+

The name of the font.

@@ -360,9 +350,8 @@ The name of the font. -

-Indicates if the font should be rendered with an outline. -

+
+

Indicates if the font should be rendered with an outline.

@@ -387,9 +376,8 @@ Indicates if the font should be rendered with an outline. -

-Indicates if the font should be rendered with a shadow. -

+
+

Indicates if the font should be rendered with a shadow.

@@ -414,9 +402,8 @@ Indicates if the font should be rendered with a shadow. -

-Indicates if the font should be rendered with a strikthrough. -

+
+

Indicates if the font should be rendered with a strikthrough.

@@ -441,9 +428,8 @@ Indicates if the font should be rendered with a strikthrough. -

-The size of the font. -

+
+

The size of the font.

@@ -480,9 +466,8 @@ The size of the font. -

-Creates a new Font. -

+
+

Creates a new Font.

@@ -504,9 +489,8 @@ Creates a new Font. -

-Serializes the fill. -

+
+

Serializes the fill.

@@ -527,9 +511,8 @@ Serializes the fill.

-

-Creates a new Font -

+ +

Creates a new Font

@@ -550,9 +533,8 @@ Creates a new Font — -

-a customizable set of options -

+
+

a customizable set of options

@@ -729,9 +711,8 @@ a customizable set of options

-

-Indicates if the font should be rendered in bold -

+ +

Indicates if the font should be rendered in bold

@@ -789,37 +770,35 @@ Indicates if the font should be rendered in bold
Note: -

-The following values are defined in the OOXML specification and are OS -dependant values -

-
- 0   ANSI_CHARSET
- 1   DEFAULT_CHARSET
- 2   SYMBOL_CHARSET
- 77  MAC_CHARSET
- 128 SHIFTJIS_CHARSET
- 129 HANGUL_CHARSET
- 130 JOHAB_CHARSET
- 134 GB2312_CHARSET
- 136 CHINESEBIG5_CHARSET
- 161 GREEK_CHARSET
- 162 TURKISH_CHARSET
- 163 VIETNAMESE_CHARSET
- 177 HEBREW_CHARSET
- 178 ARABIC_CHARSET
- 186 BALTIC_CHARSET
- 204 RUSSIAN_CHARSET
- 222 THAI_CHARSET
- 238 EASTEUROPE_CHARSET
- 255 OEM_CHARSET
+    
+

The following values are defined in the OOXML specification and are OS +dependant values

+ +
0   ANSI_CHARSET
+1   DEFAULT_CHARSET
+2   SYMBOL_CHARSET
+77  MAC_CHARSET
+128 SHIFTJIS_CHARSET
+129 HANGUL_CHARSET
+130 JOHAB_CHARSET
+134 GB2312_CHARSET
+136 CHINESEBIG5_CHARSET
+161 GREEK_CHARSET
+162 TURKISH_CHARSET
+163 VIETNAMESE_CHARSET
+177 HEBREW_CHARSET
+178 ARABIC_CHARSET
+186 BALTIC_CHARSET
+204 RUSSIAN_CHARSET
+222 THAI_CHARSET
+238 EASTEUROPE_CHARSET
+255 OEM_CHARSET
 
-

-The charset of the font -

+ +

The charset of the font

@@ -874,9 +853,8 @@ The charset of the font

-

-The color of the font -

+ +

The color of the font

@@ -931,9 +909,8 @@ The color of the font

-

-Indicates if the font should be condensed -

+ +

Indicates if the font should be condensed

@@ -988,9 +965,8 @@ Indicates if the font should be condensed

-

-The font’s extend property -

+ +

The font’s extend property

@@ -1048,24 +1024,22 @@ The font’s extend property
Note: -

-The following are defined OOXML specification -

-
- 0 Not applicable.
- 1 Roman
- 2 Swiss
- 3 Modern
- 4 Script
- 5 Decorative
- 6..14 Reserved for future use
+    
+

The following are defined OOXML specification

+ +
0 Not applicable.
+1 Roman
+2 Swiss
+3 Modern
+4 Script
+5 Decorative
+6..14 Reserved for future use
 
-

-The font’s family -

+ +

The font’s family

@@ -1120,9 +1094,8 @@ The font’s family

-

-Indicates if the font should be rendered italicized -

+ +

Indicates if the font should be rendered italicized

@@ -1177,9 +1150,8 @@ Indicates if the font should be rendered italicized

-

-The name of the font -

+ +

The name of the font

@@ -1234,9 +1206,8 @@ The name of the font

-

-Indicates if the font should be rendered with an outline -

+ +

Indicates if the font should be rendered with an outline

@@ -1291,9 +1262,8 @@ Indicates if the font should be rendered with an outline

-

-Indicates if the font should be rendered with a shadow -

+ +

Indicates if the font should be rendered with a shadow

@@ -1348,9 +1318,8 @@ Indicates if the font should be rendered with a shadow

-

-Indicates if the font should be rendered with a strikthrough -

+ +

Indicates if the font should be rendered with a strikthrough

@@ -1405,9 +1374,8 @@ Indicates if the font should be rendered with a strikthrough

-

-The size of the font. -

+ +

The size of the font.

@@ -1466,9 +1434,8 @@ The size of the font.

-

-Serializes the fill -

+ +

Serializes the fill

@@ -1487,9 +1454,8 @@ Serializes the fill — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -1545,7 +1511,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/GradientFill.html b/doc/Axlsx/GradientFill.html index 35d21972..30fa6143 100644 --- a/doc/Axlsx/GradientFill.html +++ b/doc/Axlsx/GradientFill.html @@ -94,9 +94,8 @@

Overview

-

-A GradientFill defines the color and positioning for gradiant cell fill. -

+ +

A GradientFill defines the color and positioning for gradiant cell fill.

@@ -135,9 +134,8 @@ A GradientFill defines the color and positioning for gradiant cell fill. -

-Percentage format bottom. -

+
+

Percentage format bottom.

@@ -162,9 +160,8 @@ Percentage format bottom. -

-Angle of the linear gradient. -

+
+

Angle of the linear gradient.

@@ -189,9 +186,8 @@ Angle of the linear gradient. -

-Percentage format left. -

+
+

Percentage format left.

@@ -216,9 +212,8 @@ Percentage format left. -

-Percentage format right. -

+
+

Percentage format right.

@@ -243,9 +238,8 @@ Percentage format right. -

-Collection of stop objects. -

+
+

Collection of stop objects.

@@ -270,9 +264,8 @@ Collection of stop objects. -

-Percentage format top. -

+
+

Percentage format top.

@@ -297,9 +290,8 @@ Percentage format top. -

-The type of gradient. -

+
+

The type of gradient.

@@ -336,9 +328,8 @@ The type of gradient. -

-Creates a new GradientFill object. -

+
+

Creates a new GradientFill object.

@@ -360,9 +351,8 @@ Creates a new GradientFill object. -

-Serializes the gradientFill. -

+
+

Serializes the gradientFill.

@@ -383,9 +373,8 @@ Serializes the gradientFill.

-

-Creates a new GradientFill object -

+ +

Creates a new GradientFill object

@@ -406,9 +395,8 @@ Creates a new GradientFill object — -

-a customizable set of options -

+
+

a customizable set of options

@@ -526,9 +514,8 @@ a customizable set of options

-

-Percentage format bottom -

+ +

Percentage format bottom

@@ -583,9 +570,8 @@ Percentage format bottom

-

-Angle of the linear gradient -

+ +

Angle of the linear gradient

@@ -640,9 +626,8 @@ Angle of the linear gradient

-

-Percentage format left -

+ +

Percentage format left

@@ -697,9 +682,8 @@ Percentage format left

-

-Percentage format right -

+ +

Percentage format right

@@ -754,9 +738,8 @@ Percentage format right

-

-Collection of stop objects -

+ +

Collection of stop objects

@@ -811,9 +794,8 @@ Collection of stop objects

-

-Percentage format top -

+ +

Percentage format top

@@ -871,19 +853,17 @@ Percentage format top
Note: -

-valid options are -

-
- :linear
- :path
+    
+

valid options are

+ +
:linear
+:path
 
-

-The type of gradient. -

+ +

The type of gradient.

@@ -942,9 +922,8 @@ The type of gradient.

-

-Serializes the gradientFill -

+ +

Serializes the gradientFill

@@ -963,9 +942,8 @@ Serializes the gradientFill — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -1017,7 +995,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/GradientStop.html b/doc/Axlsx/GradientStop.html index b1067f0e..c767a85e 100644 --- a/doc/Axlsx/GradientStop.html +++ b/doc/Axlsx/GradientStop.html @@ -94,9 +94,8 @@

Overview

-

-The GradientStop object represents a color point in a gradient. -

+ +

The GradientStop object represents a color point in a gradient.

@@ -135,9 +134,8 @@ The GradientStop object represents a color point in a gradient. -

-The color for this gradient stop. -

+
+

The color for this gradient stop.

@@ -162,9 +160,8 @@ The color for this gradient stop. -

-The position of the color. -

+
+

The position of the color.

@@ -201,9 +198,8 @@ The position of the color. -

-Creates a new GradientStop object. -

+
+

Creates a new GradientStop object.

@@ -225,9 +221,8 @@ Creates a new GradientStop object. -

-Serializes the gradientStop. -

+
+

Serializes the gradientStop.

@@ -248,9 +243,8 @@ Serializes the gradientStop.

-

-Creates a new GradientStop object -

+ +

Creates a new GradientStop object

@@ -325,9 +319,8 @@ Creates a new GradientStop object

-

-The color for this gradient stop -

+ +

The color for this gradient stop

@@ -389,9 +382,8 @@ The color for this gradient stop

-

-The position of the color -

+ +

The position of the color

@@ -450,9 +442,8 @@ The position of the color

-

-Serializes the gradientStop -

+ +

Serializes the gradientStop

@@ -471,9 +462,8 @@ Serializes the gradientStop — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -517,7 +507,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/GraphicFrame.html b/doc/Axlsx/GraphicFrame.html index 71ff8747..60a775d8 100644 --- a/doc/Axlsx/GraphicFrame.html +++ b/doc/Axlsx/GraphicFrame.html @@ -97,15 +97,13 @@
Note: -

-The recommended way to manage charts is Worksheet#add_chart -

+
+

The recommended way to manage charts is Worksheet#add_chart

-

-A graphic frame defines a container for a chart object -

+ +

A graphic frame defines a container for a chart object

@@ -144,9 +142,8 @@ A graphic frame defines a container for a chart object -

-A anchor that holds this frame. -

+
+

A anchor that holds this frame.

@@ -171,9 +168,8 @@ A anchor that holds this frame. -

-A reference to the chart object associated with this frame. -

+
+

A reference to the chart object associated with this frame.

@@ -210,9 +206,8 @@ A reference to the chart object associated with this frame. -

-Creates a new GraphicFrame object. -

+
+

Creates a new GraphicFrame object.

@@ -234,9 +229,8 @@ Creates a new GraphicFrame object. -

-The relationship id for this graphic. -

+
+

The relationship id for this graphic.

@@ -258,9 +252,8 @@ The relationship id for this graphic. -

-Serializes the graphic frame. -

+
+

Serializes the graphic frame.

@@ -281,9 +274,8 @@ Serializes the graphic frame.

-

-Creates a new GraphicFrame object -

+ +

Creates a new GraphicFrame object

@@ -360,9 +352,8 @@ Creates a new GraphicFrame object

-

-A anchor that holds this frame -

+ +

A anchor that holds this frame

@@ -417,9 +408,8 @@ A anchor that holds this frame

-

-A reference to the chart object associated with this frame -

+ +

A reference to the chart object associated with this frame

@@ -478,9 +468,8 @@ A reference to the chart object associated with this frame

-

-The relationship id for this graphic -

+ +

The relationship id for this graphic

@@ -532,9 +521,8 @@ The relationship id for this graphic

-

-Serializes the graphic frame -

+ +

Serializes the graphic frame

@@ -553,9 +541,8 @@ Serializes the graphic frame — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -633,7 +620,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Line3DChart.html b/doc/Axlsx/Line3DChart.html index 5c05b8bd..a0995552 100644 --- a/doc/Axlsx/Line3DChart.html +++ b/doc/Axlsx/Line3DChart.html @@ -96,10 +96,9 @@

Overview

-

-The Line3DChart is a three dimentional line chart (who would have guessed?) -that you can add to your worksheet. -

+ +

The Line3DChart is a three dimentional line chart (who would have guessed?) +that you can add to your worksheet.

@@ -109,9 +108,8 @@ that you can add to your worksheet.

Examples:

-

-Creating a chart -

+

+

Creating a chart

# This example creates a line in a single sheet.
 require "rubygems" # if that is your preferred way to manage gems!
@@ -151,9 +149,8 @@ Creating a chart
         
GAP_AMOUNT_PERCENT =
-

-validation regex for gap amount percent -

+ +

validation regex for gap amount percent

@@ -196,9 +193,8 @@ validation regex for gap amount percent -

-the category axis. -

+
+

the category axis.

@@ -223,10 +219,9 @@ the category axis. -

-space between bar or column clusters, as a percentage of the bar or column -width. -

+
+

space between bar or column clusters, as a percentage of the bar or column +width.

@@ -251,9 +246,8 @@ width. -

-grouping for a column, line, or area chart. -

+
+

grouping for a column, line, or area chart.

@@ -278,9 +272,8 @@ grouping for a column, line, or area chart. -

-the category axis. -

+
+

the category axis.

@@ -305,9 +298,8 @@ the category axis. -

-the category axis. -

+
+

the category axis.

@@ -352,9 +344,8 @@ the category axis. -

-Creates a new line chart object. -

+
+

Creates a new line chart object.

@@ -376,9 +367,8 @@ Creates a new line chart object. -

-Serializes the bar chart. -

+
+

Serializes the bar chart.

@@ -409,9 +399,8 @@ Serializes the bar chart.

-

-Creates a new line chart object -

+ +

Creates a new line chart object

@@ -430,9 +419,8 @@ Creates a new line chart object — -

-The workbook that owns this chart. -

+
+

The workbook that owns this chart.

@@ -449,9 +437,8 @@ The workbook that owns this chart. — -

-a customizable set of options -

+
+

a customizable set of options

@@ -628,9 +615,8 @@ a customizable set of options

-

-the category axis -

+ +

the category axis

@@ -685,10 +671,9 @@ the category axis

-

-space between bar or column clusters, as a percentage of the bar or column -width. -

+ +

space between bar or column clusters, as a percentage of the bar or column +width.

@@ -743,10 +728,9 @@ width.

-

-grouping for a column, line, or area chart. must be one of -[:percentStacked, :clustered, :standard, :stacked] -

+ +

grouping for a column, line, or area chart. must be one of +[:percentStacked, :clustered, :standard, :stacked]

@@ -801,9 +785,8 @@ grouping for a column, line, or area chart. must be one of

-

-the category axis -

+ +

the category axis

@@ -858,9 +841,8 @@ the category axis

-

-the category axis -

+ +

the category axis

@@ -919,9 +901,8 @@ the category axis

-

-Serializes the bar chart -

+ +

Serializes the bar chart

@@ -995,7 +976,7 @@ Serializes the bar chart
diff --git a/doc/Axlsx/LineSeries.html b/doc/Axlsx/LineSeries.html index d9bfc986..f45ede72 100644 --- a/doc/Axlsx/LineSeries.html +++ b/doc/Axlsx/LineSeries.html @@ -99,15 +99,13 @@
Note: -

-The recommended way to manage series is to use Chart#add_series -

+
+

The recommended way to manage series is to use Chart#add_series

-

-A LineSeries defines the title, data and labels for line charts -

+ +

A LineSeries defines the title, data and labels for line charts

@@ -152,9 +150,8 @@ A LineSeries defines the title, data and labels for line charts -

-The data for this series. -

+
+

The data for this series.

@@ -179,9 +176,8 @@ The data for this series. -

-The labels for this series. -

+
+

The labels for this series.

@@ -226,9 +222,8 @@ The labels for this series. -

-Creates a new series. -

+
+

Creates a new series.

@@ -250,9 +245,8 @@ Creates a new series. -

-Serializes the series. -

+
+

Serializes the series.

@@ -283,9 +277,8 @@ Serializes the series.

-

-Creates a new series -

+ +

Creates a new series

@@ -317,9 +310,8 @@ Creates a new series — -

-a customizable set of options -

+
+

a customizable set of options

@@ -401,9 +393,8 @@ a customizable set of options

-

-The data for this series. -

+ +

The data for this series.

@@ -458,9 +449,8 @@ The data for this series.

-

-The labels for this series. -

+ +

The labels for this series.

@@ -519,9 +509,8 @@ The labels for this series.

-

-Serializes the series -

+ +

Serializes the series

@@ -540,9 +529,8 @@ Serializes the series — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -596,7 +584,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Marker.html b/doc/Axlsx/Marker.html index 39e34ed6..9ae65689 100644 --- a/doc/Axlsx/Marker.html +++ b/doc/Axlsx/Marker.html @@ -97,17 +97,15 @@
Note: -

-The recommended way to manage markers is Worksheet#add_chart Markers are -created for a two cell anchor based on the :start and :end options. -

+
+

The recommended way to manage markers is Worksheet#add_chart Markers are +created for a two cell anchor based on the :start and :end options.

-

-The Marker class defines a point in the worksheet that drawing anchors -attach to. -

+ +

The Marker class defines a point in the worksheet that drawing anchors +attach to.

@@ -146,9 +144,8 @@ attach to. -

-The column this marker anchors to. -

+
+

The column this marker anchors to.

@@ -173,9 +170,8 @@ The column this marker anchors to. -

-The offset distance from this marker’s column. -

+
+

The offset distance from this marker’s column.

@@ -200,9 +196,8 @@ The offset distance from this marker’s column. -

-The row this marker anchors to. -

+
+

The row this marker anchors to.

@@ -227,9 +222,8 @@ The row this marker anchors to. -

-The offset distance from this marker’s row. -

+
+

The offset distance from this marker’s row.

@@ -264,9 +258,8 @@ The offset distance from this marker’s row. -

-shortcut to set the column, row position for this marker. -

+
+

shortcut to set the column, row position for this marker.

@@ -290,9 +283,8 @@ shortcut to set the column, row position for this marker. -

-Creates a new Marker object. -

+
+

Creates a new Marker object.

@@ -314,9 +306,8 @@ Creates a new Marker object. -

-Serializes the marker. -

+
+

Serializes the marker.

@@ -337,9 +328,8 @@ Serializes the marker.

-

-Creates a new Marker object -

+ +

Creates a new Marker object

@@ -360,9 +350,8 @@ Creates a new Marker object — -

-a customizable set of options -

+
+

a customizable set of options

@@ -460,9 +449,8 @@ a customizable set of options

-

-The column this marker anchors to -

+ +

The column this marker anchors to

@@ -517,9 +505,8 @@ The column this marker anchors to

-

-The offset distance from this marker’s column -

+ +

The offset distance from this marker’s column

@@ -574,9 +561,8 @@ The offset distance from this marker’s column

-

-The row this marker anchors to -

+ +

The row this marker anchors to

@@ -631,9 +617,8 @@ The row this marker anchors to

-

-The offset distance from this marker’s row -

+ +

The offset distance from this marker’s row

@@ -692,9 +677,8 @@ The offset distance from this marker’s row

-

-shortcut to set the column, row position for this marker -

+ +

shortcut to set the column, row position for this marker

@@ -713,9 +697,8 @@ shortcut to set the column, row position for this marker — -

-the column for the marker -

+
+

the column for the marker

@@ -730,9 +713,8 @@ the column for the marker — -

-the row of the marker -

+
+

the row of the marker

@@ -773,9 +755,8 @@ the row of the marker

-

-Serializes the marker -

+ +

Serializes the marker

@@ -794,9 +775,8 @@ Serializes the marker — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -848,7 +828,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/NumFmt.html b/doc/Axlsx/NumFmt.html index e32a23fc..968f5c9b 100644 --- a/doc/Axlsx/NumFmt.html +++ b/doc/Axlsx/NumFmt.html @@ -97,16 +97,14 @@
Note: -

-The recommended way to manage styles is Styles#add_style -

+
+

The recommended way to manage styles is Styles#add_style

-

-A NumFmt object defines an identifier and formatting code for data in -cells. -

+ +

A NumFmt object defines an identifier and formatting code for data in +cells.

@@ -138,9 +136,8 @@ cells. -

-The formatting to use for this number format. -

+
+

The formatting to use for this number format.

@@ -165,9 +162,8 @@ The formatting to use for this number format. -

-An unsinged integer referencing a standard or custom number format. -

+
+

An unsinged integer referencing a standard or custom number format.

@@ -204,9 +200,8 @@ An unsinged integer referencing a standard or custom number format. -

-A new instance of NumFmt. -

+
+

A new instance of NumFmt.

@@ -228,10 +223,9 @@ A new instance of NumFmt. -

-Creates a numFmt element applying the instance values of this object as -attributes. -

+
+

Creates a numFmt element applying the instance values of this object as +attributes.

@@ -252,9 +246,8 @@ attributes.

-

-A new instance of NumFmt -

+ +

A new instance of NumFmt

@@ -309,9 +302,8 @@ A new instance of NumFmt

-

-The formatting to use for this number format. -

+ +

The formatting to use for this number format.

@@ -329,9 +321,8 @@ The formatting to use for this number format. — -

-The formatting to use for this number format. -

+
+

The formatting to use for this number format.

@@ -382,51 +373,49 @@ The formatting to use for this number format.
Note: -

-These are the known formats I can dig up. The constant NUM_FMT_PERCENT is +

+

These are the known formats I can dig up. The constant NUM_FMT_PERCENT is 9, and uses the default % formatting. Axlsx also defines a few formats for date and time that are commonly used in asia as NUM_FMT_YYYYMMDD and -NUM_FRM_YYYYMMDDHHMMSS. -

-
- 1 0
- 2 0.00
- 3 #,##0
- 4 #,##0.00
- 5 $#,##0_);($#,##0)
- 6 $#,##0_);[Red]($#,##0)
- 7 $#,##0.00_);($#,##0.00)
- 8 $#,##0.00_);[Red]($#,##0.00)
- 9 0%
- 10 0.00%
- 11 0.00E+00
- 12 # ?/?
- 13 # ??/??
- 14 m/d/yyyy
- 15 d-mmm-yy
- 16 d-mmm
- 17 mmm-yy
- 18 h:mm AM/PM
- 19 h:mm:ss AM/PM
- 20 h:mm
- 21 h:mm:ss
- 22 m/d/yyyy h:mm
- 37 #,##0_);(#,##0)
- 38 #,##0_);[Red](#,##0)
- 39 #,##0.00_);(#,##0.00)
- 40 #,##0.00_);[Red](#,##0.00)
- 45 mm:ss
- 46 [h]:mm:ss
- 47 mm:ss.0
- 48 ##0.0E+0
- 49 @
+NUM_FRM_YYYYMMDDHHMMSS.

+ +
1 0
+2 0.00
+3 #,##0
+4 #,##0.00
+5 $#,##0_);($#,##0)
+6 $#,##0_);[Red]($#,##0)
+7 $#,##0.00_);($#,##0.00)
+8 $#,##0.00_);[Red]($#,##0.00)
+9 0%
+10 0.00%
+11 0.00E+00
+12 # ?/?
+13 # ??/??
+14 m/d/yyyy
+15 d-mmm-yy
+16 d-mmm
+17 mmm-yy
+18 h:mm AM/PM
+19 h:mm:ss AM/PM
+20 h:mm
+21 h:mm:ss
+22 m/d/yyyy h:mm
+37 #,##0_);(#,##0)
+38 #,##0_);[Red](#,##0)
+39 #,##0.00_);(#,##0.00)
+40 #,##0.00_);[Red](#,##0.00)
+45 mm:ss
+46 [h]:mm:ss
+47 mm:ss.0
+48 ##0.0E+0
+49 @
 
-

-An unsinged integer referencing a standard or custom number format. -

+ +

An unsinged integer referencing a standard or custom number format.

@@ -444,9 +433,8 @@ An unsinged integer referencing a standard or custom number format. — -

-An unsinged integer referencing a standard or custom number format. -

+
+

An unsinged integer referencing a standard or custom number format.

@@ -498,10 +486,9 @@ An unsinged integer referencing a standard or custom number format.

-

-Creates a numFmt element applying the instance values of this object as -attributes. -

+ +

Creates a numFmt element applying the instance values of this object as +attributes.

@@ -520,9 +507,8 @@ attributes. — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -553,7 +539,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/OneCellAnchor.html b/doc/Axlsx/OneCellAnchor.html index 68ec5ab9..40e76ca2 100644 --- a/doc/Axlsx/OneCellAnchor.html +++ b/doc/Axlsx/OneCellAnchor.html @@ -97,16 +97,14 @@
Note: -

-The recommended way to manage drawings, images and charts is -Worksheet#add_chart or Worksheet#add_image. -

+
+

The recommended way to manage drawings, images and charts is +Worksheet#add_chart or Worksheet#add_image.

-

-This class details a single cell anchor for drawings. -

+ +

This class details a single cell anchor for drawings.

@@ -147,9 +145,8 @@ This class details a single cell anchor for drawings. -

-The drawing that holds this anchor. -

+
+

The drawing that holds this anchor.

@@ -174,9 +171,8 @@ The drawing that holds this anchor. -

-A marker that defines the from cell anchor. -

+
+

A marker that defines the from cell anchor.

@@ -201,10 +197,9 @@ A marker that defines the from cell anchor. -

-the height of the graphic object in pixels this is converted to EMU at a 92 -ppi resolution. -

+
+

the height of the graphic object in pixels this is converted to EMU at a 92 +ppi resolution.

@@ -229,9 +224,8 @@ ppi resolution. -

-The object this anchor hosts. -

+
+

The object this anchor hosts.

@@ -256,9 +250,8 @@ The object this anchor hosts. -

-the width of the graphic object in pixels. -

+
+

the width of the graphic object in pixels.

@@ -293,9 +286,8 @@ the width of the graphic object in pixels. -

-The index of this anchor in the drawing. -

+
+

The index of this anchor in the drawing.

@@ -319,9 +311,8 @@ The index of this anchor in the drawing. -

-Creates a new OneCellAnchor object and an Pic associated with it. -

+
+

Creates a new OneCellAnchor object and an Pic associated with it.

@@ -343,9 +334,8 @@ Creates a new OneCellAnchor object and an Pic associated with it. -

-Serializes the anchor. -

+
+

Serializes the anchor.

@@ -366,9 +356,8 @@ Serializes the anchor.

-

-Creates a new OneCellAnchor object and an Pic associated with it. -

+ +

Creates a new OneCellAnchor object and an Pic associated with it.

@@ -400,9 +389,8 @@ Creates a new OneCellAnchor object and an Pic associated with it. — -

-a customizable set of options -

+
+

a customizable set of options

@@ -423,9 +411,8 @@ a customizable set of options - —

-the col, row to start at -

+ —
+

the col, row to start at

@@ -453,9 +440,8 @@ the col, row to start at - —

-the file location of the image you will render -

+ —
+

the file location of the image you will render

@@ -465,9 +451,8 @@ the file location of the image you will render - —

-the name attribute for the rendered image -

+ —
+

the name attribute for the rendered image

@@ -477,9 +462,8 @@ the name attribute for the rendered image - —

-the description of the image rendered -

+ —
+

the description of the image rendered

@@ -542,9 +526,8 @@ the description of the image rendered

-

-The drawing that holds this anchor -

+ +

The drawing that holds this anchor

@@ -599,10 +582,9 @@ The drawing that holds this anchor

-

-A marker that defines the from cell anchor. The default from column and row -are 0 and 0 respectively -

+ +

A marker that defines the from cell anchor. The default from column and row +are 0 and 0 respectively

@@ -657,10 +639,9 @@ are 0 and 0 respectively

-

-the height of the graphic object in pixels this is converted to EMU at a 92 -ppi resolution -

+ +

the height of the graphic object in pixels this is converted to EMU at a 92 +ppi resolution

@@ -715,9 +696,8 @@ ppi resolution

-

-The object this anchor hosts -

+ +

The object this anchor hosts

@@ -772,10 +752,9 @@ The object this anchor hosts

-

-the width of the graphic object in pixels. this is converted to EMU at a 92 -ppi resolution -

+ +

the width of the graphic object in pixels. this is converted to EMU at a 92 +ppi resolution

@@ -834,9 +813,8 @@ ppi resolution

-

-The index of this anchor in the drawing -

+ +

The index of this anchor in the drawing

@@ -888,9 +866,8 @@ The index of this anchor in the drawing

-

-Serializes the anchor -

+ +

Serializes the anchor

@@ -909,9 +886,8 @@ Serializes the anchor — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -973,7 +949,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Override.html b/doc/Axlsx/Override.html index 8db1c816..68ce281e 100644 --- a/doc/Axlsx/Override.html +++ b/doc/Axlsx/Override.html @@ -94,10 +94,9 @@

Overview

-

-An override content part. These parts are automatically created by for you -based on the content of your package. -

+ +

An override content part. These parts are automatically created by for you +based on the content of your package.

@@ -129,9 +128,8 @@ based on the content of your package. -

-The type of content. -

+
+

The type of content.

@@ -156,9 +154,8 @@ The type of content. -

-The name and location of the part. -

+
+

The name and location of the part.

@@ -195,9 +192,8 @@ The name and location of the part. -

-Creates a new Override object. -

+
+

Creates a new Override object.

@@ -219,9 +215,8 @@ Creates a new Override object. -

-Serializes the Override object to xml. -

+
+

Serializes the Override object to xml.

@@ -242,9 +237,8 @@ Serializes the Override object to xml.

-

-Creates a new Override object -

+ +

Creates a new Override object

@@ -265,9 +259,8 @@ Creates a new Override object — -

-a customizable set of options -

+
+

a customizable set of options

@@ -312,10 +305,9 @@ a customizable set of options — -

-An argument error is raised if both PartName and ContentType are not -specified. -

+
+

An argument error is raised if both PartName and ContentType are not +specified.

@@ -367,9 +359,8 @@ specified.

-

-The type of content. -

+ +

The type of content.

@@ -424,9 +415,8 @@ The type of content.

-

-The name and location of the part. -

+ +

The name and location of the part.

@@ -485,9 +475,8 @@ The name and location of the part.

-

-Serializes the Override object to xml -

+ +

Serializes the Override object to xml

@@ -506,9 +495,8 @@ Serializes the Override object to xml — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -543,7 +531,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Package.html b/doc/Axlsx/Package.html index 2c003230..29c1b79f 100644 --- a/doc/Axlsx/Package.html +++ b/doc/Axlsx/Package.html @@ -94,11 +94,10 @@

Overview

-

-Package is responsible for managing all the bits and peices that Open + +

Package is responsible for managing all the bits and peices that Open Office XML requires to make a valid xlsx document including valdation and -serialization. -

+serialization.

@@ -137,9 +136,8 @@ serialization. -

-Initializes your package. -

+
+

Initializes your package.

@@ -161,9 +159,8 @@ Initializes your package. -

-Accepts a ruport table for serialization to xlsx. -

+
+

Accepts a ruport table for serialization to xlsx.

@@ -185,9 +182,8 @@ Accepts a ruport table for serialization to xlsx. -

-Serialize your workbook to disk as an xlsx document. -

+
+

Serialize your workbook to disk as an xlsx document.

@@ -209,9 +205,8 @@ Serialize your workbook to disk as an xlsx document. -

-Validate all parts of the package against xsd schema. -

+
+

Validate all parts of the package against xsd schema.

@@ -233,9 +228,8 @@ Validate all parts of the package against xsd schema. -

-The workbook this package will serialize or validate. -

+
+

The workbook this package will serialize or validate.

@@ -277,9 +271,8 @@ The workbook this package will serialize or validate.

-

-Initializes your package -

+ +

Initializes your package

@@ -289,9 +282,8 @@ Initializes your package

Examples:

-

-Package.new :author => ‘you!’, :workbook => Workbook.new -

+

+

Package.new :author => ‘you!’, :workbook => Workbook.new

 
@@ -312,10 +304,9 @@ Package.new :author => ‘you!’, :workbook => Workbook.new — -

-A hash that you can use to specify the author and workbook for this -package. -

+
+

A hash that you can use to specify the author and workbook for this +package.

@@ -334,9 +325,8 @@ package. - —

-The author of the document -

+ —
+

The author of the document

@@ -369,9 +359,8 @@ The author of the document — -

-the object that the method was called on -

+
+

the object that the method was called on

@@ -422,9 +411,8 @@ the object that the method was called on

-

-Accepts a ruport table for serialization to xlsx -

+ +

Accepts a ruport table for serialization to xlsx

@@ -443,9 +431,8 @@ Accepts a ruport table for serialization to xlsx — -

-a ruport Table object -

+
+

a ruport Table object

@@ -487,17 +474,15 @@ a ruport Table object
Note: -

-A tremendous amount of effort has gone into ensuring that you cannot create +

+

A tremendous amount of effort has gone into ensuring that you cannot create invalid xlsx documents. confirm_valid should be used in the rare case that -you cannot open the serialized file. -

+you cannot open the serialized file.

-

-Serialize your workbook to disk as an xlsx document. -

+ +

Serialize your workbook to disk as an xlsx document.

@@ -530,9 +515,8 @@ Serialize your workbook to disk as an xlsx document. — -

-The file you want to serialize your package to -

+
+

The file you want to serialize your package to

@@ -549,9 +533,8 @@ The file you want to serialize your package to — -

-Validate the package prior to serialization. -

+
+

Validate the package prior to serialization.

@@ -569,10 +552,9 @@ Validate the package prior to serialization. — -

-False if confirm_valid and validation errors exist. True if the package was -serialized -

+
+

False if confirm_valid and validation errors exist. True if the package was +serialized

@@ -650,25 +632,22 @@ serialized
Note: -

-This gem includes all schema from OfficeOpenXML-XMLSchema-Transitional.zip +

+

This gem includes all schema from OfficeOpenXML-XMLSchema-Transitional.zip and OpenPackagingConventions-XMLSchema.zip as per ECMA-376, Third edition. opc schema require an internet connection to import remote schema from dublin core for dc, dcterms and xml namespaces. Those remote schema are -included in this gem, and the original files have been altered to refer to -the local versions. -

-

-If by chance you are able to creat a package that does not validate it +included in this gem, and the original files have been altered to refer to +the local versions.

+ +

If by chance you are able to creat a package that does not validate it indicates that the internal validation is not robust enough and needs to be -improved. Please report your errors to the gem author. -

+improved. Please report your errors to the gem author.

-

-Validate all parts of the package against xsd schema. -

+ +

Validate all parts of the package against xsd schema.

@@ -698,9 +677,8 @@ Validate all parts of the package against xsd schema. — -

-An array of all validation errors found. -

+
+

An array of all validation errors found.

@@ -752,25 +730,23 @@ An array of all validation errors found.
Note: -

-As there are multiple ways to instantiate a workbook for the package, here -are a few examples: -

-
-  # assign directly during package instanciation
-  wb = Package.new(:workbook => Workbook.new).workbook
-
-  # get a fresh workbook automatically from the package
-  wb = Pacakge.new().workbook
-  #     # set the workbook after creating the package
-  wb = Package.new().workbook = Workbook.new
+    
+

As there are multiple ways to instantiate a workbook for the package, here +are a few examples:

+ +
# assign directly during package instanciation
+wb = Package.new(:workbook => Workbook.new).workbook
+
+# get a fresh workbook automatically from the package
+wb = Pacakge.new().workbook
+#     # set the workbook after creating the package
+wb = Package.new().workbook = Workbook.new
 
-

-The workbook this package will serialize or validate. -

+ +

The workbook this package will serialize or validate.

@@ -801,10 +777,9 @@ The workbook this package will serialize or validate. — -

-If no workbook instance has been assigned with this package a new Workbook -instance is returned. -

+
+

If no workbook instance has been assigned with this package a new Workbook +instance is returned.

@@ -821,9 +796,8 @@ instance is returned. -

-ArgumentError if workbook parameter is not a Workbook instance. -

+
+

ArgumentError if workbook parameter is not a Workbook instance.

@@ -902,7 +876,7 @@ ArgumentError if workbook parameter is not a Workbook instance.
diff --git a/doc/Axlsx/PatternFill.html b/doc/Axlsx/PatternFill.html index 6370e694..a4a6e647 100644 --- a/doc/Axlsx/PatternFill.html +++ b/doc/Axlsx/PatternFill.html @@ -97,15 +97,13 @@
Note: -

-The recommended way to manage styles is with Styles#add_style -

+
+

The recommended way to manage styles is with Styles#add_style

-

-A PatternFill is the pattern and solid fill styling for a cell. -

+ +

A PatternFill is the pattern and solid fill styling for a cell.

@@ -144,9 +142,8 @@ A PatternFill is the pattern and solid fill styling for a cell. -

-The color to use for the background of the fill when the type is not solid. -

+
+

The color to use for the background of the fill when the type is not solid.

@@ -171,9 +168,8 @@ The color to use for the background of the fill when the type is not solid. -

-The color to use for the the background in solid fills. -

+
+

The color to use for the the background in solid fills.

@@ -198,9 +194,8 @@ The color to use for the the background in solid fills. -

-The pattern type to use. -

+
+

The pattern type to use.

@@ -237,9 +232,8 @@ The pattern type to use. -

-Creates a new PatternFill Object. -

+
+

Creates a new PatternFill Object.

@@ -261,9 +255,8 @@ Creates a new PatternFill Object. -

-Serializes the pattern fill. -

+
+

Serializes the pattern fill.

@@ -284,9 +277,8 @@ Serializes the pattern fill.

-

-Creates a new PatternFill Object -

+ +

Creates a new PatternFill Object

@@ -307,9 +299,8 @@ Creates a new PatternFill Object — -

-a customizable set of options -

+
+

a customizable set of options

@@ -398,9 +389,8 @@ a customizable set of options

-

-The color to use for the background of the fill when the type is not solid. -

+ +

The color to use for the background of the fill when the type is not solid.

@@ -455,9 +445,8 @@ The color to use for the background of the fill when the type is not solid.

-

-The color to use for the the background in solid fills. -

+ +

The color to use for the the background in solid fills.

@@ -515,36 +504,34 @@ The color to use for the the background in solid fills.
Note: -

-patternType must be one of -

-
- :none
- :solid
- :mediumGray
- :darkGray
- :lightGray
- :darkHorizontal
- :darkVertical
- :darkDown
- :darkUp
- :darkGrid
- :darkTrellis
- :lightHorizontal
- :lightVertical
- :lightDown
- :lightUp
- :lightGrid
- :lightTrellis
- :gray125
- :gray0625
+    
+

patternType must be one of

+ +
:none
+:solid
+:mediumGray
+:darkGray
+:lightGray
+:darkHorizontal
+:darkVertical
+:darkDown
+:darkUp
+:darkGrid
+:darkTrellis
+:lightHorizontal
+:lightVertical
+:lightDown
+:lightUp
+:lightGrid
+:lightTrellis
+:gray125
+:gray0625
 
-

-The pattern type to use -

+ +

The pattern type to use

@@ -597,9 +584,8 @@ The pattern type to use

-

-Serializes the pattern fill -

+ +

Serializes the pattern fill

@@ -618,9 +604,8 @@ Serializes the pattern fill — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -672,7 +657,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Pic.html b/doc/Axlsx/Pic.html index 505d49c0..cb791160 100644 --- a/doc/Axlsx/Pic.html +++ b/doc/Axlsx/Pic.html @@ -94,10 +94,9 @@

Overview

-

-a Pic object represents an image in your worksheet Worksheet#add_image is -the recommended way to manage images in your sheets -

+ +

a Pic object represents an image in your worksheet Worksheet#add_image is +the recommended way to manage images in your sheets

@@ -120,9 +119,8 @@ the recommended way to manage images in your sheets
ALLOWED_EXTENSIONS =
-

-allowed file extenstions -

+ +

allowed file extenstions

@@ -161,9 +159,8 @@ allowed file extenstions -

-The anchor for this image. -

+
+

The anchor for this image.

@@ -188,9 +185,8 @@ The anchor for this image. -

-A description of the picture. -

+
+

A description of the picture.

@@ -215,10 +211,9 @@ A description of the picture. -

-The path to the image you want to include Only local images are supported -at this time and only jpg support. -

+
+

The path to the image you want to include Only local images are supported +at this time and only jpg support.

@@ -243,9 +238,8 @@ at this time and only jpg support. -

-The name to use for this picture. -

+
+

The name to use for this picture.

@@ -280,9 +274,8 @@ The name to use for this picture. -

-returns the extension of image_src without the preceeding ’.’. -

+
+

returns the extension of image_src without the preceeding ‘.’.

@@ -304,9 +297,8 @@ returns the extension of image_src without the preceeding ’.’. -

-The file name of image_src without any path information. -

+
+

The file name of image_src without any path information.

@@ -328,9 +320,8 @@ The file name of image_src without any path information. -

-providing access to update the anchor’s height attribute. -

+
+

providing access to update the anchor’s height attribute.

@@ -373,9 +364,8 @@ providing access to update the anchor’s height attribute. -

-The index of this image in the workbooks images collections. -

+
+

The index of this image in the workbooks images collections.

@@ -399,9 +389,8 @@ The index of this image in the workbooks images collections. -

-Creates a new Pic(ture) object. -

+
+

Creates a new Pic(ture) object.

@@ -423,10 +412,9 @@ Creates a new Pic(ture) object. -

-The part name for this image used in serialization and relationship -building. -

+
+

The part name for this image used in serialization and relationship +building.

@@ -448,11 +436,10 @@ building. -

-This is a short cut method to set the start anchor position If you need +

+

This is a short cut method to set the start anchor position If you need finer granularity in positioning use graphic_frame.anchor.from.colOff / -rowOff. -

+rowOff.

@@ -474,9 +461,8 @@ rowOff. -

-Serializes the picture. -

+
+

Serializes the picture.

@@ -498,9 +484,8 @@ Serializes the picture. -

-providing access to the anchor’s width attribute. -

+
+

providing access to the anchor’s width attribute.

@@ -542,9 +527,8 @@ providing access to the anchor’s width attribute.

-

-Creates a new Pic(ture) object -

+ +

Creates a new Pic(ture) object

@@ -563,9 +547,8 @@ Creates a new Pic(ture) object — -

-the anchor that holds this image -

+
+

the anchor that holds this image

@@ -582,9 +565,8 @@ the anchor that holds this image — -

-a customizable set of options -

+
+

a customizable set of options

@@ -682,9 +664,8 @@ a customizable set of options — -

-the object that the method was called on -

+
+

the object that the method was called on

@@ -742,9 +723,8 @@ the object that the method was called on

-

-The anchor for this image -

+ +

The anchor for this image

@@ -799,9 +779,8 @@ The anchor for this image

-

-A description of the picture -

+ +

A description of the picture

@@ -856,10 +835,9 @@ A description of the picture

-

-The path to the image you want to include Only local images are supported -at this time and only jpg support -

+ +

The path to the image you want to include Only local images are supported +at this time and only jpg support

@@ -914,9 +892,8 @@ at this time and only jpg support

-

-The name to use for this picture -

+ +

The name to use for this picture

@@ -975,9 +952,8 @@ The name to use for this picture

-

-returns the extension of image_src without the preceeding ’.’ -

+ +

returns the extension of image_src without the preceeding ‘.’

@@ -1029,9 +1005,8 @@ returns the extension of image_src without the preceeding ’.’

-

-The file name of image_src without any path information -

+ +

The file name of image_src without any path information

@@ -1083,9 +1058,8 @@ The file name of image_src without any path information

-

-providing access to update the anchor’s height attribute -

+ +

providing access to update the anchor’s height attribute

@@ -1191,9 +1165,8 @@ providing access to update the anchor’s height attribute

-

-The index of this image in the workbooks images collections -

+ +

The index of this image in the workbooks images collections

@@ -1245,10 +1218,9 @@ The index of this image in the workbooks images collections

-

-The part name for this image used in serialization and relationship -building -

+ +

The part name for this image used in serialization and relationship +building

@@ -1300,11 +1272,10 @@ building

-

-This is a short cut method to set the start anchor position If you need + +

This is a short cut method to set the start anchor position If you need finer granularity in positioning use graphic_frame.anchor.from.colOff / -rowOff -

+rowOff

@@ -1323,9 +1294,8 @@ rowOff — -

-The column -

+
+

The column

@@ -1340,9 +1310,8 @@ The column — -

-The row -

+
+

The row

@@ -1396,9 +1365,8 @@ The row

-

-Serializes the picture -

+ +

Serializes the picture

@@ -1417,9 +1385,8 @@ Serializes the picture — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -1515,9 +1482,8 @@ The document builder instance this objects xml will be added to.

-

-providing access to the anchor’s width attribute -

+ +

providing access to the anchor’s width attribute

@@ -1619,7 +1585,7 @@ providing access to the anchor’s width attribute
diff --git a/doc/Axlsx/Pie3DChart.html b/doc/Axlsx/Pie3DChart.html index 710eeed1..21cd7df4 100644 --- a/doc/Axlsx/Pie3DChart.html +++ b/doc/Axlsx/Pie3DChart.html @@ -96,10 +96,9 @@

Overview

-

-The Pie3DChart is a three dimentional piechart (who would have guessed?) -that you can add to your worksheet. -

+ +

The Pie3DChart is a three dimentional piechart (who would have guessed?) +that you can add to your worksheet.

@@ -161,9 +160,8 @@ that you can add to your worksheet. -

-Creates a new pie chart object. -

+
+

Creates a new pie chart object.

@@ -185,9 +183,8 @@ Creates a new pie chart object. -

-Serializes the pie chart. -

+
+

Serializes the pie chart.

@@ -218,9 +215,8 @@ Serializes the pie chart.

-

-Creates a new pie chart object -

+ +

Creates a new pie chart object

@@ -239,9 +235,8 @@ Creates a new pie chart object — -

-The workbook that owns this chart. -

+
+

The workbook that owns this chart.

@@ -258,9 +253,8 @@ The workbook that owns this chart. — -

-a customizable set of options -

+
+

a customizable set of options

@@ -420,9 +414,8 @@ a customizable set of options

-

-Serializes the pie chart -

+ +

Serializes the pie chart

@@ -480,7 +473,7 @@ Serializes the pie chart
diff --git a/doc/Axlsx/PieSeries.html b/doc/Axlsx/PieSeries.html index 5102caee..49c37a7c 100644 --- a/doc/Axlsx/PieSeries.html +++ b/doc/Axlsx/PieSeries.html @@ -99,16 +99,14 @@
Note: -

-The recommended way to manage series is to use Chart#add_series -

+
+

The recommended way to manage series is to use Chart#add_series

-

-A PieSeries defines the data and labels and explosion for pie charts -series. -

+ +

A PieSeries defines the data and labels and explosion for pie charts +series.

@@ -153,9 +151,8 @@ series. -

-The data for this series. -

+
+

The data for this series.

@@ -180,9 +177,8 @@ The data for this series. -

-The explosion for this series. -

+
+

The explosion for this series.

@@ -207,9 +203,8 @@ The explosion for this series. -

-The labels for this series. -

+
+

The labels for this series.

@@ -254,9 +249,8 @@ The labels for this series. -

-Creates a new series. -

+
+

Creates a new series.

@@ -278,9 +272,8 @@ Creates a new series. -

-Serializes the series. -

+
+

Serializes the series.

@@ -311,9 +304,8 @@ Serializes the series.

-

-Creates a new series -

+ +

Creates a new series

@@ -345,9 +337,8 @@ Creates a new series — -

-a customizable set of options -

+
+

a customizable set of options

@@ -447,9 +438,8 @@ a customizable set of options

-

-The data for this series. -

+ +

The data for this series.

@@ -504,9 +494,8 @@ The data for this series.

-

-The explosion for this series -

+ +

The explosion for this series

@@ -561,9 +550,8 @@ The explosion for this series

-

-The labels for this series. -

+ +

The labels for this series.

@@ -622,9 +610,8 @@ The labels for this series.

-

-Serializes the series -

+ +

Serializes the series

@@ -643,9 +630,8 @@ Serializes the series — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -701,7 +687,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/RegexValidator.html b/doc/Axlsx/RegexValidator.html index b4d48742..0e7baede 100644 --- a/doc/Axlsx/RegexValidator.html +++ b/doc/Axlsx/RegexValidator.html @@ -94,9 +94,8 @@

Overview

-

-Validates the value against the regular expression provided. -

+ +

Validates the value against the regular expression provided.

@@ -174,10 +173,9 @@ Validates the value against the regular expression provided. — -

-The name of what is being validated. This is included in the output when -the value is invalid -

+
+

The name of what is being validated. This is included in the output when +the value is invalid

@@ -192,9 +190,8 @@ the value is invalid — -

-The regular expression to evaluate -

+
+

The regular expression to evaluate

@@ -209,9 +206,8 @@ The regular expression to evaluate — -

-The value to validate. -

+
+

The value to validate.

@@ -259,7 +255,7 @@ The value to validate.
diff --git a/doc/Axlsx/Relationship.html b/doc/Axlsx/Relationship.html index e2c5cd91..e0f7b487 100644 --- a/doc/Axlsx/Relationship.html +++ b/doc/Axlsx/Relationship.html @@ -97,15 +97,13 @@
Note: -

-Packages automatcially manage relationships. -

+
+

Packages automatcially manage relationships.

-

-A relationship defines a reference between package parts. -

+ +

A relationship defines a reference between package parts.

@@ -137,9 +135,8 @@ A relationship defines a reference between package parts. -

-The location of the relationship target. -

+
+

The location of the relationship target.

@@ -164,9 +161,8 @@ The location of the relationship target. -

-The type of relationship. -

+
+

The type of relationship.

@@ -203,9 +199,8 @@ The type of relationship. -

-A new instance of Relationship. -

+
+

A new instance of Relationship.

@@ -227,9 +222,8 @@ A new instance of Relationship. -

-Serializes the relationship. -

+
+

Serializes the relationship.

@@ -250,9 +244,8 @@ Serializes the relationship.

-

-A new instance of Relationship -

+ +

A new instance of Relationship

@@ -301,9 +294,8 @@ A new instance of Relationship

-

-The location of the relationship target -

+ +

The location of the relationship target

@@ -361,15 +353,13 @@ The location of the relationship target
Note: -

-Supported types are defined as constants in Axlsx: -

+
+

Supported types are defined as constants in Axlsx:

-

-The type of relationship -

+ +

The type of relationship

@@ -453,9 +443,8 @@ The type of relationship

-

-Serializes the relationship -

+ +

Serializes the relationship

@@ -474,9 +463,8 @@ Serializes the relationship — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -491,9 +479,8 @@ The document builder instance this objects xml will be added to. — -

-the reference id of the object. -

+
+

the reference id of the object.

@@ -545,7 +532,7 @@ the reference id of the object.
diff --git a/doc/Axlsx/Relationships.html b/doc/Axlsx/Relationships.html index d930a3de..fd687a8b 100644 --- a/doc/Axlsx/Relationships.html +++ b/doc/Axlsx/Relationships.html @@ -99,16 +99,14 @@
Note: -

-The package automatically manages releationships. -

+
+

The package automatically manages releationships.

-

-Relationships are a collection of Relations that define how package parts -are related. -

+ +

Relationships are a collection of Relations that define how package parts +are related.

@@ -159,9 +157,8 @@ are related. -

-Creates a new Relationships collection based on SimpleTypedList. -

+
+

Creates a new Relationships collection based on SimpleTypedList.

@@ -183,9 +180,8 @@ Creates a new Relationships collection based on SimpleTypedList. -

-Serializes the relationships document. -

+
+

Serializes the relationships document.

@@ -211,9 +207,8 @@ Serializes the relationships document.

-

-Creates a new Relationships collection based on SimpleTypedList -

+ +

Creates a new Relationships collection based on SimpleTypedList

@@ -269,9 +264,8 @@ Creates a new Relationships collection based on SimpleTypedList

-

-Serializes the relationships document. -

+ +

Serializes the relationships document.

@@ -329,7 +323,7 @@ Serializes the relationships document.
diff --git a/doc/Axlsx/RestrictionValidator.html b/doc/Axlsx/RestrictionValidator.html index e0eb7e45..a5a2bb53 100644 --- a/doc/Axlsx/RestrictionValidator.html +++ b/doc/Axlsx/RestrictionValidator.html @@ -94,9 +94,8 @@

Overview

-

-Validate a value against a specific list of allowed values. -

+ +

Validate a value against a specific list of allowed values.

@@ -133,9 +132,8 @@ Validate a value against a specific list of allowed values. -

-Perform validation. -

+
+

Perform validation.

@@ -159,9 +157,8 @@ Perform validation.

-

-Perform validation -

+ +

Perform validation

@@ -180,9 +177,8 @@ Perform validation — -

-The name of what is being validatied. This is included in the error message -

+
+

The name of what is being validatied. This is included in the error message

@@ -197,9 +193,8 @@ The name of what is being validatied. This is included in the error message — -

-The list of choices to validate against -

+
+

The list of choices to validate against

@@ -214,9 +209,8 @@ The list of choices to validate against — -

-The value to be validated -

+
+

The value to be validated

@@ -234,9 +228,8 @@ The value to be validated — -

-true if validation succeeds. -

+
+

true if validation succeeds.

@@ -253,9 +246,8 @@ true if validation succeeds. — -

-Raised if the value provided is not in the list of choices. -

+
+

Raised if the value provided is not in the list of choices.

@@ -291,7 +283,7 @@ Raised if the value provided is not in the list of choices.
diff --git a/doc/Axlsx/Row.html b/doc/Axlsx/Row.html index 06467bd5..8a8639bf 100644 --- a/doc/Axlsx/Row.html +++ b/doc/Axlsx/Row.html @@ -97,15 +97,13 @@
Note: -

-The recommended way to manage rows and cells is to use Worksheet#add_row -

+
+

The recommended way to manage rows and cells is to use Worksheet#add_row

-

-A Row is a single row in a worksheet. -

+ +

A Row is a single row in a worksheet.

@@ -144,9 +142,8 @@ A Row is a single row in a worksheet. -

-The cells this row holds. -

+
+

The cells this row holds.

@@ -171,9 +168,8 @@ The cells this row holds. -

-The worksheet this row belongs to. -

+
+

The worksheet this row belongs to.

@@ -208,10 +204,9 @@ The worksheet this row belongs to. -

-Adds a singel sell to the row based on the data provided and updates the -worksheet’s autofit data. -

+
+

Adds a singel sell to the row based on the data provided and updates the +worksheet’s autofit data.

@@ -233,9 +228,8 @@ worksheet’s autofit data. -

-The index of this row in the worksheet. -

+
+

The index of this row in the worksheet.

@@ -259,9 +253,8 @@ The index of this row in the worksheet. -

-Creates a new row. -

+
+

Creates a new row.

@@ -283,9 +276,8 @@ Creates a new row. -

-sets the style for every cell in this row. -

+
+

sets the style for every cell in this row.

@@ -307,10 +299,9 @@ sets the style for every cell in this row. -

-returns the cells in this row as an array This lets us transpose the rows -into columns. -

+
+

returns the cells in this row as an array This lets us transpose the rows +into columns.

@@ -332,9 +323,8 @@ into columns. -

-Serializes the row. -

+
+

Serializes the row.

@@ -355,18 +345,17 @@ Serializes the row.

-

-Creates a new row. New Cell objects are created based on the values, types + +

Creates a new row. New Cell objects are created based on the values, types and style options. A new cell is created for each item in the values array. -style and types options are applied as follows: -

-
-  If the types option is defined and is a symbol it is applied to all the cells created.
-  If the types option is an array, cell types are applied by index for each cell
-  If the types option is not set, the cell will automatically determine its type.
-  If the style option is defined and is an Integer, it is applied to all cells created.
-  If the style option is an array, style is applied by index for each cell.
-  If the style option is not defined, the default style (0) is applied to each cell.
+style and types options are applied as follows:

+ +
If the types option is defined and is a symbol it is applied to all the cells created.
+If the types option is an array, cell types are applied by index for each cell
+If the types option is not set, the cell will automatically determine its type.
+If the style option is defined and is an Integer, it is applied to all cells created.
+If the style option is an array, style is applied by index for each cell.
+If the style option is not defined, the default style (0) is applied to each cell.
 
@@ -399,9 +388,8 @@ style and types options are applied as follows: — -

-a customizable set of options -

+
+

a customizable set of options

@@ -503,9 +491,8 @@ a customizable set of options

-

-The cells this row holds -

+ +

The cells this row holds

@@ -560,9 +547,8 @@ The cells this row holds

-

-The worksheet this row belongs to -

+ +

The worksheet this row belongs to

@@ -621,10 +607,9 @@ The worksheet this row belongs to

-

-Adds a singel sell to the row based on the data provided and updates the -worksheet’s autofit data. -

+ +

Adds a singel sell to the row based on the data provided and updates the +worksheet’s autofit data.

@@ -680,9 +665,8 @@ worksheet’s autofit data.

-

-The index of this row in the worksheet -

+ +

The index of this row in the worksheet

@@ -734,9 +718,8 @@ The index of this row in the worksheet

-

-sets the style for every cell in this row -

+ +

sets the style for every cell in this row

@@ -781,10 +764,9 @@ sets the style for every cell in this row

-

-returns the cells in this row as an array This lets us transpose the rows -into columns -

+ +

returns the cells in this row as an array This lets us transpose the rows +into columns

@@ -836,9 +818,8 @@ into columns

-

-Serializes the row -

+ +

Serializes the row

@@ -857,9 +838,8 @@ Serializes the row — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -907,7 +887,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Scaling.html b/doc/Axlsx/Scaling.html index 0d239bdf..333a8ba2 100644 --- a/doc/Axlsx/Scaling.html +++ b/doc/Axlsx/Scaling.html @@ -94,9 +94,8 @@

Overview

-

-The Scaling class defines axis scaling -

+ +

The Scaling class defines axis scaling

@@ -128,9 +127,8 @@ The Scaling class defines axis scaling -

-logarithmic base for a logarithmic axis. -

+
+

logarithmic base for a logarithmic axis.

@@ -155,9 +153,8 @@ logarithmic base for a logarithmic axis. -

-the maximum scaling. -

+
+

the maximum scaling.

@@ -182,9 +179,8 @@ the maximum scaling. -

-the minimu scaling. -

+
+

the minimu scaling.

@@ -209,9 +205,8 @@ the minimu scaling. -

-the orientation of the axis must be one of [:minMax, :maxMin]. -

+
+

the orientation of the axis must be one of [:minMax, :maxMin].

@@ -248,9 +243,8 @@ the orientation of the axis must be one of [:minMax, :maxMin]. -

-creates a new Scaling object. -

+
+

creates a new Scaling object.

@@ -272,9 +266,8 @@ creates a new Scaling object. -

-Serializes the axId. -

+
+

Serializes the axId.

@@ -295,9 +288,8 @@ Serializes the axId.

-

-creates a new Scaling object -

+ +

creates a new Scaling object

@@ -318,9 +310,8 @@ creates a new Scaling object — -

-a customizable set of options -

+
+

a customizable set of options

@@ -420,9 +411,8 @@ a customizable set of options

-

-logarithmic base for a logarithmic axis. must be between 2 and 1000 -

+ +

logarithmic base for a logarithmic axis. must be between 2 and 1000

@@ -477,9 +467,8 @@ logarithmic base for a logarithmic axis. must be between 2 and 1000

-

-the maximum scaling -

+ +

the maximum scaling

@@ -534,9 +523,8 @@ the maximum scaling

-

-the minimu scaling -

+ +

the minimu scaling

@@ -591,9 +579,8 @@ the minimu scaling

-

-the orientation of the axis must be one of [:minMax, :maxMin] -

+ +

the orientation of the axis must be one of [:minMax, :maxMin]

@@ -652,9 +639,8 @@ the orientation of the axis must be one of [:minMax, :maxMin]

-

-Serializes the axId -

+ +

Serializes the axId

@@ -673,9 +659,8 @@ Serializes the axId — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -733,7 +718,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/SerAxis.html b/doc/Axlsx/SerAxis.html index f0930dea..34b87079 100644 --- a/doc/Axlsx/SerAxis.html +++ b/doc/Axlsx/SerAxis.html @@ -96,9 +96,8 @@

Overview

-

-A SerAxis object defines a series axis -

+ +

A SerAxis object defines a series axis

@@ -134,9 +133,8 @@ A SerAxis object defines a series axis -

-The number of tick lables to skip between labels. -

+
+

The number of tick lables to skip between labels.

@@ -161,9 +159,8 @@ The number of tick lables to skip between labels. -

-The number of tickmarks to be skipped before the next one is rendered. -

+
+

The number of tickmarks to be skipped before the next one is rendered.

@@ -208,9 +205,8 @@ The number of tickmarks to be skipped before the next one is rendered. -

-Creates a new SerAxis object. -

+
+

Creates a new SerAxis object.

@@ -232,9 +228,8 @@ Creates a new SerAxis object. -

-Serializes the series axis. -

+
+

Serializes the series axis.

@@ -260,9 +255,8 @@ Serializes the series axis.

-

-Creates a new SerAxis object -

+ +

Creates a new SerAxis object

@@ -281,9 +275,8 @@ Creates a new SerAxis object — -

-the id of this axis. Inherited -

+
+

the id of this axis. Inherited

@@ -298,9 +291,8 @@ the id of this axis. Inherited — -

-the id of the perpendicular axis. Inherited -

+
+

the id of the perpendicular axis. Inherited

@@ -317,9 +309,8 @@ the id of the perpendicular axis. Inherited — -

-a customizable set of options -

+
+

a customizable set of options

@@ -342,9 +333,8 @@ a customizable set of options - —

-Inherited -

+ —
+

Inherited

@@ -354,9 +344,8 @@ Inherited - —

-Inherited -

+ —
+

Inherited

@@ -366,9 +355,8 @@ Inherited - —

-Inherited -

+ —
+

Inherited

@@ -435,9 +423,8 @@ Inherited

-

-The number of tick lables to skip between labels -

+ +

The number of tick lables to skip between labels

@@ -492,9 +479,8 @@ The number of tick lables to skip between labels

-

-The number of tickmarks to be skipped before the next one is rendered. -

+ +

The number of tickmarks to be skipped before the next one is rendered.

@@ -553,9 +539,8 @@ The number of tickmarks to be skipped before the next one is rendered.

-

-Serializes the series axis -

+ +

Serializes the series axis

@@ -574,9 +559,8 @@ Serializes the series axis — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -632,7 +616,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Series.html b/doc/Axlsx/Series.html index 0b905df5..a86ebc17 100644 --- a/doc/Axlsx/Series.html +++ b/doc/Axlsx/Series.html @@ -97,16 +97,14 @@
Note: -

-The recommended way to manage series is to use Chart#add_series -

+
+

The recommended way to manage series is to use Chart#add_series

-

-A Series defines the common series attributes and is the super class for -all concrete series types. -

+ +

A Series defines the common series attributes and is the super class for +all concrete series types.

@@ -151,9 +149,8 @@ all concrete series types. -

-The chart that owns this series. -

+
+

The chart that owns this series.

@@ -178,9 +175,8 @@ The chart that owns this series. -

-The title of the series. -

+
+

The title of the series.

@@ -215,9 +211,8 @@ The title of the series. -

-The index of this series in the chart’s series. -

+
+

The index of this series in the chart’s series.

@@ -241,9 +236,8 @@ The index of this series in the chart’s series. -

-Creates a new series. -

+
+

Creates a new series.

@@ -265,9 +259,8 @@ Creates a new series. -

-The order of this series in the chart’s series. -

+
+

The order of this series in the chart’s series.

@@ -310,9 +303,8 @@ The order of this series in the chart’s series. -

-Serializes the series. -

+
+

Serializes the series.

@@ -333,9 +325,8 @@ Serializes the series.

-

-Creates a new series -

+ +

Creates a new series

@@ -367,9 +358,8 @@ Creates a new series — -

-a customizable set of options -

+
+

a customizable set of options

@@ -455,9 +445,8 @@ a customizable set of options

-

-The chart that owns this series -

+ +

The chart that owns this series

@@ -512,9 +501,8 @@ The chart that owns this series

-

-The title of the series -

+ +

The title of the series

@@ -573,9 +561,8 @@ The title of the series

-

-The index of this series in the chart’s series. -

+ +

The index of this series in the chart’s series.

@@ -627,10 +614,9 @@ The index of this series in the chart’s series.

-

-The order of this series in the chart’s series. By default the order -is the index of the series. -

+ +

The order of this series in the chart’s series. By default the order is +the index of the series.

@@ -723,9 +709,8 @@ is the index of the series.

-

-Serializes the series -

+ +

Serializes the series

@@ -744,9 +729,8 @@ Serializes the series — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -804,7 +788,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/SeriesTitle.html b/doc/Axlsx/SeriesTitle.html index 622aaf8a..08954e4c 100644 --- a/doc/Axlsx/SeriesTitle.html +++ b/doc/Axlsx/SeriesTitle.html @@ -96,10 +96,9 @@

Overview

-

-A series title is a Title with a slightly different serialization than -chart titles. -

+ +

A series title is a Title with a slightly different serialization than +chart titles.

@@ -148,9 +147,8 @@ chart titles. -

-Serializes the series title. -

+
+

Serializes the series title.

@@ -190,9 +188,8 @@ Serializes the series title.

-

-Serializes the series title -

+ +

Serializes the series title

@@ -211,9 +208,8 @@ Serializes the series title — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -281,7 +277,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Styles.html b/doc/Axlsx/Styles.html index f3c8f0df..4c5f376d 100644 --- a/doc/Axlsx/Styles.html +++ b/doc/Axlsx/Styles.html @@ -97,20 +97,18 @@
Note: -

-The recommended way to manage styles is with add_style -

+
+

The recommended way to manage styles is with add_style

-

-The Styles class manages worksheet styles In addition to creating the + +

The Styles class manages worksheet styles In addition to creating the require style objects for a valid xlsx package, this class provides the key mechanism for adding styles to your workbook, and safely applying them to the cells of your worksheet. All portions of the stylesheet are implemented here exception colors, which specify legacy and modified pallete colors, -and exLst, whic is used as a future feature data storage area. -

+and exLst, whic is used as a future feature data storage area.

@@ -151,10 +149,9 @@ and exLst, whic is used as a future feature data storage area. -

-The collection of borders used in this workbook Axlsx predefines -THIN_BORDER which can be used to put a border around all of your cells. -

+
+

The collection of borders used in this workbook Axlsx predefines +THIN_BORDER which can be used to put a border around all of your cells.

@@ -179,10 +176,9 @@ THIN_BORDER which can be used to put a border around all of your cells. -

-The collection of named styles, referencing cellStyleXfs items in the -workbook. -

+
+

The collection of named styles, referencing cellStyleXfs items in the +workbook.

@@ -207,10 +203,9 @@ workbook. -

-The collection of master formatting records for named cell styles, which -means records defined in cellStyles, in the workbook. -

+
+

The collection of master formatting records for named cell styles, which +means records defined in cellStyles, in the workbook.

@@ -235,9 +230,8 @@ means records defined in cellStyles, in the workbook. -

-The collection of master formatting records. -

+
+

The collection of master formatting records.

@@ -262,9 +256,8 @@ The collection of master formatting records. -

-The collection of non-cell formatting records used in the worksheet. -

+
+

The collection of non-cell formatting records used in the worksheet.

@@ -289,9 +282,8 @@ The collection of non-cell formatting records used in the worksheet. -

-The collection of fills used in this workbook. -

+
+

The collection of fills used in this workbook.

@@ -316,9 +308,8 @@ The collection of fills used in this workbook. -

-The collection of fonts used in this workbook. -

+
+

The collection of fonts used in this workbook.

@@ -343,9 +334,8 @@ The collection of fonts used in this workbook. -

-numFmts for your styles. -

+
+

numFmts for your styles.

@@ -370,10 +360,9 @@ numFmts for your styles. -

-The collection of table styles that will be available to the user in the -excel UI. -

+
+

The collection of table styles that will be available to the user in the +excel UI.

@@ -408,9 +397,8 @@ excel UI. -

-Drastically simplifies style creation and management. -

+
+

Drastically simplifies style creation and management.

@@ -434,10 +422,9 @@ Drastically simplifies style creation and management. -

-Creates a new Styles object and prepopulates it with the requires objects -to generate a valid package style part. -

+
+

Creates a new Styles object and prepopulates it with the requires objects +to generate a valid package style part.

@@ -459,9 +446,8 @@ to generate a valid package style part. -

-Serializes the styles document. -

+
+

Serializes the styles document.

@@ -482,10 +468,9 @@ Serializes the styles document.

-

-Creates a new Styles object and prepopulates it with the requires objects -to generate a valid package style part. -

+ +

Creates a new Styles object and prepopulates it with the requires objects +to generate a valid package style part.

@@ -535,16 +520,14 @@ to generate a valid package style part.
Note: -

-The recommended way to manage styles is with add_style -

+
+

The recommended way to manage styles is with add_style

-

-The collection of borders used in this workbook Axlsx predefines -THIN_BORDER which can be used to put a border around all of your cells. -

+ +

The collection of borders used in this workbook Axlsx predefines +THIN_BORDER which can be used to put a border around all of your cells.

@@ -609,16 +592,14 @@ THIN_BORDER which can be used to put a border around all of your cells.
Note: -

-The recommended way to manage styles is with add_style -

+
+

The recommended way to manage styles is with add_style

-

-The collection of named styles, referencing cellStyleXfs items in the -workbook. -

+ +

The collection of named styles, referencing cellStyleXfs items in the +workbook.

@@ -683,16 +664,14 @@ workbook.
Note: -

-The recommended way to manage styles is with add_style -

+
+

The recommended way to manage styles is with add_style

-

-The collection of master formatting records for named cell styles, which -means records defined in cellStyles, in the workbook -

+ +

The collection of master formatting records for named cell styles, which +means records defined in cellStyles, in the workbook

@@ -757,16 +736,14 @@ means records defined in cellStyles, in the workbook
Note: -

-The recommended way to manage styles is with add_style -

+
+

The recommended way to manage styles is with add_style

-

-The collection of master formatting records. This is the list that you will -actually use in styling a workbook. -

+ +

The collection of master formatting records. This is the list that you will +actually use in styling a workbook.

@@ -831,15 +808,13 @@ actually use in styling a workbook.
Note: -

-The recommended way to manage styles is with add_style -

+
+

The recommended way to manage styles is with add_style

-

-The collection of non-cell formatting records used in the worksheet. -

+ +

The collection of non-cell formatting records used in the worksheet.

@@ -904,15 +879,13 @@ The collection of non-cell formatting records used in the worksheet.
Note: -

-The recommended way to manage styles is with add_style -

+
+

The recommended way to manage styles is with add_style

-

-The collection of fills used in this workbook -

+ +

The collection of fills used in this workbook

@@ -977,15 +950,13 @@ The collection of fills used in this workbook
Note: -

-The recommended way to manage styles is with add_style -

+
+

The recommended way to manage styles is with add_style

-

-The collection of fonts used in this workbook -

+ +

The collection of fonts used in this workbook

@@ -1050,50 +1021,48 @@ The collection of fonts used in this workbook
Note: -

-The recommended way to manage styles is with add_style -

+
+

The recommended way to manage styles is with add_style

-

-numFmts for your styles. -

-
- The default styles, which change based on the system local, are as follows.
- id formatCode
-  0 General
-  1 0
-  2 0.00
-  3 #,##0
-  4 #,##0.00
-  9 0%
-  10 0.00%
-  11 0.00E+00
-  12 #   ?/?
-  13 #   ??/??
-  14 mm-dd-yy
-  15 d-mmm-yy
-  16 d-mmm
-  17 mmm-yy
-  18 h:mm AM/PM
-  19 h:mm:ss AM/PM
-  20 h:mm
-  21 h:mm:ss
-  22 m/d/yy h:mm
-  37 #,##0 ;(#,##0)
-  38 #,##0 ;[Red](#,##0)
-  39 #,##0.00;(#,##0.00)
-  40 #,##0.00;[Red](#,##0.00)
-  45 mm:ss
-  46 [h]:mm:ss
-  47 mmss.0
-  48 ##0.0E+0
-  49 @
- Axlsx also defines the following constants which you can use in add_style.
-    NUM_FMT_PERCENT formats to "0%"
-    NUM_FMT_YYYYMMDD formats to "yyyy/mm/dd"
-    NUM_FMT_YYYYMMDDHHMMSS  formats to "yyyy/mm/dd hh:mm:ss"
+
+

numFmts for your styles.

+ +
The default styles, which change based on the system local, are as follows.
+id formatCode
+ 0 General
+ 1 0
+ 2 0.00
+ 3 #,##0
+ 4 #,##0.00
+ 9 0%
+ 10 0.00%
+ 11 0.00E+00
+ 12 #   ?/?
+ 13 #   ??/??
+ 14 mm-dd-yy
+ 15 d-mmm-yy
+ 16 d-mmm
+ 17 mmm-yy
+ 18 h:mm AM/PM
+ 19 h:mm:ss AM/PM
+ 20 h:mm
+ 21 h:mm:ss
+ 22 m/d/yy h:mm
+ 37 #,##0 ;(#,##0)
+ 38 #,##0 ;[Red](#,##0)
+ 39 #,##0.00;(#,##0.00)
+ 40 #,##0.00;[Red](#,##0.00)
+ 45 mm:ss
+ 46 [h]:mm:ss
+ 47 mmss.0
+ 48 ##0.0E+0
+ 49 @
+Axlsx also defines the following constants which you can use in add_style.
+   NUM_FMT_PERCENT formats to "0%"
+   NUM_FMT_YYYYMMDD formats to "yyyy/mm/dd"
+   NUM_FMT_YYYYMMDDHHMMSS  formats to "yyyy/mm/dd hh:mm:ss"
 
@@ -1161,16 +1130,14 @@ numFmts for your styles.
Note: -

-The recommended way to manage styles is with add_style -

+
+

The recommended way to manage styles is with add_style

-

-The collection of table styles that will be available to the user in the -excel UI -

+ +

The collection of table styles that will be available to the user in the +excel UI

@@ -1236,9 +1203,8 @@ excel UI

-

-Drastically simplifies style creation and management. -

+ +

Drastically simplifies style creation and management.

@@ -1248,9 +1214,8 @@ Drastically simplifies style creation and management.

Examples:

-

-You Got Style -

+

+

You Got Style

require "rubygems" # if that is your preferred way to manage gems!
 require "axlsx"
@@ -1268,9 +1233,8 @@ You Got Style
 p.serialize(f)
 
-

-Styling specifically -

+

+

Styling specifically

# an example of applying specific styles to specific cells
 require "rubygems" # if that is your preferred way to manage gems!
@@ -1322,9 +1286,8 @@ Styling specifically
       
       
         —
-        

-a customizable set of options -

+
+

a customizable set of options

@@ -1343,9 +1306,8 @@ a customizable set of options - —

-The text color -

+ —
+

The text color

@@ -1355,9 +1317,8 @@ The text color - —

-The text size -

+ —
+

The text size

@@ -1367,9 +1328,8 @@ The text size - —

-Indicates if the text should be bold -

+ —
+

Indicates if the text should be bold

@@ -1379,9 +1339,8 @@ Indicates if the text should be bold - —

-Indicates if the text should be italicised -

+ —
+

Indicates if the text should be italicised

@@ -1391,9 +1350,8 @@ Indicates if the text should be italicised - —

-Indicates if the text should be rendered with a strikethrough -

+ —
+

Indicates if the text should be rendered with a strikethrough

@@ -1403,9 +1361,8 @@ Indicates if the text should be rendered with a strikethrough - —

-Indicates if the text should be rendered with a shadow -

+ —
+

Indicates if the text should be rendered with a shadow

@@ -1415,9 +1372,8 @@ Indicates if the text should be rendered with a shadow - —

-The character set to use. -

+ —
+

The character set to use.

@@ -1427,9 +1383,8 @@ The character set to use. - —

-The font family to use. -

+ —
+

The font family to use.

@@ -1439,9 +1394,8 @@ The font family to use. - —

-The name of the font to use -

+ —
+

The name of the font to use

@@ -1451,9 +1405,8 @@ The name of the font to use - —

-The number format to apply -

+ —
+

The number format to apply

@@ -1463,9 +1416,8 @@ The number format to apply - —

-The formatting to apply. If this is specified, num_fmt is ignored. -

+ —
+

The formatting to apply. If this is specified, num_fmt is ignored.

@@ -1475,9 +1427,8 @@ The formatting to apply. If this is specified, num_fmt is ignored. - —

-The border style to use. -

+ —
+

The border style to use.

@@ -1487,9 +1438,8 @@ The border style to use. - —

-The background color to apply to the cell -

+ —
+

The background color to apply to the cell

@@ -1499,9 +1449,8 @@ The background color to apply to the cell - —

-Indicates if the cell should be hidden -

+ —
+

Indicates if the cell should be hidden

@@ -1511,9 +1460,8 @@ Indicates if the cell should be hidden - —

-Indicates if the cell should be locked -

+ —
+

Indicates if the cell should be locked

@@ -1523,9 +1471,8 @@ Indicates if the cell should be locked - —

-A hash defining any of the attributes used in CellAlignment -

+ —
+

A hash defining any of the attributes used in CellAlignment

@@ -1681,9 +1628,8 @@ A hash defining any of the attributes used in CellAlignment

-

-Serializes the styles document -

+ +

Serializes the styles document

@@ -1745,7 +1691,7 @@ Serializes the styles document
diff --git a/doc/Axlsx/TableStyle.html b/doc/Axlsx/TableStyle.html index 2c563660..41cd0318 100644 --- a/doc/Axlsx/TableStyle.html +++ b/doc/Axlsx/TableStyle.html @@ -99,16 +99,14 @@
Note: -

-Table are not supported in this version and only the defaults required for -a valid workbook are created. -

+
+

Table are not supported in this version and only the defaults required for +a valid workbook are created.

-

-A single table style definition and is a collection for tableStyleElements -

+ +

A single table style definition and is a collection for tableStyleElements

@@ -144,9 +142,8 @@ A single table style definition and is a collection for tableStyleElements -

-The name of this table style. -

+
+

The name of this table style.

@@ -171,9 +168,8 @@ The name of this table style. -

-indicates if this style should be applied to pivot tables. -

+
+

indicates if this style should be applied to pivot tables.

@@ -198,9 +194,8 @@ indicates if this style should be applied to pivot tables. -

-indicates if this style should be applied to tables. -

+
+

indicates if this style should be applied to tables.

@@ -245,9 +240,8 @@ indicates if this style should be applied to tables. -

-creates a new TableStyle object. -

+
+

creates a new TableStyle object.

@@ -269,9 +263,8 @@ creates a new TableStyle object. -

-Serializes the table style. -

+
+

Serializes the table style.

@@ -297,9 +290,8 @@ Serializes the table style.

-

-creates a new TableStyle object -

+ +

creates a new TableStyle object

@@ -331,9 +323,8 @@ creates a new TableStyle object — -

-a customizable set of options -

+
+

a customizable set of options

@@ -380,9 +371,8 @@ a customizable set of options — -

-if name option is not provided. -

+
+

if name option is not provided.

@@ -446,9 +436,8 @@ if name option is not provided.

-

-The name of this table style -

+ +

The name of this table style

@@ -503,9 +492,8 @@ The name of this table style

-

-indicates if this style should be applied to pivot tables -

+ +

indicates if this style should be applied to pivot tables

@@ -560,9 +548,8 @@ indicates if this style should be applied to pivot tables

-

-indicates if this style should be applied to tables -

+ +

indicates if this style should be applied to tables

@@ -621,9 +608,8 @@ indicates if this style should be applied to tables

-

-Serializes the table style -

+ +

Serializes the table style

@@ -642,9 +628,8 @@ Serializes the table style — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -696,7 +681,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/TableStyleElement.html b/doc/Axlsx/TableStyleElement.html index fa9ef1a0..3b629497 100644 --- a/doc/Axlsx/TableStyleElement.html +++ b/doc/Axlsx/TableStyleElement.html @@ -97,16 +97,14 @@
Note: -

-tables and table styles are not supported in this version. This class -exists in preparation for that support. -

+
+

tables and table styles are not supported in this version. This class +exists in preparation for that support.

-

-an element of style that belongs to a table style. -

+ +

an element of style that belongs to a table style.

@@ -138,9 +136,8 @@ an element of style that belongs to a table style. -

-The dxfId this style element points to. -

+
+

The dxfId this style element points to.

@@ -165,10 +162,9 @@ The dxfId this style element points to. -

-Number of rows or columns used in striping when the type is firstRowStripe, -secondRowStripe, firstColumnStripe, or secondColumnStripe. -

+
+

Number of rows or columns used in striping when the type is firstRowStripe, +secondRowStripe, firstColumnStripe, or secondColumnStripe.

@@ -193,9 +189,8 @@ secondRowStripe, firstColumnStripe, or secondColumnStripe. -

-The type of style element. -

+
+

The type of style element.

@@ -232,9 +227,8 @@ The type of style element. -

-creates a new TableStyleElement object. -

+
+

creates a new TableStyleElement object.

@@ -256,9 +250,8 @@ creates a new TableStyleElement object. -

-Serializes the table style element. -

+
+

Serializes the table style element.

@@ -279,9 +272,8 @@ Serializes the table style element.

-

-creates a new TableStyleElement object -

+ +

creates a new TableStyleElement object

@@ -302,9 +294,8 @@ creates a new TableStyleElement object — -

-a customizable set of options -

+
+

a customizable set of options

@@ -391,9 +382,8 @@ a customizable set of options

-

-The dxfId this style element points to -

+ +

The dxfId this style element points to

@@ -448,10 +438,9 @@ The dxfId this style element points to

-

-Number of rows or columns used in striping when the type is firstRowStripe, -secondRowStripe, firstColumnStripe, or secondColumnStripe. -

+ +

Number of rows or columns used in striping when the type is firstRowStripe, +secondRowStripe, firstColumnStripe, or secondColumnStripe.

@@ -506,38 +495,37 @@ secondRowStripe, firstColumnStripe, or secondColumnStripe.

-

-The type of style element. The following type are allowed -

-
-  :wholeTable
-  :headerRow
-  :totalRow
-  :firstColumn
-  :lastColumn
-  :firstRowStripe
-  :secondRowStripe
-  :firstColumnStripe
-  :secondColumnStripe
-  :firstHeaderCell
-  :lastHeaderCell
-  :firstTotalCell
-  :lastTotalCell
-  :firstSubtotalColumn
-  :secondSubtotalColumn
-  :thirdSubtotalColumn
-  :firstSubtotalRow
-  :secondSubtotalRow
-  :thirdSubtotalRow
-  :blankRow
-  :firstColumnSubheading
-  :secondColumnSubheading
-  :thirdColumnSubheading
-  :firstRowSubheading
-  :secondRowSubheading
-  :thirdRowSubheading
-  :pageFieldLabels
-  :pageFieldValues
+    
+

The type of style element. The following type are allowed

+ +
:wholeTable
+:headerRow
+:totalRow
+:firstColumn
+:lastColumn
+:firstRowStripe
+:secondRowStripe
+:firstColumnStripe
+:secondColumnStripe
+:firstHeaderCell
+:lastHeaderCell
+:firstTotalCell
+:lastTotalCell
+:firstSubtotalColumn
+:secondSubtotalColumn
+:thirdSubtotalColumn
+:firstSubtotalRow
+:secondSubtotalRow
+:thirdSubtotalRow
+:blankRow
+:firstColumnSubheading
+:secondColumnSubheading
+:thirdColumnSubheading
+:firstRowSubheading
+:secondRowSubheading
+:thirdRowSubheading
+:pageFieldLabels
+:pageFieldValues
 
@@ -597,9 +585,8 @@ The type of style element. The following type are allowed

-

-Serializes the table style element -

+ +

Serializes the table style element

@@ -618,9 +605,8 @@ Serializes the table style element — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -668,7 +654,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/TableStyles.html b/doc/Axlsx/TableStyles.html index b86cd4b8..4f265099 100644 --- a/doc/Axlsx/TableStyles.html +++ b/doc/Axlsx/TableStyles.html @@ -99,18 +99,16 @@
Note: -

-Support for custom table styles does not exist in this version. Many of the +

+

Support for custom table styles does not exist in this version. Many of the classes required are defined in preparation for future release. Please do -not attempt to add custom table styles. -

+not attempt to add custom table styles.

-

-TableStyles represents a collection of style definitions for table styles -and pivot table styles. -

+ +

TableStyles represents a collection of style definitions for table styles +and pivot table styles.

@@ -146,9 +144,8 @@ and pivot table styles. -

-The default pivot table style. -

+
+

The default pivot table style.

@@ -173,9 +170,8 @@ The default pivot table style. -

-The default table style. -

+
+

The default table style.

@@ -220,10 +216,9 @@ The default table style. -

-Creates a new TableStyles object that is a container for TableStyle -objects. -

+
+

Creates a new TableStyles object that is a container for TableStyle +objects.

@@ -245,9 +240,8 @@ objects. -

-Serializes the table styles element. -

+
+

Serializes the table styles element.

@@ -273,9 +267,8 @@ Serializes the table styles element.

-

-Creates a new TableStyles object that is a container for TableStyle objects -

+ +

Creates a new TableStyles object that is a container for TableStyle objects

@@ -296,9 +289,8 @@ Creates a new TableStyles object that is a container for TableStyle objects — -

-a customizable set of options -

+
+

a customizable set of options

@@ -386,10 +378,8 @@ a customizable set of options

-

-The default pivot table style. The default value is -‘PivotStyleLight6’ -

+ +

The default pivot table style. The default value is ‘PivotStyleLight6’

@@ -444,10 +434,8 @@ The default pivot table style. The default value is

-

-The default table style. The default value is -‘TableStyleMedium9’ -

+ +

The default table style. The default value is ‘TableStyleMedium9’

@@ -506,9 +494,8 @@ The default table style. The default value is

-

-Serializes the table styles element -

+ +

Serializes the table styles element

@@ -527,9 +514,8 @@ Serializes the table styles element — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -585,7 +571,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Title.html b/doc/Axlsx/Title.html index a027360a..d4b7daf6 100644 --- a/doc/Axlsx/Title.html +++ b/doc/Axlsx/Title.html @@ -94,9 +94,8 @@

Overview

-

-A Title stores information about the title of a chart -

+ +

A Title stores information about the title of a chart

@@ -132,9 +131,8 @@ A Title stores information about the title of a chart -

-The cell that holds the text for the title. -

+
+

The cell that holds the text for the title.

@@ -159,9 +157,8 @@ The cell that holds the text for the title. -

-The text to be shown. -

+
+

The text to be shown.

@@ -198,9 +195,8 @@ The text to be shown. -

-Creates a new Title object. -

+
+

Creates a new Title object.

@@ -222,9 +218,8 @@ Creates a new Title object. -

-Serializes the chart title. -

+
+

Serializes the chart title.

@@ -245,9 +240,8 @@ Serializes the chart title.

-

-Creates a new Title object -

+ +

Creates a new Title object

@@ -268,9 +262,8 @@ Creates a new Title object — -

-The cell or string to be used for the chart’s title -

+
+

The cell or string to be used for the chart’s title

@@ -319,10 +312,9 @@ The cell or string to be used for the chart’s title

-

-The cell that holds the text for the title. Setting this property will -automatically update the text attribute. -

+ +

The cell that holds the text for the title. Setting this property will +automatically update the text attribute.

@@ -377,10 +369,9 @@ automatically update the text attribute.

-

-The text to be shown. Setting this property directly with a string will -remove the cell reference. -

+ +

The text to be shown. Setting this property directly with a string will +remove the cell reference.

@@ -439,9 +430,8 @@ remove the cell reference.

-

-Serializes the chart title -

+ +

Serializes the chart title

@@ -460,9 +450,8 @@ Serializes the chart title — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -534,7 +523,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/TwoCellAnchor.html b/doc/Axlsx/TwoCellAnchor.html index 88616ceb..388b1e26 100644 --- a/doc/Axlsx/TwoCellAnchor.html +++ b/doc/Axlsx/TwoCellAnchor.html @@ -97,16 +97,14 @@
Note: -

-The recommended way to manage drawings and charts is Worksheet#add_chart. -Anchors are specified by the :start_at and :end_at options to that method. -

+
+

The recommended way to manage drawings and charts is Worksheet#add_chart. +Anchors are specified by the :start_at and :end_at options to that method.

-

-This class details the anchor points for drawings. -

+ +

This class details the anchor points for drawings.

@@ -145,9 +143,8 @@ This class details the anchor points for drawings. -

-The drawing that holds this anchor. -

+
+

The drawing that holds this anchor.

@@ -172,9 +169,8 @@ The drawing that holds this anchor. -

-A marker that defines the from cell anchor. -

+
+

A marker that defines the from cell anchor.

@@ -199,9 +195,8 @@ A marker that defines the from cell anchor. -

-The object this anchor hosts. -

+
+

The object this anchor hosts.

@@ -226,9 +221,8 @@ The object this anchor hosts. -

-A marker that returns the to cell anchor. -

+
+

A marker that returns the to cell anchor.

@@ -263,9 +257,8 @@ A marker that returns the to cell anchor. -

-Creates a graphic frame and chart object associated with this anchor. -

+
+

Creates a graphic frame and chart object associated with this anchor.

@@ -287,9 +280,8 @@ Creates a graphic frame and chart object associated with this anchor. -

-The index of this anchor in the drawing. -

+
+

The index of this anchor in the drawing.

@@ -313,10 +305,9 @@ The index of this anchor in the drawing. -

-Creates a new TwoCellAnchor object and sets up a reference to the from and -to markers in the graphic_frame’s chart. -

+
+

Creates a new TwoCellAnchor object and sets up a reference to the from and +to markers in the graphic_frame’s chart.

@@ -338,9 +329,8 @@ to markers in the graphic_frame’s chart. -

-Serializes the two cell anchor. -

+
+

Serializes the two cell anchor.

@@ -364,17 +354,15 @@ Serializes the two cell anchor.
Note: -

-the chart_type parameter will be replaced with object in v. 2.0.0 -

+
+

the chart_type parameter will be replaced with object in v. 2.0.0

-

-Creates a new TwoCellAnchor object and sets up a reference to the from and -to markers in the graphic_frame’s chart. That means that you can do -stuff like c = worksheet.add_chart Axlsx::Chart c.start_at 5, 9 -

+ +

Creates a new TwoCellAnchor object and sets up a reference to the from and +to markers in the graphic_frame’s chart. That means that you can do +stuff like c = worksheet.add_chart Axlsx::Chart c.start_at 5, 9

@@ -404,10 +392,9 @@ stuff like c = worksheet.add_chart Axlsx::Chart c.start_at 5, 9 — -

-This is passed to the graphic frame for instantiation. must be Chart or a -subclass of Chart -

+
+

This is passed to the graphic frame for instantiation. must be Chart or a +subclass of Chart

@@ -422,9 +409,8 @@ subclass of Chart — -

-The object this anchor holds. -

+
+

The object this anchor holds.

@@ -441,9 +427,8 @@ The object this anchor holds. — -

-a customizable set of options -

+
+

a customizable set of options

@@ -464,9 +449,8 @@ a customizable set of options - —

-the col, row to start at -

+ —
+

the col, row to start at

@@ -476,9 +460,8 @@ the col, row to start at - —

-the col, row to end at -

+ —
+

the col, row to end at

@@ -529,9 +512,8 @@ the col, row to end at

-

-The drawing that holds this anchor -

+ +

The drawing that holds this anchor

@@ -586,10 +568,9 @@ The drawing that holds this anchor

-

-A marker that defines the from cell anchor. The default from column and row -are 0 and 0 respectively -

+ +

A marker that defines the from cell anchor. The default from column and row +are 0 and 0 respectively

@@ -644,9 +625,8 @@ are 0 and 0 respectively

-

-The object this anchor hosts -

+ +

The object this anchor hosts

@@ -701,10 +681,9 @@ The object this anchor hosts

-

-A marker that returns the to cell anchor. The default to column and row are -5 and 10 respectively -

+ +

A marker that returns the to cell anchor. The default to column and row are +5 and 10 respectively

@@ -763,9 +742,8 @@ A marker that returns the to cell anchor. The default to column and row are

-

-Creates a graphic frame and chart object associated with this anchor -

+ +

Creates a graphic frame and chart object associated with this anchor

@@ -819,9 +797,8 @@ Creates a graphic frame and chart object associated with this anchor

-

-The index of this anchor in the drawing -

+ +

The index of this anchor in the drawing

@@ -873,9 +850,8 @@ The index of this anchor in the drawing

-

-Serializes the two cell anchor -

+ +

Serializes the two cell anchor

@@ -894,9 +870,8 @@ Serializes the two cell anchor — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -964,7 +939,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/ValAxis.html b/doc/Axlsx/ValAxis.html index 3f37db0e..4096a451 100644 --- a/doc/Axlsx/ValAxis.html +++ b/doc/Axlsx/ValAxis.html @@ -96,9 +96,8 @@

Overview

-

-the ValAxis class defines a chart value axis. -

+ +

the ValAxis class defines a chart value axis.

@@ -134,9 +133,8 @@ the ValAxis class defines a chart value axis. -

-This element specifies how the value axis crosses the category axis. -

+
+

This element specifies how the value axis crosses the category axis.

@@ -181,9 +179,8 @@ This element specifies how the value axis crosses the category axis. -

-Creates a new ValAxis object. -

+
+

Creates a new ValAxis object.

@@ -205,9 +202,8 @@ Creates a new ValAxis object. -

-Serializes the value axis. -

+
+

Serializes the value axis.

@@ -233,9 +229,8 @@ Serializes the value axis.

-

-Creates a new ValAxis object -

+ +

Creates a new ValAxis object

@@ -254,9 +249,8 @@ Creates a new ValAxis object — -

-the id of this axis -

+
+

the id of this axis

@@ -271,9 +265,8 @@ the id of this axis — -

-the id of the perpendicular axis -

+
+

the id of the perpendicular axis

@@ -290,9 +283,8 @@ the id of the perpendicular axis — -

-a customizable set of options -

+
+

a customizable set of options

@@ -390,10 +382,9 @@ a customizable set of options

-

-This element specifies how the value axis crosses the category axis. must -be one of [:between, :midCat] -

+ +

This element specifies how the value axis crosses the category axis. must +be one of [:between, :midCat]

@@ -452,9 +443,8 @@ be one of [:between, :midCat]

-

-Serializes the value axis -

+ +

Serializes the value axis

@@ -473,9 +463,8 @@ Serializes the value axis — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -529,7 +518,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/ValAxisData.html b/doc/Axlsx/ValAxisData.html index 61811a25..cbc2210f 100644 --- a/doc/Axlsx/ValAxisData.html +++ b/doc/Axlsx/ValAxisData.html @@ -98,9 +98,8 @@

Overview

-

-The ValAxisData class manages the values for a chart value series. -

+ +

The ValAxisData class manages the values for a chart value series.

@@ -156,9 +155,8 @@ The ValAxisData class manages the values for a chart value series. -

-Serializes the value axis data. -

+
+

Serializes the value axis data.

@@ -213,9 +211,8 @@ Serializes the value axis data.

-

-Serializes the value axis data -

+ +

Serializes the value axis data

@@ -234,9 +231,8 @@ Serializes the value axis data — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -312,7 +308,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/View3D.html b/doc/Axlsx/View3D.html index 382f182c..324478c2 100644 --- a/doc/Axlsx/View3D.html +++ b/doc/Axlsx/View3D.html @@ -94,9 +94,8 @@

Overview

-

-3D attributes for a chart. -

+ +

3D attributes for a chart.

@@ -112,9 +111,8 @@
H_PERCENT_REGEX =
-

-Validation for hPercent -

+ +

Validation for hPercent

@@ -130,9 +128,8 @@ Validation for hPercent
DEPTH_PERCENT_REGEX =
-

-validation for depthPercent -

+ +

validation for depthPercent

@@ -171,9 +168,8 @@ validation for depthPercent -

-depth or chart as % of chart width must be between 20% and 2000%. -

+
+

depth or chart as % of chart width must be between 20% and 2000%.

@@ -198,9 +194,8 @@ depth or chart as % of chart width must be between 20% and 2000%. -

-height of chart as % of chart must be between 5% and 500%. -

+
+

height of chart as % of chart must be between 5% and 500%.

@@ -225,9 +220,8 @@ height of chart as % of chart must be between 5% and 500%. -

-field of view angle. -

+
+

field of view angle.

@@ -252,9 +246,8 @@ field of view angle. -

-Chart axis are at right angles. -

+
+

Chart axis are at right angles.

@@ -279,9 +272,8 @@ Chart axis are at right angles. -

-x rotation for the chart must be between -90 and 90. -

+
+

x rotation for the chart must be between -90 and 90.

@@ -306,9 +298,8 @@ x rotation for the chart must be between -90 and 90. -

-y rotation for the chart must be between 0 and 360. -

+
+

y rotation for the chart must be between 0 and 360.

@@ -345,9 +336,8 @@ y rotation for the chart must be between 0 and 360. -

-Creates a new View3D for charts. -

+
+

Creates a new View3D for charts.

@@ -369,9 +359,8 @@ Creates a new View3D for charts. -

-Serializes the view3D properties. -

+
+

Serializes the view3D properties.

@@ -392,9 +381,8 @@ Serializes the view3D properties.

-

-Creates a new View3D for charts -

+ +

Creates a new View3D for charts

@@ -415,9 +403,8 @@ Creates a new View3D for charts — -

-a customizable set of options -

+
+

a customizable set of options

@@ -533,9 +520,8 @@ a customizable set of options

-

-depth or chart as % of chart width must be between 20% and 2000% -

+ +

depth or chart as % of chart width must be between 20% and 2000%

@@ -590,9 +576,8 @@ depth or chart as % of chart width must be between 20% and 2000%

-

-height of chart as % of chart must be between 5% and 500% -

+ +

height of chart as % of chart must be between 5% and 500%

@@ -647,9 +632,8 @@ height of chart as % of chart must be between 5% and 500%

-

-field of view angle -

+ +

field of view angle

@@ -704,9 +688,8 @@ field of view angle

-

-Chart axis are at right angles -

+ +

Chart axis are at right angles

@@ -761,9 +744,8 @@ Chart axis are at right angles

-

-x rotation for the chart must be between -90 and 90 -

+ +

x rotation for the chart must be between -90 and 90

@@ -818,9 +800,8 @@ x rotation for the chart must be between -90 and 90

-

-y rotation for the chart must be between 0 and 360 -

+ +

y rotation for the chart must be between 0 and 360

@@ -879,9 +860,8 @@ y rotation for the chart must be between 0 and 360

-

-Serializes the view3D properties -

+ +

Serializes the view3D properties

@@ -900,9 +880,8 @@ Serializes the view3D properties — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -964,7 +943,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/Axlsx/Workbook.html b/doc/Axlsx/Workbook.html index 6d18fd7c..915b139b 100644 --- a/doc/Axlsx/Workbook.html +++ b/doc/Axlsx/Workbook.html @@ -94,32 +94,31 @@

Overview

-

-The Workbook class is an xlsx workbook that manages worksheets, charts, + +

The Workbook class is an xlsx workbook that manages worksheets, charts, drawings and styles. The following parts of the Office Open XML spreadsheet -specification are not implimented in this version. -

-
-  bookViews
-  calcPr
-  customWorkbookViews
-  definedNames
-  externalReferences
-  extLst
-  fileRecoveryPr
-  fileSharing
-  fileVersion
-  functionGroups
-  oleSize
-  pivotCaches
-  smartTagPr
-  smartTagTypes
-  webPublishing
-  webPublishObjects
-  workbookProtection
-  workbookPr*
-
-  *workbookPr is only supported to the extend of date1904
+specification are not implimented in this version.

+ +
bookViews
+calcPr
+customWorkbookViews
+definedNames
+externalReferences
+extLst
+fileRecoveryPr
+fileSharing
+fileVersion
+functionGroups
+oleSize
+pivotCaches
+smartTagPr
+smartTagTypes
+webPublishing
+webPublishObjects
+workbookProtection
+workbookPr*
+
+*workbookPr is only supported to the extend of date1904
 
@@ -136,10 +135,9 @@ specification are not implimented in this version.
@@date1904 =
-

-Indicates if the epoc date for serialization should be 1904. If false, 1900 -is used. -

+ +

Indicates if the epoc date for serialization should be 1904. If false, 1900 +is used.

@@ -178,9 +176,8 @@ is used. -

-A colllection of charts associated with this workbook. -

+
+

A colllection of charts associated with this workbook.

@@ -205,9 +202,8 @@ A colllection of charts associated with this workbook. -

-A colllection of drawings associated with this workbook. -

+
+

A colllection of drawings associated with this workbook.

@@ -232,9 +228,8 @@ A colllection of drawings associated with this workbook. -

-A colllection of images associated with this workbook. -

+
+

A colllection of images associated with this workbook.

@@ -259,9 +254,8 @@ A colllection of images associated with this workbook. -

-A collection of worksheets associated with this workbook. -

+
+

A collection of worksheets associated with this workbook.

@@ -296,9 +290,8 @@ A collection of worksheets associated with this workbook. -

-retrieves the date1904 attribute. -

+
+

retrieves the date1904 attribute.

@@ -320,9 +313,8 @@ retrieves the date1904 attribute. -

-Sets the date1904 attribute to the provided boolean. -

+
+

Sets the date1904 attribute to the provided boolean.

@@ -353,9 +345,8 @@ Sets the date1904 attribute to the provided boolean. -

-Adds a worksheet to this workbook. -

+
+

Adds a worksheet to this workbook.

@@ -377,9 +368,8 @@ Adds a worksheet to this workbook. -

-Instance level access to the class variable 1904. -

+
+

Instance level access to the class variable 1904.

@@ -401,9 +391,8 @@ Instance level access to the class variable 1904. -

-see @date1904. -

+
+

see @date1904.

@@ -427,9 +416,8 @@ see @date1904. -

-Creates a new Workbook. -

+
+

Creates a new Workbook.

@@ -451,9 +439,8 @@ Creates a new Workbook. -

-The workbook relationships. -

+
+

The workbook relationships.

@@ -475,9 +462,8 @@ The workbook relationships. -

-The styles associated with this workbook. -

+
+

The styles associated with this workbook.

@@ -499,9 +485,8 @@ The styles associated with this workbook. -

-Serializes the workbook document. -

+
+

Serializes the workbook document.

@@ -522,9 +507,8 @@ Serializes the workbook document.

-

-Creates a new Workbook -

+ +

Creates a new Workbook

@@ -545,9 +529,8 @@ Creates a new Workbook — -

-a customizable set of options -

+
+

a customizable set of options

@@ -598,9 +581,8 @@ a customizable set of options — -

-the object that the method was called on -

+
+

the object that the method was called on

@@ -661,15 +643,13 @@ the object that the method was called on
Note: -

-The recommended way to manage charts is Worksheet#add_chart -

+
+

The recommended way to manage charts is Worksheet#add_chart

-

-A colllection of charts associated with this workbook -

+ +

A colllection of charts associated with this workbook

@@ -736,15 +716,13 @@ A colllection of charts associated with this workbook
Note: -

-The recommended way to manage drawings is Worksheet#add_chart -

+
+

The recommended way to manage drawings is Worksheet#add_chart

-

-A colllection of drawings associated with this workbook -

+ +

A colllection of drawings associated with this workbook

@@ -811,15 +789,13 @@ A colllection of drawings associated with this workbook
Note: -

-The recommended way to manage images is Worksheet#add_image -

+
+

The recommended way to manage images is Worksheet#add_image

-

-A colllection of images associated with this workbook -

+ +

A colllection of images associated with this workbook

@@ -886,15 +862,13 @@ A colllection of images associated with this workbook
Note: -

-The recommended way to manage worksheets is add_worksheet -

+
+

The recommended way to manage worksheets is add_worksheet

-

-A collection of worksheets associated with this workbook. -

+ +

A collection of worksheets associated with this workbook.

@@ -962,9 +936,8 @@ A collection of worksheets associated with this workbook.

-

-retrieves the date1904 attribute -

+ +

retrieves the date1904 attribute

@@ -1012,9 +985,8 @@ retrieves the date1904 attribute

-

-Sets the date1904 attribute to the provided boolean -

+ +

Sets the date1904 attribute to the provided boolean

@@ -1068,9 +1040,8 @@ Sets the date1904 attribute to the provided boolean

-

-Adds a worksheet to this workbook -

+ +

Adds a worksheet to this workbook

@@ -1091,9 +1062,8 @@ Adds a worksheet to this workbook — -

-a customizable set of options -

+
+

a customizable set of options

@@ -1112,9 +1082,8 @@ a customizable set of options - —

-The name of the worksheet. -

+ —
+

The name of the worksheet.

@@ -1190,9 +1159,8 @@ The name of the worksheet.

-

-Instance level access to the class variable 1904 -

+ +

Instance level access to the class variable 1904

@@ -1240,9 +1208,8 @@ Instance level access to the class variable 1904

-

-see @date1904 -

+ +

see @date1904

@@ -1277,9 +1244,8 @@ see @date1904

-

-The workbook relationships. This is managed automatically by the workbook -

+ +

The workbook relationships. This is managed automatically by the workbook

@@ -1344,15 +1310,13 @@ The workbook relationships. This is managed automatically by the workbook
Note: -

-The recommended way to manage styles is Styles#add_style -

+
+

The recommended way to manage styles is Styles#add_style

-

-The styles associated with this workbook -

+ +

The styles associated with this workbook

@@ -1428,9 +1392,8 @@ The styles associated with this workbook

-

-Serializes the workbook document -

+ +

Serializes the workbook document

@@ -1500,7 +1463,7 @@ Serializes the workbook document
diff --git a/doc/Axlsx/Worksheet.html b/doc/Axlsx/Worksheet.html index 1672e4c7..39bd418b 100644 --- a/doc/Axlsx/Worksheet.html +++ b/doc/Axlsx/Worksheet.html @@ -94,9 +94,8 @@

Overview

-

-The Worksheet class represents a worksheet in the workbook. -

+ +

The Worksheet class represents a worksheet in the workbook.

@@ -128,9 +127,8 @@ The Worksheet class represents a worksheet in the workbook. -

-An array of content based calculated column widths. -

+
+

An array of content based calculated column widths.

@@ -155,9 +153,8 @@ An array of content based calculated column widths. -

-The name of the worksheet. -

+
+

The name of the worksheet.

@@ -182,9 +179,8 @@ The name of the worksheet. -

-The rows in this worksheet. -

+
+

The rows in this worksheet.

@@ -209,9 +205,8 @@ The rows in this worksheet. -

-The workbook that owns this worksheet. -

+
+

The workbook that owns this worksheet.

@@ -246,9 +241,8 @@ The workbook that owns this worksheet. -

-Adds a chart to this worksheets drawing. -

+
+

Adds a chart to this worksheets drawing.

@@ -270,9 +264,8 @@ Adds a chart to this worksheets drawing. -

-Adds a media item to the worksheets drawing. -

+
+

Adds a media item to the worksheets drawing.

@@ -294,9 +287,8 @@ Adds a media item to the worksheets drawing. -

-Adds a row to the worksheet and updates auto fit data. -

+
+

Adds a row to the worksheet and updates auto fit data.

@@ -318,9 +310,8 @@ Adds a row to the worksheet and updates auto fit data. -

-Determines the proper width for a column based on content. -

+
+

Determines the proper width for a column based on content.

@@ -342,9 +333,8 @@ Determines the proper width for a column based on content. -

-Set the style for cells in a specific column. -

+
+

Set the style for cells in a specific column.

@@ -366,9 +356,8 @@ Set the style for cells in a specific column. -

-returns the sheet data as columnw. -

+
+

returns the sheet data as columnw.

@@ -390,9 +379,8 @@ returns the sheet data as columnw. -

-The drawing associated with this worksheet. -

+
+

The drawing associated with this worksheet.

@@ -414,9 +402,8 @@ The drawing associated with this worksheet. -

-The index of this worksheet in the owning Workbook’s worksheets list. -

+
+

The index of this worksheet in the owning Workbook’s worksheets list.

@@ -440,9 +427,8 @@ The index of this worksheet in the owning Workbook’s worksheets list. -

-Creates a new worksheet. -

+
+

Creates a new worksheet.

@@ -464,9 +450,8 @@ Creates a new worksheet. -

-The part name of this worksheet. -

+
+

The part name of this worksheet.

@@ -488,9 +473,8 @@ The part name of this worksheet. -

-The worksheet relationships. -

+
+

The worksheet relationships.

@@ -512,9 +496,8 @@ The worksheet relationships. -

-The relationship part name of this worksheet. -

+
+

The relationship part name of this worksheet.

@@ -536,9 +519,8 @@ The relationship part name of this worksheet. -

-The relationship Id of thiw worksheet. -

+
+

The relationship Id of thiw worksheet.

@@ -560,9 +542,8 @@ The relationship Id of thiw worksheet. -

-Set the style for cells in a specific row. -

+
+

Set the style for cells in a specific row.

@@ -584,9 +565,8 @@ Set the style for cells in a specific row. -

-Serializes the worksheet document. -

+
+

Serializes the worksheet document.

@@ -608,9 +588,8 @@ Serializes the worksheet document. -

-Updates auto fit data. -

+
+

Updates auto fit data.

@@ -634,15 +613,13 @@ Updates auto fit data.
Note: -

-the recommended way to manage worksheets is Workbook#add_worksheet -

+
+

the recommended way to manage worksheets is Workbook#add_worksheet

-

-Creates a new worksheet. -

+ +

Creates a new worksheet.

@@ -663,9 +640,8 @@ Creates a new worksheet. — -

-a customizable set of options -

+
+

a customizable set of options

@@ -686,9 +662,8 @@ a customizable set of options - —

-The name of this sheet. -

+ —
+

The name of this sheet.

@@ -759,16 +734,14 @@ The name of this sheet.
Note: -

-a single auto fit data item is a hash with :longest => [String] and -:sz=> [Integer] members. -

+
+

a single auto fit data item is a hash with :longest => [String] and +:sz=> [Integer] members.

-

-An array of content based calculated column widths. -

+ +

An array of content based calculated column widths.

@@ -786,9 +759,8 @@ An array of content based calculated column widths. — -

-of Hash -

+
+

of Hash

@@ -829,9 +801,8 @@ of Hash

-

-The name of the worksheet -

+ +

The name of the worksheet

@@ -889,15 +860,13 @@ The name of the worksheet
Note: -

-The recommended way to manage rows is Worksheet#add_row -

+
+

The recommended way to manage rows is Worksheet#add_row

-

-The rows in this worksheet -

+ +

The rows in this worksheet

@@ -959,9 +928,8 @@ The rows in this worksheet

-

-The workbook that owns this worksheet -

+ +

The workbook that owns this worksheet

@@ -1023,18 +991,16 @@ The workbook that owns this worksheet
Note: -

-each chart type also specifies additional options -

+
+

each chart type also specifies additional options

-

-Adds a chart to this worksheets drawing. This is the recommended way to + +

Adds a chart to this worksheets drawing. This is the recommended way to create charts for your worksheet. This method wraps the complexity of dealing with ooxml drawing, anchors, markers graphic frames chart objects -and all the other dirty details. -

+and all the other dirty details.

@@ -1066,9 +1032,8 @@ and all the other dirty details. — -

-a customizable set of options -

+
+

a customizable set of options

@@ -1195,9 +1160,8 @@ a customizable set of options

-

-Adds a media item to the worksheets drawing -

+ +

Adds a media item to the worksheets drawing

@@ -1229,9 +1193,8 @@ Adds a media item to the worksheets drawing — -

-a customizable set of options -

+
+

a customizable set of options

@@ -1250,9 +1213,8 @@ a customizable set of options - —

-unknown -

+ —
+

unknown

@@ -1308,9 +1270,8 @@ unknown

-

-Adds a row to the worksheet and updates auto fit data -

+ +

Adds a row to the worksheet and updates auto fit data

@@ -1331,9 +1292,8 @@ Adds a row to the worksheet and updates auto fit data — -

-a customizable set of options -

+
+

a customizable set of options

@@ -1445,20 +1405,18 @@ a customizable set of options
Note: -

-From ECMA docs -

-
- Column width measured as the number of characters of the maximum digit width of the numbers 0 .. 9 as
- rendered in the normal style's font. There are 4 pixels of margin padding (two on each side), plus 1 pixel padding for the gridlines.
- width = Truncate([!{Number of Characters} * !{Maximum Digit Width} + !{5 pixel padding}]/{Maximum Digit Width}*256)/256
+    
+

From ECMA docs

+ +
Column width measured as the number of characters of the maximum digit width of the numbers 0 .. 9 as 
+rendered in the normal style's font. There are 4 pixels of margin padding (two on each side), plus 1 pixel padding for the gridlines.
+width = Truncate([!{Number of Characters} * !{Maximum Digit Width} + !{5 pixel padding}]/{Maximum Digit Width}*256)/256
 
-

-Determines the proper width for a column based on content. -

+ +

Determines the proper width for a column based on content.

@@ -1477,9 +1435,8 @@ Determines the proper width for a column based on content. — -

-hash of auto_fit_data -

+
+

hash of auto_fit_data

@@ -1550,16 +1507,14 @@ hash of auto_fit_data
Note: -

-You can also specify the style for specific columns in the call to add_row -by using an array for the :styles option -

+
+

You can also specify the style for specific columns in the call to add_row +by using an array for the :styles option

-

-Set the style for cells in a specific column -

+ +

Set the style for cells in a specific column

@@ -1578,9 +1533,8 @@ Set the style for cells in a specific column — -

-the index of the column -

+
+

the index of the column

@@ -1595,9 +1549,8 @@ the index of the column — -

-cellXfs index -

+
+

cellXfs index

@@ -1614,9 +1567,8 @@ cellXfs index — -

-a customizable set of options -

+
+

a customizable set of options

@@ -1639,9 +1591,8 @@ a customizable set of options - —

-only cells after this column will be updated. -

+ —
+

only cells after this column will be updated.

@@ -1705,9 +1656,8 @@ only cells after this column will be updated.

-

-returns the sheet data as columnw -

+ +

returns the sheet data as columnw

@@ -1749,15 +1699,13 @@ returns the sheet data as columnw
Note: -

-the recommended way to work with drawings and charts is Worksheet#add_chart -

+
+

the recommended way to work with drawings and charts is Worksheet#add_chart

-

-The drawing associated with this worksheet. -

+ +

The drawing associated with this worksheet.

@@ -1816,9 +1764,8 @@ The drawing associated with this worksheet.

-

-The index of this worksheet in the owning Workbook’s worksheets list. -

+ +

The index of this worksheet in the owning Workbook’s worksheets list.

@@ -1870,9 +1817,8 @@ The index of this worksheet in the owning Workbook’s worksheets list.

-

-The part name of this worksheet -

+ +

The part name of this worksheet

@@ -1924,9 +1870,8 @@ The part name of this worksheet

-

-The worksheet relationships. This is managed automatically by the worksheet -

+ +

The worksheet relationships. This is managed automatically by the worksheet

@@ -1982,9 +1927,8 @@ The worksheet relationships. This is managed automatically by the worksheet

-

-The relationship part name of this worksheet -

+ +

The relationship part name of this worksheet

@@ -2036,9 +1980,8 @@ The relationship part name of this worksheet

-

-The relationship Id of thiw worksheet -

+ +

The relationship Id of thiw worksheet

@@ -2093,15 +2036,13 @@ The relationship Id of thiw worksheet
Note: -

-You can also specify the style in the add_row call -

+
+

You can also specify the style in the add_row call

-

-Set the style for cells in a specific row -

+ +

Set the style for cells in a specific row

@@ -2120,9 +2061,8 @@ Set the style for cells in a specific row — -

-or range of indexes in the table -

+
+

or range of indexes in the table

@@ -2137,9 +2077,8 @@ or range of indexes in the table — -

-cellXfs index -

+
+

cellXfs index

@@ -2156,9 +2095,8 @@ cellXfs index — -

-a customizable set of options -

+
+

a customizable set of options

@@ -2181,9 +2119,8 @@ a customizable set of options - —

-only cells after this column will be updated. -

+ —
+

only cells after this column will be updated.

@@ -2243,9 +2180,8 @@ only cells after this column will be updated.

-

-Serializes the worksheet document -

+ +

Serializes the worksheet document

@@ -2333,11 +2269,10 @@ Serializes the worksheet document

-

-Updates auto fit data. Autofit data attempts to determine the cell in a + +

Updates auto fit data. Autofit data attempts to determine the cell in a column that has the greatest width by comparing the length of the text -multiplied by the size of the font. -

+multiplied by the size of the font.

@@ -2356,9 +2291,8 @@ multiplied by the size of the font. — -

-an array of cells -

+
+

an array of cells

@@ -2376,9 +2310,8 @@ an array of cells — -

-of Cell objects -

+
+

of Cell objects

@@ -2444,7 +2377,7 @@ of Cell objects
diff --git a/doc/Axlsx/Xf.html b/doc/Axlsx/Xf.html index 6f54c8c0..4c839a3e 100644 --- a/doc/Axlsx/Xf.html +++ b/doc/Axlsx/Xf.html @@ -94,10 +94,9 @@

Overview

-

-The Xf class defines a formatting record for use in Styles. The recommended -way to manage styles for your workbook is with Styles#add_style -

+ +

The Xf class defines a formatting record for use in Styles. The recommended +way to manage styles for your workbook is with Styles#add_style

@@ -136,9 +135,8 @@ way to manage styles for your workbook is with Styles#add_style -

-The cell alignment for this style. -

+
+

The cell alignment for this style.

@@ -163,9 +161,8 @@ The cell alignment for this style. -

-Indicates if the alignment options should be applied. -

+
+

Indicates if the alignment options should be applied.

@@ -190,9 +187,8 @@ Indicates if the alignment options should be applied. -

-indicates if the borderId should be applied. -

+
+

indicates if the borderId should be applied.

@@ -217,9 +213,8 @@ indicates if the borderId should be applied. -

-indicates if the fillId should be applied. -

+
+

indicates if the fillId should be applied.

@@ -244,9 +239,8 @@ indicates if the fillId should be applied. -

-indicates if the fontId should be applied. -

+
+

indicates if the fontId should be applied.

@@ -271,9 +265,8 @@ indicates if the fontId should be applied. -

-indicates if the numFmtId should be applied. -

+
+

indicates if the numFmtId should be applied.

@@ -298,9 +291,8 @@ indicates if the numFmtId should be applied. -

-Indicates if the protection options should be applied. -

+
+

Indicates if the protection options should be applied.

@@ -325,9 +317,8 @@ Indicates if the protection options should be applied. -

-index (0 based) of the border to be used in this style. -

+
+

index (0 based) of the border to be used in this style.

@@ -352,9 +343,8 @@ index (0 based) of the border to be used in this style. -

-index (0 based) of the fill to be used in this style. -

+
+

index (0 based) of the fill to be used in this style.

@@ -379,9 +369,8 @@ index (0 based) of the fill to be used in this style. -

-index (0 based) of the font to be used in this style. -

+
+

index (0 based) of the font to be used in this style.

@@ -406,9 +395,8 @@ index (0 based) of the font to be used in this style. -

-id of the numFmt to apply to this style. -

+
+

id of the numFmt to apply to this style.

@@ -433,9 +421,8 @@ id of the numFmt to apply to this style. -

-indicates if the cell has a pivot table drop down button. -

+
+

indicates if the cell has a pivot table drop down button.

@@ -460,9 +447,8 @@ indicates if the cell has a pivot table drop down button. -

-The cell protection for this style. -

+
+

The cell protection for this style.

@@ -487,9 +473,8 @@ The cell protection for this style. -

-indecates if text should be prefixed by a single quote in the cell. -

+
+

indecates if text should be prefixed by a single quote in the cell.

@@ -514,9 +499,8 @@ indecates if text should be prefixed by a single quote in the cell. -

-index (0 based) of cellStylesXfs item to be used in this style. -

+
+

index (0 based) of cellStylesXfs item to be used in this style.

@@ -553,9 +537,8 @@ index (0 based) of cellStylesXfs item to be used in this style. -

-Creates a new Xf object. -

+
+

Creates a new Xf object.

@@ -577,9 +560,8 @@ Creates a new Xf object. -

-Serializes the xf elemen. -

+
+

Serializes the xf elemen.

@@ -600,9 +582,8 @@ Serializes the xf elemen.

-

-Creates a new Xf object -

+ +

Creates a new Xf object

@@ -623,9 +604,8 @@ Creates a new Xf object — -

-a customizable set of options -

+
+

a customizable set of options

@@ -820,9 +800,8 @@ a customizable set of options

-

-The cell alignment for this style -

+ +

The cell alignment for this style

@@ -884,9 +863,8 @@ The cell alignment for this style

-

-Indicates if the alignment options should be applied -

+ +

Indicates if the alignment options should be applied

@@ -941,9 +919,8 @@ Indicates if the alignment options should be applied

-

-indicates if the borderId should be applied -

+ +

indicates if the borderId should be applied

@@ -998,9 +975,8 @@ indicates if the borderId should be applied

-

-indicates if the fillId should be applied -

+ +

indicates if the fillId should be applied

@@ -1055,9 +1031,8 @@ indicates if the fillId should be applied

-

-indicates if the fontId should be applied -

+ +

indicates if the fontId should be applied

@@ -1112,9 +1087,8 @@ indicates if the fontId should be applied

-

-indicates if the numFmtId should be applied -

+ +

indicates if the numFmtId should be applied

@@ -1169,9 +1143,8 @@ indicates if the numFmtId should be applied

-

-Indicates if the protection options should be applied -

+ +

Indicates if the protection options should be applied

@@ -1226,9 +1199,8 @@ Indicates if the protection options should be applied

-

-index (0 based) of the border to be used in this style -

+ +

index (0 based) of the border to be used in this style

@@ -1283,9 +1255,8 @@ index (0 based) of the border to be used in this style

-

-index (0 based) of the fill to be used in this style -

+ +

index (0 based) of the fill to be used in this style

@@ -1340,9 +1311,8 @@ index (0 based) of the fill to be used in this style

-

-index (0 based) of the font to be used in this style -

+ +

index (0 based) of the font to be used in this style

@@ -1397,9 +1367,8 @@ index (0 based) of the font to be used in this style

-

-id of the numFmt to apply to this style -

+ +

id of the numFmt to apply to this style

@@ -1454,9 +1423,8 @@ id of the numFmt to apply to this style

-

-indicates if the cell has a pivot table drop down button -

+ +

indicates if the cell has a pivot table drop down button

@@ -1511,9 +1479,8 @@ indicates if the cell has a pivot table drop down button

-

-The cell protection for this style -

+ +

The cell protection for this style

@@ -1575,9 +1542,8 @@ The cell protection for this style

-

-indecates if text should be prefixed by a single quote in the cell -

+ +

indecates if text should be prefixed by a single quote in the cell

@@ -1632,10 +1598,9 @@ indecates if text should be prefixed by a single quote in the cell

-

-index (0 based) of cellStylesXfs item to be used in this style. Only -applies to cellXfs items -

+ +

index (0 based) of cellStylesXfs item to be used in this style. Only +applies to cellXfs items

@@ -1694,9 +1659,8 @@ applies to cellXfs items

-

-Serializes the xf elemen -

+ +

Serializes the xf elemen

@@ -1715,9 +1679,8 @@ Serializes the xf elemen — -

-The document builder instance this objects xml will be added to. -

+
+

The document builder instance this objects xml will be added to.

@@ -1771,7 +1734,7 @@ The document builder instance this objects xml will be added to.
diff --git a/doc/_index.html b/doc/_index.html index 82f20230..91b046d0 100644 --- a/doc/_index.html +++ b/doc/_index.html @@ -626,7 +626,7 @@
diff --git a/doc/css/style.css b/doc/css/style.css index 60829f7e..0b6fa69b 100644 --- a/doc/css/style.css +++ b/doc/css/style.css @@ -294,7 +294,7 @@ li.r2 { background: #fafafa; } #filecontents pre.code, .docstring pre.code { display: block; } .source_code .lines { padding-right: 12px; color: #555; text-align: right; } #filecontents pre.code, .docstring pre.code, -.tags .example { padding: 5px 12px; margin-top: 4px; border: 1px solid #eef; background: #f5f5ff; } +.tags pre.example { padding: 5px 12px; margin-top: 4px; border: 1px solid #eef; background: #f5f5ff; } pre.code { color: #000; } pre.code .info.file { color: #555; } pre.code .val { color: #036A07; } diff --git a/doc/file.LICENSE.html b/doc/file.LICENSE.html index 64ff7901..fac44ea9 100644 --- a/doc/file.LICENSE.html +++ b/doc/file.LICENSE.html @@ -54,35 +54,31 @@ -

-Copyright © 2011 Randy Morgan -

-

-Permission is hereby granted, free of charge, to any person obtaining a +

+

Copyright © 2011 Randy Morgan

+ +

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the -"Software"), to deal in the Software without restriction, -including without limitation the rights to use, copy, modify, merge, -publish, distribute, sublicense, and/or sell copies of the Software, and to -permit persons to whom the Software is furnished to do so, subject to the -following conditions: -

-

-The above copyright notice and this permission notice shall be included in -all copies or substantial portions of the Software. -

-

-THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, -EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF -MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN -NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, -DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR -OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE -USE OR OTHER DEALINGS IN THE SOFTWARE. -

+“Software”), to deal in the Software without restriction, including +without limitation the rights to use, copy, modify, merge, publish, +distribute, sublicense, and/or sell copies of the Software, and to permit +persons to whom the Software is furnished to do so, subject to the +following conditions:

+ +

The above copyright notice and this permission notice shall be included in +all copies or substantial portions of the Software.

+ +

THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS +OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, +FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE +AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER +LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING +FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER +DEALINGS IN THE SOFTWARE.

diff --git a/doc/file.README.html b/doc/file.README.html index 6138a068..0c788706 100644 --- a/doc/file.README.html +++ b/doc/file.README.html @@ -56,14 +56,17 @@

Axlsx: Office Open XML Spreadsheet Generation

+

Build Status

+

IRC: irc.freenode.net / #axlsx
Git: http://github.com/randym/axlsx
Author: Randy Morgan
Copyright: 2011
License: MIT License
Latest Version: 1.0.10
-Ruby Version: 1.8.7 - 1.9.3
-Release Date: November 29th 2011

+Ruby Version: 1.8.7, 1.9.3

+ +

Release Date: November 30th 2011

Synopsis

@@ -271,14 +274,17 @@ With Axlsx you can create worksheets with charts, images, automated column width

Changelog

    -
  • October.29.11: 1.0.10 release

    +
  • October.30.11: 1.0.10 release

    • Updating gemspec to lower gem version requirements.
    • Added row.style assignation for updating the cell style for an entire row
    • Added col_style method to worksheet upate a the style for a column of cells
    • Added cols for an easy reference to columns in a worksheet.
    • -
    • prep for release of acts_as_xlsx gem
    • +
    • prep for pre release of acts_as_xlsx gem
    • +
    • added in travis.ci configuration and build status
    • +
    • fixed out of range bug in time calculations for 32bit time.
    • +
    • added i18n for active support
  • October.26.11: 1.0.9 release

    @@ -300,7 +306,7 @@ licensed under the MIT license. Please see the
diff --git a/doc/index.html b/doc/index.html index 6138a068..0c788706 100644 --- a/doc/index.html +++ b/doc/index.html @@ -56,14 +56,17 @@

Axlsx: Office Open XML Spreadsheet Generation

+

Build Status

+

IRC: irc.freenode.net / #axlsx
Git: http://github.com/randym/axlsx
Author: Randy Morgan
Copyright: 2011
License: MIT License
Latest Version: 1.0.10
-Ruby Version: 1.8.7 - 1.9.3
-Release Date: November 29th 2011

+Ruby Version: 1.8.7, 1.9.3

+ +

Release Date: November 30th 2011

Synopsis

@@ -271,14 +274,17 @@ With Axlsx you can create worksheets with charts, images, automated column width

Changelog

    -
  • October.29.11: 1.0.10 release

    +
  • October.30.11: 1.0.10 release

    • Updating gemspec to lower gem version requirements.
    • Added row.style assignation for updating the cell style for an entire row
    • Added col_style method to worksheet upate a the style for a column of cells
    • Added cols for an easy reference to columns in a worksheet.
    • -
    • prep for release of acts_as_xlsx gem
    • +
    • prep for pre release of acts_as_xlsx gem
    • +
    • added in travis.ci configuration and build status
    • +
    • fixed out of range bug in time calculations for 32bit time.
    • +
    • added i18n for active support
  • October.26.11: 1.0.9 release

    @@ -300,7 +306,7 @@ licensed under the MIT license. Please see the
diff --git a/doc/js/app.js b/doc/js/app.js index 97095cbf..1b4e04b5 100644 --- a/doc/js/app.js +++ b/doc/js/app.js @@ -2,11 +2,11 @@ function createSourceLinks() { $('.method_details_list .source_code'). before("[View source]"); $('.toggleSource').toggle(function() { - $(this).parent().next().slideDown(100); + $(this).parent().nextAll('.source_code').slideDown(100); $(this).text("Hide source"); }, function() { - $(this).parent().next().slideUp(100); + $(this).parent().nextAll('.source_code').slideUp(100); $(this).text("View source"); }); } @@ -109,10 +109,10 @@ function summaryToggle() { $('.summary_toggle').click(function() { localStorage.summaryCollapsed = $(this).text(); $(this).text($(this).text() == "collapse" ? "expand" : "collapse"); - var next = $(this).parent().parent().next(); + var next = $(this).parent().parent().nextAll('ul.summary').first(); if (next.hasClass('compact')) { next.toggle(); - next.next().toggle(); + next.nextAll('ul.summary').first().toggle(); } else if (next.hasClass('summary')) { var list = $('
diff --git a/examples/example.rb b/examples/example.rb index 747c34ee..1ef2ab24 100644 --- a/examples/example.rb +++ b/examples/example.rb @@ -1,7 +1,7 @@ #!/usr/bin/env ruby # -*- coding: utf-8 -*- require 'rubygems' - require 'axlsx' + require 'axlsx.rb' #A Simple Workbook -- cgit v1.2.3