summaryrefslogtreecommitdiffhomepage
path: root/lib/axlsx/workbook/worksheet
AgeCommit message (Collapse)Author
2014-02-26Ensure auto_filter defined name is correctly added to workbook (refs #285)Jonathan Tron
2014-02-26Add auto_filter defined name in `Axlsx::Worksheet#to_xml_string` (refs #285)Jonathan Tron
The way ot was done previously (adding the defined name on `Axlsx::Worksheet#auto_filter=`) meant that it was added only when using this method. But it's possible to assign range on the auto-created `AutoFilter` with: ```ruby workheet.auto_filter.range = "A1:B2" ``` In this case the defined name was never added to the workbook.
2014-02-26Fix wrong value for auto_filter defined name (refs #285)Jonathan Tron
2014-02-04Column_widths must be set after add_row is calledWill Bradley
Fixes https://github.com/randym/axlsx/issues/165
2014-01-23fixing comments for 2010 starter editionDustin Smith
2014-01-06Update header_footer.rbAndrew Grimm
Fix documentation.
2013-09-30add name attribute to cell to create defined names for a single cell. ↵Randy Morgan
https://github.com/randym/axlsx/issues/241
2013-09-29Integrate workbook views and alter serializationRandy Morgan
This integrates workbook views and sheet state into serialization. I also noticed that we were populating defined names during serialization. While it is good to delay this as late as possible as there is always the chance that some conditional programming by the consumer adds, and then removes an autofilter, I am choosing to risk it at this point for cleaner code.
2013-09-13initialize subtotal to remove warningsRandy Morgan
2013-09-13Add support for automatically adjusting serialized times and dates to ↵Randy Morgan
account for the zone
2013-09-13Bring documentation up to 100%Randy Morgan
2013-09-13repair pivot table data ref populate and bring coverage back up to 100%Randy Morgan
2013-09-13Fixes for anchor swapping when adding images. - Two -> One swap still pending.Randy Morgan
2013-09-13Page Breaks - round oneRandy Morgan
This sets up the basic col and row break creation and serialization. You can specify either a string reference like "C7" or provide an Axlsx::Cell instance to specify the break point. Serialization is working cleanly but excel does not automatically render those breaks yet. You need to switch to page preview mode.
2013-09-13sorry folks 1.8.7 is just simply a no-goRandy Morgan
2013-09-13docs for ColBreaksRandy Morgan
2013-08-19More work on page breaksRandy Morgan
2013-08-17add first bits of col/row break supportRandy Morgan
2013-08-17whitespace and debug cleanupRandy Morgan
2013-08-17Extracted control char sanitization to module level and applied to shared ↵Randy Morgan
strings table output.
2013-08-16Merge pull request #174 from IndependentIP/masterRandy Morgan (@morgan_randy)
Fix hardcoded sheet name in PivotTableCacheDefinition and allow other sheet to be the data source for the pivot table
2013-07-30Update row.rbMichael Westbom
Fixed a little typo.
2013-07-24Merge branch 'master' of https://github.com/randym/axlsxJean Jacques Warmerdam
2013-07-08Make relationship ids more reliable.Stefan Daschek
Relationship instances now keep track of their own id – this should be much more reliable than the old way of more or less “guessing” the relationship id based on the position of some object in some array. Fixes https://github.com/randym/axlsx/issues/212, especially. Each relationship now has its own, unique id – except for the cases when it doesn’t: Some relationships need to share the same id, see `Relation#should_use_same_id_as?` for the gory details. All tests pass, and the full example.xlsx is generated without errors and looks fine in Excel for Mac 2011. The pivot table example still has the problems mentioned in https://github.com/randym/axlsx/issues/168 – but as far as I can tell I didn’t make it worse (Excel is still be able to “repair” the file, and the repaired file then contains the pivot table).
2013-07-03Do not start comment text with stray colon if author is blankStefan Daschek
2013-07-03Escape special chars for comments’ text and author.Stefan Daschek
2013-06-27Merge pull request #194 from sdeframond/subtotalRandy Morgan (@morgan_randy)
Add a subtotal option to PivotTable.
2013-06-23escape formula for conditional formattingRandy Morgan
2013-06-23added sparse array transposition with blocks for rows/cols switching and ↵Randy Morgan
some docs updates for release prep
2013-06-13Allow a different subtotal function for each data field.Samuel de Framond
2013-06-13Modify pivot table caption according to subtotal function.Samuel de Framond
2013-06-12Add a subtotal option to PivotTable (dirty).Samuel de Framond
2013-05-12implement transpose for SimpleTypedList that supports sparse data.Randy Morgan
2013-04-28Refactored and renamed space preservationRandy Morgan
preserve_spaces has been moved to the workbook and renamed xml_space as that provides a good reference for people trying to figure out what it does, and let's the author specify space preservation for serializations using the shared strings table as well as the default inline serialization in cells.
2013-04-27Add a preserve_spaces option to worksheet, defaults to trueAdam Gardiner
2013-04-27Revert changes to cell serializationAdam Gardiner
2013-04-10Add support for preserving leading and trailing spaces in cell valuesAdam Gardiner
2013-04-04Documentation for @formula attribute.Noel Peden
2013-04-04Added support for specifying between/notBetween formula in an array.Noel Peden
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-02-25Allow other sheet as data source for pivot tables and fix hard coded sheet ↵Jean Jacques Warmerdam
name in Pivot Table Cache Definition
2013-02-04Completed missing docs and pre-release prepRandy Morgan
2013-02-04Extracted type based cell serializersRandy Morgan
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