| Age | Commit message (Collapse) | Author | |
|---|---|---|---|
| 2022-07-21 | Prevent Excel from crashing when multiple data columns are added to PivotTable | Knut Stenmark | |
| Excel will crash unless both `colFields` and `colItems` are declared in the PivotTable xml. First `field` of `colFields` needs to be set to -2 to tell Excel that the value columns comes from individual columns and not groups. I do not know why `colItems` are needed, but when set, the Excel document opens without crashing. | |||
| 2022-07-12 | Add `hideDropDown` alias for `showDropDown` setting, as the latter is ↵ | Koza | |
| confusing to use (because its logic seems inverted). | |||
| 2022-07-09 | Add pivot table option to sort headers (#143) | James Lam | |
| 2022-06-05 | Implement “rounded corners” setting for charts | Stefan | |
| Until now this setting was not present in the generated XML. According to the ECMA spec the setting defaults to true, so charts always had rounded corners. Now rounded corners can be disabled explicitly. | |||
| 2022-06-01 | Implement “plot visible only” setting for charts | Stefan | |
| Until now this setting was hardcoded to `true`. The setting affects whether data from hidden cells (cells width zero height or width) is used when plotting the chart. | |||
| 2022-05-23 | Fix default values in docs | Stefan | |
| 2022-05-18 | Completely hide chart titles if blank | Stefan | |
| Before this change, a chart with a blank title would show up in Excel with a default title like “Chart title” or “Diagrammtitel”. It was not possible to completely hide a chart title: Setting it to an empty space would override Excel’s default, but the empty title did still occupy vertical space. Per OOXML standard the `title` element is optional, so omitting it if the title is blank looks like the right thing to do and seems to work correctly in Excel. | |||
| 2022-05-18 | Implement `Title#empty?` | Stefan | |
| This is primarily a refactoring, but exposing it as a public method seems useful. | |||
| 2022-05-18 | Fix missing cell reference for chart title when cell empty | Stefan | |
| Before this change, creating a chart title referencing an empty cell would lose the cell reference. If the cell was later set to a non-blank value (either during generating the file, or while editing it in a spreadsheet app), the chart title would stay blank. | |||
| 2022-04-07 | Sort archive entries for correct MIME detection with file command | ytjmt | |
| 2022-03-02 | instance_values -> instance_values_for | pjskennedy | |
| 2022-03-02 | Update references to use new class method | pjskennedy | |
| 2022-03-02 | Remove monkey patch on Object | pjskennedy | |
| 2022-02-23 | Version bump to 3.2.0 [skip ci] | Noel Peden | |
| 2022-02-07 | Validate name option to be non-empty string when passed. | Josef Šimánek | |
| 2022-02-07 | Merge branch 'master' into feature/manageable-scatter-markers | Oleg Yakovenko | |
| 2022-02-06 | Allow border style to accept an Array (#117) | Weston Ganger | |
| Co-authored-by: Noel Peden <[email protected]> | |||
| 2022-02-06 | Autowidth cell calculation is now configurable | Tobias Egli | |
| On the workbook you can now configure the font_scale_divisor and the bold_font_multiplier to get better results for the automatic cell width calculationb | |||
| 2022-02-05 | Merge branch 'master' into improve_range_error | Noel Peden | |
| 2022-01-28 | Fix invalid xml when pivot table created with more than one column in data field | Weston Ganger | |
| 2022-01-24 | Refractor to use constant based error messages | Weston Ganger | |
| 2021-12-29 | Fix Worksheet#name_to_cell bug which returned reversed row/col indexes | Weston Ganger | |
| 2021-12-28 | Return output stream in binmode | Dan DeBruler | |
| 2021-09-22 | Version bump to 3.1.1 [skip ci] | Noel Peden | |
| 2021-07-25 | Fix gap width validator for bar charts (#108) | Zsolt Kozaroczy | |
| `gap_width` and `gap_depth` now allow only integers in the range of 0–500. The previous behaviour (requiring a percentage value) was according to the current version of the OOXML spec, but Excel seems to rely on an older version, where the gap amount was required to be a simple integer. Also, `gapDepth` is only allowed in 3D bar charts, so it is now no longer available for 2D bar charts. | |||
| 2021-07-24 | Add overlap to bar charts (#107) | Zsolt Kozaroczy | |
| 2021-05-31 | Fix typo in row.rb | Pascal Andermatt | |
| 2021-04-26 | Add option to define a series color for the BarSeries (#81) | Zsolt Kozaroczy | |
| 2021-04-26 | Optimize Axlsx.cell_range (#94) | Oleg Yakovenko | |
| Optimize Axlsx.cell_range by using minmax_by instead of sorting the cells (the sorted cells are not used for anything else in this method). | |||
| 2021-03-28 | Version bump to 3.1.0 | Noel Peden | |
| 2021-03-27 | Replace mimemagic with marcel (#95) | Jorne Kandziora | |
| Mimemagic requires users to download or install additional files. Rails used Marcel as an abstration layer on this library. Marcel was updated to another file matching database. Following Rails in this matter will remove the need for users to do additional work, just to use caxlsx. | |||
| 2021-03-19 | Implement :offset option for worksheet#add_row (#87) | Agustin Gomez | |
| 2021-03-19 | Add support for format in pivot tables (#79) | Knut I. Stenmark | |
| 2021-03-05 | feature: useless assignment removed | Oleg Yakovenko | |
| 2021-03-05 | feature: helper method naming adjustment | Oleg Yakovenko | |
| 2021-03-05 | feature: spec fix | Oleg Yakovenko | |
| 2021-03-05 | feature: handle default marker symbol | Oleg Yakovenko | |
| 2021-03-02 | feature: respect marker preferences without color specification | Oleg Yakovenko | |
| 2021-03-01 | feature: marker symbol management for scatter series | Oleg Yakovenko | |
| 2021-03-01 | feature: scatter series should respect marker preference of parent chart | Oleg Yakovenko | |
| 2021-02-17 | Merge pull request #57 from rylwin/change-serialize-signature | Noel Peden | |
| Deprecate using `#serialize` with boolean argument | |||
| 2021-02-12 | Merge pull request #77 from rfdonnelly/fix-special-char-in-table-header | Noel Peden | |
| Fix special characters in table header | |||
| 2021-02-03 | Fix special characters in pivot table cache definition | Rob Donnelly | |
| 2021-02-03 | Fix special characters in table header | Rob Donnelly | |
| 2021-01-05 | Bump version 3.0.4 | Noel Peden | |
| 2021-01-05 | Merge pull request #71 from artplan1/add-date-type | Noel Peden | |
| Allow to set cell type to `date` | |||
| 2021-01-05 | Merge pull request #70 from chi-deutschland/fix-worksheet-title-length-rule | Noel Peden | |
| Fix worksheet title length enforcement | |||
| 2020-12-10 | Fix calculation of worksheet name length | Luka Lüdicke | |
| - The previous change caused unnecessary issues - We approximate that Excel calculates the character length with UTF-16 - Fixes https://github.com/caxlsx/caxlsx/issues/67 | |||
| 2020-12-07 | Version bump to 3.0.3 | Noel Peden | |
| 2020-12-03 | Extend cell_type_from_value with sanity checks | Toms Mikoss | |
