From 4d16bfc43780e5d3f7368625700b583e3e98217a Mon Sep 17 00:00:00 2001 From: Randy Morgan Date: Sun, 27 Nov 2011 18:11:42 +0900 Subject: adding in row_style and col_style methods to worksheet and active record 'acts_as_axlsx' to provide to_xlsx. --- doc/Axlsx.html | 917 +++++++++++++++++++++++++++++++++++---------------------- 1 file changed, 557 insertions(+), 360 deletions(-) (limited to 'doc/Axlsx.html') diff --git a/doc/Axlsx.html b/doc/Axlsx.html index 05fbc258..bb177b0b 100644 --- a/doc/Axlsx.html +++ b/doc/Axlsx.html @@ -73,7 +73,7 @@
Defined in:
lib/axlsx.rb,
- lib/axlsx/version.rb,
lib/axlsx/package.rb,
lib/axlsx/drawing/pic.rb,
lib/axlsx/drawing/axis.rb,
lib/axlsx/doc_props/app.rb,
lib/axlsx/drawing/title.rb,
lib/axlsx/drawing/chart.rb,
lib/axlsx/stylesheet/xf.rb,
lib/axlsx/doc_props/core.rb,
lib/axlsx/drawing/series.rb,
lib/axlsx/drawing/marker.rb,
lib/axlsx/util/constants.rb,
lib/axlsx/stylesheet/font.rb,
lib/axlsx/drawing/view_3D.rb,
lib/axlsx/drawing/drawing.rb,
lib/axlsx/stylesheet/fill.rb,
lib/axlsx/util/validators.rb,
lib/axlsx/drawing/scaling.rb,
lib/axlsx/drawing/cat_axis.rb,
lib/axlsx/stylesheet/color.rb,
lib/axlsx/drawing/ser_axis.rb,
lib/axlsx/drawing/val_axis.rb,
lib/axlsx/stylesheet/border.rb,
lib/axlsx/workbook/workbook.rb,
lib/axlsx/stylesheet/styles.rb,
lib/axlsx/rels/relationship.rb,
lib/axlsx/stylesheet/num_fmt.rb,
lib/axlsx/drawing/bar_series.rb,
lib/axlsx/rels/relationships.rb,
lib/axlsx/drawing/pie_series.rb,
lib/axlsx/drawing/line_series.rb,
lib/axlsx/drawing/bar_3D_chart.rb,
lib/axlsx/stylesheet/border_pr.rb,
lib/axlsx/content_type/default.rb,
lib/axlsx/drawing/series_title.rb,
lib/axlsx/drawing/pie_3D_chart.rb,
lib/axlsx/drawing/val_axis_data.rb,
lib/axlsx/drawing/graphic_frame.rb,
lib/axlsx/drawing/line_3D_chart.rb,
lib/axlsx/content_type/override.rb,
lib/axlsx/drawing/cat_axis_data.rb,
lib/axlsx/stylesheet/cell_style.rb,
lib/axlsx/util/simple_typed_list.rb,
lib/axlsx/workbook/worksheet/row.rb,
lib/axlsx/stylesheet/table_style.rb,
lib/axlsx/drawing/one_cell_anchor.rb,
lib/axlsx/stylesheet/table_styles.rb,
lib/axlsx/workbook/worksheet/cell.rb,
lib/axlsx/drawing/two_cell_anchor.rb,
lib/axlsx/stylesheet/pattern_fill.rb,
lib/axlsx/stylesheet/gradient_stop.rb,
lib/axlsx/stylesheet/gradient_fill.rb,
lib/axlsx/stylesheet/cell_alignment.rb,
lib/axlsx/content_type/content_type.rb,
lib/axlsx/stylesheet/cell_protection.rb,
lib/axlsx/workbook/worksheet/worksheet.rb,
lib/axlsx/stylesheet/table_style_element.rb + lib/axlsx/ar.rb,
lib/axlsx/package.rb,
lib/axlsx/version.rb,
lib/axlsx/drawing/pic.rb,
lib/axlsx/drawing/axis.rb,
lib/axlsx/drawing/chart.rb,
lib/axlsx/drawing/title.rb,
lib/axlsx/doc_props/app.rb,
lib/axlsx/stylesheet/xf.rb,
lib/axlsx/util/constants.rb,
lib/axlsx/drawing/series.rb,
lib/axlsx/drawing/marker.rb,
lib/axlsx/doc_props/core.rb,
lib/axlsx/drawing/drawing.rb,
lib/axlsx/stylesheet/fill.rb,
lib/axlsx/drawing/scaling.rb,
lib/axlsx/util/validators.rb,
lib/axlsx/stylesheet/font.rb,
lib/axlsx/drawing/view_3D.rb,
lib/axlsx/stylesheet/color.rb,
lib/axlsx/drawing/cat_axis.rb,
lib/axlsx/drawing/ser_axis.rb,
lib/axlsx/drawing/val_axis.rb,
lib/axlsx/workbook/workbook.rb,
lib/axlsx/stylesheet/styles.rb,
lib/axlsx/stylesheet/border.rb,
lib/axlsx/rels/relationship.rb,
lib/axlsx/drawing/bar_series.rb,
lib/axlsx/drawing/pie_series.rb,
lib/axlsx/rels/relationships.rb,
lib/axlsx/stylesheet/num_fmt.rb,
lib/axlsx/drawing/line_series.rb,
lib/axlsx/drawing/pie_3D_chart.rb,
lib/axlsx/stylesheet/border_pr.rb,
lib/axlsx/drawing/series_title.rb,
lib/axlsx/drawing/bar_3D_chart.rb,
lib/axlsx/content_type/default.rb,
lib/axlsx/stylesheet/cell_style.rb,
lib/axlsx/content_type/override.rb,
lib/axlsx/drawing/cat_axis_data.rb,
lib/axlsx/drawing/val_axis_data.rb,
lib/axlsx/drawing/line_3D_chart.rb,
lib/axlsx/drawing/graphic_frame.rb,
lib/axlsx/util/simple_typed_list.rb,
lib/axlsx/workbook/worksheet/row.rb,
lib/axlsx/stylesheet/table_style.rb,
lib/axlsx/stylesheet/pattern_fill.rb,
lib/axlsx/stylesheet/table_styles.rb,
lib/axlsx/workbook/worksheet/cell.rb,
lib/axlsx/drawing/one_cell_anchor.rb,
lib/axlsx/drawing/two_cell_anchor.rb,
lib/axlsx/stylesheet/gradient_fill.rb,
lib/axlsx/stylesheet/gradient_stop.rb,
lib/axlsx/stylesheet/cell_alignment.rb,
lib/axlsx/content_type/content_type.rb,
lib/axlsx/stylesheet/cell_protection.rb,
lib/axlsx/workbook/worksheet/worksheet.rb,
lib/axlsx/stylesheet/table_style_element.rb
@@ -81,14 +81,15 @@

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. +

