summaryrefslogtreecommitdiffhomepage
path: root/test/workbook
AgeCommit message (Collapse)Author
2013-03-16First run at 'hidden' comments WIPRandy Morgan
The xml is genrated correcty, but the comment still shows until it is selected once in the excel ui - so I must be missing something.
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-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-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-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-11-27Merge pull request #148 from alexrothenberg/pivot_tableRandy Morgan (@morgan_randy)
Create a simple Pivot Table
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-22Adds tests for HeaderFooter.Adam Mueller
Change-Id: I77c92cb6af09a13193517adc102093c26cd0cead
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-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-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-10-21Fixed and added specs for best_fit and custom_width attribute serializationRandy Morgan
2012-10-21Added insert_worksheet to Workbook so we can add worksheets at a specific ↵Randy Morgan
position
2012-10-14Refactored to use options parser, accessors and serialization attributesRandy Morgan
2012-10-14refactored Col to use serialized attributes and correct camel cased ↵Randy Morgan
outline_level attribute An alias to outlineLevel is provided for backwards compatability
2012-10-09Added a helper to find and return a worksheet from the workbook by nameRandy Morgan
2012-09-30Forgot to add these files to last commit!Randy Morgan
extraction refactoring
2012-09-30Patched .yardopts to remove nodoc option and proprly include CHANGELOG.md ↵Randy Morgan
and LICENSE
2012-09-30Finished and Specced Auto Filter with Filters (standard) filter supportRandy Morgan
This means you can add autofilters that will restrict the visible rows based on a specified value.
2012-09-30Extracted and completed support for PageSetUpPrRandy Morgan
2012-09-26set filter_modeRandy Morgan
2012-09-26pre-release readme updates and more work on auto_filter preset valuesRandy Morgan
2012-09-25hasty hastyRandy Morgan
2012-09-25Add dummy test for filter column so it shuts up on 1.8.7Randy Morgan
2012-09-25more work on deep autofilter implementationRandy Morgan
Adding in Filters, Filter, DateGroupItem and FilterColumns. Still needs more specs/docs but we are almost there.
2012-09-23Autofilter extended implementationRandy Morgan
Beginnings of 18.3.2 AutoFilter Settings implementation. I've moved auto_filter into its own directory as there will be a minimum of 15 or 20 classes required to implement this in full.
2012-09-15Preserve newlines in xml output for a worksheetErik Benoist
2012-09-14Implement table style info for named tables.Randy Morgan
2012-09-14incorporate deeper check for cell size and adjust for boldRandy Morgan
2012-09-07properly recognize exponential values as floatRandy Morgan
2012-09-02implement paper_size as at least some version of office ignore the paper ↵Randy Morgan
width and paper height page setup attributes. See PageSetup#paper_size for a list of sizes supported in the specification.
2012-08-12Release prepRandy Morgan
2012-08-12remove expired option from testRandy Morgan
2012-08-12finish specs for worksheet hyperlink to_xml_stringRandy Morgan
2012-08-12add specs for hyperlink targetRandy Morgan
2012-08-12specs to prove the sz bug is actually fixed.Randy Morgan
2012-08-11temporarily disable to_xml_string testing for jrubyRandy Morgan
need a way to add in the relations namespace or xerces cannot parse the xml string
2012-08-11spec workRandy Morgan
2012-08-11add hyperlinks for worksheets #118Randy Morgan
2012-08-02bring coverage up to 100% for d_lbls and defined namesRandy Morgan
release prep!
2012-07-20bring spec coverage back up to 100%Randy Morgan