summaryrefslogtreecommitdiffhomepage
AgeCommit message (Collapse)Author
2022-07-21Prevent Excel from crashing when multiple data columns are added to PivotTableKnut 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-12Add `hideDropDown` alias for `showDropDown` setting, as the latter is ↵Koza
confusing to use (because its logic seems inverted).
2022-07-12Move "capture warning" test helper to its own moduleKoza
2022-07-09Add pivot table option to sort headers (#143)James Lam
2022-07-09Improve font exampleStefan Daschek
2022-07-09Update changelog, add missing PRs and IssuesKoza
2022-07-09Add a pull request template to make contributions easierKoza
2022-07-09Improve list validation exampleStefan Daschek
2022-06-05Add example for defining print area (#134)Stefan
2022-06-05Update changelogStefan
2022-06-05Implement “rounded corners” setting for chartsStefan
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-01Add missing screenshot for panes_exampleStefan
Fixes #135
2022-06-01Update CHANGELOGStefan
2022-06-01Implement “plot visible only” setting for chartsStefan
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-23Fix default values in docsStefan
2022-05-18Update ChangelogStefan
2022-05-18Completely hide chart titles if blankStefan
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-18Implement `Title#empty?`Stefan
This is primarily a refactoring, but exposing it as a public method seems useful.
2022-05-18Fix missing cell reference for chart title when cell emptyStefan
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-14Merge pull request #142 from tmikoss/update-outline-documentationNoel Peden
Add row outline options example
2022-04-14Add row outline options exampleToms Mikoss
2022-04-11Merge pull request #139 from ↵Noel Peden
ytjmt/sort_archive_entries_for_correct_mime_detection Sort archive entries for correct MIME detection with `file` command
2022-04-11Merge pull request #140 from mishina2228/update-gemspecNoel Peden
Update gemspec to recent styles
2022-04-10Fix borders exampleKoza
2022-04-10Update gemspec to recent stylesmishina
- `date` should not be set - Remove deprecated `test_files` to shrink gem size
2022-04-07Sort archive entries for correct MIME detection with file commandytjmt
2022-04-01Merge pull request #132 from pjskennedy/remove-object-monkey-patchNoel Peden
Remove Object#instance_values monkey patch
2022-03-06Added a spec for instance_values_forpjskennedy
2022-03-02instance_values -> instance_values_forpjskennedy
2022-03-02Update references to use new class methodpjskennedy
2022-03-02Remove monkey patch on Objectpjskennedy
2022-02-23Version bump to 3.2.0 [skip ci]Noel Peden
2022-02-23Merge pull request #129 from westonganger/patch-5Noel Peden
Add changelog entry for PR #94
2022-02-09Add changelog entry for PR #94Weston Ganger
2022-02-08Updated Changelog (Possibility to configure the calculation of the autowidth ↵Tobias Egli
mechanism)
2022-02-08Switch CI to Github ActionsWeston Ganger
2022-02-07Merge pull request #116 from caxlsx/empty-sheet-nameNoel Peden
Validate name option to be non-empty string when passed.
2022-02-07Validate name option to be non-empty string when passed.Josef Šimánek
2022-02-07Merge pull request #85 from olegykz/feature/manageable-scatter-markersNoel Peden
feature: manageable markers for scatter series
2022-02-07Merge branch 'master' into feature/manageable-scatter-markersOleg Yakovenko
2022-02-07Update CHANGELOG.mdOleg Yakovenko
2022-02-06Allow border style to accept an Array (#117)Weston Ganger
Co-authored-by: Noel Peden <[email protected]>
2022-02-06Autowidth cell calculation is now configurableTobias 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-05Merge pull request #122 from westonganger/improve_range_errorNoel Peden
Improve error for invalid ranges
2022-02-05Merge branch 'master' into improve_range_errorNoel Peden
2022-02-05Merge pull request #125 from westonganger/patch-4Noel Peden
Remove Known Bugs Section in Readme
2022-01-28Fix invalid xml when pivot table created with more than one column in data fieldWeston Ganger
2022-01-25Remove Known Bugs Section in ReadmeWeston Ganger
2022-01-24Refractor to use constant based error messagesWeston Ganger
2022-01-21Merge pull request #120 from DDeBruler/string-encodingNoel Peden
Return output stream in binmode