@@ -100,6 +101,8 @@ to load on your client's machine.

+ Modules: Ar + Classes: App, Axis, Bar3DChart, BarSeries, Border, BorderPr, CatAxis, CatAxisData, Cell, CellAlignment, CellProtection, CellStyle, Chart, Color, ContentType, Core, DataTypeValidator, Default, Drawing, Fill, Font, GradientFill, GradientStop, GraphicFrame, Line3DChart, LineSeries, Marker, NumFmt, OneCellAnchor, Override, Package, PatternFill, Pic, Pie3DChart, PieSeries, RegexValidator, Relationship, Relationships, RestrictionValidator, Row, Scaling, SerAxis, Series, SeriesTitle, Styles, TableStyle, TableStyleElement, TableStyles, Title, TwoCellAnchor, ValAxis, ValAxisData, View3D, Workbook, Worksheet, Xf @@ -114,8 +117,9 @@ to load on your client's machine.

VERSION =
- -

version

+

+version +

@@ -125,13 +129,15 @@ to load on your client's machine.

- 
"1.0.9"
+ 
"1.0.10"
+
ENCODING =
- -

XML Encoding

+

+XML Encoding +

@@ -141,13 +147,15 @@ to load on your client's machine.

- 
"UTF-8"
+ 
"UTF-8"
+
XML_NS =
- -

spreadsheetML namespace

+

+spreadsheetML namespace +

@@ -157,13 +165,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/spreadsheetml/2006/main"
+ 
"http://schemas.openxmlformats.org/spreadsheetml/2006/main"
+
XML_NS_T =
- -

content-types namespace

+

+content-types namespace +

@@ -173,13 +183,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/package/2006/content-types"
+ 
"http://schemas.openxmlformats.org/package/2006/content-types"
+
APP_NS =
- -

extended-properties namespace

+

+extended-properties namespace +

@@ -189,13 +201,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/officeDocument/2006/extended-properties"
+ 
"http://schemas.openxmlformats.org/officeDocument/2006/extended-properties"
+
APP_NS_VT =
- -

doc props namespace

+

+doc props namespace +

@@ -205,13 +219,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes"
+ 
"http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes"
+
CORE_NS =
- -

core properties namespace

+

+core properties namespace +

