summaryrefslogtreecommitdiffhomepage
path: root/lib/axlsx
AgeCommit message (Collapse)Author
2013-01-15Added support for iso 8601 data types.Randy Morgan
Not really sure what excel is going to do with these data types, but hooking it up is the first step ;)
2013-01-10Merge branch 'master' of https://github.com/randym/axlsxRandy Morgan
2013-01-10reduced processing of 3000 rows from 3+ seconds to just under 2Randy Morgan
2013-01-02Worksheet name uniqueness doesn't apply to itselfEdward Anderson
This constraint would prevent you from creating a new worksheet with the name that it would have gotten by default.
2013-01-02Don't add worksheets to the workbook when initialize failsEdward Anderson
Creating a worksheet with an invalid name would still add it to the workbook, despite raising an exception.
2012-12-21removed typo spaceRandy Morgan
2012-12-21Applied patches for 1.8.7Randy Morgan
2012-12-20Removed validation for col#widthRandy Morgan
This needs to be smarter and only validate when the user supplies a value directly. 10% performance increase just by removing the validataion as this gets updated every time we set a single cell value.
2012-12-20Simplified to_xml_string serializationRandy Morgan
Spit out cell type based serializers and got rid of the case statement.
2012-12-19Removed unused relationships_index_of method in pivot_tableRandy Morgan
2012-12-19changed outline_row to outline_level_row to minimize confusion with bordersRandy Morgan
2012-12-15Added methods to simplify outlining with specsRandy Morgan
worksheet#outline_rows worksheet#outline_columns
2012-12-14Added formula_values options and specs for sheet format pr.Randy Morgan
This lets cache formula values and specify the default row height so that iOS and Max OSX previews render properly
2012-12-14Updated readme and version for next releaseRandy Morgan
2012-12-12Test for invalid characters in the sheet name.Hayden Ball
With thanks to http://stackoverflow.com/a/451488/1322410 for providing the list of characters
2012-12-04Added sheet_format_pr to help iOS/OSX preview renderers look niceRandy Morgan
This is part of https://github.com/randym/axlsx/issues/149
2012-12-04Added unsigned_int and float attr_accessor helpersRandy Morgan
These need to be added to existing classes to replace all the repeated accessor method validation.
2012-12-04Moved defined names in workbook to be serialized before pivot tablesRandy Morgan
This fixes https://github.com/randym/axlsx/issues/150
2012-11-27Merge pull request #148 from alexrothenberg/pivot_tableRandy Morgan (@morgan_randy)
Create a simple Pivot Table
2012-11-27Merge pull request #147 from raiis/masterRandy Morgan (@morgan_randy)
Different left/right border style
2012-11-28Better way hot to override borders style.raiis
2012-11-27Can configure a pivot table when creating itAlex Rothenberg
see examples/pivot_table.rb wb.add_worksheet(:name => "Data Sheet") do |sheet| sheet.add_row ['Month', 'Year', 'Type', 'Sales', 'Region'] 30.times { sheet.add_row [month, year, type, sales, region] } sheet.add_pivot_table 'G4:L17', "A1:E31" do |pivot_table| pivot_table.rows = ['Month', 'Year'] pivot_table.columns = ['Type'] pivot_table.data = ['Sales'] pivot_table.pages = ['Region'] end end
2012-11-27Create a simple Pivot TableAlex Rothenberg
* an example can be run with `ruby examples/pivot_table.rb` * right now you cannot set options on the pivot table to make it useful (coming soon...)
2012-11-26Added individual border override options.raiis
2012-11-25Added note for ::CGI.escapeHTML performance issueRandy Morgan
2012-11-25Removed row data type validation for cellsRandy Morgan
This gives us a 24% increase in speed. Ill take that tradeoff against the risk that a user will be manually hacking cells and making a mess of it.
2012-11-25Updated readme and docs for pre 1.3.4 releaseRandy Morgan
2012-11-25Patched serilalized_element_attributes to properly update value from called ↵Randy Morgan
block
2012-11-25Refactored header_footer element serialization.Randy Morgan
This adds a serializable_element_attributes helper that should be integrated as we have time for serializing child elements that are based on object attributes.
2012-11-23Adds an example of header/footers.Adam Mueller
Also, header and footer content is now escaped. So that the user doesn't have to worry about that. Change-Id: Ib35b2eca6755d9b2d9974be25887734873d6e64a
2012-11-22Merge pull request #145 from freerunningtechnologies/masterRandy Morgan (@morgan_randy)
Basic support for headers and footers.
2012-11-23Updated thin_chars and replaced cover_me with simplecovRandy Morgan
2012-11-22Adds basic support for headers and footers.Adam Mueller
Based on the discussion here: https://github.com/randym/axlsx/issues/111 Very simple implementation right now. Does not include any tests yet! Change-Id: Ia8ec8c52f82577d05e07e21311cdb5fe5d1294be
2012-11-16Minimized two_tone class methodRandy Morgan
This is really the same as just initializing the object, but anyone who knows about three_tone is going to expect two_tone to be there as well.
2012-11-16Updated README & version for next releaseRandy Morgan
2012-11-16Added sensible defaults for color scaleRandy Morgan
You can now use Axlsx::ColorScale.three_tone or Axlsx::ColorScale.two_tone to create pretty conditional formatting.
2012-11-15Patched for 1.8.7Randy Morgan
Time to think about ending support for 1.8.7?
2012-11-15Updated DataBar conditional formatting to accept cfvo hashes in the ↵Randy Morgan
initializer to bring the API inline with ColorScale
2012-11-15Added color scale initializationRandy Morgan
This lets us pass hashes defiing cfvo and colors for color scale conditional formatting with out the bs of hacking up the existing defaults.
2012-11-12Escape URLs used as target for hyperlinks.Stefan Daschek
Up to now, when using an URL containing a & character, the generated XML was invalid.
2012-11-08fixed cell text run validation for u and familyRandy Morgan
2012-11-05refactored Row serializationRandy Morgan
2012-11-05completed documentationRandy Morgan
2012-11-05updated readme and version for 1.3.2 releaseRandy Morgan
2012-10-27removed instance caching for package partsRandy Morgan
Some users have reported that they are repeatedly serializing the package. They need to know that it is not additive, and I need to remove the instance variable as there is no reason to maintain completed parts list since it is only used for serialization.
2012-10-21Added index_of to drawing for finding the position of a chart, image or ↵Randy Morgan
hyperlink
2012-10-21refactored conditional formatting classes that depend on pre-initialized ↵Randy Morgan
cfvo collections and fixed camel casing in data_bar
2012-10-21Added insert_worksheet to Workbook so we can add worksheets at a specific ↵Randy Morgan
position
2012-10-19refactored content types.Randy Morgan
2012-10-19added namespace parameter to element_for_attributeRandy Morgan