| Age | Commit message (Collapse) | Author |
|---|
|
By only sanitizing just before serialisation.
|
|
|
|
|
|
and added multiline autowidth for both RichText and normal strings
|
|
Do not create huge strings
Let Row inherit from SimpleTypedList
Optimized sanitizing
Optimized validation
And more..
|
|
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.
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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).
|
|
|
|
|
|
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.
|
|
|
|
|
|
some docs updates for release prep
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
|
|
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.
|
|
Not really sure what excel is going to do with these data types, but
hooking it up is the first step ;)
|
|
This constraint would prevent you from creating a new worksheet
with the name that it would have gotten by default.
|
|
Creating a worksheet with an invalid name would still add it to the
workbook, despite raising an exception.
|
|
|
|
worksheet#outline_rows
worksheet#outline_columns
|
|
This lets cache formula values and specify the default row height so
that iOS and Max OSX previews render properly
|
|
With thanks to http://stackoverflow.com/a/451488/1322410 for providing the
list of characters
|
|
This is part of https://github.com/randym/axlsx/issues/149
|
|
Create a simple Pivot Table
|
|
see examples/pivot_table.rb
wb.add_worksheet(:name => "Data Sheet") do |sheet|
sheet.add_row ['Month', 'Year', 'Type', 'Sales', 'Region']
30.times { sheet.add_row [month, year, type, sales, region] }
sheet.add_pivot_table 'G4:L17', "A1:E31" do |pivot_table|
pivot_table.rows = ['Month', 'Year']
pivot_table.columns = ['Type']
pivot_table.data = ['Sales']
pivot_table.pages = ['Region']
end
end
|
|
* an example can be run with `ruby examples/pivot_table.rb`
* right now you cannot set options on the pivot table to make it useful (coming soon...)
|