@@ -221,13 +237,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/package/2006/metadata/core-properties"
+ 
"http://schemas.openxmlformats.org/package/2006/metadata/core-properties"
+
CORE_NS_DC =
- -

dc elements (core) namespace

+

+dc elements (core) namespace +

@@ -237,13 +255,15 @@ to load on your client's machine.

- 
"http://purl.org/dc/elements/1.1/"
+ 
"http://purl.org/dc/elements/1.1/"
+
CORE_NS_DCMIT =
- -

dcmit (core) namespcace

+

+dcmit (core) namespcace +

@@ -253,13 +273,15 @@ to load on your client's machine.

- 
"http://purl.org/dc/dcmitype/"
+ 
"http://purl.org/dc/dcmitype/"
+
CORE_NS_DCT =
- -

dc terms namespace

+

+dc terms namespace +

@@ -269,13 +291,15 @@ to load on your client's machine.

- 
"http://purl.org/dc/terms/"
+ 
"http://purl.org/dc/terms/"
+
CORE_NS_XSI =
- -

xml schema namespace

+

+xml schema namespace +

@@ -285,13 +309,15 @@ to load on your client's machine.

- 
"http://www.w3.org/2001/XMLSchema-instance"
+ 
"http://www.w3.org/2001/XMLSchema-instance"
+
XML_NS_XDR =
- -

spreadsheet drawing namespace

+

+spreadsheet drawing namespace +

@@ -301,13 +327,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"
+ 
"http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"
+
XML_NS_A =
- -

drawing namespace

+

+drawing namespace +

@@ -317,13 +345,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/drawingml/2006/main"
+ 
"http://schemas.openxmlformats.org/drawingml/2006/main"
+
XML_NS_C =
- -

chart namespace

+

+chart namespace +

@@ -333,13 +363,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/drawingml/2006/chart"
+ 
"http://schemas.openxmlformats.org/drawingml/2006/chart"
+
XML_NS_R =
- -

relationships namespace

+

+relationships namespace +

@@ -349,13 +381,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships"
+ 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships"
+
RELS_R =
- -

relationships name space

+

+relationships name space +

@@ -365,13 +399,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/package/2006/relationships"
+ 
"http://schemas.openxmlformats.org/package/2006/relationships"
+
TABLE_R =
- -

table rels namespace

+

+table rels namespace +

@@ -381,13 +417,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/table"
+ 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/table"
+
WORKBOOK_R =
- -

workbook rels namespace

+

+workbook rels namespace +

@@ -397,13 +435,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument"
+ 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument"
+
WORKSHEET_R =
- -

worksheet rels namespace

+

+worksheet rels namespace +

@@ -413,13 +453,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet"
+ 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet"
+
APP_R =
- -

app rels namespace

+

+app rels namespace +

@@ -429,13 +471,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties"
+ 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties"
+
CORE_R =
- -

core rels namespace

+

+core rels namespace +

@@ -445,13 +489,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/metadata/core-properties"
+ 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/metadata/core-properties"
+
STYLES_R =
- -

styles rels namespace

+

+styles rels namespace +

@@ -461,13 +507,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles"
+ 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles"
+
DRAWING_R =
- -

drawing rels namespace

+

+drawing rels namespace +

@@ -477,13 +525,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/drawing"
+ 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/drawing"
+
CHART_R =
- -

chart rels namespace

+

+chart rels namespace +

@@ -493,13 +543,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/chart"
+ 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/chart"
+
IMAGE_R =
- -

image rels namespace

+

+image rels namespace +

@@ -509,13 +561,15 @@ to load on your client's machine.

- 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/image"
+ 
"http://schemas.openxmlformats.org/officeDocument/2006/relationships/image"
+
TABLE_CT =
- -

table content type

+

+table content type +

@@ -525,13 +579,15 @@ to load on your client's machine.

- 
"application/vnd.openxmlformats-officedocument.spreadsheetml.table+xml"
+ 
"application/vnd.openxmlformats-officedocument.spreadsheetml.table+xml"
+
WORKBOOK_CT =
- -

workbook content type

+

+workbook content type +

@@ -541,13 +597,15 @@ to load on your client's machine.

- 
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml"
+ 
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml"
+
APP_CT =
- -

app content type

+

+app content type +

@@ -557,13 +615,15 @@ to load on your client's machine.

- 
"application/vnd.openxmlformats-officedocument.extended-properties+xml"
+ 
"application/vnd.openxmlformats-officedocument.extended-properties+xml"
+
RELS_CT =
- -

rels content type

+

+rels content type +

@@ -573,13 +633,15 @@ to load on your client's machine.

