| Age | Commit message (Collapse) | Author |
|---|
|
|
|
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
strings table output.
|
|
file extensions
|
|
|
|
|
|
Fix hardcoded sheet name in PivotTableCacheDefinition and allow other sheet to be the data source for the pivot table
|
|
Correct minor typos
|
|
|
|
|
|
|
|
Fixed a little typo.
|
|
|
|
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).
|
|
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.
|
|
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).
|
|
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)`.
|
|
|
|
|
|
Add a subtotal option to PivotTable.
|
|
the constructor
|
|
* 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
|
|
|
|
|
|
some docs updates for release prep
|
|
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.
|
|
|
|
|
|
|
|
|
|
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.
|
|
|
|
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.
|
|
|
|
|
|
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.
|
|
Add support for preserving leading and trailing spaces in cell values
|
|
|
|
|
|
|
|
|
|
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.
|
|
|
