| Age | Commit message (Collapse) | Author |
|---|
|
|
|
|
|
* Commit f8ef8eb78eb4556676b5770c82493e6e6edf7ec8 fixed the shared
strings class to automatically sanitize its serialized XML output to
remove any control characters. However, this commit did not include
tests that the shared strings actually removed the control
characters when serializing to an XML string.
* This tests confirms that the string with control characters is
added to the shared strings, and that the control characters are
removed from the string in question when serialized to XML.
|
|
soutaro-fix-time-cast
|
|
|
|
9999 is too big
|
|
This skips calling `#to_time` if the value is a instance of subclass of `Time`, like `ActiveSupport::TimeWithZone`.
|
|
|
|
Use 1 or 0 instead of 'true' or 'false' in the XML output
|
|
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.
|
|
|
|
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`.
|
|
|
|
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.
|
|
|
|
|
|
|
|
|
