| Age | Commit message (Collapse) | Author |
|---|
|
|
|
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.
|
|
|
|
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`.
|
|
|
|
As per the spec, a bubble series tag should not include a marker tag.
This was preventing files from being open with Excel Viewer.
|
|
|
|
https://github.com/randym/axlsx/issues/241
|
|
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.
|
|
|
|
|
|
|
|
|
|
account for the zone
|
|
|
|
|
|
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.
|
|
|
|
upgrade to rubyzip 1.0.0
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
file extensions
|
|
|
|
|
|
Fix hardcoded sheet name in PivotTableCacheDefinition and allow other sheet to be the data source for the pivot table
|
|
|
|
|
|
|
|
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)`.
|
|
|
|
|
|
This test case was completely ignored when running the tests, because its name didn't start with "test_".
Some details in the test case needed to be fixed, too.
|
|
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.
|
