summaryrefslogtreecommitdiffhomepage
path: root/lib/axlsx
AgeCommit message (Collapse)Author
2013-08-06Fix minor typosMartin madsen
2013-07-31Fix minor typoMichael Westbom
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-08Implement Relationship.clear_cached_instances, use it before serializing the ↵Stefan Daschek
package. This is necessary to make serialization idempotent (i.e. make sure that Relationship instances are generated with the same IDs everytime the package is serialized). It also fixes a memory leak if Axlsx is used in a long running server process (eg a Rails app).
2013-07-08Simply Relationship.next_free_id by depending on number of cached instances.Stefan Daschek
Only drawback: Setting @next_freed_id_counter to 1000 in tc_helper.rb is no longer possible. But this was useful mainly while adding / fixing test cases when implementing the Relationship instance cache.
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-08Make sure serializing axlsx packages with identical contents always results ↵Stefan Daschek
in identical zip files. This improves the possibilites for caching and/or consolidating the generated zip (xlsx) files. Up to now, serializing the same package at different times resulted in different zip files because of the timestamp in the zip entry metadata. Note: To generate identical packages (and thus identical zip files), you'll have set Core#created explicitly, eg. with `Package.new(created_at: Time.local(2013, 1, 1)`.
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-27Fixes Issue #202 Axes are borked in Bar3DChart by requiring axis order in ↵Moses Hohman
the constructor
2013-06-27Merge remote-tracking branch 'randym/master'Moses Hohman
* randym/master: escape formula for conditional formatting fix typo in specs added sparse array transposition with blocks for rows/cols switching and some docs updates for release prep
2013-06-23escape formula for conditional formattingRandy Morgan
2013-06-23Merge branch 'master' of https://github.com/randym/axlsxRandy Morgan
2013-06-23added sparse array transposition with blocks for rows/cols switching and ↵Randy Morgan
some docs updates for release prep
2013-06-23fixed bad test case and bad code for dispBlanksAs (setting now actually ↵Moses Hohman
makes it into XML) This means there are many other test cases in the suite that are not verifying what they look like they're verifying.
2013-06-23provide a better default for dispBlanksAs and allow it to be configuredMoses Hohman
2013-06-23Fixes Issue #202 Axes are borked in Bar3DChartMoses Hohman
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-12Allow overriding the 'created' timestamp in the docprops.Stefan Daschek
Can be specified as option to Package#new: ``` Axlsx::Package.new :created_at => time ``` If omitted, the current time at the moment the document is serialized will be used. This change is therefore fully backward compatible.
2013-06-12Add a subtotal option to PivotTable (dirty).Samuel de Framond
2013-05-26Update bg_color in conditional formattingAnkur Sethi
Conditional formatting for background color fills is different for DXF. This must be undocumented and is quite annoying. I verified the behavior in Excel 2010 Mac and Windows. I didn't understand why background colors were not being applied even though the style was being applied for conditional formatting. Looking at styles.xml I saw that it is different in a file created by Excel. I have updated the code to reflect it and tested in Mac and Windows.
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-27Merge pull request #185 from agardiner/preserve-spacesRandy Morgan (@morgan_randy)
Add support for preserving leading and trailing spaces in cell values
2013-04-27Add a preserve_spaces option to worksheet, defaults to trueAdam Gardiner
2013-04-27Revert changes to cell serializationAdam Gardiner
2013-04-20Fixed comment visibilityRandy Morgan
2013-04-19Added prep for 1.3.6 releaseRandy Morgan
2013-04-18Added line specificationRandy Morgan
Required by Libre and Open office, and correct by spec. When we get a requirement to customize the line width/shape this should be extracted out into a Line class.
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-17Fixed LineChart and refactored chart axes managementRandy Morgan
2013-03-15Merge pull request #178 from Programatica/masterRandy Morgan (@morgan_randy)
Add LineChart
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-03-14fix line chart nameSergio Cambra
2013-03-14only yield if block givenSergio Cambra
2013-03-14fix loading LineChartSergio Cambra
2013-03-14add lineChart (2D) and show_marker to LineSeries (for 2D line chart)Sergio Cambra
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-04Added docs for Drawing#child_objectsRandy Morgan
2013-02-04Extracted type based cell serializersRandy Morgan
2013-01-23Updated chart vary_colorsRandy Morgan
This sets the proper default for each chart type and lets us change it as we need.
2013-01-21Update comments to reflect new usage of #add_row methodNestor Pestelos and Ramon Tayag
2013-01-15Refactored relationship management for drawingsRandy Morgan
This should fix #160