- 
"application/vnd.openxmlformats-package.relationships+xml"
+ 
"application/vnd.openxmlformats-package.relationships+xml"
+
STYLES_CT =
- -

styles content type

+

+styles content type +

@@ -589,13 +651,15 @@ to load on your client's machine.

- 
"application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml"
+ 
"application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml"
+
XML_CT =
- -

xml content type

+

+xml content type +

@@ -605,13 +669,15 @@ to load on your client's machine.

- 
"application/xml"
+ 
"application/xml"
+
WORKSHEET_CT =
- -

worksheet content type

+

+worksheet content type +

@@ -621,13 +687,15 @@ to load on your client's machine.

- 
"application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"
+ 
"application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"
+
SHARED_STRINGS_CT =
- -

shared strings content type

+

+shared strings content type +

@@ -637,13 +705,15 @@ to load on your client's machine.

- 
"application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml"
+ 
"application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml"
+
CORE_CT =
- -

core content type

+

+core content type +

@@ -653,13 +723,15 @@ to load on your client's machine.

- 
"application/vnd.openxmlformats-package.core-properties+xml"
+ 
"application/vnd.openxmlformats-package.core-properties+xml"
+
CHART_CT =
- -

chart content type

+

+chart content type +

@@ -669,13 +741,15 @@ to load on your client's machine.

- 
"application/vnd.openxmlformats-officedocument.drawingml.chart+xml"
+ 
"application/vnd.openxmlformats-officedocument.drawingml.chart+xml"
+
JPEG_CT =
- -

jpeg content type

+

+jpeg content type +

@@ -685,13 +759,15 @@ to load on your client's machine.

- 
"image/jpeg"
+ 
"image/jpeg"
+
GIF_CT =
- -

gif content type

+

+gif content type +

@@ -701,13 +777,15 @@ to load on your client's machine.

- 
"image/gif"
+ 
"image/gif"
+
PNG_CT =
- -

png content type

+

+png content type +

@@ -717,13 +795,15 @@ to load on your client's machine.

- 
"image/png"
+ 
"image/png"
+
DRAWING_CT =
- -

drawing content type

+

+drawing content type +

@@ -733,13 +813,15 @@ to load on your client's machine.

- 
"application/vnd.openxmlformats-officedocument.drawing+xml"
+ 
"application/vnd.openxmlformats-officedocument.drawing+xml"
+
XML_EX =
- -

xml content type extensions

+

+xml content type extensions +

@@ -749,13 +831,15 @@ to load on your client's machine.

- 
"xml"
+ 
"xml"
+
JPEG_EX =
- -

jpeg extension

+

+jpeg extension +

@@ -765,13 +849,15 @@ to load on your client's machine.

- 
"jpeg"
+ 
"jpeg"
+
GIF_EX =
- -

gif extension

+

+gif extension +

@@ -781,13 +867,15 @@ to load on your client's machine.

- 
"gif"
+ 
"gif"
+
PNG_EX =
- -

png extension

+

+png extension +

@@ -797,13 +885,15 @@ to load on your client's machine.

- 
"png"
+ 
"png"
+
RELS_EX =
- -

rels content type extension

+

+rels content type extension +

@@ -813,13 +903,15 @@ to load on your client's machine.

- 
"rels"
+ 
"rels"
+
WORKBOOK_PN =
- -

workbook part

+

+workbook part +

@@ -829,13 +921,15 @@ to load on your client's machine.

- 
"xl/workbook.xml"
+ 
"xl/workbook.xml"
+
STYLES_PN =
- -

styles part

+

+styles part +

@@ -845,13 +939,15 @@ to load on your client's machine.

- 
"styles.xml"
+ 
"styles.xml"
+
APP_PN =
- -

app part

+

+app part +

@@ -861,13 +957,15 @@ to load on your client's machine.

- 
"docProps/app.xml"
+ 
"docProps/app.xml"
+
CORE_PN =
- -

core part

+

+core part +

@@ -877,13 +975,15 @@ to load on your client's machine.

- 
"docProps/core.xml"
+ 
"docProps/core.xml"
+
CONTENT_TYPES_PN =
- -

content types part

+

+content types part +

@@ -893,13 +993,15 @@ to load on your client's machine.

- 
"[Content_Types].xml"
+ 
"[Content_Types].xml"
+
RELS_PN =
- -

rels part

+

+rels part +

@@ -909,13 +1011,15 @@ to load on your client's machine.

- 
"_rels/.rels"
+ 
"_rels/.rels"
+
WORKBOOK_RELS_PN =
- -

workbook rels part

+

+workbook rels part +

@@ -925,13 +1029,15 @@ to load on your client's machine.

