| Age | Commit message (Collapse) | Author |
|---|
|
There was some ruby code and numbered list with a wrong markdown syntax, causing them to not render properly. Fixed those.
|
|
|
|
|
|
Make relationship ids more reliable.
|
|
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.
|
|
provide a better default for dispBlanksAs and allow it to be configured
|
|
Fixes Issue #202 Axes are borked in Bar3DChart
|
|
Fixes #202 Axes are borked in Bar3DChart
|
|
the constructor
|
|
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.
|
|
|
|
|
|
|
|
|
|
Allow overriding the 'created' timestamp in the docprops.
|
|
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.
|
|
|
|
Update bg_color in conditional formatting
|
|
|
|
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.
|
|
|
|
|
|
|
|
This font may not be avilalbe in all renderes.
|
|
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
|
|
|
|
|
|
|
|
The validator will try to cast whatever it is fed to_i. Unfortunately
in 1.8.7 Symbol supports to_i.
|
|
|
|
|
|
|
|
|
|
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.
|
|
Colors are required by OpenOffice, and LibreOffice, and syntactically
correct regardless so we should be putting them in.
|
