summaryrefslogtreecommitdiffhomepage
path: root/lib/axlsx/workbook
AgeCommit message (Collapse)Author
2014-03-05Small fixesJurriaan Pruis
2014-03-04Fix cell merging, #179Jurriaan Pruis
2014-03-04Merge pull request #295 from tafryn/arrayformulaJurriaan Pruis
Added array formula support
2014-03-04Fix sanitizing and some cleanupJurriaan Pruis
2014-03-03Add support for array formulas.tafryn
2014-03-01Implemented RichText (multiple text runs)Jurriaan Pruis
and added multiline autowidth for both RichText and normal strings
2014-02-26Huge refactoringJurriaan Pruis
Do not create huge strings Let Row inherit from SimpleTypedList Optimized sanitizing Optimized validation And more..
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-26Add missing change from 4400e233c (refs #285)Jonathan Tron
2014-02-26Do not put Axlsx::DefinedName#name in serialized_attributes (fixes #285)Jonathan Tron
When using serialized_attributes both attribute's name and value are camelcased, in `Axlsx::DefinedName` the values starts with `_xmln` which is then transformed in `Xmln`. The fix proposed on #285 does not work because then other `Axlsx::DefinedName` attributes name are no more camelcased (`localSheetId` become `local_sheet_id` for instance). As proposed by @randym in #285, this commit only make a special case of the name and let the other attributes go through serialized_attributes. Adding a test on it revealed a wrong test which would have catched similar error but was not because of value returned by `doc.xpath`.
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-29Added workbook views collection and workbook view objectRandy Morgan
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-08-06Fix minor typosMartin madsen
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-14correct shared strings table xml:space attribute parsing and schemaRandy Morgan
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