- 
"xl/_rels/workbook.xml.rels"
+ 
"xl/_rels/workbook.xml.rels"
+
WORKSHEET_PN =
- -

worksheet part

+

+worksheet part +

@@ -941,13 +1047,15 @@ to load on your client's machine.

- 
"worksheets/sheet%d.xml"
+ 
"worksheets/sheet%d.xml"
+
WORKSHEET_RELS_PN =
- -

worksheet rels part

+

+worksheet rels part +

@@ -957,13 +1065,15 @@ to load on your client's machine.

- 
"worksheets/_rels/sheet%d.xml.rels"
+ 
"worksheets/_rels/sheet%d.xml.rels"
+
DRAWING_PN =
- -

drawing part

+

+drawing part +

@@ -973,13 +1083,15 @@ to load on your client's machine.

- 
"drawings/drawing%d.xml"
+ 
"drawings/drawing%d.xml"
+
DRAWING_RELS_PN =
- -

drawing rels part

+

+drawing rels part +

@@ -989,13 +1101,15 @@ to load on your client's machine.

- 
"drawings/_rels/drawing%d.xml.rels"
+ 
"drawings/_rels/drawing%d.xml.rels"
+
CHART_PN =
- -

chart part

+

+chart part +

@@ -1005,13 +1119,15 @@ to load on your client's machine.

- 
"charts/chart%d.xml"
+ 
"charts/chart%d.xml"
+
IMAGE_PN =
- -

chart part

+

+chart part +

@@ -1021,13 +1137,15 @@ to load on your client's machine.

- 
"media/image%d.%s"
+ 
"media/image%d.%s"
+
APP_XSD =
- -

App validation schema

+

+App validation schema +

@@ -1037,13 +1155,15 @@ to load on your client's machine.

- 
"lib/schema/shared-documentPropertiesExtended.xsd"
+ 
"lib/schema/shared-documentPropertiesExtended.xsd"
+
CORE_XSD =
- -

core validation schema

+

+core validation schema +

@@ -1053,13 +1173,15 @@ to load on your client's machine.

- 
"lib/schema/opc-coreProperties.xsd"
+ 
"lib/schema/opc-coreProperties.xsd"
+
CONTENT_TYPES_XSD =
- -

content types validation schema

+

+content types validation schema +

@@ -1069,13 +1191,15 @@ to load on your client's machine.

- 
"lib/schema/opc-contentTypes.xsd"
+ 
"lib/schema/opc-contentTypes.xsd"
+
RELS_XSD =
- -

rels validation schema

+

+rels validation schema +

@@ -1085,13 +1209,15 @@ to load on your client's machine.

- 
"lib/schema/opc-relationships.xsd"
+ 
"lib/schema/opc-relationships.xsd"
+
SML_XSD =
- -

spreadsheetML validation schema

+

+spreadsheetML validation schema +

@@ -1101,13 +1227,15 @@ to load on your client's machine.

- 
"lib/schema/sml.xsd"
+ 
"lib/schema/sml.xsd"
+
DRAWING_XSD =
- -

drawing validation schema

+

+drawing validation schema +

@@ -1117,13 +1245,15 @@ to load on your client's machine.

- 
"lib/schema/dml-spreadsheetDrawing.xsd"
+ 
"lib/schema/dml-spreadsheetDrawing.xsd"
+
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. +

@@ -1133,13 +1263,15 @@ to load on your client's machine.

- 
9
+ 
9
+
NUM_FMT_YYYYMMDD =
- -

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

+

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

@@ -1149,13 +1281,15 @@ to load on your client's machine.

- 
100
+ 
100
+
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 +

@@ -1165,13 +1299,15 @@ to load on your client's machine.

- 
101
+ 
101
+
STYLE_THIN_BORDER =
- -

cellXfs id for thin borders around the cell

+

+cellXfs id for thin borders around the cell +

@@ -1181,13 +1317,15 @@ to load on your client's machine.

- 
1
+ 
1
+
ERR_RESTRICTION =
- -

error messages RestrictionValidor

+

+error messages RestrictionValidor +

@@ -1197,13 +1335,15 @@ to load on your client's machine.

- 
"Invalid Data: %s. %s must be one of %s."
+ 
"Invalid Data: %s. %s must be one of %s."
+
ERR_TYPE =
- -

error message DataTypeValidator

+

+error message DataTypeValidator +

@@ -1213,13 +1353,15 @@ to load on your client's machine.

- 
"Invalid Data %s for %s. must be %s."
+ 
"Invalid Data %s for %s. must be %s."
+
ERR_REGEX =
- -

error message for RegexValidator

+

+error message for RegexValidator +

@@ -1229,7 +1371,8 @@ to load on your client's machine.

- 
"Invalid Data. %s does not match %s."
+ 
"Invalid Data. %s does not match %s."
+
@@ -1262,8 +1405,9 @@ to load on your client's machine.

-
-

determines the cell range for the items provided.

+

+determines the cell range for the items provided. +

 @@ -1285,9 +1429,10 @@ to load on your client's machine.

-
-

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. +

 @@ -1309,10 +1454,11 @@ 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. +

@@ -1334,8 +1480,9 @@ CORE_CT, CHART_CT, DRAWING_CT are allowed.

-
-

Requires that the value is a Float.

+

+Requires that the value is a Float. +

 @@ -1357,8 +1504,9 @@ CORE_CT, CHART_CT, DRAWING_CT are allowed.

-
-

Requires that the value is a gradient_type.

+

+Requires that the value is a gradient_type. +

 @@ -1380,10 +1528,11 @@ CORE_CT, CHART_CT, DRAWING_CT are allowed.

-
-

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. +

@@ -1405,8 +1554,9 @@ allowed.

-
-

Requires that the value is a Fixnum or Integer.

+

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

 @@ -1428,8 +1578,9 @@ allowed.

-
-

Requires that the value is valid pattern type.

+

+Requires that the value is valid pattern type. +

 @@ -1451,10 +1602,11 @@ allowed.

-
-

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. +

@@ -1476,8 +1628,9 @@ DRAWING_R are allowed.

-
-

Requires that the value is a String.

+

+Requires that the value is a String. +

 @@ -1499,8 +1652,8 @@ DRAWING_R are allowed.

-
-

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, @@ -1508,7 +1661,8 @@ DRAWING_R are allowed.

:firstSubtotalRow, :secondSubtotalRow, :thirdSubtotalRow, :blankRow, :firstColumnSubheading, :secondColumnSubheading, :thirdColumnSubheading, :firstRowSubheading, :secondRowSubheading, :thirdRowSubheading, -:pageFieldLabels, :pageFieldValues are allowed.

+:pageFieldLabels, :pageFieldValues are allowed. +

@@ -1530,9 +1684,10 @@ DRAWING_R are allowed.

-
-

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. +

 @@ -1554,9 +1709,10 @@ DRAWING_R are allowed.

-
-

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. +

 @@ -1580,8 +1736,9 @@ DRAWING_R are allowed.

- -

determines the cell range for the items provided

+

+determines the cell range for the items provided +

@@ -1595,24 +1752,25 @@ DRAWING_R are allowed.

 
 
-36
 37
 38
 39
 40
 41
-42
+42 +43 - 
# File 'lib/axlsx.rb', line 36
-
-def self.cell_range(items)
-  return "" unless items.first.is_a? Cell          
-  ref = "#{items.first.row.worksheet.name}!" +
-    "#{items.first.r_abs}"
-  ref += ":#{items.last.r_abs}" if items.size > 1
-  ref
-end
+ 
# File 'lib/axlsx.rb', line 37
+
+def self.cell_range(items)
+  return "" unless items.first.is_a? Cell          
+  ref = "#{items.first.row.worksheet.name}!" +
+    "#{items.first.r_abs}"
+  ref += ":#{items.last.r_abs}" if items.size > 1
+  ref
+end
+
@@ -1627,11 +1785,13 @@ DRAWING_R are allowed.

- -

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" +

@@ -1650,8 +1810,9 @@ Symbol, TrueClass or FalseClass and it must be one of 0, 1, "true", — -
-

The value validated

+

+The value validated +

@@ -1672,9 +1833,10 @@ Symbol, TrueClass or FalseClass and it must be one of 0, 1, "true", 
# File 'lib/axlsx/util/validators.rb', line 65
 
-def self.validate_boolean(v)
-  DataTypeValidator.validate(:boolean, [Fixnum, String, Integer, Symbol, TrueClass, FalseClass], v, lambda { |arg| [0, 1, "true", "false", :true, :false, true, false, "0", "1"].include?(arg) })
-end
+def self.validate_boolean(v) + DataTypeValidator.validate(:boolean, [Fixnum, String, Integer, Symbol, TrueClass, FalseClass], v, lambda { |arg| [0, 1, "true", "false", :true, :false, true, false, "0", "1"].include?(arg) }) +end + @@ -1689,10 +1851,11 @@ Symbol, TrueClass or FalseClass and it must be one of 0, 1, "true",

- -

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 +

@@ -1711,8 +1874,9 @@ CORE_CT, CHART_CT, DRAWING_CT are allowed

— -
-

The value validated

+

+The value validated +

@@ -1733,9 +1897,10 @@ CORE_CT, CHART_CT, DRAWING_CT are allowed

# File 'lib/axlsx/util/validators.rb', line 114
 
-def self.validate_content_type(v)
-  RestrictionValidator.validate :content_type, [TABLE_CT, WORKBOOK_CT, APP_CT, RELS_CT, STYLES_CT, XML_CT, WORKSHEET_CT, SHARED_STRINGS_CT, CORE_CT, CHART_CT, JPEG_CT, GIF_CT, PNG_CT, DRAWING_CT], v
-end
+def self.validate_content_type(v) + RestrictionValidator.validate :content_type, [TABLE_CT, WORKBOOK_CT, APP_CT, RELS_CT, STYLES_CT, XML_CT, WORKSHEET_CT, SHARED_STRINGS_CT, CORE_CT, CHART_CT, JPEG_CT, GIF_CT, PNG_CT, DRAWING_CT], v +end + @@ -1750,8 +1915,9 @@ CORE_CT, CHART_CT, DRAWING_CT are allowed

- -

Requires that the value is a Float

+

+Requires that the value is a Float +

@@ -1770,8 +1936,9 @@ CORE_CT, CHART_CT, DRAWING_CT are allowed

— -
-

The value validated

+

+The value validated +

@@ -1792,9 +1959,10 @@ CORE_CT, CHART_CT, DRAWING_CT are allowed

# File 'lib/axlsx/util/validators.rb', line 77
 
-def self.validate_float(v)
-  DataTypeValidator.validate :float, Float, v
-end
+def self.validate_float(v) + DataTypeValidator.validate :float, Float, v +end + @@ -1809,9 +1977,10 @@ CORE_CT, CHART_CT, DRAWING_CT are allowed

- -

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 +

@@ -1830,8 +1999,9 @@ CORE_CT, CHART_CT, DRAWING_CT are allowed

— -
-

The value validated

+

+The value validated +

@@ -1852,9 +2022,10 @@ CORE_CT, CHART_CT, DRAWING_CT are allowed

# File 'lib/axlsx/util/validators.rb', line 93
 
-def self.validate_gradient_type(v)
-  RestrictionValidator.validate :gradient_type, [:linear, :path], v
-end
+def self.validate_gradient_type(v) + RestrictionValidator.validate :gradient_type, [:linear, :path], v +end + @@ -1869,10 +2040,11 @@ CORE_CT, CHART_CT, DRAWING_CT are allowed

- -

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 +

@@ -1891,8 +2063,9 @@ allowed

— -
-

The value validated

+

+The value validated +

@@ -1913,9 +2086,10 @@ allowed

# File 'lib/axlsx/util/validators.rb', line 100
 
-def self.validate_horizontal_alignment(v)
-  RestrictionValidator.validate :horizontal_alignment, [:general, :left, :center, :right, :fill, :justify, :centerContinuous, :distributed], v
-end
+def self.validate_horizontal_alignment(v) + RestrictionValidator.validate :horizontal_alignment, [:general, :left, :center, :right, :fill, :justify, :centerContinuous, :distributed], v +end + @@ -1930,8 +2104,9 @@ allowed

- -

Requires that the value is a Fixnum or Integer

+

+Requires that the value is a Fixnum or Integer +

@@ -1950,8 +2125,9 @@ allowed

— -
-

The value validated

+

+The value validated +

@@ -1972,9 +2148,10 @@ allowed

# File 'lib/axlsx/util/validators.rb', line 57
 
-def self.validate_int(v)
-  DataTypeValidator.validate :unsigned_int, [Fixnum, Integer], v
-end
+def self.validate_int(v) + DataTypeValidator.validate :unsigned_int, [Fixnum, Integer], v +end + @@ -1989,12 +2166,13 @@ allowed

- -

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. +

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

The value validated

+

+The value validated +

@@ -2036,10 +2215,11 @@ one of :none, :solid, :mediumGray, :darkGray, :lightGray, :darkHorizontal, 
# File 'lib/axlsx/util/validators.rb', line 85
 
-def self.validate_pattern_type(v)
-  RestrictionValidator.validate :pattern_type, [:none, :solid, :mediumGray, :darkGray, :lightGray, :darkHorizontal, :darkVertical, :darkDown, :darkUp, :darkGrid,
-     :darkTrellis, :lightHorizontal, :lightVertical, :lightDown, :lightUp, :lightGrid, :lightTrellis, :gray125, :gray0625], v
-end
+def self.validate_pattern_type(v) + RestrictionValidator.validate :pattern_type, [:none, :solid, :mediumGray, :darkGray, :lightGray, :darkHorizontal, :darkVertical, :darkDown, :darkUp, :darkGrid, + :darkTrellis, :lightHorizontal, :lightVertical, :lightDown, :lightUp, :lightGrid, :lightTrellis, :gray125, :gray0625], v +end + @@ -2054,10 +2234,11 @@ one of :none, :solid, :mediumGray, :darkGray, :lightGray, :darkHorizontal,

- -

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 +

@@ -2076,8 +2257,9 @@ DRAWING_R are allowed

— -
-

The value validated

+

+The value validated +

@@ -2098,9 +2280,10 @@ DRAWING_R are allowed

# File 'lib/axlsx/util/validators.rb', line 121
 
-def self.validate_relationship_type(v)
-  RestrictionValidator.validate :relationship_type, [XML_NS_R, TABLE_R, WORKBOOK_R, WORKSHEET_R, APP_R, RELS_R, CORE_R, STYLES_R, CHART_R, DRAWING_R, IMAGE_R], v
-end
+def self.validate_relationship_type(v) + RestrictionValidator.validate :relationship_type, [XML_NS_R, TABLE_R, WORKBOOK_R, WORKSHEET_R, APP_R, RELS_R, CORE_R, STYLES_R, CHART_R, DRAWING_R, IMAGE_R], v +end + @@ -2115,8 +2298,9 @@ DRAWING_R are allowed

- -

Requires that the value is a String

+

+Requires that the value is a String +

@@ -2135,8 +2319,9 @@ DRAWING_R are allowed

— -
-

The value validated

+

+The value validated +

@@ -2157,9 +2342,10 @@ DRAWING_R are allowed

# File 'lib/axlsx/util/validators.rb', line 71
 
-def self.validate_string(v)
-  DataTypeValidator.validate :string, String, v
-end
+def self.validate_string(v) + DataTypeValidator.validate :string, String, v +end + @@ -2174,8 +2360,8 @@ DRAWING_R are allowed

- -

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, @@ -2183,7 +2369,8 @@ DRAWING_R are allowed

:firstSubtotalRow, :secondSubtotalRow, :thirdSubtotalRow, :blankRow, :firstColumnSubheading, :secondColumnSubheading, :thirdColumnSubheading, :firstRowSubheading, :secondRowSubheading, :thirdRowSubheading, -:pageFieldLabels, :pageFieldValues are allowed

+:pageFieldLabels, :pageFieldValues are allowed +

@@ -2202,8 +2389,9 @@ DRAWING_R are allowed

— -
-

The value validated

+

+The value validated +

@@ -2224,9 +2412,10 @@ DRAWING_R are allowed

# File 'lib/axlsx/util/validators.rb', line 128
 
-def self.validate_table_element_type(v)
-  RestrictionValidator.validate :table_element_type, [: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], v
-end
+def self.validate_table_element_type(v) + RestrictionValidator.validate :table_element_type, [: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], v +end + @@ -2241,8 +2430,9 @@ DRAWING_R are allowed

- -

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 +

@@ -2261,8 +2451,9 @@ DRAWING_R are allowed

— -
-

The value validated

+

+The value validated +

@@ -2280,8 +2471,9 @@ DRAWING_R are allowed

— -
-

true if the data is valid

+

+true if the data is valid +

@@ -2298,8 +2490,9 @@ DRAWING_R are allowed

— -
-

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 +

@@ -2319,9 +2512,10 @@ DRAWING_R are allowed

# File 'lib/axlsx/util/validators.rb', line 51
 
-def self.validate_unsigned_int(v)
-  DataTypeValidator.validate(:unsigned_int, [Fixnum, Integer], v, lambda { |arg| arg.respond_to?(:>=) && arg >= 0 })
-end
+def self.validate_unsigned_int(v) + DataTypeValidator.validate(:unsigned_int, [Fixnum, Integer], v, lambda { |arg| arg.respond_to?(:>=) && arg >= 0 }) +end + @@ -2336,9 +2530,10 @@ DRAWING_R are allowed

- -

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 +

@@ -2357,8 +2552,9 @@ DRAWING_R are allowed

— -
-

The value validated

+

+The value validated +

@@ -2379,9 +2575,10 @@ DRAWING_R are allowed

# File 'lib/axlsx/util/validators.rb', line 107
 
-def self.validate_vertical_alignment(v)
-  RestrictionValidator.validate :vertical_alignment, [:top, :center, :bottom, :justify, :distributed], v
-end
+def self.validate_vertical_alignment(v) + RestrictionValidator.validate :vertical_alignment, [:top, :center, :bottom, :justify, :distributed], v +end + @@ -2392,9 +2589,9 @@ DRAWING_R are allowed

-- cgit v1.2.3